BUS 150 Study Guide - Midterm Guide: Pivot Table, Long Term Ecological Research Network, Railways Act 1921

• School: University of Miami
• Department: Business
• Course: BUS 150
• Professor: Maryann Barber

Document Summary

Record layout: the records, their order, & data type of individual elds; same. Elds should be in same order. Unique fields: every entry in eld must be di erent for every record. Non- unique fields: are permimed depending on the situa/on. Purpose of pivot table: summarizes data, works best with a lot of data, easy to rearrange summarized. Row labels fields: text fields automa/cally go to row labels regardless of how many you check. Report filter fields: allows you to lter, adds dimension. Refreshing pivottable data: pivot table isn"t linked to data, so refresh it when you make changes, nothing changes automa/cally. If/nested if func/on: =if(condi/on, value if true, value if false) And func/on: =and(condi/on 1, condi/on 2, condi/on 250: all condi/ons must be true, result will be true or false. Condi=onal forma>ng: finding duplicates through highlight cells rules, new rule based on a formula: New rule, i. e. whenever =j5