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
