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 option won't allow you to print an embedded chart?

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

Which worksheet function estimates variance based on a sample?

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

Which keyboard shortcut selects cells that contain formulas that directly reference the active cell?

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

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

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

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

Option used for limiting or restricting the cell entries to a certain data type?