Excel Modified True/False & Matching – Flashcards
Unlock all answers in this set
Unlock answersquestion
True/Columns
answer
In a worksheet, columns typically contain information that is similar to a list
question
True/Range
answer
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8 is called a range.
question
True/splitting
answer
The opposite of merging a cell is splitting a merged cell.
question
False/Highest
answer
The Top (correct: highest) status bar is used to display the highest value in the selected range in the AutoCalculate area.
question
True/Redo
answer
If you accidentally undo an action, you can use the Redo button to redo it.
question
False/Data presentation
answer
In designing a worksheet, visual aesthetics (correct: data presentation) should come first
question
True/Cooler
answer
Cooler colors tend to pull away from the reader.
question
True/12
answer
You can choose from 12 categories of formats in the Format Cells dialog box.
question
True/Function
answer
You can replace a formula with its function so it remains constant
question
True/CTRL+ACCENT MARK ( ' )
answer
You can press the CTRL+ACCENT MARK ( ' ) keys to display the formula in a worksheet.
question
HOME
answer
Selects the cell at the beginning of the row that contains the active cell
question
CTRL+F
answer
Displays the Find dialog box.
question
END
answer
Selects the cell one worksheet window to the right
question
ARROW
answer
Selects the adjacent cell in the direction of the arrow key
question
SHIFT+RIGHT ARROW
answer
Highlights one or more adjacent characters to the right.
question
BACKSPACE
answer
Should not be used to clear a cell.
question
SPACEBAR
answer
Deletes characters to the left of the insertion point.
question
CTRL+HOME
answer
Selects cell A1
question
INSERT
answer
Toggles between Insert and Overtype mode
question
ALT+PAGE DOWN
answer
Moves the insertion point to the end of data in a cell
question
MAX
answer
A function that displays the highest value in a range
question
CTRL+C
answer
Copies a formula
question
Function
answer
A prewritten formula built into Excel.
question
CTRL+1
answer
Wraps text in a cell
question
F7
answer
Spell checking a worksheet
question
Circular Reference
answer
A formula in a cell that contains a reference back to itself
question
CTRL+V
answer
Pastes a formula
question
ALT+ENTER
answer
Opens the format cells dialog box
question
Order of Operations
answer
Negation comes first in this
question
CTRL+ACCENT MARK ( ' )
answer
Displays the worksheet with formulas
question
Fill Formatting Only
answer
Fills a destination area using the format of the source area; no content is copied
question
Fill Series
answer
Pastes the contents, format, and styles of the source area.
question
Goal Seeking
answer
The default option to fill an area
question
NOW Function
answer
Returns a number that corresponds to the system date and time beginning with December 31, 1899
question
Keep Source Formatting
answer
Keeps a cell reference constant when copying a formula or function.
question
IF function
answer
Assigns a value based on a logical test
question
#NAME?
answer
Indicates a cell is using a name Excel does not recognize
question
NUM!
answer
Indicates a cell that uses a number incorrectly
question
What-if analysis
answer
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell
question
Absolute cell referencing
answer
Determines the value of a cell on which the formula depends.
