ADM 1370 Study Guide - Final Guide: Standard Deviation, Sensitivity Analysis, Negative Number

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Craig Kuziemsky

Document Summary

Most popular spreadsheet tool today, simple data management, problem solving and complex decision making, critical thinking and decision making skills. Four skills required for future job roles: abstract reasoning skills, systems thinking skills, collaboration skills, experimentation skills. Data management features, automatic calculation functions, presentation tools, decision analysis functions. Computerized spreadsheet application used to build and manipulate worksheets and workbooks. Worksheet: spreadsheet that may contain data including text, numbers, formulas, charts, charts are chart sheets. Workbooks: a collection of related worksheets within one file. File tab: file operations (open, saving, printing), options and features part of backstage view. Tabs and ribbon: corresponds to sets of features displayed horizontally as a ribbon, groupings and controls, designed to be task-oriented and consist of several logical groupings of controls that perform similar functions. Quick access toolbar: contains controls/commands that are the most commonly used, added through office button. Select all: used to select all elements of the worksheet.