# From the given image, 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”)?

Are you looking for an answer to the question “From the given image, 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”)?”? If that’s the case, congratulations! You’ve arrived to the right place. Throughout this post, I will help you by answering your question correctly.

## From the given image, 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”)?

Options

· 16

· 10

· 6

· 4

The Correct Answer Is:

· 16

## Warming Up

I hope I was able to provide you with the correct answer to your question “From the given image, 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”)?”. The above question was asked in the Fiverr Microsoft Excel Test. I appreciate your trust in this website. Additionally please keep checking back to this site for more answers to questions from more other certification exams.