EXCEL AT EXCEL

EXCEL SHORTCUTS

100

WHAT IS THE SHORT CUT FOR COPY IN EXCEL

CTRL + C

200

CTRL + X DOES WHAT?

CUT THE INFORMATION FROM A CELL(S)

300

WHAT IS THE SHORTCUT TO HIGHLIGHT A TABLE IN A WORKSHEET

CTRL + A

400

CTRL + [ DOES WHAT?

HOW DO YOU MOVE TO A REFERENCED CELL? (i.e. THE CELL THAT IS APART OF YOUR FORMULA)

500

WHAT IS THE SHORTCUT FOR HIGHLIGHTING AN ENTIRE COLUMN?

CTRL + SPACEBAR

EXCEL FORMATING

100

WHAT DOES CTRL+ B YIELD?

BOLD OF TEXT/NUMBER

200

WHAT IS THE SIMPLEST WAY TO INSERT A ROW OR COLUMN IN A WORKSHEET

RIGHT-CLICK ON THE ROW/COLUMN YOU WANT TO INSERT BESIDE AND CLICK INSERT

300

SELECTING THE "," ON THE NUMBER FORMATTING BAR, DOES WHAT?

CHANGE NUMBER FORMAT TO ACCOUNTING 

400

WHAT TABLE CAN BE USED TO SUMMERIZE DATA IN EXCEL?

PIVOT TABLES

500

WHAT IS THE SIMPLEST WAY TO CONVERT GL ACCOUNT CODES TO NUMBERS? (HINT THE CELL NORMALLY HAS A GREEN TRIANGLE AT THE UPPER RIGHT-HAND CORNER)

CLICK THE YELLOW EXCLAMATION RHOMBUS AND SELECT "CONVERT TO NUMBER"

EXCEL FORMULAS

100

WHICH FORMULA CAN BE USED TO TOTAL A RAGE OF CELLS?

SUM

200

SELECTING F4 ON YOUR KEYBOARD DOES WHAT TO YOUR FORMULA REFERENCE?

ABSOLUTE CELLS

300

WHAT CAN THE IF FUNCTION BE USED FOR?

AN INSTANCE WHERE A CONDITION NEEDS TO BE MET IN A FORMULA

400

WHAT FORMULA WILL SHOW YOU THE TOTAL OF THE CELLS FILTERED?

=SUBTOTAL(9,(RAGE))

500

NAME TWO FORMULAS USED TO JOIN INFORMATION FROM DIFFERENT CELLS INTO A STRING.

CONCAT

CONCATENATE

TEXTJOIN