From the given image, Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the “Marks Obtained” in the cell “I4”?

Digital Marketing, Fiverr Microsoft Excel Test Answers

Are you looking for an answer to the question “From the given image, Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the “Marks Obtained” in the cell “I4”?”? 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, Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the “Marks Obtained” in the cell “I4”?

Options

· =AVERAGE(B4:G4)

· =AVG(B4 C4 D4 E4 F4 G4)

· =(SUM(B4:G4)/COUNT(B4:G4))

· Both options A and C.

· Both options A and B.

The Correct Answer Is:

· Both options A and C.

Warming Up

I hope I was able to provide you with the correct answer to your question “From the given image, Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the “Marks Obtained” in the cell “I4”?”. 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.