 |
| 1 | |
Describe the select method of creating a formula and explain why it is more accurate than the keyboard technique. |
| | |
|
|
|
| 2 | |
Name the three types of cell references used in Excel formulas and describe with an example how each is used. |
| | |
|
|
|
| 3 | |
Describe the purpose of the IF function and give an example of how it might be used in an Excel worksheet. (Answers may vary.) |
| | |
|
|
|
| 4 | |
Explain the main difference between the two principal types of LOOKUP functions and briefly describe what they do. |
| | |
|
|
|
| 5 | |
Suppose you have a worksheet with cash amounts you have received for a fundraiser. You need to add up all of the amounts over $100 because those will be matched by an outside company. What function would be the best to use and how would you use it? |
| | |
|
|