Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What formula will divide the value in Cell E5 by the value in Cell E6?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
The format applied to a spreadsheet that keeps one or more rows or columns from moving when the user scrolls either down or to the side is ________
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
Purchase discounts are awarded as follows: 3% for $300, 5% for $500, and 9% for 900 or more. What function is used to determine which discount is allowed based on the purchase price?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
Sam uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
Which function can be used that will result in the current data?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
In a spreadsheet, to view the data for a specific department, use the _________ funciton.
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
In a spreadsheet, which function will result in the total number of entries in a cell range?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This is an example of which operation?
LookUp
freeze panes
list
Now
Freeze
Count
=E5/E6
IF
Check it!