- AEducation and awareness programs
- BSustainable agriculture practices
- ✓Deforestation and habitat destruction
- DGreen technology advancements
Answer: C.
View full solution →46 questions across 5 question groups — pick any mix to generate a Information Technology paper with step-by-step answer keys.
M.C.Q[1M] [Employability Skills]
6 Q→02M.C.Q[1M] [Subject Skills]
24 Q→032 Marks Quetions [Employability Skills]
5 Q→042 Marks Quetions [Subject Skills]
6 Q→054 Marks Quetions
5 Q→One sample from each question group in this chapter. Select any group above to see the full set with answer keys.
Answer: C.
View full solution →Answer: B.
View full solution →Answer: C.
View full solution →Answer: A.
View full solution →Answer: A.
View full solution →Answer: A.
View full solution →Answer: B.
View full solution →Answer: D.
View full solution →Answer: A.
View full solution →Answer: B.
View full solution →
| 1 | Item Code | Item Name | Minimum Stock | Quantity in Stock (Unit) | Rate (₹) | Stock Value (₹) | Quantity to Order (Unit) | Order Value |
| 2 | 101 | P. Holder | 200 | 500 | 35 | |||
| 3 | 123 | Whitner | 45 | 150 | 25 | |||
| 4 | 113 | Steppler Pin | 250 | 450 | 5 | |||
| 5 | 156 | Paper cutter | 300 | 600 | 10 |
(i) To calculate the Stock Value as a product of ‘Quantity in Stock’ and ‘Rate’ for each item present in the spreadsheet.
(ii) To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.
(iii) To calculate the ‘Order Value’ as a product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity to Order’ > = 0, else assign the value as 0.
(iv) The Proprietor wants to graphically represent his stationery stock. Suggest to him the most appropriate feature of MS Excel.
Pick question groups from the list above, set marks and difficulty, and export a branded PDF with step-by-step answer keys. First 3 chapters free — no signup.