In Microsoft Excel 2016, 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 options can be copied using the format painter in Microsoft Excel 2016? 1. Alignment 2. Background color 3. Cell text

In Microsoft Excel 2016, which of the following statements are correct about a Pivot chart? 1. A Pivot chart is a graphical depiction of a data summary. 2. You cannot create a Pivot chart without a Pivot table. 3. You can create a Pivot table and a Pivot chart at the same time.

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?

Which of the following is NOT an option to erase the contents of a cell?

If you enter the formula =mod(2,5) into a cell, what will the cell display?