| A | B |
|---|
| Purchase discounts are awarded as follows: 3% for salees of $300, 5% for sales of $500, and 9% for sales of $900 or more. What function is used to determine which discount is allowed based on the purchase price? | Lookup |
| Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This is an example of which operation? | Freeze |
| What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation? | Embed |
| Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use? | If |
| Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to calculate a final grade for each student. | Average |
| Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation? | Primary |
| What operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moves around the worksheet? | Freeze |
| What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month? | If |
| Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received? | Days360 |
| What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost? | Sum |
| What functin will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise? | If |
| What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily work counts 50%? | Average |
| A spreadsheet is created with drop down items that a user can select from. This is an example of which function? | List |
| In the formula +F10*$J$4, F10 is an example of a/an: | relative reference |
| In the formula +F10*$J$4, $J$4, is an example of a/an: | absolute reference |
| In the formula =A1+B1, $A1 is an example of a/an: | mixed reference |
| Which function can an accounting department use in Cell A2 that will result in the current date? | Now |
| What formula will divide the value in Cell E5 by the value in Cell E6? | =E5/E6 |
