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