Page 34 - C_GPT _V4 _class_6
P. 34
A Better Me! 21 st Century #Leadership & Responsibility
Skills
#Productivity & Accountability
Don't copy someone's data without his/her permission. It is an illegal activity.
Explore in the Lab 21 st Century #Productivity & Accountability
Skills
#Technology Literacy
To
Subject Creating Worksheet
1. Create the following sales report in an Excel worksheet by using the hints given below:
Sales Report (Month-January)
Product Units Sold Unit Price Total Sales
Bats 20 2000 40000
Balls 50 250 12500
Stumps 100 1000 100000
Bails 30 100 3000
Pads (Leg Guards) 40 2500 100000
Gloves 60 800 48000
Helmet 70 1200 84000
Merge the cells of the first row.
Merge the cells of the second row.
Apply normal border for internal cells.
Apply Thick Outside Borders (Option in the Borders command).
Use cell styles on the first and third rows and make the text bold.
2. Create an Excel workbook with five sheets (Students, Fees, Exams, Results, and Teachers). Change the
colour of the sheet tabs to green, blue, orange, gray, and gold, respectively. The final output of the sheet
tabs should look like the one given below.
For The Teacher
Do a detailed walk-through with students on all the topics presented in the chapter.
Provide some tasks which make use of the functional facilities discussed in the chapter.
32 CodeGPT (Ver. 4.0)-VI

