Page 89 - TGPT_V5.0_C5_Flipbook
P. 89
(ii) You have to convert the names in lowercase. Which function will you use to convert the
range of names into lowercase?
21 st
A Better Me! Century #Responsibility
Skills
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.
21 st
DIY In The Lab Century #Technology Literacy
#Information Literacy
Skills
To
Subject Software Skills
Start Excel on the computer and click on "Blank Workbook" to create a new workbook:
1. Fill in the serial numbers in column A. In column C, type the list of months. In column E, type
the list of days.
2. Now using the Autofill feature, complete the list in columns A and C.
3. Select the cell that needs to be auto-filled. Click on the Home tab. Click on the Fill button in the
Editing group and select the Series option to Autofill the list of days in column E.
4. Using the text function, convert the text string in columns C and D into uppercase.
For The Teacher
Take the students for a quick run through of all the features taught in the chapter.
Discuss the difference between labels and values.
Demonstrate all the operations given in the chapter.
Editing Cell Contents in Excel 2021 87

