Page 28 - TrackpadV5.1_class7
P. 28
2. Fill in the blanks using the words from the help box.
Sort A to Z, IF, Custom Sort, Filter
a. The _____________ command is used to display only the rows of data that meet certain criteria.
b. The _____________ function in Excel checks a condition and returns different values based on
whether the condition is true or false.
c. To add another column to sort data within a sorted column, you can use the _____________ option
in Excel.
d. To sort data in ascending order, you would select the option _____________ in the Sort & Filter menu.
3. Write 'T' for true and 'F' for false.
a. The SUM() function is used to calculate the average of a given set of values.
b. Excel allows us to see the important data and hide the rest data temporarily.
c. Sorting data in Excel cannot be done in descending order.
d. Custom sorting allows you to sort data based on multiple columns.
4. Answer in one or two words.
a. What is the physical arrangement of data in ascending or descending
order is called? ____________
b. Which feature helps you view only specific data in Excel? ____________
c. What type of formatting in Excel changes cell appearance based on conditions? ____________
d. Which tab in Excel contains the Insert Function command? ____________
5. Think and answer.
a. What steps are involved in applying a filter to data in Excel?
_______________________________________________________________________________
_______________________________________________________________________________
b. How can you sort data by multiple columns using Custom Sort in Excel?
_______________________________________________________________________________
_______________________________________________________________________________
c. What is conditional formatting, and how is it used in Excel?
_______________________________________________________________________________
_______________________________________________________________________________
d. What are the two types of sorting available in Excel?
_______________________________________________________________________________
_______________________________________________________________________________
26 Pro (V5.1)-VII

