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 keyboard shortcut selects cells that contain formulas that directly reference the active cell?

When working in a Pivot Table, the additional menu items 'Options' and 'Design' are found:

Which worksheet function estimates variance based on a sample?

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: