with reference to the screenshot given which of following formulae cannot..., MS Excel, Computer Skills

Test
Index

Question:
With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?

A =AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15) 
B =AVERAGE(E6:E15) 
C =(SUM(E6:E15)/COUNT(E6:E15)) 
D =AVERAGE(E6 to E15)

/39

+ AnswerD

+ Report

Descriptive on MS Excel Ebook

Total Preview: 657

Question: With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?

A =AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)

B =AVERAGE(E6:E15)

C =(SUM(E6:E15)/COUNT(E6:E15))

D =AVERAGE(E6 to E15)

D