GCFLearnFree.org

This site covers more than I ever dreamed.”

Online Learner

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

Excel 2007

Quiz

Question 1
How many sheets are there in a workbook by default?
A. One
B. Two
C. Three
D. Four
Question 2
Click the ____________ and select New to create a new blank workbook.
A. File menu
B. Ribbon
C. Home tab
D. Microsoft Office button
Question 3
True or False: You can change column width, but you cannot change row height.
A. True
B. False
Question 4
A cell is _________________.
A. an intersection of a row and column
B. another name for a worksheet
C. both A and B
D. neither A nor B
Question 5
True or False: You can use numbers or cell references in formulas.
A. True
B. False
Question 6
The ________ command removes information from the selected cell.
A. Copy
B. Paste
C. Remove
D. Cut
Question 7
The __________ command allows you to indicate specific rows or columns that will be repeated on each printed page.
A. Print Preview
B. Print Area
C. Print Titles
D. None of the above
Question 8
The AutoSum command is located on the _________ tab.
A. Function
B. Data
C. Formula
D. None of the above
Question 9
__________ is a common spreadsheet task that allows you to reorder data.
A. Grouping
B. Sorting
C. Formatting
D. None of the above
Question 10
True or False: When you Format as a Table, drop-down filter arrows automatically appear in the first row.
A. True
B. False
Question 11
Which of the following commands is not in the Alignment Group?
A. Merge & Center
B. Wrap Text
C. Align Center
D. Sort & Filter
Question 12
To group worksheets that are contiguous, or side by side, use the _____ key.
A. Shift
B. Control
C. F11
D. Enter
Question 13
True or False: You can download templates from Microsoft Office Online to use in Excel.
A. True
B. False
Question 14
True or False: Goal Seek is a type of what-if analysis you can use to find an input value to a problem if you know the result you need.
A. True
B. False
Question 15
True or False: When you insert a chart in Excel, it appears in the selected worksheet with the source data by default.
A. True
B. False
Question 16
Data Bars and Color Scales are types of _______________.
A. conditional formatting
B. table formatting
C. data formatting
D. none of the above
Question 17
True or False: Each column label in your spreadsheet becomes a field that can be used in the pivot table report.
A. True
B. False
Question 18
With _____________ you can change the formatting on cells that meet certain criteria such as above average, top 10 percent, or greater than/less than a specific amount.
A. Conditional Formatting
B. Reports
C. What-if analysis
D. Pivot tables
Question 19
True or False: When you use the Subtotal command, cells are grouped together.
A. True
B. False

Answers:

  • 1) C. Three
  • 2) D. Microsoft Office button
  • 3) B. False
  • 4) A. an intersection of a row and column
  • 5) A. True
  • 6) D. Cut
  • 7) C. Print Titles
  • 8) C. Formula
  • 9) B. Sorting
  • 10) A. True
  • 11) D. Sort & Filter
  • 12) A. Shift
  • 13) A. True
  • 14) A. True
  • 15) A. True
  • 16) A. conditional formatting
  • 17) A. True
  • 18) D. Pivot tables
  • 19) A. True
Terms Of Use

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