Page 26 - TrackpadV2.1_Class8
P. 26
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. Which function checks whether a condition is true or false?
(i) POWER() (ii) ELSE
(iii) IF() (iv) None of these
b. The Sort & Filter command is present under _____________ group.
(i) Editing (ii) Cells
(iii) Number (iv) Both (i) & (ii)
c. Which key combination is used to filter the data?
(i) Ctrl+Shift+F (ii) Ctrl+Shift+L
(iii) Ctrl+L (iv) Ctrl+F
d. Under which group is the Conditional Formatting command present?
(i) Styles (ii) Editing
(iii) Font (iv) Cells
24 Trackpad (V2.1)-VII

