ADM 1370 Study Guide - Final Guide: Lookup Table, Pearson Product-Moment Correlation Coefficient, Emv

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Umar Ruhi

Document Summary

You may be tested on your familiarity with concepts such as: Difference between absolute, relative, and mixed references. Purpose of decision analysis / what-if analysis tools such as conditional formatting, goal seek, and solver. While you are required to know the purpose of various excel features and functions that were discussed in class, you will not be asked to recall parameters for functions or their order: For example, you should know that vlookup allows you to search for values in a table that correspond to a lookup value, you will not be asked to write the function or specify what parameters are required. Excel: computerized spreadsheet application used to build & manipulate worksheets & workbooks. Program used to enter, analyze, & present (quantitative) data. Excel aids a multitude of problem-solving & decision-making processes through providing: data management features, automatic calculation functions, presentation tools, decision analysis functions.