Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/36

Click to flip

36 Cards in this Set

  • Front
  • Back
The process of summarizing data included on multiple worksheets on one worksheet is called _____.
consolidation
_____ format codes allow you to specify how a cell entry assigned a format will appear.
Custom
You document a workbook by adding _____ to cells that contain complex formulas.
comments
Excel allows you to work with separate workbooks in a _____ and then link the workbooks to provide a consolidated view of the data in the workbooks.
workspace
_____ often are used when creating an initial consolidated worksheet to guide users of the worksheet regarding what type of data to enter in cells.
Placeholders
In consolidated worksheets with more complex formulas, you may want to use _____ that test the extreme boundaries of valid data.
numbers
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 enter _____ in a cell to display tomorrow's date.
=NOW()+1
You can use the _____ function to change a year, month, and day to a serial number.
DATE
You should create good _____ to ensure your workbooks are free of errors.
test data
The following sequence, Jan, Feb, Mar, etc., is an example of a _____ series.
date
The following sequence, 1, 1, 1, etc., is an example of a _____ series.
fill
The following sequence, 2, 4, 6, etc., is an example of a _____ series.
linear
The following sequence, 1, 2, 3, etc., is an example of a _____ series.
linear
Which of the following is the path to the Fill button?
(Home tab | Editing group)
To fill a linear series using the fill handle, hold down the _____ key as you drag through the range.
CTRL
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 path to the Sum button is _____.
(Home tab | Editing group)
You can change from Enter mode or Edit mode to Point mode by typing the _____ sign or symbol followed by clicking a cell.
=
To copy the contents of a cell to the cell directly below it, click the target cell and press _____.
CTRL+D
The path to the Accounting Number Format button is _____.
(Home tab | Number group)
Which of the following format codes insures that Excel will display a decimal point in the number?
. (period)
Which of the following format symbols displays text along with numbers entered in a cell?
" " (quotation marks)
You should click _____ in the Category list on the Number tab in the Format Cells dialog box to select or create a format code.
Custom
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%)
You can open a workbook each time you start your computer by copying the workbook file to the _____ folder located in the All Programs list.
Startup
A workbook contains _____ worksheets by default.
three
Which of the following is the path to the Insert Cells button?
(Home tab | Cells group)
Which of the following can you drill through a workbook?
All of the above
A range that spans two or more sheets in a workbook is called a _____ range.
3-D
To select noncontiguous sheets, hold down the _____ key as you select the sheets.
CTRL
A(n) _____ reference is a formula that depends on its own value.
circular
Headers, footers, and margins are all _____ options.
page setup
Pressing the _____ keyboard shortcut keys pastes an image of the source area as a picture.
CTRL+U
You can switch to Page Layout view by clicking the Page Layout button _____.
on the status bar
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