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;
14 Cards in this Set
- Front
- Back
|
Cell Referencing is using a _____ __________ when writing a formula
|
Cell referencing is using a cell address when writing a formula.
|
|
|
A ________ is a built in formula that performs a calculation.
|
A function is a built in formula that performs a calculation.
|
|
|
An argument is the information inside the ______________ of a function.
|
An argument is the information inside the parentheses of a function.
|
|
|
Absolute cell reference- A cell reference that contains a ______ sign before the column letter and row number. A formula that contains an ________ cell address won't change when copied or filled to another cell location.
|
Absolute cell reference- A cell reference that contains a dollar sign before the column letter and row number. A formula that contains an absolute cell address won't change when copied or filled to another cell location.
|
|
|
Fill handle- The small square at the bottom of the ______ cell. The fill handle is used to ____ labels, formulas, and values.
|
Fill handle- The small square at the bottom of the active cell. The fill handle is used to copy labels, formulas, and values.
|
|
|
The undo button allows you to reverse the last how many previous actions?
|
The undo button allows you to reverse the last 16 actions
|
|
|
Control and what key is a short cut key to undo
|
Control and Z is a short cut for undo
|
|
|
The ________ border indicates the cell(s) used in a calculation
|
moving border indicates the cells used in a calculation
|
|
|
What is an example of an absolute cell reference?
|
$B$6
|
|
|
Which key on the keyboard deactivates the moving border?
|
escape or enter deactivates the moving border.
|
|
|
How many items can the office clipboard hold?
|
The office clipboard can hold up to 24 items.
|
|
|
When you copy formulas with _______ references, excel follows the pattern of the formula from the source formula to the new formula. Column letters and row numbers _______ based on the new location of the formula.
|
When you copy formulas with relative references, excel follows the pattern of the formula from the source formula to the new formula. Column letters and row numbers change based on the new location of the formula.
|
|
|
The counta function allows the user to count three types of data. What are they?
|
COUNTA allows the user to count alphanumeric, words, and numbers.
|
|
|
What function decreases decimal places?
|
ROUND function decreases decimal places.
|
