Excel 2010

Quiz

Question 1

The ___________ lets you access commands no matter which tab you are on.

A. Mini-ribbon

B. Quick Access toolbar

C. Shortcut bar

D. Access All Commands button

Question 2

To merge two or more cells together, use the ___________ command.

A. Wrap Text

B. Format as Table

C. Autosum

D. Merge & Center

Question 3

Which number format should you use if don't want Excel to alter the formatting?

A. Text

B. Scientific

C. Time

D. Currency

Question 4

Which command should you use if you want to save your workbook with a different file name?

A. Save

B. Save As

C. Info

D. Options

Question 5

When a formula contains the address of a cell, it is called a(n) ___________.

A. address book

B. group

C. order of operations

D. cell reference

Question 6

Worksheets can be ___________.

A. named

B. color-coded

C. grouped

D. all of the above

Question 7

If you're printing a workbook and want certain rows and columns to appear on each page, you should use the ___________ command.

A. Orientation

B. Print Titles

C. Background

D. Print Area

Question 8

A cell reference that does not change when copied or filled is called a(n) ___________.

A. absolute reference

B. relative reference

C. concrete reference

D. immutable reference

Question 9

To select a common function such as SUM or AVERAGE, you can use the ___________ command.

A. CommonFunction

B. QuickSum

C. AutoSum

D. PivotTable

Question 10

If you want to alphabetize your rows, you should use the ___________ command.

A. Alphabetize

B. Filter

C. Sort

D. Merge & Center

Question 11

To automatically group and summarize your data, you can use the ___________ command.

A. Subtotal

B. AutoGroup

C. Conditional Formatting

D. Merge & Center

Question 12

You can use ___________ to narrow down the data in your worksheet or hide parts of it from view.

A. conditional formatting

B. borders

C. functions

D. filters

Question 13

True or False: Tables include filters on each column.

A. True

B. False

Question 14

True or False: When tracking changes, there are certain changes Excel does not track or highlight.

A. True

B. False

Question 15

Instead of creating a blank workbook, you can create one that's based on a predefined pattern called ___________.

A. a formula

B. clip art

C. a template

D. conditional formatting

Question 16

True or False: In a chart, the horizontal axis is always the category axis.

A. True

B. False

Question 17

One of the advantages of using sparklines is:

A. they have animated "sparks"

B. they are much larger than normal charts

C. you can keep them very close to their source data

D. they have more types and features than traditional charts

Question 18

Conditional formatting includes all of the following types EXCEPT:

A. Area lines

B. Color scales

C. Data bars

D. Icon sets

Question 19

Slicers are basically a type of ___________.

A. sparkline

B. row label

C. column label

D. filter

Answers:

1) B. Quick Access toolbar
2) D. Merge & Center
3) A. Text
4) B. Save As
5) D. cell reference
6) D. all of the above
7) B. Print Titles
8) A. absolute reference
9) C. AutoSum
10) C. Sort
11) A. Subtotal
12) D. filters
13) A. True
14) A. True
15) C. a template
16) B. False
17) C. you can keep them very close to their source data
18) A. Area lines
19) D. filter