Name:     ID: 
 
Email: 

Chapter 5 review questions

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

 1. 

A worksheet window displays all the rows in the worksheet.
 

 2. 

The selected cell is called the active cell.
 

 3. 

A label that extends beyond the width of the cell will be truncated if the next cell contains data.
 

 4. 

If a label is truncated because it extends beyond the width of the cell, the truncated data is deleted.
 

 5. 

Formatting is applied to cells to make the data easier to understand.
 

 6. 

Unless cells are formatted otherwise, dates/times are automatically right aligned.
 

 7. 

Long column headings can be wrapped to the next line of the same cell.
 

 8. 

Headers are automatically printed at the bottom of every page.
 

 9. 

The order in which Excel evaluates a mathematical expression can be changed by including parentheses in the expression.
 

 10. 

Exponentiation is represented by the asterisk (*) symbol.
 

 11. 

The expression =4+2*2-2 evaluates to 10.
 

 12. 

Displaying formulas changes the value of the cells that contain formulas.
 

 13. 

A circular reference error occurs if a formula references the cell it is stored in.
 

 14. 

Additional protection can be added to a worksheet by requiring a password to unprotected a sheet.
 

 15. 

Changes to a worksheet can be tracked.
 

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

 16. 

How many worksheets are in a new workbook?
a.
one
c.
three
b.
two
d.
five
 

 17. 

Which of the following is an example of a cell reference?
a.
B7
c.
B
b.
7B
d.
7
 

 18. 

When the pointer is moved onto the worksheet, it changes to
a.
mc018-1.jpg
c.
mc018-3.jpg
b.
mc018-2.jpg
d.
mc018-4.jpg
 

 19. 

Number signs (####) displayed in a cell indicate
a.
number signs have been typed as a column title.
b.
the cell is not wide enough to display the formatted number.
c.
an incorrect format has been applied.
d.
the Number format has been applied.
 

 20. 

To select the entire worksheet
a.
click the Select All button.
b.
press the Worksheet button.
c.
press Ctrl+End.
d.
drag the pointer from cell A1 to cell A1048576.
 

 21. 

A variety of cell styles is associated with a
a.
cell reference.
c.
template.
b.
theme.
d.
formula.
 

 22. 

Which theme is applied to a new workbook?
a.
Apex
c.
Office
b.
Equity
d.
Trek
 
 
Assume cell C8 stores a value of 3 and cell D9 stores a value of 2.
 

 23. 

What will be displayed when the formula =2*C8+3*D9 is entered?
a.
18
c.
#DIV/O!
b.
2*C8+3*D9
d.
12
 

 24. 

What will be displayed when the formula =C8+D9/0 is entered?
a.
3+2
c.
#DIV/O!
b.
5
d.
0
 

 25. 

Which key removes the dashed border around copied cells?
a.
the Esc key
c.
the Alt key
b.
the Ctrl key
d.
the Tab key
 

 26. 

The Fill handle is
a.
used to change the color of a cell.
b.
used to copy the contents of the selected cell to adjacent cells.
c.
an icon used to scroll a worksheet.
d.
a cell representing a column of labels.
 

 27. 

Data from Word can be copied to an Excel worksheet
a.
only if it contains numeric data.
b.
if it is formatted in paragraphs.
c.
if it is organized in a table or aligned with tabs and tab stops.
d.
if it is all uppercase letters.
 

 28. 

A triangle in the upper-left corner of a cell indicates
a.
the cell has been modified while changes are being tracked.
b.
the worksheet has been e-mailed.
c.
the cell is a hyperlink.
d.
the cell contents are on the Clipboard.
 

 29. 

Which type of application is required to view an HTML file?
a.
a word processor
c.
a browser
b.
a spreadsheet application
d.
a personal information manager
 

 30. 

A master worksheet that includes the basic elements for a particular type of worksheet is called
a.
a master.
c.
a basic worksheet.
b.
an HTML workbook.
d.
a template.
 



 
         Start Over