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
Instructs the software to perform a calculation
|
Formula
|
|
Indicates a cell’s location & instructions for how cell data
is to be copied. |
Cell Reference
|
|
Will be displayed when there is not enough room to
display the entry. |
A # symbol
|
|
The cell value changes “relative” to the cell in
which it is being copied |
Relative cell reference
|
|
The cell remains constant when copied.
|
Absolute cell reference
|
|
Row remains constant when copied.
|
Absolute cell row reference
|
|
Column remains constant when copied.
|
Absolute cell column reference
|
|
Short cut formula
|
Function
|
|
Is when formulas use greater than, less than, equal to, and so on.
|
Argument
|
|
Calculates the total for all cells above the feature when used
|
AutoSum feature
|
|
Allow for formulas to access data in other worksheets or other workbooks.
|
AutoSum feature
|
|
In Microsoft Excel 2010, toolbar that contains buttons for commonly used program commands.
|
Three Dimensional Formula
|
|
Shift + F11
|
Quick access toolbar
|
|
the blank space that surrounds a document
|
Insert Worksheet
|
|
Content that goes at the top of each page
|
Margins
|
|
Content that goes at the bottom of each page
|
Header:
|
|
allows user to display only the data that meets specific criteria
|
Footer
|
|
allows the user to control the order in which the data is presented in the worksheet.
|
Filter
|
|
Returns the current date and time formatted as a date and time
|
Sorting
|
|
checks to see if a condition is met (logical test).
|
NOW():
|