Quiz 2:
xyz
company
|
||||
product name
|
produced
|
sold
|
corrupted
|
storage
|
Cakes
|
1000
|
500
|
70
|
430
|
Cookies
|
3000
|
1500
|
100
|
1400
|
biscuits
|
2700
|
2000
|
20
|
680
|
Copy this table in an excel
sheet and calculate the following using
functions :
1- Sum of produced
units
2- Sum of storage
units
3- Minimum product
sold
4- Maximum corrupted
product
5- Average of
corrupted units and trace this function
6- Count of products
in this table
7- Sum of all units
in the table and trace this function
Then take another copy to do
the following :
1- Delete the
cookies from table
2- Insert new
product ‘soft drinks’ with produced units 1200 ,sold units 1000, corrupted 100
, storage 0 .
3- Write comment on
storage cell of soft drink saying that ‘we have to contact the manufacture to
send us another 1000 units’
Comments
Post a Comment