XYZ SALES COMPANY PERFORMANCE

SALESPE QRT1 QRT2 QRT3 QRT4

ANNUAL TOTAL AVERAGE

TARGET SALES SALES

ALBERT 750 148 256 133 154 691 173

MICHAEL 650 187 143 258 143 731 183
CARL 800 233 200 216 152 801 200
GEORGE 700 256 145 136 259 796 199
LUCKY 1,000 249 212 215 124 800 200

TOTAL 3,900 1,073 956 958 832 3,819

COMMISS 6%

(ii) Copy the text to duplicate then paste

(iii) Total sales * B14
(4) Click row 10, right click then select insert ,at the dialogue box select entire colomn
(5) the sign ## comes after inserting the wrong formula
(6) select the row to delete then press delete key
(7) 2D column chart
(8) select the chart then click formart to apply the formants
COMMISSION

41.46
43.86
48.06
47.76
48