Excel XP

Quiz

Question 1

Microsoft Excel is what type of program?

A. Word processor

B. Email

C. Spreadsheet

D. Database

Question 2

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

A. Edit

B. Open

C. File

D. View

Question 3

True or False: Columns go up and down and have number labels.

A. True

B. False

Question 4

True or False: The AUTOSUM command is used to find the average of a range of numbers.

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. =C3+B2

B. =SUM(B2+C3)

C. =B2+C3

D. All of the above

Question 7

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

A. double-click any cell in the row

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

C. click the row heading

D. choose the Select option in the Edit menu

Question 8

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

A. True

B. False

Question 9

True or False: To change the color and size of text in a spreadsheet, you would first need to format the text in Microsoft Word.

A. True

B. False

Question 10

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

A. A new worksheet needs to be created

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. Retype all of the information in the worksheet

Question 11

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

A. True

B. False

Question 12

Which menu would you select to print a worksheet?

A. Print

B. File

C. View

D. Format

Question 13

You want to create a chart to provide a picture image of the data in your spreadsheet. Which menu do you select?

A. Tools

B. Data

C. Edit

D. Insert

Question 14

Which of the following chart types is NOT a valid Excel chart?

A. Pie

B. Bar

C. Pin

D. Line

Question 15

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

A. True

B. False

Question 16

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

A. Page Setup

B. Filter Data

C. View Options

D. Save As

Question 17

True or False: An embedded chart cannot be deleted from a spreadsheet.

A. True

B. False

Question 18

True or False: AutoFit is a term associated with adjusting column widths and row heights.

A. True

B. False

Question 19

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

A. Wrap text

B. Merge cells

C. Change text orientation

D. Color a cell background

Answers:

1) C. Spreadsheet
2) C. File
3) B. False
4) B. False
5) C. =
6) D. All of the above
7) C. click the row heading
8) B. False
9) B. False
10) C. Insert a column by selecting the Columns selection on the Insert menu
11) A. True
12) B. File
13) D. Insert
14) C. Pin
15) B. False
16) A. Page Setup
17) B. False
18) A. True
19) D. Color a cell background