Question

If I type the marks in cells B5:810, which formula would you use to get the average of marks in 5 subjects?
a. =MAX(B5:B10)
b. =TOTAL(B5:B10)
C =MIN(B5:B10)
d. =AVERAGE(B5:310)​

Answer 1

Explanation:

Create a formula without using a function that adds 1 to the value in cell B12 and then multiplied the result by the value I. Cell B 13.

Create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from B6 and then multiples the result by cell B8.

=(B6-(B5+B7))*B8

Create a formula without using a function that adds 1 to the value in cell B12 and then multiplied the result by the value I. Cell B 13.

=(1+B12)*B13

Answer 2

Answer:

u cheater asking answer for periodic IT test last exam

Explanation:

ur studying 9th std velammal Vidyalaya annexure also ur mom is a teacher in that school also I was ur class mate

searching google and brainly for exams

wait I will complain to HM and Principal