Advertisements
Advertisements
प्रश्न
Where is the address of the active cell displayed?
पर्याय
Row heading
Status bar
Name Box
Formula bar
MCQ
Advertisements
उत्तर
Name Box
shaalaa.com
Concept of Electronic Spreadsheet (ES)
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
APPEARS IN
संबंधित प्रश्न
Sales Information of Asha Traders
| A | B | C | D | E | F | |
| 1. | Particulars | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total |
| 2. | Unit sold (in kg) | 3500 | 4300 | 3100 | 4700 | |
| 3. | ||||||
| 4. | ||||||
| 5. | ||||||
| 6. | Electricity Expenses | 18000 | 16000 | 22000 | 76000 | |
| 7. | Advertisement Expenses | 22000 | 26000 | 18000 | 28000 | |
| 8. | Total Cost | |||||
| 9. | Net Profit | |||||
| 10. | Selling price per unit | 50 | 50 | 50 | 50 | |
| 11. | Cost price per unit | 35 | 35 | 35 | 35 |
Based on the information given in the spread sheet above, write the formula for calculating each of the following:
(a) Sales Revenue for Quarter 1 in cell B3.
(b) Cost of Goods Sold for Quarter 2 in cell C4.
(c) Total Advertisement Expenses incurred in cell F7.
(d) Gross Profit for Quarter 4 in cell E5.
(e) Electricity Expenses for Quarter 3 cell D6.
How is a Formula different from a Function in Excel?
