E03
EmpNumber EmpName Department Salary Donation
E01 Sarika Madan 10
55000 500
E02 Divya Singh D10
34000 300
Mona Sharma 011
65000
600
E04 Sarthak kapoor 012
67000 600
EOS
Parth Arora 013
49000
E06 Rahul Sharma 014
50000
E07 Neha Gupta
D15
45000
EOS Riya Sharma D16
60000 600
E09
Nitin Garg 017
70000
490
500
450
700
3. The accountant of Myra Pvt. Ltd. Company has prepared a list of employee salary and donation by each
4 employec. Accountant has been assigned the task to create a worksheet that records the details of the
5 employee. He wants to make few changes in the sheet. Help him to do the following tasks in the given table.
6
7 1. Move the data in cell range N3:R12 to A16:E25 (1 Mark)
8 2. Change the row height of the cell range A16:E16 to 40 points and column width to 12 points. (2 Mark)
9 3. Calculate total Salary of each employee after donation (2 Mark)
10 4.Use background colors to make it more visually appealing (1 Mark)
11 5. Use atleast two different font styles and give font size appropriately.(1 Mark)
12 6. Apply sulable border (1 Mark)
13 7. Use bold, Italic and underline features appropriately. (1 Mark)
14 8. Apply center and middle alignment to range A16 to E16.(1 Mark)
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Answers
Answered by
0
Answer:
sorry this is questions not written instructions
Similar questions