Qmb 3302 test - Study guides, Class notes & Summaries

Counts the number of cells within a range that meet the given criteria - =COUNTIF(range, criteria) Sorting data and calculating cumulative proportions. - Pareto Analysis Multiple criteria in the same row are logically joined by "and," while criteria in rows are joined by "or." - Advanced Filter When you are performing an advanced filter, where do you enter the range for the dataset? - List range cell range containing one row of labels and at least one additional row underneath th...