IST 195 Lecture Notes - Lecture 5: Negative Number, Ticketmaster, Spreadsheet
Document Summary
Important software tool that you will use. Because we live in a world of data, excel manipulates and reports data. Spreadsheet quiz 1: evaluate this spreadsheet formula. Percent or negative number your evaluate first. Formulas: addition, subtraction, multiplication, division, and etc put into excel. You can also create your own formulas. =if and then fill in the requirements such as if f2 is greater than. 70 you write pass and if not you write fail, so then when you hit enter then pass and fail will come up in each column. Allows you to set rules for cell formatting. Ex: if the word pass is there you want to condition that cell to have a green background and if a cell says fail you want to condition that cell to have a red background. Hit the conditional formatting button in the home tab. Use cells that contain to do this.