Advertisements
Advertisements
Question
Where is the address of the active cell displayed?
Options
Row heading
Status bar
Name Box
Formula bar
MCQ
Advertisements
Solution
Name Box
shaalaa.com
Concept of Electronic Spreadsheet (ES)
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
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?
