CS100 Lecture Notes - Lecture 1: Boolean Algebra, Scatter Plot, Line Chart

• School: University of Waterloo
• Department: Computer Science
• Course: CS100
• Professor: Alexandra Boutros

Document Summary

Values can be text values (lables) or number values or date/time and boolean. Can reference cells instead by using the cell number ex. Pmt calculates the payment =pmt(rate, number of payments, principal value) Autofill for excel, bottom right corner and you can drag it. It can copy down the pattern or be the same as the formula if you are adding. Absolute references () keep the column and row the same (keep same cell) () keep the column the same but not the row (a) keep the row the same but not the column. Working with multiple worksheets: =sheet1!cell+sheet2!cell, this will add 2 values from 2 different cells. Can combine text together: cell& &cell& & cell, can use if(isblank) function for boolean logic, ex if all cells were filled you get kris kris kris if one is blank you get kris kris, ^ use cell& &if(isblank(cell),,cell& & cell.