Microsoft Excel flashcards

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