COMPSCI 1BA3 Study Guide - Midterm Guide: Lookup Table, Flowchart, Dialog Box

• School: McMaster University
• Department: Computer Science
• Course: COMPSCI 1BA3
• Professor: Nicole Wagner

Document Summary

Spreadsheet software collection of text and numbers laid out in a rectangular grid; often used in business for budgeting, inventory; electronic versions are created through excel. What-if analysis change one or more values in a spreadsheet and asses the effect those changes have on the calculated values. Workbook can contain two types of sheets: worksheets and chart sheets. Worksheets grid of rows and columns where data values and formulas are entered. Chart sheets excel chart; visual representation of worksheet data. Multiple sheets allow for more specific division separating into categories. Include a documentation sheet to describe your workbook. Cell reference identifies a cell within a worksheet; indicates column and row location. A1 is always the default active cell. Planning analysis sheet finding workbook"s purpose and how to achieve the desired results (what do i want to solve; what data is needed; what calculations need to be entered; what form should it take)