Which of the following statements is correct about the #Data constant in Microsoft Excel 2016?

Which filter can be created using the AutoFilter option in Microsoft Excel 2016? i) By list values. ii) By format. iii) By criteria.

Commands 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?

Which option won't allow you to print an embedded chart?

If two formulas that depend on one another need to be solved at once and a circular reference is created, this can be resolved by:

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?