Advertisements
Advertisements
प्रश्न
How is a Formula different from a Function in Excel?
फरक स्पष्ट करा
उत्तर
| Formula | Function | |
| 1. | The formula is like an equation in Excel which the user types. It can be any type of calculation depending on the user’s choice. | A function in Excel is a predefined calculation which is in-built in Excel. |
| 2. | Manually typing out a formula every time a calculation needs to be performed is time consuming, Eg. = A1 + A2 + A3 | Performing calculations are more comfortable and faster while working with functions. Eg. =SUM(A1 : A3) |
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.
Where is the address of the active cell displayed?
