Computer 1

Remember, this quiz is a little different in that it's a exercise that you'll need to complete. Here's a couple helpful hints:
- know your relational operators (> greater than. < less than. <= less than or equal to. >= greater than or equal to. <> not equal to. )
- know your wildcards (* will match anything while ? Only matches one character) Example: starts in "s" would be s* or ends in "ing" would be "*ing"
- know how to turn a range of dates into a relational operator critera. Example: between 1/1/08 and 1/31/08 would be >=1/1/08 AND <=1/31/08
- its very logical, so remember what you've

This is to help you study for your Quarter 2 Exam, over chapters 10 and 11.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
Click Read More below to read the study guide.

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)

Our exam is coming soon. Instead of giving you a test over the 2 chapters from this quarter, I'll be rolling the test and exam grade together. This means that your exam is worth both an exam grade and a test grade. It's important to do well on the exam.

Here's what you need to know for the exam:
Any information in a quiz study guide or any question asked on a quiz.
Be ready to complete one of the exercises from each chapter in class without any help. I'll pick one exercise from each chapter and hand out the instructions on the exam day. You'll turn in your completed answers taken from the quiz study guides and the print of your completed exercise for your grade.
If you understand the concepts and steps from the chapters, you'll do great on the exam!

Chapter 8 Quiz 2 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.
- Ascending is low to high. Know the button for Ascending order
- Descending is high to low. Know the button for Descending order
- An IF fucnction 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)

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.