DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the formula for the average price of the current inventory of brushes when Column A is the department, Column B is the tool name, and Column C is the price?
|
=AVERAGE(C2:C14, “Brushes")
|
|
=AVERAGEIF(C2:C25, B2:B25, “Brushes")
|
|
=AVERAGEIF(A2:B14, “Brushes", C2:C14)
|
|
=AVERAGEIF(B2:B14, “Brushes", C2:C14)
|
Explanation:
Detailed explanation-1: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-2: -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-3: -The statistical functions AVERAGEIF and AVERAGEIFS are similar to SUMIF and SUMIFS. They calculate the average value where cells meet specified criteria.
There is 1 question to complete.