Page 234 - CA_165_V2.0_C9_Flipbook
P. 234

4.   Explain the following terms associated with charts:
                          i.  Data Labels                                     ii.  Walls and Floors
                          iii.  Plot Area                                     iv.  Data Series
                      Ans.  i.  Data Labels: It is the set of values which the user wants to plot in the chart.
                          ii.   Walls and Floors: In a 3-D chart, the base area or the plane in X-Y axis is called the floor and the
                              vertical areas, i.e. planes in X-Z and Y-Z axis are called walls.
                          iii.   Plot Area:  It is that area of the chart in which the data is plotted. In a 2-D chart; axis bound the plot
                              area whereas in 3-D charts, walls and floors bound the plot area.
                          iv.  Data Series: It is the set of values which the user wants to plot in the chart.

                  D.  Application based questions.
                      1.   What formula should be contained in the cell C2 to calculate Temp in Fahrenheit?







                            If Temperature in Fahrenheit = 9 ÷ 5 × (Temperature in Celsius + 32). Also, name the referencing techniques
                          that can be used to copy the formula to the other cells to obtain the result for C3,C4.
                      2.   Tripti wants to refer the range of cells from D2 to E5. What is the correct way of doing it?
                      3.     Soumil is entering the formula 22/3 in the cell to find the quotient. But the result is not getting displayed.
                          What can be the problem?
                      4.     Shyambhavi is applying absolute cell referencing using the formula = and A and 1 + 6. But she is not
                          getting the desired result, what could be wrong in this case?
                      5.   What will Sameera do if she wants to join the content of two cells as shown below:
                          A1 contains the text ‘Be’
                          A3 contains the text ‘Happy’
                          She wants B4 to display  ‘Be Happy’.

                      Ans. 1. =9/5*(B2+32), Relative Referencing
                          2. D2:E5
                          3. He needs to put ‘=’ sign before the formula.
                          4. She should use the $ sign instead of &.
                          5. She should write the formula =A1&A3 in B4.


                                                               SECTION C
                                               (Case-based/Passage-based Type Questions)

                      You have to plan your birthday party. You decide to create a spreadsheet to keep track of party
                      expenses. Consider the following worksheet and answer the questions that follow:


















                   232   Touchpad Computer Applications (Ver. 2.0)-IX
   229   230   231   232   233   234   235   236   237   238   239