1.                  Excel 2003 is a program best used for

A.                  Building large and complex databases.

B.                 Word processing.

C.                 Manipulating and editing text files.

D.                 Organizing, analyzing, and presenting data.

 

 

2.                  If you need help with Excel, you can find a table of contents link

A.                  On the help task pane.

B.                 On the standard toolbar.

C.                 By right clicking on the office assistant.

D.                 By selecting the table of contents option on the help menu.

 

 

3.                  A keyboard shortcut to create a new workbook is

A.                  Pressing the Ctrl + W keys.

B.                 Pressing the Ctrl + N keys.

C.                 Pressing the F1 key.

D.                 Pressing the Ctrl + S keys.

 

 

4.                  The Excel file menu provides options for

A.                  Editing your worksheets.

B.                 Formatting your worksheets.

C.                 Opening, saving, and printing your worksheets.

D.                 Connecting to Microsoft Office Online.

 

 

5.                  Which one of the following statements is true

A.                  A worksheet is a collection of workbook documents.

B.                 A .doc file extension implies that the file is an Excel workbook.

C.                 The active cell is located on the standard toolbar.

D.                 A workbook is a collection of one or more worksheets.

 

 

6.                  To save an existing workbook as a new file with a different name 

A.                  Click the Rename button on the Standard Toolbar.

B.                 Select File ® New File Name Save from the menu.

C.                 Select File ® Save As from the file menu.

D.                 Excel can’t save documents as new files with different names.

 

 

7.                  The zoom feature is used for

A.                  Selecting cells.

B.                 Exploring task panes.

C.                 Moving in a worksheet.

D.                 Changing the size of the viewing area on a work sheet.

 

 

8.                  To switch between worksheets in an Excel workbook 

A.                  Click the Switch button on the formatting toolbar.

B.                 Select File ® Switch from the file menu.

C.                 There is no way to switch between worksheets

D.                 Click the worksheet tabs near the bottom of the Excel screen

 

 

9.                  To save changes you made to an existing workbook without creating a new file

A.                  Click the save button on the standard tool bar.

B.                 Press the Ctrl + S keys.

C.                 A and B.

D.                 None of the above.

 

 

10.              In an Excel menu, three dots … following a menu item indicates

A.                    A dialogue box will be displayed when you click the menu item.

B.                    A sub menu will appear when you move your pointer over the menu item.

C.                   The feature has not yet been installed.

D.                   None of the above.