In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?

The Save As option can be accessed from which of the following tabs?

Which is correct about the customization of the Quick Access Toolbar?

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

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

Which worksheet function estimates variance based on a sample?

The formula ISERR(A1) does not return TRUE if A1 is :

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: