Functions and Formulae Level 2

Linda (tutor)
Flashcards by , created over 6 years ago

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

Eye 255
Pin 5
Balloon left 0
Tags
Linda (tutor)
Created by Linda (tutor) over 6 years ago
Biometric Data
Hammo
General questions quiz
Hammo
Cultural Studies
Emily Fenton
The Berlin Crisis
Alina A
GPS
Hammo
Spreadsheet Level 1 Formula and Functions
Linda (tutor)
ICT revision
ben goddard
Data Protection Act
isabel.nemitz
Diary Management Software(DMS)
10syeda
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