32.Consider the following work sheet and answer the questions that follow:
A B
1 TARGET 5000
2 SALE VARIANCE
3 4300
4 6200
5 3000
6
i. Calculate variance Formula- target (B1) – sale.
ii. Insert function in cells A6 and B6 to calculate average sale and variance respectively.
iii. Display how many furniture items are there using a function in cell A6.
iv. Display function to find out highest variance
v. Display function to find out smallest sale.
Answers
Answered by
0
Answer:
its a silly question.
Explanation:
Similar questions