Show:
Cell References
Functions
Sorting/Filter
Printing Options/Sheets
Wild Card
100
What are the two types of cell references?
Absolute & Relative
100
Write a formula to calculate: the sum of values store in cells B4, C4, D4, and E4
=SUM(B4,C4,D4,E4)
100
What does ascending mean?
A to Z
100
How many sheets are in an default Excel file?
3
100
What error is displayed when the text is to wide to fit in a cell?
####
200
What formula would be in cell G5 if the formula from cell E4 (E7+E9) was copied into that cell?
G8+G10
200
Write a formula to calculate: the maximum value stored in the range of cells D4 through Y5.
=MAX(D4:Y5)
200
What does descending mean?
Z to A
200
Name and draw the two orientation options.
Landscape & Letter
200
What is the error when you cannot divide by 0?
#DIV/0!
300
The formula = SUM(C3:C22) is entered into cell C24. What happens when row 5 is deleted?
The formula is now: = SUM(C3:C21)
300
What answer will be displayed in Excel from the formula: =ROUND(23.75,1)
23.8
300
What should be selected before you sort or filter?
The entire data and the headings
300
What are two sizes of paper?
Legal & Letter
300
What is the error when you deleted cells that were previously referenced?
#REF
400
What formula would be in cell A8 if the formula from B7 ($C$7+C10) was copied into that cell?
$C$7+B11
400
Write a formula to: Display 50 if the value stored in D20 equals the value in C70, or 25 if they are not equal.
=IF(D20=C70,50,25)
400
Name something you can sort/filter by other than text.
Cell Color, Font Color, Icons
400
Name two ways you can modify the sheet tabs?
Move, Rename, Color
400
How can you insert rows/columns?
Select an entire row/column and right click and select insert.
500
Which key is used to convert a relative cell reference into an absolute cell reference?
F4
500
Write a formula using an IF function for: if B3 is less than or equal to C12 display LOW; if greater than, display HIGH.
=IF(B3<=C12,"LOW","HIGH")
500
What tab on the ribbon can the sort and filter buttons be found?
Data
500
How do you move the breaks in a page to fit the entire document?
View --> Page Break Preview
500
What are the three parts/arguments of an IF statement?
1) comparison 2) value if true 3) value if false