Advanced features of Excel

The (a)   feature lets you quickly enter a pre-defined series of data.

To remove conditional formatting, click (a)   in the Condition Formatting drop-down menu.

(a)   recognizes the data fill pattern in a worksheet and fills the remaining series according.

The conditional formatting options are present in the (a)   group.

Options for sorting and filtering the data are present on the (a)   tab.

The filter feature allow you to fill a range of cell with series of data without actually typing it

• False

• True

The button A to Z is used to arrange the data in descending order.

• True

• False

To remove a filter criteria click Hide in the Sort & Filter group on the Data tab

• True

• False

The filter feature of Excel 2016 shows the drop down arrow in each column heading

• True

• False

Which of the following type of data are sorted by the Sorting feature.

• Textual

• Numeric

• Alphanumeric

• All of these