ADM 1370 Study Guide - Midterm Guide: Transpose, Emv
Document Summary
These functions can be used to verify data, search for data, transform data or deliver data from one point to another. e. g. filter unique values: used to fiplter and deliver unique values from a list e. g. data validation & drop-down menus, used to allow end-users to select from a predefined lists of values e. g. lookup functions, used to retrieve values from tables based on lookup values. Summary functions: countif, sumif, averageif: you can calculate the number of cells in a range that match criteria you specify using the countif function, i. e. a conditional count: =countif( range,criteria) function, i. e. a conditional sum: =sumif( range,criteria[,sum_range], you can add the values in a range that meet criteria you specify using the sumif, you use the averageif function to calculate the average of values in a range that meet criteria you specify, i. e. a conditional average: