Question

plz answer this.....​

Answer 1

Answer:

i) Write the formula to calculate Percentage.

Ans: =(C2/40)*100

ii) If the minimum marks for passing is 33 what would be the formula applied at column E .

Ans: =IF(D2>33,"PASS","FAIL" )

iii) Which spreadsheet function would tell the length or number of characters in name (Column B)?

Ans: LEN (text)

iv) Write the average formula written in cell C10 and D10.

Ans: For cell C10 =AVERAGE(C2:C9) and for D10 =AVERAGE(D2:D9)

v) What is the maximum mark according to the table?

Ans: 40

**Please follow me and mark this ans as Branliest answer.Thank you!