Reference no: EM132674323
-What is mean, median, mode, and standard deviation and an example of when each term might be used in a real-life situation.
-What the arguments are for this function: =SUMIF(range,criteria,sum_range) and an example of when this function could be used in a real-life situation.
-In which business scenario would you use three of the eight options in the Cell Highlighting Rules submenu found in the Conditional Formatting drop-down menu. Options are Greater Than, Less Than, Between, Equal To, Containing Text, A Date Occurs, Duplicate Values, and More Rules.
-What are 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
-What is the correct syntax for the FIND function and what are its three arguments and an example of when the FIND function could be used in a business situation.
-You can use up to three levels of security and protection to control who can access and change your Excel data, and specify two of the three levels and how you access each of them.
-Real life example of how you would apply Excel and the problem solving process