GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Quiz

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
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.