Page 82 - iPlus_Ver_2.0_class_7
P. 82
#Communication
#Collaboration & Teamwork
Be Creative
Anaya is making a list of marks of her classmates and their total percentage after her teacher
asked her to do so. After completing it, she shared the Excel with her best friend without telling
the teacher. Is this act of her ethically correct? Write your views.
#Creativity & Innovativeness
#Digital Literacy
Practical Time
Create a marksheet for ten students. Now, follow these instructions:
• Insert a row after the fifth record.
• Insert a column to the right of the third column.
• Using AutoFill features, fill in the roll numbers 1 to 11 for the students.
Add the following records to the Excel worksheet and apply the cell styles as per the following
rules:
• The cells containing marks
greater than or equal to 80
should be highlighted with Good
cell style.
• The cells containing marks greater than or equal to 70 and less than 80 should be highlighted
with a Neutral cell style.
• The cells containing marks less than 70 should be highlighted with Bad cell style.
Teacher’s Corner
1. Do a detailed walk-through with students on all the topics presented in the chapter.
2. Provide some tasks which make use of the functional facilities discussed in the chapter.
80
iPlus (Ver. 2.0)-VII

