In Microsoft Excel 2016, which of the following is the correct syntax of the VLOOKUP command?

Which function is used for returning the sheet number of a reference sheet?

Which functions is used in order to return the serial number that is used for representing the date, which is the indicated number of months before or after a specified date?

Which options provides a user the access to options such as Share, Export, Account, Publish, etc.?

Consider the Excel sheet given in the image. What will be the output if we apply the formula, =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, '>6')?

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 of the following is an example of a conditional formatting rule?

Which is a valid option in the Data Validation Allow settings?

By placing the cursor in a cell and inserting a picture, the picture is then 'attached' to that cell.

True or False: The Remove Duplicates command treats items that are spelled the same but capitalized differently as two distinct items.

You're writing a macro and want to add the following comment: use this code. How would you add this comment?