Arihant stationery keeps stock of various stationeries in his shop. The proprietor wants to maintain a stock value and reorder level for following items as given in a spreadsheet. Write formulas for the operations (i) to (iii) and answer the questions (iv) and (v) based on the spreadsheet given below along with the relevant cell address:
1. To calculate the Stock Value as product of ‘Quantity in Stock1 and ‘Rate’ for each item present in the spreadsheet.
2. To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.
3. To calculate the ‘Order Value’ as product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity to Order’>=0, else assign the value as 0.
4. Proprietor wants to graphically represent his stationery stock. Suggest him the most appropriate feature of MS-Excel.
5. If Quantity in Stock’s value changes, will have to redo all the calculations for that particular column? Explain.