418
Description
Flashcards by Linda (tutor), updated more than 1 year ago
|
Created by Linda (tutor)
over 11 years ago
|
|
| 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 |
Want to create your own Flashcards for free with GoConqr? Learn more.