Name:     ID: 
 
    Email: 

Assignment: Chapters 1-4

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

 1. 

The easiest way to select a cell (make it active) is to _____.
a.
type the cell reference in the status bar
b.
use the function keys located at the top of the typewriter keys on the keyboard
c.
type the cell reference in the formula bar
d.
use the mouse to move the block plus sign to the cell and then click
 

 2. 

When proposing a range of cells to sum using the SUM button, Excel first looks for a range of cells with numbers _____.
a.
below the active cell and then to the left
b.
above the active cell and then to the left
c.
below the active cell and then to the right
d.
above the active cell and then to the right
 

 3. 

When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format.
a.
Auto Sum Options button
c.
Auto Fill Options button
b.
Auto Correct Options button
d.
Auto Complete Options button
 

 4. 

The small _____ at the corners and along the sides of the rectangle that encloses an embedded chart indicate the chart is selected.
a.
sizing handles
c.
move handles
b.
fill handles
d.
marquee
 

 5. 

The small box to the right of an embedded column chart contains the legend, which _____.
a.
supplies the title of the chart
b.
identifies the colors assigned to each bar in the chart
c.
determines the increments along the y-axis
d.
all of the above
 

 6. 

The _____ can be used to quit Excel.
a.
Close button and Control-menu icon on the menu bar
b.
Minimize button and Restore icon on the menu bar
c.
Close button and Control-menu icon on the title bar
d.
Minimize button and Restore icon on the title bar
 

 7. 

When a cell containing an error is double-clicked, Excel switches to _____, the active cell contents display in the formula bar, and a flashing insertion point displays in the active cell.
a.
Insert mode
c.
Overtype mode
b.
Edit mode
d.
Ready mode
 

 8. 

When an error occurs in a formula in a cell, Excel displays the _____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
a.
Smart Tag Actions
c.
Trace Error
b.
AutoCorrect Options
d.
Auto Fill Options
 

 9. 

In Excel, functions can be entered using any of the following methods except the _____.
a.
Function command on the Tools menu
c.
Insert Function box on the formula bar
b.
keyboard or mouse
d.
AutoSum button menu
 

 10. 

To save a saved workbook using a new name or on a different drive, _____.
a.
click the Save button on the Standard toolbar
b.
click Save As on the File menu
c.
PRESS CTRL+S
d.
click Save on the File menu
 

 11. 

To instruct Excel to display a hidden column, position the mouse pointer to the _____.
a.
left of the column heading boundary where the hidden column is located and then drag to the right
b.
right of the column heading boundary where the hidden column is located and then drag to the left
c.
left of the column heading boundary where the hidden column is located and then drag to the left
d.
right of the column heading boundary where the hidden column is located and then drag to the right
 
 
chapters_1-4_files/i0130000.jpg
 

 12. 

In the Print dialog shown in the accompanying figure, the _____instructs Excel to print the worksheet currently on the screen or the selected worksheets.
a.
Selection option button
c.
Active sheet(s) option button
b.
Print to file check box
d.
Collate check box
 

 13. 

In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print all the worksheets with content in the workbook.
a.
Entire workbook option button
c.
Selection option button
b.
All option button
d.
Active sheet(s) option button
 

 14. 

To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then _____.
a.
click the Cancel box
c.
click the Name box
b.
press the ESC key
d.
press the ENTER key
 

 15. 

In any of the four Chart Wizard dialog boxes, a _____ button can be clicked to return to the previous Chart Wizard dialog box.
a.
Cancel
c.
Next
b.
Back
d.
Finish
 
 
chapters_1-4_files/i0180000.jpg
 

 16. 

When Split is clicked on the Window menu, Excel divides the window into four _____, as shown in the accompanying figure.
a.
zoom boxes
c.
panes
b.
sheets
d.
toolbar docks
 

 17. 

It is important that border characteristics be selected in this order: _____.
a.
(1) choose the border type; (2) choose the border line style; and (3) choose the color
b.
(1) choose the border line style; (2) choose the color; and (3) choose the border type
c.
(1) choose the color; (2) choose the border type; and (3) choose the border line style
d.
(1) choose the color; (2) choose the border line style; and (3) choose the border type
 

 18. 

The name Down Payment, which is made up of two words, would be written as _____ in a formula.
a.
Down Payment
c.
Down_Payment
b.
Down*Payment
d.
Down+Payment
 

 19. 

The Table command on the _____ is used to define a range as a data table.
a.
Insert menu
c.
Data menu
b.
Format menu
d.
Edit menu
 

 20. 

The IF function =IF(G3 <= $E$3, PV($E$2 / 12, 12 * ($E$3 – G3), -$E$4), 0) assigns _____ to the cell if the logical test is false.
a.
$E$2 / 12
c.
-$E$4
b.
12 * ($E$3 – G3)
d.
0 (zero)
 

Completion
Complete each sentence or statement.
 
 
chapters_1-4_files/i0250000.jpg
 

 21. 

In the accompanying figure, cell A1 is designated the _________________________ because it is the one into which data can be entered.
 

 

 22. 

As data is typed, Excel displays in the _________________________, and also displays the active cell reference in the Name box on the left.
 

 

 23. 

You _________________________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
 

 

 24. 

The opposite of merging cells is _________________________, which is done by selecting a merged cell and clicking the Merge and Center button on the Formatting toolbar.
 

 

 25. 

The area of a worksheet where an embedded chart appears is called the _________________________.
 

 

 26. 

A saved workbook is referred to as a(n) _________________________.
 

 

 27. 

A(n) _________________________ takes a value or values, performs an operation, and returns a result to the cell.
 

 

 28. 

The _________________________ is a format that displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and rounds numbers to the nearest cent.
 

 
 
chapters_1-4_files/i0340000.jpg
 

 29. 

When Excel’s spell checker finds a word that is not in the standard or custom dictionaries, it displays the word in the _________________________, as shown in the accompanying figure.
 

 

 30. 

By _________________________ the worksheet, you see exactly how it will look without generating a printout.
 

 

 31. 

A cell reference with only one dollar sign before either the column or the row is called a(n) _________________________.
 

 

 32. 

A(n) _________________________ is a toolbar that is displayed in its own window and can be moved anywhere in the Excel window.
 

 
 
chapters_1-4_files/i0390000.jpg
 

 33. 

To add a drop shadow to a cell, select the desired shadow style on the _________________________ shown in the accompanying figure.
 

 

 34. 

The names that identify the slices of a Pie chart are called _________________________.
 

 

 35. 

When working with a large worksheet, the Excel window can be _________________________ into two or four window panes to view different parts of the worksheet at the same time.
 

 

 36. 

_________________________ portions of a workbook lets only the parts of the workbook that the user needs to see be displayed.
 

 

 37. 

In a data table, the values that vary are called _________________________.
 

 

 38. 

To assign a hyperlink to an embedded graphic, right-click the graphic and click _________________________ on the shortcut menu.
 

 

 39. 

If you continually select the same range in a worksheet to print, you can specify the range to print each time you print the worksheet by using the _________________________ on the Print Area submenu.
 

 

 40. 

To unlock cells for specific users, use the _________________________ on the Protection submenu.
 

 



 
Submit          Reset Help