9.2 Spreadsheets Flashcards
1.1 Spreadsheet
A program which is used to store, add, delete and edit data.
1.2 Worksheet
A collection of cells organised in rows and columns.
1.3 Function
A specific set of operations that can be performed on referenced values.
1.4 Formatting
A way that we can modify the data’s appearance in a worksheet.
1.5 Formula
An expression made by the user that can perform calculations on values in a range of cells
2.1 Cell
A location of a piece of data in a spreadsheet.
2.2 Row
A row arranges data horizontally from left to right.
2.3 Column
A column arranges data vertically from top to bottom.
3.1 IF
Returns a value if the criteria is met, returns another if the criteria is not met.
3.2 SUM
Adds a specific range of values.
3.3 SUMIF
Adds a specific range of values if they meet the criteria.
3.4 MIN
Finds the minimum value out of a range of cells.
3.5 MAX
Finds the maximum value out of a range of cells.
3.6 COUNT
Counts the number of cells that contain numbers.
3.7 VLOOKUP
Allow a search for a value across a set range of columns.
3.8 Absolute Cell Referencing
A way of referencing a value in a specific cell. The cell reference will not change when the formula is copied.
4.1 +
Adds the data in two cells
4.2 -
Subtracts the data in one cell from another
4.3 *
Multiplies two numbers/cells
4.4 /
Divides the data in one cell by another
4.5 <
Less than
4.6 >
Greater than
4.7 <=
Less than or equal to
4.8 >=
Greater than or equal to