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

What's the recalculate shortcut?

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

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

A formula to show the date for the previous Sunday could be:

To share your workbook with another user, what must they have?

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

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.

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

State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).