Chapter 3- Excel 2010

Question 0

What will decrease the indent by three spaces each time you click it?

Answer 0

Decrease Indent Button

Question 1

The fill handle can be used to ______.

Answer 1

Copy a cell, copy a range of cells, and create a series of numbers or dates

Question 2

The Copy button copies the contents and format to the _____.

Answer 2

Office Clipboard

Question 3

What are valid format symbols?

Answer 3

Comma, percent sign, and dollar sign

Question 4

Excel displays the error message _____ in those cells that indicate a cell reference error.

Answer 4

REF!

Question 5

A cell reference of $B17 is an ______ cell reference.

Answer 5

Mixed

Question 6

One $ sign means it is _____.

Answer 6

Mixed

Question 7

Two $ signs means it is ______.

Answer 7

Absolute

Question 8

Excel displays error messages that begin with ____ to indicate when there has been an error.

Answer 8

#

Question 9

What specifies an invalid intersection of two areas?

Answer 9

NULL!

Question 10

If you know the result you want a formula to produce, you can use ________ to determine the value a cell on which the formula depends.

Answer 10

Goal seeking

Question 11

After the Paste button is clicked, Excel displays the ______ button.

Answer 11

Paste Option

Question 12

Using the mouse to move or copy cells is called ______.

Answer 12

Drag and drop

Question 13

The ______ on the shortcut menu allows you to insert rows between rows that already contain it.

Answer 13

Insert Command

Question 14

After inserting a single row with the Insert command, you can repeatedly press the ____ key to continue inserting rows

Answer 14

F4

Question 15

Excel allows you to _________, so that Excel displays the title on the screen no matter how far you scroll down.

Answer 15

Freeze the titles

Question 16

The __________ returns a number that corresponds to the system date and time beginning with December 31, 1899.

Answer 16

NOW Function

Question 17

Excel uses a technique called __________ to keep cell reference constant when copying a formula or function.

Answer 17

Absolute cell referencing

Question 18

If the value you want to assign to a cell is dependent on a logical test, use the ________.

Answer 18

IF Function

Question 19

You can ______ a slice of 3-D pie chart to make it stand out from the rest.

Answer 19

Explode

Question 20

You can magnify or shrink the appearance of a worksheet or chart by using the _______ button on the View tab on the Ribbon.

Answer 20

Zoom

Question 21

Accounting

Answer 21

$ is away from numbers

Question 22

$ is close to numbers

Answer 22

Currency