Exam Review
(these are the quiz study guides, just assembled in one place for your convenience.)
Ch 8
- Ascending is low to high. Know the button for Ascending order
- Descending is high to low. Know the button for Descending order
- An IF function will make a decision based on a comparison
- =IF(<comparison>, <value if true>, <value if false>)
- the relational operators = (equal), < (less than), > (greater than), <= (less than or equal to), >= (greater than or equal to), <> (not equal to)
- Principal is the amount of money owed
- Interest in the rate that the amount owed grows
- Term is the length of the loan
- =PMT(rate, term, principal)
- 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.
Don't forget to be ready to do one of the exercises without any help.