Chapter 5 Flashcards
The process of summarizing data included on multiple worksheets on one worksheet like the one in the accompanying figure is called___
Consolidation
A ___ is a reference to a cell or range of cells in another workbook
link
A workbook contains ___worksheets by default.
one
A(n) ___reference is a formula that depends upon its own value
circular
Headers, footers, and margins are all ___ options.
page setup
It is recommended that you use the __ function on formulas that potential can result in more decimal places than the applied format displays.
round
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
Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.
F11
The ____ keyboard shortcut copies an image of the source area as a picture.
CTRL + U
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. Selected Answer: Correct auto fill Correct Answer: Correct auto fill
auto fill
The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.
linear
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 Sum button is ____.
(Home tab | Editing group)
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
When you insert a manual page break, Excel displays a(n) ____ line between pages.
dotted
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.
page
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.
page breaks
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
Which of the following format symbols displays text along with numbers entered in a cell?
quotation marks
Which of the following is the path to the Breaks button?
(Page Layout tab | Page Setup group)
Which of the following is the path to the Fill button?
(home tab | Editing Group)
Which of the following is the path to the Insert Cells button?
(Home tab | Cells group)
Which of the following is the path to the Switch Windows button?
(View tab | Window 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 switch to Page Layout view by clicking the Page Layout button ____.
on the status bar
You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.
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
___ format codes allow you to specify how a cell entry assigned a format will appear.
Custom