MCQs > Admin Support > Microsoft Office > What will be the output if we apply the formula. =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, '>6')?

Microsoft Office MCQs


Consider the Excel sheet given in the image. What will be the output if we apply the formula. =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, ">6")?

Answer

Correct Answer:

16 

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft Office Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More Microsoft Office MCQ Questions

search

Microsoft Office Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it