Which of the following types of filters 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?

Keyboard shortcuts used for moving from any cell to the beginning of a worksheet, i.e. cell A1?

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?

Which of the following is an example of a conditional formatting rule?