Advertisements
Advertisements
प्रश्न
Read the following table.
| A | B | C | D | E | |
| 1 | Year | Chennai | Madurai | Tiruchi | Coimbatore |
| 2 | 2012 | 1500 | 1250 | 1000 | 500 |
| 3 | 2013 | 1600 | 1000 | 950 | 350 |
| 4 | 2014 | 1900 | 1320 | 750 | 300 |
| 5 | 2015 | 1850 | 1415 | 820 | 200 |
| 6 | 2016 | 1950 | 1240 | 920 | 250 |
Above table shows the sales figures for “Air Cooler” sold in four major cities of Tamilnadu from the year 2012 to 2016. Based on this data, write the formula to calculate the following.
- Total sales in the year 2015.
- Total sales in Coimbatore from 2012 to 2016.
- Total sales in Madurai and Tiruchi during 2015 and 2016.
- Average sales in Chennai from 2012 to 2016
- In 2016, how many “Air Coolers” are sold in Chennai compared to Coimbatore?
थोडक्यात उत्तर
उत्तर
- Formula to find total sales in the year 2015 is; = SUM(B5:E5)
- Formula to find total sales in Coimbatore from 2012 to 2016: = SUM(E2:E6)
- Formula to find total sales In Madurai and Tiruchi during 2015 and 2016: =SUM(C5;D6)
- Formula to find average sales in Chennai from 2012 to 2016; = AVERAGE(B2:B6)
- Formula to find, in 2016, how many “Air Coolers” are sold in Chennai compared to Coimbatore? =(B6-E6)
shaalaa.com
Creating Formulae
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
APPEARS IN
संबंधित प्रश्न
A formula in calc may begin with ______.
What will be the result from the following formula (Assume A1=5, B2=2)? + A1^B2?
What will be the result from the following expression (Assume H1=12, H2=12)? = H1<>H2?
Write about the text operator in OpenOffice Calc.
Write the general syntax of constructing a formula in Calc.
Define Text Operator.
In cell A1=34 A2=65 A3=89 write the formula to find the average.
