Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js

Functions and Formulae Level 2

Description

ICT (ICT ) Flashcards on Functions and Formulae Level 2, created by Linda (tutor) on 10/10/2012.
Linda (tutor)
Flashcards by Linda (tutor), updated more than 1 year ago
Linda (tutor)
Created by Linda (tutor) over 12 years ago
290
5
1 2 3 4 5 (0)

Resource summary

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
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom