Quiz 1-B :

Quiz 1-B :

company	Sold  units
	Jan	Feb.	Mar.
A	100	200	300
B	50	70	200
C	120	180	290
D	200	190	250

We have 4 companies A,B,C, D use Excel to calculate the following :

1-        Total Sold  units to company A,B,C , D in the 3 months

2-        Total Sold  units in Jan , Feb and Mar, for all companies  each month in one cell .

3-        The difference in  Sold  units between company A and company B

4-        The difference in  Sold  units between company C and company D

5-         The total Sold  units for the four companies in the 3 months (the result must be in one cell )

*calculate the results in any cell you choose