Page 55 - KEC Khaitan C6 Flipbook
P. 55
CONDITIONAL FORMATTING
To apply conditional formatting to a series of data, follow the given steps:
1 Select the data and click on the
Conditional Formatting command.
2 Select the
desired option.
3 Choose
desired fill effect.
uiz Bee Write the use of custom sorting.
_________________________________________________________________
Hashtag
#SUM(): This function is used to calculate the total of a given set of values
#IF(): This function is used to check a condition to be evaluated as True or False
REVISIT
▶ The SUM() function calculates the total of a given set of values.
▶ The IF() function checks a condition to be evaluated as True or False, and based on the result, suitable
actions are performed.
▶ The physical arrangement of data in ascending or descending order is called sorting.
▶ The feature of viewing rows of data suiting a specified selection criterion is called filtering data.
Advanced Features of Excel 53

