ADM 1370 Lecture Notes - Lecture 1: Decision Analysis, Data Management
Document Summary
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. Excel table can enhance presentation & facilitate sorting & filtering of data in the ranges. Spreadsheet: collection of text & numbers laid out in a rectangular grid: often used in business for accounting, budgeting, financial analysis, inventory mgmt. , etc. Worksheet (cid:862)chartsheet(cid:863): spreadsheet that may contain data including text, numbers, formulas, charts, etc. Workbook: collection of related worksheets w/in 1 file. Cell: each cell is referenced by its intersecting column (letter) & row (number): E. g. cell a1 = topmost left cell in spreadsheet. Cell reference is shown in the name box beside formula bar. Range: rectangular group of cells in a worksheet. Can be one single cell or may be entire worksheet.