# Functions and Formulae Level 2

Flashcards by , created over 6 years ago

## ICT (ICT ) Flashcards on Functions and Formulae Level 2, created by Linda (tutor) on 10/10/2012.

255
5
0
 Created by Linda (tutor) over 6 years ago
Memory
Biometric Data
General questions quiz
Cultural Studies
The Berlin Crisis
GPS
Spreadsheet Level 1 Formula and Functions
ICT revision
Data Protection Act
Diary Management Software(DMS)
 Question Answer Function to return a value dependent on specific criteria =IF(A1>50, "Yes", "No") BODMAS The order of precedence when calculating numerical data Function used to calculate the AVERAGE value of a range of cells =Average(cellref:cellref) Function used to calculate the MAXIMUM value in a range of cells =MAX(cellref:cellref) Function used to calculate the MINIMUM value in a range of cells =MIN(cellref:cellref) Function used to calculate the SUM (total) of a range of cells =SUM(cellref:cellref) Function used to COUNT a range of cells which contain NUMERIC data =COUNT(cellref:cellref) Function used to ROUND the value in a range of cells to a set number of decimal places (e.g. 0, 1, 2) =ROUND(cellref,0) Function used to COUNT a range of cells which contain data =COUNTA(cellref:cellref) Function used to COUNT a range of cells which do not contain data =COUNTBLANK(cellref:cellref) Formula to MULTIPLY cells =cellref * cellref Formula to SUBTRACT data in cells =cellref - cellref Formula to DIVIDE numeric data in cells = cellref / cellref Formula to ADD numeric data together =cellref + cellref