CS100 Lecture Notes - Lecture 4: Tab Key, Dollar Sign
30 Oct 2017
School
Department
Course
Professor
Document Summary
Module 4. 2 values: all formulas begin with the equal sign, excel keeps track of the number of dates as the number of dates since january 1. 1900 (don"t need to know this: entering a text is also a value (called labels, typing in true or false is called a bullion value, 4 different type of values: number, text, date and time, bullion. Module 4. 3 formulas and expressions: 1+1 (expression): + operator, =1+1 is not a valid formula in math, but in excel we will just call it a formula. Module 4. 4 order of operations: bedmas. Module 4. 5 functions: functions in excel will have function name and parameters, ex: =sum(10,5,20, can combine functions (ex. Module 4. 6 references and ranges: referencing cells (ex. d2, can do ranges as well (ex. b1:b5), specify upper left cell and bottom right cell. Module 4. 6 pmt example: function called pmt that calculates payment.
