Ch. 3 Excel Test Question Preview (ID: 14845)


Review Games For Ch. 3 Excel MOS Question Test In Moodle. TEACHERS: click here for quick copy question ID numbers.

A cell reference of $A$2 is a ____ cell reference.
a) absolute
b) invalid
c) relative
d) mixed

A cell reference of A20 is a ____ cell reference.
a) relative
b) absolute
c) invalid
d) mixed

Which of the following is NOT a valid format symbol?
a) semi-colon
b) dollar sign
c) comma
d) percent sign

If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
a) decrement, increment
b) cut, copy
c) increment, decrement
d) copy, cut

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, ___.
a) No deductions
b) #REF!
c) F5
d) Deductions

When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
a) NOW
b) CURRENT
c) DATETIME
d) SYSDATE

The ___ function is useful when you want to assign a value to a cell based on a logical test.
a) IF
b) OR
c) AND
d) NOW

The fill handle can be used to do which of the following?
a) all of these
b) create a series of numbers or dates
c) copy a cell
d) copy a range of cells

Excel converts all the formulas from ____.
a) lowercase to uppercase
b) uppercase to lowercase
c) absolute to relative
d) relative to absolute

In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.
a) copy
b) cut
c) move
d) delete

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 14845 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register