Page 27 - TrackpadV5.1_class7
P. 27
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.
1. Tick ( ) the correct option.
a. What function in Excel is used to calculate the total of a given set of values?
(i) AVERAGE() (ii) SUM()
(iii) IF() (iv) MAX()
b. Which of the following is used to check a condition and take action based on the results in Excel?
(i) SUM() (ii) AVERAGE()
(iii) IF() (iv) COUNT()
c. What feature in Excel allows you to arrange data in increasing or decreasing order?
(i) Filtering (ii) Sorting
(iii) Conditional Formatting (iv) Data Validation
d. To filter data in Excel, which command do you use?
(i) Sort & Filter (ii) Data Validation
(iii) Pivot Table (iv) Conditional Formatting
Advanced Features of Excel 25

