|
Created by christina Littlewood
about 4 years ago
|
|
A function within Microsoft Excel that adds together the contents of a number of cells.
A function within Microsoft Excel that calculates the mean (average) of a list of numbers.
A collection of records where each record is made up of fields for the individual data items (e.g. name, address, etc.).
A function within Microsoft Excel that looks at the cells within a given range and counts the number of these cells that meet a given condition.
A set of instructions used to perform a calculation in a spreadsheet. A formula can include cell references, numbers, mathematical symbols and, in some cases, pre-defined functions.
A function within Microsoft Excel that looks at a given condition and performs an operation if the condition is met, or a different operation if the condition is not met.
A function within Microsoft Excel which looks up data using the first row or the first column of a range of cells and returns a relative value.
Consisting of numbers: real, integer or fixed decimal.
Function within Microsoft Excel that rounds a number up to a specified number of decimal places
Function within Microsoft Excel that returns a number between 0 and 59 as the number of seconds shown on a clock from a given time
Software used for performing calculations and for modelling situations using data arranged in a grid consisting of rows and columns
Function within Microsoft Excel that looks at the cells within a given range and adds the total from those cells that meet a given condition
Function within Microsoft Excel that looks up data using data organised in vertical columns
A single sheet in an excel file
A set of sheets in an Excel file