Name:     ID: 
 
Email: 

Microsoft Excel Lesson 4

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 point-and-click 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.
a.
F1
c.
F3
b.
F2
d.
F4
 

 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.
double-arrow
 

 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
 
 
FIGURE EX 4-1

nar001-1.jpg
 

 22. 

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

 23. 

In Figure EX 4-1 above, number 1 is pointing to the ____ button.
a.
Show Now
c.
Calculate Now
b.
Calculate Formulas
d.
Calculate Sheet
 
 
Case EX 4-2
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.
 



 
         Start Over