Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5,"Deductions","No deductions"), then cell G5 displays the message, ___.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
The ___ function is useful when you want to assign a value to a cell based on a logical test.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
Excel converts all the formulas from ____.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
A cell reference of $A$2 is a ____ cell reference.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
Which of the following is NOT a valid format symbol?
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
NOW
decrement, increment
semi-colon
IF
copy
No deductions
lowercase to uppercase
absolute
Check it!