IASC 1P01 Lecture Notes - Lecture 6: Pie Chart, Line Chart, Dialog Box
28 Feb 2017
School
Department
Course
Professor
Document Summary
Columns and rows in a worksheet, can have more than one worksheets in a workbook. Open excel (defaults with 1 worksheet, can add more at the bottom left of the screen) Can sort rows by ascending/descending, or subsort. Calculations: formulas always begin with an = sign. Add labels to identify values/calculations and organize data. Use numbers or cells that contain numbers in a formula. Can contain +, -, * and / Order of operation matters, same in math. 3 ways to find the sum: numbers: =25+8, cell address: =a1+a2 function: =sum(a1+a2) Autosum is a command that automatically inserts a function into a cell to sum those cells. Cell addresses in a formula are relative to the location of the formula (changes cell address when the formula is copied into another cell) ex. Absolute reference is a cell address in a formula that does not change when the formula is copied (ex.
