418
Descripción
Fichas por Linda (tutor), actualizado hace más de 1 año
|
Creado por Linda (tutor)
hace más de 12 años
|
|
| Pregunta | Respuesta |
| 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 |
0 comentarios
¿Quieres crear tus propias Fichas gratiscon GoConqr? Más información.