Page 25 - Computer - 7

Post-Processing  


 The Flash Fill in Excel feature recognises the data pattern in a cell and fills other cells in a range
using the same pattern.
 The Sort feature in Excel rearranges the rows in increasing or decreasing order of values of

numeric data or alphabetical order of letters in columns.
 Excel lets you sort data on the basis of values, font colour, or background colour of cells.
 You can sort data on multiple columns.
 The Filter feature lets you display the rows that meet a specific criteria and hide rows that do
not satisfy the criteria.

 Custom Filter helps you filter data based on specific conditions on values in cell range.
 Conditional Formatting in Excel lets you apply formatting to cells according to the conditions
you specify.
 The Format Painter in Excel allows you to copy all the formatting applied to one cell to other
cells, easily and quickly.

INFO RETENTION
INFO RETENTION

A. Select the correct option for each of the following statements.

1. The feature in Excel that recognises the data pattern in a cell and fills other cells in a range using
the same pattern is ______.

(a) Flash Fill (b) Filter Data (c) Sort Data (d) AutoComplete

2. The Z to A button sorts data in ______.
(a) ascending order (b) descending order (c) original order (d) random order

3. The button that appears in the column heading when you filter data is ______.

(a) (b) (c) (d)

4. The feature in Excel that lets you apply formatting to cells according to the condition you specify
is ______.

(a) Conditional Formatting (b) Custom Filter

(c) Custom Format (d) Conditional Find

5. The tab on the Ribbon in Excel that provides options to sort and filter data is ______.

(a) Home (b) Review (c) Data (d) Insert

23