Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?

Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

Which of the following defines the correct purpose of using a poster frame image?

Which among the following settings is the default macro security setting?

What does the Compare tool do?

Which among the following chart types do not have axes?

While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named 'Sheet5'?

Which tab will you click for accessing the View Macrosoption?

In Microsoft Excel 2016, which of the following options used for displaying or hiding formulas change(s) the state of a cell?

i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them.

ii) Switch between displaying formulas and formula results on a worksheet.

iii) Show hidden formulas by removing the protection from cells.

Which of the following options can be used for checking the protection status of a file in Microsoft Excel 2016?

Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?