Page 149 - Trackpad_V4.0_c7_Flpbook
P. 149
Practical Assessment
Excel 21 st Century #Technology Literacy
Skills
#Critical Thinking
1. Create the following spreadsheet in Excel and perform the operations given below:
Name Age Gender Score
Rahul 12 Male 85
Priya 14 Female 92
Aryan 13 Male 78
Nisha 11 Female 95
Vikram 15 Male 80
Ananya 16 Female 88
Rohit 10 Male 75
Sneha 12 Female 90
a. Apply conditional formatting on the column Age to display the students age in red colour who are below
13.
b. Sort the records in ascending order of the basis of Score column.
c. Display the records of Female students only. 21 st Century #Technology Literacy
Skills
#Creativity
HTML
1. Create the following table in HTML. Also apply border style and colour to decorate it.
Price
Product Description Quantity
Unit Total
Pencils HB pencils, pack of 12 2 75 50
Pens Ballpoint pens, assorted colors, pack of 10 2 60 30
Notebooks College-ruled notebooks, pack of 3 4 70 20
Markers Highlighter markers, assorted colors, pack of 6 5 68 15
Practical Assessment 147

