Page 56 - KEC Khaitan C6 Flipbook
P. 56
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
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?
_______________________________________________________________________________
54 Premium Edition-VI

