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?

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?

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

Robert inserts a PivotTable in Sheet 2 of a worksheet. He drags the 'Days' field from the PivotTable Fields to Values section. Which of the following options will be the default selection under Values?

Which of the following is NOT a valid option for language settings?

Which statement is correct about Microsoft Excel Online?

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

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

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

Which of the following sorting options is NOT available under the Sort On dropdown menu in Sort dialog box while sorting the data of a table in an Microsoft Excel 2013 worksheet?

Keyboard shortcut used to switch between relative and absolute cell references while writing a formula in a worksheet?