Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
The fill handle can be used to do which of the following?
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
A cell reference of $A$2 is a ____ cell reference.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
The ___ function is useful when you want to assign a value to a cell based on a logical test.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
Excel converts all the formulas from ____.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
A cell reference of A20 is a ____ cell reference.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
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, ___.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
decrement, increment
relative
all of these
No deductions
absolute
IF
lowercase to uppercase
copy
Check it!
Match it!
Match it!