Page 30 - C_GPT _V4 _class_7
P. 30
2. Ankita has a list of students with their final examination marks. She wants to display the records of the
students from the list who scored 90 marks in the final examination. Which option will help her?
a. Sort A to Z b. Number Filters
c. Sort Smallest to Largest d. None of these
3. Which of the following options is used when you want to highlight all the cells satisfying a given
condition?
a. Data Bars b. Color Scales
c. Top/Bottom Rules d. Highlight Cells Rules
4. Smallest to Largest option is used to .
a. Sort numbers b. Sort text
c. Both a. and b. d. None of these
5. If you want to remove conditional formatting from a spreadsheet, which option will you choose?
a. New Rule b. Clear Rules
c. Remove Rules d. Delete Rules
Tick ( ) the correct statements and cross ( ) the wrong ones.
1. Excel allows you to sort both numeric and textual data.
2. You can sort the data according to a particular column as well as a range of data.
3. The Sort & Filter option is used to apply filter to a column.
4. Excel does not allow you to use a custom filter.
Q Answer the following questions:
A
1. What is the difference between sorting and filtering?
2. Name any four options present under the Highlight Cell Rules command.
3. What is the purpose of the Data Bars option under the Conditional Formatting command?
CodeGPT (Ver. 4.0)-VII
28

