A workbook contains sales information for the first quarter and you are interested in
finding the totals sales generated in January by the sales rep Jim Anderson. What
function is best suited to handle the task?
a. SUMIFS
b. AVERAGEIFS
c. DCOUNT
d. COUNTIFS
Give this one a try later!
a. SUMIFS
Histogram
Give this one a try later!
, A visual display of tabulated frequencies
Standard Deviation
Give this one a try later!
Measures how far the data sample is spread around the mean.
RANK.EQ function
Give this one a try later!
Identifies the rank of a value, omitting the next rank when tie values exist.
AVERAGEIF function
Give this one a try later!
Calculates the average of values in a range when a specified condition is
met.
PERCENTRANK.INC function
Give this one a try later!
finding the totals sales generated in January by the sales rep Jim Anderson. What
function is best suited to handle the task?
a. SUMIFS
b. AVERAGEIFS
c. DCOUNT
d. COUNTIFS
Give this one a try later!
a. SUMIFS
Histogram
Give this one a try later!
, A visual display of tabulated frequencies
Standard Deviation
Give this one a try later!
Measures how far the data sample is spread around the mean.
RANK.EQ function
Give this one a try later!
Identifies the rank of a value, omitting the next rank when tie values exist.
AVERAGEIF function
Give this one a try later!
Calculates the average of values in a range when a specified condition is
met.
PERCENTRANK.INC function
Give this one a try later!
