Page 21 - Code & Click - 7

Post-Processingost-Processing
P
 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.
 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

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 tab on the Ribbon in Excel that provides options to sort and filter data is ______.
(a) Home (b) Review (c) Data (d) Insert

B. Fill in the blanks with the correct answer.
1. To remove filter conditions from the column, click the Clear button in the _________ group
on the Data tab.

2. _________ helps you filter data in a cell range based on specific conditions.

3. To apply conditional formatting, select the cell range and click the Conditional Formatting
button in the _________ group on the Home tab.

4. The _________ lets you copy formatting from a cell to another cell.
C. Write ‘T’ for True and ‘F’ for False statement.

1. You can sort data in a worksheet using one column only. _______
2. Once you have filtered data in a cell range, you can clear a filter to redisplay all
the data. _______

3. You can apply multiple conditional formatting on a cell range. _______
4. Conditional formatting makes it easy to highlight certain values. _______

19