In Microsoft Excel 2013, which of the following is the 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'?

How many passwords can be set on a Microsoft Excel 2013 file?

Excel 2013 automatically arranges any two workbooks __________, when comparing them.

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.

Wilson prepares a PivotTable to summarize the month-wise sales of all the salesmen for the Fiscal year 2016-17. His boss asks him to show an additional report to showcase the difference from the previous month. Which of the following tabs in the Value Field Settings dialog box will fulfil this requirement?

Kristen is working on confidential data and wants to make the Excel 2010 document password protected. Which of the following sets of steps will allow her to protect the document with a password?