In Microsoft Excel 2016, which of the following options can be locked in a worksheet?

i) Ranges

ii) Formulas

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')?

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?

Which is NOT an option for formatting a row?

Which worksheet function returns the maximum value in a list of arguments, including numbers, text, and logical values?