True/False Indicate whether the
statement is true or false.


1.

Each formula begins with a quotation mark (“).


2.

The formula =B5+C5 is an example of a multiplication operation.


3.

Formulas can include more than one operator.


4.

Although Excel checks that the formula has the correct structure, it does not
check that the formula contains the correct values or cell references.


5.

When formulas with mixed cell references are copied or moved, the row or column
references preceded by a question mark do not change.


6.

You can include cell references in a formula more quickly by using the
pointandclick method to click each cell, rather than typing cell references.


7.

COUNT CELLS determine how many entries are included in the range.


8.

Whenever you select a range, the Ribbon shows the results of common calculations
for the selected cells.


9.

The formulas replace the formula results in the worksheet. If a cell does not
contain a formula, the cell appears shaded out.


10.

The results of the calculation appear in the cell in which the formula is
entered.

Multiple Choice Identify the
choice that best completes the statement or answers the question.


11.

After you finish typing a formula in a cell, you must enter it by pressing the
____.
a.  Enter key  c.  Enter button on the formula bar  b.  Tab
key  d.  any of the
above 


12.

The formula = E6/4 is an example of a(n) ____ operation.
a.  multiplication  c.  subtraction  b.  division  d.  exponentiation 


13.

You can change which cells are included in a reference by dragging any corner of
the ____ to resize the selected range.
a.  column border  c.  colored outline  b.  formula bar  d.  row border 


14.

The sequence used to calculate the value of a formula is called the ____.
a.  evaluation map  c.  order of evaluation  b.  sequence map  d.  sequence order 


15.

When evaluating formulas, the ____ of parentheses is evaluated first.
a.  innermost set  c.  set that starts farthest to the right  b.  outermost
set  d.  set that starts
farthest to the left 


16.

You cannot enter a formula with an incorrect structure in Excel. If you attempt
to do so, a(n) ____ appears, explaining the error and providing a possible correction.
a.  error message  c.  Formula Wizard  b.  dialog box  d.  none of the
above 


17.

Three types of cell references are used in formulas that do NOT include
____.
a.  relative  c.  mixed  b.  absolute  d.  relational 


18.

You can press the ____ key to cycle a selected cell reference from a relative
reference to an absolute reference to a mixed reference with an absolute row to a mixed reference
with an absolute column and back to a relative reference.


19.

A ____ border indicates that you can replace the current reference in the
formula by clicking another cell or selecting a range.
a.  flashing  c.  flashing colored  b.  colored  d.  doublearrow 


20.

To make all formulas visible, click the Formulas tab on the Ribbon, and then
click the Show Formulas button in the ____ group.
a.  Formula  c.  Formula Auditing  b.  View  d.  Formula View 


21.

If you were using relative cell references, the formula =A3+A4 would change to
____ when copied from cell A5 to cell B5.
a.  =B3+B4  c.  =$B3+$B4  b.  =B4+B5  d.  =B$4+B$5 





22.

In Figure EX 41 above, number 3 is pointing to the ____ menu.
a.  Customize Calculations  c.  Show Formulas  b.  Calculations Options  d.  Manual
Calculations 


23.

In Figure EX 41 above, number 1 is pointing to the ____ button.
a.  Show Now  c.  Calculate Now  b.  Calculate Formulas  d.  Calculate Sheet 



Case EX 42 Ben is copying some formulas and wants to make sure he has
the cell references correct.


24.

Ben wants to copy a formula that is the sum of five rows. He wants the
formula to change as he copies it so that it shows the sum of five rows for each column. What
type of cell reference should Ben use?
a.  Absolute  c.  Mixed  b.  Relative  d.  None of the
above 


25.

Ben also wants to copy a formula from the bottom of the spreadsheet and put it
at the top of the spreadsheet in a summary section. He wants the formula to stay exactly the
same and result in the same figure. What type of cell reference should Ben use?
a.  Mixed  c.  Absolute  b.  Relative  d.  None of the
above 

Matching



Identify the letter of the choice that best matches the phrase or
definition.
a.  Operand  b.  Operator  c.  Mixed cell
reference  d.  Absolute cell reference  e.  Relative cell
reference 


26.

A symbol that indicates the type of calculation to perform.


27.

A constant (text or number) or cell reference used in a formula.


28.

Adjusts to its new location when copied or moved.


29.

Does not change when copied or moved to a new cell.


30.

Cell reference that contain both relative and absolute references.
