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;
7 Cards in this Set
- Front
- Back
- 3rd side (hint)
|
Spreadsheet/ worksheet |
A file made of rows and columns that help sort data, arrange data easily, and calculate numerical data. |
|
|
|
Relative cell reference |
When copied across multiple cells it changes based on the relative position of rows and columns |
|
|
|
Absolute cell reference |
Remains constant when the reference is copied or moved to another cell or sheet |
|
|
|
Average |
Calculates the average of a range of cells |
=average (b1:b5) |
|
|
Count |
Counts the number of cells that contain numbers |
|
|
|
Countif |
Counts the number of cells that meet a given critera |
=countif (d1:d30,"=A") meaning count if ther is an A . |
|
|
If function |
Performs a logical test and returns one value for a TRUE result, and another for a FALSE result |
=if (logical test, true value, false value) |
