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;
23 Cards in this Set
- Front
- Back
|
Formula:
|
Instructs the software to perform a calculation
|
|
|
Cell Reference:
|
1. Indicates a cell’s location & instructions for how cell data
is to be copied. |
|
|
A # symbol:
|
Indicates a cell’s location & instructions for how cell data
is to be copied. |
|
|
Relative cell reference:
|
The cell value changes “relative” to the cell in
which it is being copied |
|
|
Absolute cell reference:
|
The cell remains constant when copied.
|
|
|
Absolute cell row reference:
|
Row remains constant when copied.
|
|
|
Absolute cell column reference:
|
: Column remains constant when copied.
|
|
|
Function:
|
Short cut formula
|
|
|
Argument:
|
Is when formulas use greater than, less than, equal to, and so on.
|
|
|
AutoSum feature:
|
Calculates the total for all cells above the feature when used
|
|
|
12. Three Dimensional Formula:
|
Allow for formulas to access data in other worksheets or other workbooks.
|
|
|
13. Quick access toolbar:
|
: In Microsoft Excel 2010, toolbar that contains buttons for commonly used program commands.
|
|
|
14. Insert Worksheet:
|
Shift + F11
|
|
|
15. Margins:
|
: the blank space that surrounds a document
|
|
|
16. Header:
|
Content that goes at the top of each page
|
|
|
17. Footer:
|
Content that goes at the bottom of each page.
|
|
|
18. Filter:
|
allows user to display only the data that meets specific criteria
|
|
|
19. Sorting:
|
allows the user to control the order in which the data is presented in the worksheet.
|
|
|
20. NOW():
|
Returns the current date and time formatted as a date and time
|
|
|
21. IF function:
|
checks to see if a condition is met (logical test).
|
|
|
22. Paste:
|
CTRL + V
|
|
|
23. Arrange:
|
When working with multiple workbooks, this command on the View ribbon allows a user to organize the workbook windows so that all are visible
|
|
|
24. Split
|
This command on the View tab will divide a worksheet into multiple panes allowing more cells to be visible
|
