COMPSCI 1BA3 Chapter Notes -Summary Statistics, Semicolon, Dialog Box
8 Dec 2012
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.
