Which of the following commands in Microsoft Excel allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?

Which statements is correct about Track Changes in Microsoft Excel 2016?

Function used for providing the decimal number of the time represented by a text string?

Options 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

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?