1. List and explain briefly mean, median, mode, and standard deviation. Give an example of when it each term could be used in a real-life situation.
2. Describe what the arguments are for this function: =SUMIF(range,criteria,sum_range). Give an example of when this function could be used in a real-life situation
3.List and explain briefly the five guidelines given by Edward R. Tufte (page158 of your textbook). Do not paraphrase -
4. Name any five of the eleven types of charts listed in Chapter 5 and give an example of where you would use the chart(s) if a business situation.
5. Briefly describe a business situation where you would use any three of the eight Highlight Cells Rules sub-menu options that are found on the Conditional Formatting drop-down menu. The options are Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, Duplicate Values, and More Rules.
6. Briefly describe each of the arguments in an IF function: IF(logical_test,value_if_true,value_if_false). Give an example of how the IF function could be used in a business situation
7. Write the correct syntax for the FIND function, and briefly describe each of its three arguments. Give an example of when the FIND function could be used in a business situation.
8. You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.
9. The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.
10. Give a real-life example of how you would apply Excel and the Problem-Solving Process you learned in this course.