ADM 1370 Lecture Notes - Lecture 5: Microsoft Excel, Status Bar, Decision Analysis

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Sadiq Abbas

Document Summary

Microsoft office excel a computer program used to enter, analyze, and present (quantitative) data. A spreadsheet program a collection of text and numbers laid out in a rectangular grid: often used in business for accounting, budgeting, financial analysis, inventory management and other functions. Excel aids a multitude of problem-solving & decision-making process through providing: data management features, automatic calculation functions, presentation tools, decision analysis functions. Worksheet a spreadsheet that may contain data including text, numbers, formulas, charts, etc. Workbook a collection of related worksheets within one file. File tab: consists of file operations commands such as opening, closing, saving, printing, and sharing files, the options and features are part of the (cid:862)(cid:271)a(cid:272)kstage (cid:448)ie(cid:449)(cid:863) Quick access toolbar: contains controls/ commands that are most commonly used. Additional controls can be added through excel options settings through office button. Select all button: used to select all elements of the worksheet.