Page 340 - Computer - 9(A&B)

Item Price Qty
Pencil 5 10
Eraser 5 20

Colors box 20 10
Pen 10 50

• Replace the item name ‘ Colors box’ with ‘Pencil box’ by using overwrite method.
• Change the ‘Pencil box’ price to 50 using modifi cation method.
• Save the workbook as ‘Bill’.

Project 2
Create a worksheet as shown and format the cells.

Project 3
Create the following worksheet.
Marksheet

Roll No. Name Marks
1 Nancy 350

2 Ajay 382
3 Ajay 382

4 Rohan 389
5 Lalit 430

Create the following worksheet.
• Ajay’s record is entered two times. Delete one record of Ajay from the worksheet.

• Add two more rows between Rohan and Lalit to insert the following data in these rows:
4. Rahul 385
5. Arjun 425
• Insert a blank column between Roll No and Name fi elds. Enter the heading Class and type the class of each
student along with section in the fi eld.

202
202