Question

. Create an Excel Sheet to calculate the sales of Wagon – R and Maruti
Alto 800 of ABC Maruti Sales Centre.
2. Format the spread sheet and design it as given below.
3. Use formula using absolute referencing to calculate Revenue of Wagon R
and Revenue of Alto 800.
(Revenue = unit sold x price per unit.)
4. Apply formula to calculate Total Revenue . (Total Revenue = Revenue of
Wagon R + Revenue of Alto 800).
5. Apply formula to calculate the Total number of units sold and Total
Annual Turnover.
6. Create a chart to compare the sales of both the cars.
send the pic if you are a genius

Answer 1

here is your answer please mark it as branliest