This question is based upon the figure shown below.

 

In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected? 

 

In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?

In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?

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))

What function would you use if you want to find the 3rd largest value in a set of data?

Which worksheet function returns the most common value in a data set?

Which chart would be best used to illustrate a proportional relationship?

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

What is the first thing before launching subtotal function?