CSE 2111 Exam Review With 100% Correct Answers

CSE 2111 Exam Review With 100%
Correct Answers


Sum(number1, [number2],...) CORRECT ANSWERS Adds the
numbers in a range of cells


Average(number1, [number2]...) CORRECT ANSWERS
Calculates the arithmetic mean of a list of values


Min(number1, [number2],...) CORRECT ANSWERS Calculates
the arithmetic mean of a list of values


Max(number1, [number2],...) CORRECT ANSWERS Returns
the largest number of a range of values


Count(value1, [value2],...) CORRECT ANSWERS Determines
the number of cells in a range that contain numbers


CountA(value1, [value2],...) CORRECT ANSWERS
Determines the number of cells in a range that are not empty

, Round(number,num_digits) CORRECT ANSWERS Rounds a
number to specified number of digits. When nesting use before
other formulas.
=Round(Sum(A2:A4),1)
=Round(Average(A2:A4),-1)


Countif(range, criteria) CORRECT ANSWERS Counts the
number of items in a range that meet a specific criteria


Countifs(criteria_range1,criteria1, [criteria_range2,criteria2]...)
CORRECT ANSWERS Counts the number of items in a range
that meet a specific criteria for multiple criteria and ranges.


Sumif(range, criteria, [sum_range]) CORRECT ANSWERS
Sums the number of items in a range that meet a specific criteria


Sumifs(sum_range,criteria_range1,criteria1,
[criteria_range2,criteria2],...) CORRECT ANSWERS Sums the
number of items in a range that meet a specific criteria for
multiple criteria and ranges.


AverageIf(range, criteria, [average_range]) CORRECT
ANSWERS Averages the number of items in a range that meet a
specific criteria