USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which formula will calculate the average based on a condition? (return the average of sales if over $20)
|
|
average
|
|
|
countif
|
|
|
averageif
|
|
|
sumif
|
Explanation:
Detailed explanation-1: -Answer. you would use count to calculate your answer!
Detailed explanation-2: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
There is 1 question to complete.