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.
