Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
|
When creating panes in a worksheet, the bar going across the middle of the window is called the ____.
|
horizontal split bar
|
|
|
Excel automatically formats the date stamp to the date and time format ____.
|
mm/dd/yyyy hh:mm
|
|
|
To display the original worksheet after answering a what-if question, click the ____ button for each value you changed.
|
Undo
|
|
|
The ____ entry of the IF function is made up of two expressions and a comparison operator
|
logical_test
|
|
|
You can use the fill handle to ____.
|
all of the above
|
|
|
A cell reference with only one dollar sign before either the column or the row is called a(n) ____.
|
mixed cell reference
|
|
|
The ____ is a reserved place in a computer's memory that allows you to collect text and graphic items from an Office document and then place them into any Office document.
|
Office Clipboard
|
|
|
Which of the following comparison operator means greater than or equal to?
|
>=
|
|
|
An alternative to clicking the Paste button is to ____.
|
press the ENTER key
|
|
|
The underline format will underline ____.
|
only the characters in the cell
|
|
|
The ____ command removes selected cells from the worksheet and shifts the remaining rows up or shifts the remaining columns to the left.
|
Delete
|
|
|
With a 3-D pie chart, you can explode ____ of the slices.
|
all
|
|
|
To turn off Freeze Panes, click ____ on the Freeze Panes gallery.
|
Unfreeze Panes
|
|
|
When creating panes in a worksheet, the bar going up and down the middle of the window is called the ____.
|
vertical split bar
|
|
|
A(n) ____ instructs the paste operation to keep the same cell reference as it copies a formula from one cell to another.
|
absolute reference
|
|
|
If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which a formula depends.
|
goal seeking
|
|
|
A ____ function is one in which the action taken for the true or false case includes yet another IF function
|
Nested IF
|
|
|
When first entering text in Excel, its angle is ____ degrees.
|
0
|
|
|
A formula using a(n) ____ reference instructs Excel to adjust the cell reference as it copies it to a destination area.
|
relative cell
|
|
|
The ____ on the status bar can be used to change the size of entries to make them more readable.
|
Zoom slider
|
