418
Descrição
FlashCards por Linda (tutor), atualizado more than 1 year ago
|
Criado por Linda (tutor)
mais de 11 anos atrás
|
|
| Questão | Responda |
| 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 |
Quer criar seus próprios Flashcards gratuitos com GoConqr? Saiba mais.