COMPSCI 1BA3 Chapter Notes -Dialog Box, Numerical Analysis, Summary Statistics
12 Sep 2013
School
Department
Course
Professor
Document Summary
Use excel to do quantitative analysis (numerical analysis) What are the things you want to keep in mind when creating a workbook (planning, etc. Three different data types used in excel: dates, numbers, text. Why is it important to know the difference between those. On first tab create documentation tab telling people how to use it, what its about, etc. Spreadsheet: collection of text and numbers laid out in rectangular grid (used in business for budgeting, inventory management, decision making) What-if-analysis: when you change one or more values in a spreadsheet and assess the affect those changes have on the calculated values. Use excel to store data, generate reports, analyze data. Workbook can have two types of sheets: worksheet: contains grid of rows and columns where user enters data, chart sheet: contains excel chart providing visual representation of worksheet data. Having multiple sheets allow you to better organize data in the workbook.
