Page 41 - Computer Genius Class 07
P. 41
Notes
The filter can also e applied through Sort & Filter group under the Data
tab by selecting Filter command .
Remove Filters
The filters once applied can e easily remo ed. lic any here in the or sheet and repeat steps
to apply filters. ou ill notice that the filter arro s in ront o column headers disappear and the
hidden rows also reappear.
Information Literacy
Quest Critical Thinking
State whether these statements are true or false.
1. y de ault Form command is not isi le on the ri on.
2. Delete button is used to delete the record from the worksheet.
3. The filters once applied cannot be easily removed.
4. Excel allows you to filter unwanted data from a set of data.
Conditional Formatting
Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy a
condition or e ample greater than . This type o ormatting is no n as Conditional Formatting
in cel. To apply conditional ormatting to a series o data ollo the gi en steps
2 Click on Conditional
Formatting command.
3 Place your mouse
over Highlight Cell
Rules option and
select the Greater
Than option.
1 Select the data to which formatting is to be applied.
Advanced Features of Excel 2016 39

