MATH 1505 Lecture Notes - Lecture 8: Scenario Analysis, Pivot Table, Pie Chart
20 Aug 2016
School
Department
Course
Professor
Document Summary
Tips and formulas to remember: techniques and tools (excel basics) F4 function key: an easy way to toggle between the choices in absolute vs relative references: multiple ways to copy & paste: Fill handle (square at bottom right corner of cell) F2 function key shows computation directly at cell; colour codes each input cell and highlights each with its own colour within the spreadsheet: named ranges: attaches a text name to a cell. Can be used in place of the cell reference. Helps to make formulas more readable and easier to debug. To name a cell: insert; name; or type the name in the name box . Comments can be attached to each cell: insert; comment. F9 function key recalculates all formulas in spreadsheet. Cell references: you can refer to cells from other sheets (e. g. sheet1!a1) and other workbooks (e. g. [book1]sheet1!a1: summarizing and interpreting data.
