Which of the following statements is 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?

Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?

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?

Which worksheet function Calculates standard deviation based on the entire population, including numbers, text, and logical values?