State whether the following is true or false: Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook

When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.

In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data. Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?

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?

In Excel 2010, to protect a worksheet, choose Protection and then Protect Sheet from which menu?

Given range of cells A1:A100, select the formula that would return the 3rd lowest value from the selected range.

What's the recalculate shortcut?

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?