In Microsoft Excel 2016, which of the following options is used to access the option that is used to get data from a text file?

Keyboard shortcuts used for moving from any cell to the beginning of a worksheet, i.e. cell A1?

Which option 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 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?