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 NOT TRUE about scatter plot graphs?

A 3D reference means

What is the quickest way to highlight all of the blank cells in selected section that has both filled and blank cells?

Which of the following is an example of a conditional formatting rule?

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