Excel module 5

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

link

A range that spans two or more worksheets in a workbook is called a ____ range.

3-d range

A workbook contains ____ worksheet(s) by default.

…

A(n) ____ reference is a formula that depends on its own value.

circular

Headers, footers, and margins are all ____ options

page setup

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.

ungroup sheets

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

round

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

normal

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

&[Page]

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

auto fill

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

linear

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

date

The path to the Comma Style button is ____.

…

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

consolidation

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

ctrl + d

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.

shift

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.

CTRL

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

Period

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

0.00%;[Blue](0.00%)

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

home tab / editing group

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

CTRL+SHIFT+ASTERISK (*)

You can display the ____ tab to specify page setup options

page layout

You can drill all of the following down through a workbook EXCEPT ____.

groupings

You can drill all of the following down through a workbook EXCEPT ____.

on the status bar

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or cre

custom

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

test data

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

ctrl

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

false

As you develop more sophisticated workbooks, it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

true

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

true

Excel copies page setup characteristics when one sheet is copied to another.

false

If added, a footer appears at the bottom of every printed worksheet page.

true

Excel’s capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

false

If multiple sheets are selected and you want to select a sheet that is selected, but not active, click the sheet tab you want to select.

true

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

false

The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook

true

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

…

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.

false

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

True

The separate, individual workbooks from which you need data are called the dependent workbook.

false

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers

true

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

true

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

false

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

true

When you use the SUM function, Excel assumes that all contiguous numbers should be summed.

…

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

false

You can enter formulas that reference cells on other worksheets in the workbook.

true

You can use the ENTER key to complete a paste operation.

true

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

flase

A workbook contains ____ worksheet(s) by default.

one

The path to the Comma Style button is ____.

(Home tab | Number group)

The path to the Sum button is ____.

Home tab | Editing group)

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

true