Chapter 5

Question 1

The process of summarizing data included on multiple worksheets on one worksheet like the one in the accompanying figure is called___

Answer 1

Consolidation

Question 2

A ___ is a reference to a cell or range of cells in another workbook

Answer 2

link

Question 3

A workbook contains ___worksheets by default.

Answer 3

one

Question 4

A(n) ___reference is a formula that depends upon its own value

Answer 4

circular

Question 5

Headers, footers, and margins are all ___ options.

Answer 5

page setup

Question 6

It is recommended that you use the __ function on formulas that potential can result in more decimal places than the applied format displays.

Answer 6

round

Question 7

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ___ from the shortcut menu.

Answer 7

Ungroup sheets

Question 8

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Answer 8

F11

Question 9

The ____ keyboard shortcut copies an image of the source area as a picture.

Answer 9

CTRL + U

Question 10

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

Answer 10

normal

Question 11

The code ____ instructs Excel to insert the page number in the header or footer section.

Answer 11

&[PAGE]

Question 12

The following sequence, 1, 1, 1, etc., is an example of a(n) \_\_\_\_ series.
Selected Answer:	
Correct auto fill
Correct Answer:	
Correct auto fill

Answer 12

auto fill

Question 13

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.

Answer 13

linear

Question 14

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

Answer 14

linear

Question 15

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

Answer 15

Date

Question 16

The path to the Sum button is ____.

Answer 16

(Home tab | Editing group)

Question 17

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

Answer 17

CTRL + D

Question 18

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

Answer 18

Shift

Question 19

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

Answer 19

CTRL

Question 20

When you insert a manual page break, Excel displays a(n) ____ line between pages.

Answer 20

dotted

Question 21

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

Answer 21

page

Question 22

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ that show the boundaries of what will print on each page.

Answer 22

page breaks

Question 23

Which of the following format codes insures that Excel will display a decimal point in the number?

Answer 23

. (period)

Question 24

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

Answer 24

0.00;Blue

Question 25

Which of the following format symbols displays text along with numbers entered in a cell?

Answer 25

quotation marks

Question 26

Which of the following is the path to the Breaks button?

Answer 26

(Page Layout tab | Page Setup group)

Question 27

Which of the following is the path to the Fill button?

Answer 27

(home tab | Editing Group)

Question 28

Which of the following is the path to the Insert Cells button?

Answer 28

(Home tab | Cells group)

Question 29

Which of the following is the path to the Switch Windows button?

Answer 29

(View tab | Window group)

Question 30

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Answer 30

CTRL + SHIFT+ASTERISK (*)

Question 31

You can display the ____ tab to specify page setup options.

Answer 31

page layout

Question 32

You can switch to Page Layout view by clicking the Page Layout button ____.

Answer 32

on the status bar

Question 33

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Answer 33

Custom

Question 34

You should create good ____ to ensure your workbooks are free of errors.

Answer 34

test data

Question 35

You should hold down the ____ key to select the nonadjacent cells.

Answer 35

CTRL

Question 36

___ format codes allow you to specify how a cell entry assigned a format will appear.

Answer 36

Custom