AVERAGE: Calculates the average of a set of numbers.
a Select a cell where you want to display the result.
b Enter the formula "=AVERAGE(range)" where "range" is the range of cells
you want to calculate the average of. c Press Enter.
COUNT: Counts the number of cells that contain numbers.
a Select a cell where you want to display the result.
b Enter the formula "=COUNT(range)" where "range" is the range of cells
you want to count. c Press Enter.
MEAN: Calculates the average of a set of numbers, just like AVERAGE.
a Select a cell where you want to display the result.
b Enter the formula "=MEAN(range)" where "range" is the range of cells
you want to calculate the average of. c Press Enter.
MEDIAN: Calculates the median of a set of numbers.
a Select a cell where you want to display the result.
b Enter the formula "=MEDIAN(range)" where "range" is the range of cells
you want to calculate the median of. c Press Enter.
MODE: Calculates the mode of a set of numbers.
a Select a cell where you want to display the result.
b Enter the formula "=MODE(range)" where "range" is the range of cells
you want to calculate the mode of. c Press Enter.
COUNTIF: Counts the number of cells that meet a specific condition.
a Select a cell where you want to display the result.
b Enter the formula "=COUNTIF(range, criteria)" where "range"
is the range of cells you want to count, and "criteria" is the condition that must be met. c Press Enter.
COUNTIFS: Counts the number of cells that meet multiple conditions.
a Select a cell where you want to display the result.
b Enter the formula "=COUNTIFS(range1, criteria1, range2, criteria2, ...)"
where "range" is the range of cells you want to count, and "criteria" is the condition that must be met. c Press Enter.
SUMIF: Adds up the values of cells that meet a specific condition.
a Select a cell where you want to display the result.
b Enter the formula "=SUMIF(range, criteria, sum_range)" where "range" is
the range of cells you want to check, "criteria" is the condition that must be met, and "sum_range" is the range of cells you want to add up. c Press Enter.
SUMIFS: Adds up the values of cells that meet multiple conditions.
a Select a cell where you want to display the result.
b Enter the formula "=SUMIFS(sum_range, range1, criteria1, range2,
criteria2, ...)" where "range" is the range of cells you want to check, "criteria" is the condition that must be met, and "sum_range" is the range of cells you want to add up. c Press Enter.
10 MAX: Returns the maximum value from a set of numbers.
a Select a cell where you want to display the result.
b Enter the formula "=MAX(range)" where "range" is the range of cells you want to find the maximum value of. c Press Enter.
11 MIN: Returns the minimum value from a set of numbers.
a Select a cell where you want to display the result.
b Enter the formula "=MIN(range)" where "range" is the range of cells you want to find the minimum value of. c Press Enter.
12 MINIFS: Returns the minimum value from a set of numbers that meet multiple conditions. a Select a cell where you want to display the result.
b Enter the formula "=MINIFS(range, criteria_range1, criteria1,
criteria_range2, criteria2, ...)" where "range" is the range of cells you want to check, "criteria_range" is the range of cells you want to check the criteria, and "criteria" is the condition that must be met. c Press Enter.
13 COUNTIF for range of dates: Counts the number of cells that meet a specific condition within a date range. a Select a cell where you want to display the result.
b Enter the formula "=COUNTIF(date_range, ">="&start_date) -
COUNTIF(date_range, ">"&end_date)" where "date_range" is the range of cells containing the dates, "start_date" is the start date of the range, and "end_date" is the end date of the range. c Press Enter.
14 ROUND: Rounds a number to a specified number of decimal places.
a Select a cell where you want to display the result.
b Enter the formula "=ROUND(number, num_digits)" where "number"
is the number you want to round, and "num_digits" is the number of decimal places you want to round to. c Press Enter.
15 Array Formula: Applies a formula to an entire range of cells.
a Select a cell where you want to display the result.
b Enter the formula you want to apply to the range of cells.
c Press Enter.
Note: Array formulas can be used with many different functions, so the specific formula will depend on the task you are trying to accomplish.
Instant Download for Solution Manual for Data Structures and Abstractions with Java, 5th Edition Frank M. Carrano, Timothy M. Henry 2024 Full Chapters in PDF
