1 COMMISSION
LANGUARVERUARY MARCH
& CASH
200
6 SOUTH
NORTH
11
192
COMISION
a) Write the formula used to calculate the total sales of January, february (1)
b) Write cell address of January East, March-North
Write the range of EAST, WEST, SOUTH, NORTH.
(2)
Write the formula used to calculate commission of each three months. (2)
wate the steps to format the cells of sales amountlesser than 1000 with red color. (2)
Attachments:
Answers
Answered by
1
Answer:
add all number and multiple with concerned month number
Similar questions