C268 Spreadsheets Question and Answers 100% Correct
C268 Spreadsheets Question and Answers 100% Correct Relative Cell Reference - Cell reference that automatically updates when a formula is pasted into a new cell Absolute Cell Refernce - Cell reference that remains constant when a formula is pasted into a new cell $ - Used to make a cell absolute. Goes in front of the part you want to remain constant. SUM function - =SUM() when you want to add a group of numbers together COUNT function - =COUNT() Counts the number of cells in a range of cells that contain numbers COUNTA function - =COUNTA() Counts the number of cells in a range that are not blank AVERAGE function - =AVERAGE() Calculates the simple average of a set of numbers MAX function - =MAX() Returns the largest value in a set of numbers
Información del documento
- Subido en
- 5 de abril de 2024
- Número de páginas
- 5
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
