Advanced features of excel

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

• AutoFill

• FlashFill

• CustomFill

• Copy

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

• clear rules

• Manage rules

• Clear option

• None of These

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

• AutoFill

• Custom Fill

• Flash fill

• None of These

The Conditional Formatting button is present in the ____________ group on the Home Tab.

• Styles

• Cells

• Editing

• Alignment

Options for sorting and filtering the data are present on the Home tab and the Data tab.

• True

• False

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

• True

• False

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

• Textual

• Numeric

• Alphanumeric

• All of these

What are the numbers in spreadsheet called?

• Rows

• Alphabet

• Column

• Symbols

You cannot sort data by cell color

• True

• False

Among these AutoFill options which one is used to fill the cell with the next items in the series

• Copy Cells

• Fill Formatting only

• Fill series

• Fill without Formatting