Excel 2003

Quiz

Question 1

A cell:

A. is an intersection of a column and a row

B. has a unique cell address

C. is neither A nor B

D. is both A and B

Question 2

Microsoft Excel is what type of program?

A. Database

B. Email

C. Spreadsheet

D. Word processor

Question 3

A document was saved to your disk and you want to open it for editing. Which menu do you select?

A. Edit

B. File

C. Open

D. View

Question 4

True or False: The AutoSum function is used to create a formula that includes a range of cells.

A. True

B. False

Question 5

All formulas in Excel begin with the following symbol:

A. =

B. +

C. %

D. #

Question 6

Which formula below will add the value of B2 to the value of C3?

A. =B2+C3

B. =C3+B2

C. =SUM(B2+C3)

D. All of the above

Question 7

The easiest way to select an entire row is to _____.

A. choose the Select option in the Edit menu

B. click both the first entry and last entry in the row

C. click the row heading

D. double-click any cell in the row

Question 8

True or False: A workbook defaults to three worksheets. Additional worksheets can be created.

A. True

B. False

Question 9

True or False: If a cell shows ######, it means you must insert a column.

A. True

B. False

Question 10

Which of the following operations CANNOT be performed in the Alignment tab of the Format Cells dialog box?

A. Change text orientation

B. Color a cell background

C. Merge cells

D. Wrap text

Question 11

You want to insert a column between column A and column B. Which of the following needs to be done?

A. All of the information in the worksheet needs to be retyped

B. Insert a column by selecting the Columns selection on the Edit menu

C. Insert a column by selecting the Columns selection on the Insert menu

D. Create a new worksheet

Question 12

The quickest way to create and edit your charts is to use the:

A. Tools menu

B. Chart toolbar

C. View function

D. Format Dialog box

Question 13

Which of the following is NOT a chart type in Excel?

A. Bar

B. Pie

C. Pin

D. Line

Question 14

True or False: A chart created on the same worksheet as the source data is called a chart sheet.

A. True

B. False

Question 15

Which dialog box allows you to add headers and footers to a document?

A. Save As

B. Page Setup

C. View Options

D. Filter Data

Question 16

True or False: A dialog box will appear before you delete a worksheet even if the worksheet does not contain data.

A. True

B. False

Question 17

Grouping worksheets allows you to:

A. apply identical formulas across all of the worksheets in a group

B. apply identical formatting across all of the worksheets in a group

C. make changes to all of the worksheets in a group by changing only one of the worksheets

D. do all of the above

Question 18

The Merge and Center button:

A. is only available when worksheets are grouped

B. is used to center vertically only

C. allows you to select one or more cells and merge them into a larger cell

D. is a button on the Drawing toolbar

Question 19

The source data is:

A. the range of cells that makes up a chart

B. the same thing as an axis

C. both A and B

D. neither A nor B

Answers:

1) D. is both A and B
2) C. Spreadsheet
3) B. File
4) A. True
5) A. =
6) D. All of the above
7) C. click the row heading
8) A. True
9) B. False
10) B. Color a cell background
11) C. Insert a column by selecting the Columns selection on the Insert menu
12) B. Chart toolbar
13) C. Pin
14) B. False
15) B. Page Setup
16) B. False
17) D. do all of the above
18) C. allows you to select one or more cells and merge them into a larger cell
19) A. the range of cells that makes up a chart