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
Document information
- Uploaded on
- April 5, 2024
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers