Transcript Lesson 5 Review [Office 2003] 1. Saving an Excel file as a Web page converts it to ____ format. a. b. c. d. Database HTML PRN Word 2.

Lesson 5 Review
[Office 2003]
1. Saving an Excel file as a
Web page converts it to
____ format.
a.
b.
c.
d.
Database
HTML
PRN
Word
2. Which of the following
steps lets you open a new
workbook?
a.
b.
c.
d.
File>New Workbook>Task Pane
File>New
File>Open>New Task Pane
File>Open>New Workbook
3. You can move across a
spreadsheet using ____.
a.
b.
c.
d.
[TAB]
[HOME]
[ENTER]
the Space bar
4. Which of the following steps
lets you delete a worksheet
from a workbook?
a.
b.
c.
d.
Edit>Worksheet>Delete
File>Delete>Worksheet
Edit>Delete Sheet
File>Delete>Worksheet
5. Which of the following
allows you to move a
worksheet?
a. Choose Edit>Move or Copy
b. Click and drag on the sheet tab.
c. Right click on the sheet and click
Move or Copy.
d. All of the above.
6. Which menu contains the
commands Hide/Unhide?
a.
b.
c.
d.
Window
Edit
File
Data
7. The extension for a Web
page is ____.
a.
b.
c.
d.
.xls
.prn
.htm or .html
.doc
8. To view an Excel file that
has been converted to a
Web page choose ____.
a.
b.
c.
d.
Window>Arrange>Web Page
File>Save>Web Page
File>Web Page Preview
Window>Web Page
9. Which toolbar contains the
Print Preview button?
a.
b.
c.
d.
Formatting
Standard
Function
Drawing
10. Which command allows
you to change page
orientation?
a.
b.
c.
d.
Print Preview
Print Area
Web Page Preview
Page Setup
11. Which steps allow you to
set up a print area?
a.
b.
c.
d.
Window>Print Area
File>Print Area>Set Print Area
Edit>Print Area>Set Print Area
Insert>Set Print Area
12. A ____ indicates the edge
of the print area.
a.
b.
c.
d.
dotted line
Window
blank line
row of “###” symbols
13. The Page Break Preview is
found under the ____
menu.
a.
b.
c.
d.
Edit
Window
File
View
14. You can center your print
area in the ____ tab on
the Page Setup dialog box.
a.
b.
c.
d.
Header/Footer
Sheet
Page
Margins
15. If you want to print a
range of cells only one
time, print it as a ____.
a.
b.
c.
d.
Selection
print area
Worksheet
Print Preview
16. In the Print dialog box
which is NOT an option for
printing?
a.
b.
c.
d.
Entire workbook
Cell range
Selection
Active sheet(s)
17. Use the ____ command if you
have several workbooks open at
once and want to be able to see
them all simultaneously.
a.
b.
c.
d.
Freeze Panes
Page Setup
Arrange
Window
18. In Page Break Preview,
page breaks appear as
____.
a.
b.
c.
d.
solid red lines
separate windows
dotted blue lines
split windows
19. What does the pointer
look like when you are in
Print Preview?
a.
b.
c.
d.
20.Which of the following is not
an option listed in the Save as
type box in the Save As dialog
box?
a.
b.
c.
d.
.xls
.edt
.htm
.prn
21. If you want to specify that the a
workbook’s file name appear at
the top of every printed page, go
to the ____ tab in the ____
dialog box.
a.
b.
c.
d.
Header/Footer; Page Setup
Page; Page Setup
Properties; Print
Sheet; Print
22. If the data in a worksheet
will not quite fit on a
printed page, you can try
____.
a.
b.
c.
d.
decreasing the size of the margins
increasing the size of the margins
adding a header
printing the entire workbook
23. Which of the following steps will
make a worksheet’s column
headings always visible,
regardless of where you are in
the worksheet?
a. Click the row immediately below the column
heading and choose Window>Freeze Panes.
b. Click the column heading row and choose
Window>Freeze Panes.
c. Select the column headings and click the
Freeze Panes button on the Standard toolbar.
d. Click the column heading row, right-click and
choose Freeze Panes.
24. Which of the following
steps will print a specific
range of cells?
a. Select the range and click the Print button on
the Standard toolbar.
b. Choose File>Print and in the Print dialog box,
click Range and then key the range of the cells
to be printed (such as A1:C10).
c. Select the range, choose File>Print, in the Print
dialog box click Selection, and click Print.
d. Select the range, choose File>Print, in the Print
dialog box click Active Sheet, and click Print.
25. You have a worksheet that is eight pages
long when it is printed. You would like
the column headings to appear at the top
of each page. List the steps you need to
take to accomplish this task.
1. Choose File>Page Setup.
2. Click the Sheet tab.
3. Under Print, in the Rows to repeat at
top pane, key the range of cells
containing the column headings.
Which of the following is not an
option listed in the Save as
type box in the Save As dialog
box?
End of REVIEW
[Office 2003]