Name:     ID: 
 
Email: 

Entering Worksheet Formulas

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

 1. 
Each formula begins with a quotation mark (“).
 

 2. 
Formulas can include more than one operator.
 

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

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

 5. 
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.
 

 6. 
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.
all of the above
 

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

 8. 
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
 

 9. 
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
 

 10. 
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
 

 11. 
If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode.
a.
F1
c.
F3
b.
F2
d.
F4
 

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

 13. 
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
 

 14. 
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
 

 15. 
You can change which summary calculations appear in the status bar. Right-click the status bar to open the ____ Status Bar menu.
a.
Highlight
c.
Edit
b.
Create
d.
Customize
 

 16. 
To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual.
a.
Calculation Options
c.
Automatic Calculation
b.
Calculation Manual
d.
Formulas
 

 17. 
When you move the pointer into the formula bar or edit directly in a worksheet cell, the pointer changes to ____.
a.
a hand
c.
double arrows
b.
crosshairs
d.
an I-beam
 

 18. 
A relative cell reference adjusts to its new location when copied or moved. For example, when the formula =A3+A4 is copied from cell A5 to cell B5, the formula changes to ____.
a.
=B3+B4
c.
=$B3+$B4
b.
=B4+B5
d.
=B$4+B$5
 

 19. 
When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.
a.
=$A$3+$A$4
c.
=A3+A4
b.
=$B$5+$B$6
d.
=$B$3+$B$4
 

 20. 
The Sum button is located in the ____ group on the Home tab of the Ribbon.
a.
Commands
c.
Editing
b.
Formulas
d.
Data
 

 21. 
The SUM function that adds the numbers in the range D5:D17 is ____.
a.
SUM(D5:D17)
c.
(D5:D17)SUM
b.
=SUM(D5:D17)
d.
=(D5:D17)SUM
 
 
FIGURE 4-1

nar001-1.jpg

Excel Case 4-1
Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers.  Please refer to the figure above while answering the questions below.
 

 22. 
What should Kayden do to show the default calculations for a range of cells?
a.
Select the range and the calculations will appear in the status bar
b.
Select the range and click the Calculate button
c.
Select the range and click the Number button
d.
Select the range and click the Sum button
 

 23. 
Kayden wants to customize which calculations appear on the status bar. What should she do next?
a.
Right-click the status bar to open the Customize Status Bar menu
b.
Left-click the status bar to open the Customize Calculations menu
c.
Click the status bar multiple times to cycle through the different calculations
d.
none of the above
 
 
Excel Case 4-2
Ben is copying some formulas and wants to make sure he has the cell references correct.  Please answer the questions below.
 

 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. 

 Do not change when copied or moved to a new cell
 

 30. 

 Cell references that contain both relative and absolute references
 



 
         Start Over