Chapter 8 Quiz 1 Study Guide
This is to help you study for your quiz over the first half of Chapter 8.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
- A What If Question asks how a value will impact results
- A function performs a calculation on data
- The data we provide a function is called the arguments
- Some basic functions and their corresponding calculation
---SUM - returns the sum of all the cells
---AVERAGE - averages (adds all the values and divides by the number of items)
---MAX - returns the largest value in a range
---MIN - returns the lowest value in a range
---ROUND - Rounds the cell by the decimal places specified, ROUND(A1,2) rounds A1 to 2 decimal places
- An absolute cell reference refers to a cell and will not change when filled or copied and pasted - for A1 the absolute reference would be $A$1
- The common Error Values
---#DIV/0 - divided by 0
--- #REF - invalid reference
--- #NUM - numeric value is too large or small
--- #VALUE - a value is incorrect, like using a label instead of a value
--- #### - column width is too small or a negative date or time value.