Question

PACE ICE CREAM PARLOUR maintains the details of items sold during the day in a workbook as - 239 shown in Fig. P1 B PACE ICE CREAM PARLOUR FLAVOUR QUANTITY RATE Pisto 6 Vanilla 7 Tut Froot Cassata Mango Kesar 14 20 5 7 4 Fig P1 PACE ICE CREAM PARLOUR FLAVOUR QUANTITY RATE AMOUNT Pista Vanila Tu Froos 8 Cassala Mango 10 Kesar 12 70(2) 14 20 5 5 12 10 35 1 15 4 15 240 50 175 105 60 128 7 12 10 35 15 15 F g /P2 Enter data in a worksheet as shown in F(g, P) and perform the following operations. (a) Save the workbook as SALES.XLS. (b) Minimize the workbook SALES.XLS and then restore it to its original size (c) Calculate the total sales (AMOUNT column in the worksheet given below) for each flavor by multiplying the QUANTITY and RATE. (d) The management of ANTARCTI( CREAM PARLOUR wishes to find out the total sales at the end of the day. Modify the SALES.XLS book to fulfill the requirement. After calculating the total, the worksheet should look like the one shown in Fig,P2 (e) Change the rate of Kesar flavor from 12 to 15. Observe that the formulas get recalculated. (Save the workbook again.​

Answer 1

Answer:

Guide To English & Logical Rea… · NCERT Class 9 English - Beehive · NCERT Class 10 English - First Flight.