Question

Create a new work book and enter the data in Sheet1 as shown in following figure
Sales Report
2
3 Name
Otr1
on
anura
16
20
70
4 Rajat
5 Namit
90
&S
90
56
56
67
72
6 Sanjay
7 Arnay
76
65
76
79
& Karan
BO
78
89
85
9 Akhil
65
87
96
10 Pankaj
45
66
76
71
11 Varun
78
87
9a
93
12 Bharat
69
56
67
74
13 Chirag
65
76
87
72
a.
b.
C.
Now, perform the following operations.
Calculate the total sales of Rajat in all the quarters in cell F4. Copy this formula
calculate the total sales of the other salesmen.
Calculate the commission for all the salesmen in cells G4 to G13 using the rate of
commission given in cell H2. Use appropriate cell reference in the formula
Sort the data on the basis of the names of salesmen.
Filter the data to display sales of only those salesmen whose sales is greater than 30
in Qtrl and Qtr2
Try using different types of conditional formatting for highlighting the data
Create a Bar chart showing the sales of all the salesmen in four quarters
d.
f​

Answer 1

Answer:

dedffxgd

Explanation:

dvevrvrhtjgmgmtnfvdbfbdbwbbdhdjrjrj