This command will show all formulas in a worksheet.
What is Ctrl + ` (grave accent)
100
This shortcut inserts the SUM function.
What is Alt + =
100
There are this number of Tabs across the top of a worksheet.
What is eight (8)
100
The IF function consists of this many parts.
What is three (3)
200
This function returns the arithmetic mean of the arguments.
What is the Average function?
200
Opens the Find and Replace dialog box with the Find tab selected.
What is Ctrl + F
200
This makes the previous cell active.
What is Shift + Tab
200
This button will join the selected cells and make them one big cell with all the contents centered.
What is the Merge & Center Button
200
These are the three parts of the IF function.
What are logical test, value if true and value if false.
300
Excel has over 200 functions that are divided into this number of categories.
What is twelve (12).
300
This opens a new workbook.
What is Ctrl + O
300
This makes the cell above the current cell active.
What is Shift + Enter
300
The Orientation button allows you to change between Portrait and Landscape view, and is found in this group in the Page Layout Tab.
What is the Page Setup group.
300
These are used to identify the data as text rather than a value.
What are quotation marks.
400
This function returns the serial number of the current date and time.
What is the NOW function.
400
This opens the Go To dialog box.
What is Ctrl + G
400
This will select an entire row.
What is Shift + Spacebar
400
This button will check the spelling of text and is found in this Tab.
What is the Spelling Button in the Review Tab.
400
This tells me that if I spent less than $100 on my new shoes that mom is going to be HAPPY but if I spent more than that I better RUN.
B2 = amount spent
What is =IF(B2<100,"HAPPY","RUN")
500
These three arguments are mandatory when using the PMT function.
What is Rate, Nper and PV.
500
This changes the number to Percent Style
What is Ctrl + Shift + %
500
This command will open up the Insert Function dialog box.
What is Shift + F3
500
When double-clicked this button allows you to apply the same formatting to multiple places in the worksheet.
What is the Format Painter button.
500
This shows me what my allowance will be. If I get an A+ on my exam my mom is going to double my allowance but if it's not than I only get half.
B2=Exam Mark
C2=Allowance