Lesson 5 Review

1
Lesson 5 Review
Lesson 5 Review

• Office 2003

2
Saving an Excel file as aWeb page converts it to
____ format.

1. Database
2. HTML
3. PRN
4. Word

3
2. Which of the following steps lets you open a
new workbook?

1. FilegtNew WorkbookgtTask Pane
2. FilegtNew
3. FilegtOpengtNew Task Pane
4. FilegtOpengtNew Workbook

4
3. You can move across a spreadsheet using ____.

1. TAB
2. HOME
3. ENTER
4. the Space bar

5
4. Which of the following steps lets you delete a
worksheet from a workbook?

1. EditgtWorksheetgtDelete
2. FilegtDeletegtWorksheet
3. EditgtDelete Sheet
4. FilegtDeletegtWorksheet

6
5. Which of the following allows you to move a
worksheet?

1. Choose EditgtMove or Copy
2. Click and drag on the sheet tab.
3. Right click on the sheet and click Move or Copy.
4. All of the above.

7
6. Which menu contains the commands Hide/Unhide?

1. Window
2. Edit
3. File
4. Data

8
7. The extension for a Web page is ____.

1. .xls
2. .prn
3. .htm or .html
4. .doc

9
8. To view an Excel file that has been converted
to a Web page choose ____.

1. WindowgtArrangegtWeb Page
2. FilegtSavegtWeb Page
3. FilegtWeb Page Preview
4. WindowgtWeb Page

10
9. Which toolbar contains the Print Preview
button?

1. Formatting
2. Standard
3. Function
4. Drawing

11
10. Which command allows you to change page
orientation?

1. Print Preview
2. Print Area
3. Web Page Preview
4. Page Setup

12
11. Which steps allow you to set up a print area?

1. WindowgtPrint Area
2. FilegtPrint AreagtSet Print Area
3. EditgtPrint AreagtSet Print Area
4. InsertgtSet Print Area

13
12. A ____ indicates the edge of the print area.

1. dotted line
2. Window
3. blank line
4. row of symbols

14
13. The Page Break Preview is found under the
____ menu.

1. Edit
2. Window
3. File
4. View

15
14. You can center your print area in the ____
tab on the Page Setup dialog box.

1. Header/Footer
2. Sheet
3. Page
4. Margins

16
15. If you want to print a range of cells only
one time, print it as a ____.

1. Selection
2. print area
3. Worksheet
4. Print Preview

17
16. In the Print dialog box which is NOT an
option for printing?

1. Entire workbook
2. Cell range
3. Selection
4. Active sheet(s)

18
17. Use the ____ command if you have several
workbooks open at once and want to be able to see
them all simultaneously.

1. Freeze Panes
2. Page Setup
3. Arrange
4. Window

19
18. In Page Break Preview, page breaks appear as
____.

1. solid red lines
2. separate windows
3. dotted blue lines
4. split windows

20
19. What does the pointer look like when you are
in Print Preview?

21
20. Which of the following is not an option
listed in the Save as type box in the Save As
dialog box?

1. .xls
2. .edt
3. .htm
4. .prn

22
21. If you want to specify that the a workbooks
file name appear at the top of every printed
page, go to the ____ tab in the ____ dialog box.

1. Header/Footer Page Setup
2. Page Page Setup
3. Properties Print
4. Sheet Print

23
22. If the data in a worksheet will not quite fit
on a printed page, you can try ____.

1. decreasing the size of the margins
2. increasing the size of the margins
3. adding a header
4. printing the entire workbook

24
23. Which of the following steps will make a
worksheets column headings always visible,
regardless of where you are in the worksheet?

1. Click the row immediately below the column
   heading and choose WindowgtFreeze Panes.
2. Click the column heading row and choose
   WindowgtFreeze Panes.
3. Select the column headings and click the Freeze
   Panes button on the Standard toolbar.
4. Click the column heading row, right-click and
   choose Freeze Panes.

25
24. Which of the following steps will print a
specific range of cells?

1. Select the range and click the Print button on
   the Standard toolbar.
2. Choose FilegtPrint and in the Print dialog box,
   click Range and then key the range of the cells
   to be printed (such as A1C10).
3. Select the range, choose FilegtPrint, in the Print
   dialog box click Selection, and click Print.
4. Select the range, choose FilegtPrint, in the Print
   dialog box click Active Sheet, and click Print.

26
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 FilegtPage 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.
27
Which of the following is not an option listed in
the Save as type box in the Save As dialog box?
28
End of REVIEW
End of REVIEW

• Office 2003