This question is based upon the figure shown below.

 

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'? 

 

What does the icon marked with a red square in the figure above signify?

Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5))

Which of the following tools is used to format Excel worksheet data, as shown in the figure above?

____ shows you how a fill color will look before you apply it.

________ is the process of arranging data in a specific order based on the value in a field.

Can you set 1-inch left indentation for a cell in Excel?

What is the first thing before launching subtotal function?

A cell with a numerical value has a green corner. What does this mean?

A green flag will appear on the upper right-hand side of a cell when it contains:

How can you remove an icon from the Quick Access Toolbar?