# Excel Module 5

## Unlock all answers in this set

question
A ____ is a reference to a cell or range of cells in another workbook.
question
A range that spans two or more worksheets in a workbook is called a ____ range.
3-d range
question
A(n) ____ reference is a formula that depends on its own value.
circular
question
Headers, footers, and margins are all ____ options
page setup
question
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
question
It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.
round
question
The ____ style is the format style that Excel initially assigns to all cells in a workbook.
normal
question
The code ____ instructs Excel to insert the page number in the header or footer section.
&[Page]
question
The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.
auto fill
question
The following sequence, 2, 4, 6, etc., is an example of a ____ series.
linear
question
The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.
date
question
The process of summarizing data included on multiple worksheets on one worksheet is called ____.
consolidation
question
To copy the contents of a cell to the cell directly below it, click the target cell and press ____.
ctrl + d
question
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
question
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
question
Which of the following format codes insures that Excel will display a decimal point in the number?
Period
question
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%)
question
Which of the following is the path to the Fill button?
home tab / editing group
question
Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?
CTRL+SHIFT+ASTERISK (*)
question
You can display the ____ tab to specify page setup options
page layout
question
You can drill all of the following down through a workbook EXCEPT ____.
groupings
question
You can drill all of the following down through a workbook EXCEPT ____.
on the status bar
question
You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or cre
custom
question
You should create good ____ to ensure your workbooks are free of errors.
test data
question
You should hold down the ____ key to select the nonadjacent cells.
ctrl
question
You should hold down the ____ key to select the nonadjacent cells.
false
question
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
question
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
question
Excel copies page setup characteristics when one sheet is copied to another.
false
question
If added, a footer appears at the bottom of every printed worksheet page.
true
question
Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.
false
question
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
question
If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.
false
question
The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook
true
question
The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.
false
question
The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.
True
question
The separate, individual workbooks from which you need data are called the dependent workbook.
false
question
The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers
true
question
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
question
To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.
false
question
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
question
You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.
false
question
You can enter formulas that reference cells on other worksheets in the workbook.
true
question
You can use the ENTER key to complete a paste operation.
true
question
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
question
A workbook contains ____ worksheet(s) by default.