We can use Excel's _____________ feature to see how the pivot table would look in any style.

Excel 2013 brings in a new method to filter data with __________ feature.

Correct syntax of the function used for calculating the total of all the values from cell B2 to cell B12?

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

Charts button in Excel 2013 can change ________, ________ , and _________.

What is the function of 'Relationships' or 'Data Model'?

Ribbon can be customized by creating new tabs that house your desired commands. Which of the following statements is/are correct about Ribbon customization?

Mark's manager shares a report sample for preparing the sales report for the current year. He collects the data but is not able to figure out how to add trends (as shown in the last column of the image). Which of the following options should he insert into the worksheet to show the trends?

By using names, data can be understood and maintained in a much easier way. Peter creates a Named range, but he is not aware about the scope of the Name. Which of the followings is the default level of scope for a Name?

Maria needs to find unique values in a Microsoft Excel 2010 worksheet. Which of the following is correct about selecting data for finding unique values?

In SharePoint Foundation 2010, co-authoring of Excel 2010 workbooks is supported by the Microsoft Excel 2010 Web App.