01:198:110 Lecture Notes - Lecture 25: Cash Flow, Multiplication Sign, Order Of Operations

• School: Rutgers University
• Department: Computer Science
• Course: 01:198:110
• Professor: Alan Belowich

Document Summary

*need to use excel, free to rutgers students and provided on all rutgers computers. Computer app used for organization, analysis, and storage of data number crunching". Data is arranged in rows and columns. Data can be manipulated and used in calculations. When reading a spreadsheet - columnrow" (a3) Columns past z begin again with aa, ab, ac, etc. Labels - headers (jan - dec)/text/combo num and letter (fy2018) Plug in different values to see how they affect the outcome. If i score 120 points on the final i"ll get a b+ in that class. What is entered: values, labels, formulas, functions (built in formulas), order of operations (applied) Secondary sort - if sorting first names alphabetically and two names are ranked the same, will resort to deciding their position through secondary sort choice like their major. Spreadsheets can be used as databases (sorting and analyzing data) Cell - each individual box on the spreadsheet (a3)