USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=AVERAGE(C2:C14, “Brushes")
|
|
|
=AVERAGEIF(C2:C25, B2:B25, “Brushes")
|
|
|
=AVERAGEIF(A2:B14, “Brushes", C2:C14)
|
|
|
=AVERAGEIF(B2:B14, “Brushes", C2:C14)
|
Detailed explanation-1: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-2: -=AVERAGEIF(range, criteria, [average range]) The AVERAGEIF function uses the following arguments: Range (required argument) – This is the range of one or more cells that we want to average. The argument may include numbers or names, arrays, or references that contain numbers.
Detailed explanation-3: -To average values in cells and ranges of cells that aren’t adjacent, type an equals sign (a formula always starts with an equals sign), AVERAGE, open parenthesis, hold down the Ctrl key, click the desired cells and ranges of cells, and press Enter.
Detailed explanation-4: -The AVERAGEIF function is a premade function in Excel, which calculates the average of a range based on a true or false condition. The condition is referred to as criteria, which can check things like: If a number is greater than another number > If a number is smaller than another number <