ISYS104 Study Guide - Final Guide: Ed Sheeran, Electrical Contacts, Referential Integrity
2 Aug 2018
School
Department
Course
Professor
Document Summary
Cell referencing: all cells can be copied across cells, in a specific format. column b and row 1 do not change in values. Maximum and minimum: gets the largest and smallest value in a set of numbers, respectively. Sumif: sumif adds the value in the sum range if it fulfils the criteria within a certain range. Use sum if function to find the total sales made by it weekly magazine. Countif: countif calculates the number/frequency of occurrence according to the criteria within a certain range. =countif(where do you want to look?, what do you want to look for?) Use count if function to find the count of sales made by it weekly magazine. Sorting: sorting data helps you organise and understand data better, ultimately being able to make more effective decisions. Filtering: filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed.
