Page 56 - Digicode_AI_class_7
P. 56
2. What is the use of the conditional formatting?
3. Write the steps to search a record in a form.
Critical Thinking
Information Literacy
Guess! Who am I?
1. I restrict you to enter a specific range of values in a particular cell or a range of cells.
2. I am a feature in Excel to separate unwanted data from a range of data.
3. I am a type of formatting that can be applied on the basis of a criteria.
4. I am an option that is selected when you want to add data bars to the cells
having numeric data.
Experiential Learning
Competency-based/Application-based questions Information Literacy
Anaya was making a list of all the students of her class. She wants to highlight bottom 10 roll numbers in
her list. Which type of criteria can she use for this?
Experiential Learning
byte TASK Technology Literacy
A. Make a list of your 10 friends in Excel 2016. Make columns for the distance of their home from school,
distance of post office from their home, etc.
Highlight the cells which have distance value less than 2.5 km in any cell.
B. Make a list of 15 teachers and subjects taught by them. Apply Filters on the subjects field. Take
printouts of various filter options of subjects and their result.
54 DigiCode AI-VII

