Which of the following functions can be performed on a protected worksheet if the password is not known?

Correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

For which of the following options, if included in a worksheet, we cannot use the Track Changes option?

When do we receive a '#Value!' error in the VLOOKUP function? i) When the 'lookup_value' argument is more than 255 characters. ii) When the 'col_index_num' argument contains text. iii) When the 'col_index_num' argument is equal to 0.

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.

Correct method(s) of consolidating data in Microsoft Excel 2016?

You can set Page Border in Excel from...

Which of the following chart types is featured in Excel?

The formula SUMPRODUCT(a1:a4,b1:b4) is equivalent to:

For a formula that calculates gross pay based on hourly wage (column A) and hours worked (column B), what are the cells in columns A and B called?

What additional ability does the Classic PivotTable Layout provide?