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;
11 Cards in this Set
- Front
- Back
|
Spreadsheets Glossary
|
|
|
|
Absolute Cell Referencing
|
To freeze the cell in a formula so when you copy the cell down it doesn't change.
|
|
|
Conditional Formatting
|
Will alter the appearance of a cell depending on what it contains e.g. you can set up conditional formatting to turn a cell red if the number is less than zero.
|
|
|
IF Statement
|
An IF statement checks to see if a statement is true or false and then does one of two things depending on the result.
|
|
|
Data Types
|
A particular kind of data item as defined by the values it can take, the programming used, or the operations that can be performed on it. e.g. General, Currency, Number , Date and Time
|
|
|
Legend
|
Used to highlight a data series or some other feature.
|
|
|
SUM
|
The total amount resulting from the addition of two or more numbers, amounts or items.
|
|
|
AVERAGE
|
The simplest excel average formula for a set of values consists of the = sign, followed by the sum of the values, all divided by the number of values in this group.
|
|
|
MAX
|
A maximum amount or setting.
|
|
|
MIN
|
A minimum amount or setting.
|
|
|
Fill command
|
To copy the formula into all selected cells.
|
