Page 217 - CA 165 ver 1.0 Class 9
P. 217

Solved Exercise


                                                                PART A

                 A.   Very short answer type questions.
                     1.   Name the error displayed when we write =SIM in place of =SUM while applying the sum function.
                     2.   Which feature helps arrange data in ascending or descending order?
                     3.   Name the chart that uses lines to show information and change over a period of time.
                     4.   Name the chart that represents data in horizontal columns.
                     5.   What is a set of values which the user wants to plot in a chart called?

                     Ans. 1. #NAME    2. Sorting    3. Line Chart    4. Bar Chart    5. Data Series

                 B.   Fill in the blanks.
                     1.  ..................................... function produces the largest value from the given range of cells.
                     2.  ..................................... is a symbol that performs certain mathematical or logical operations.
                     3.  ..................................... is a quick and easy way to get required information from the subset of data in a range
                         of cells.
                     4.  ..................................... helps to identify the plotted data series.
                     5.     Cell  referencing which is  combination of absolute and relative referencing is  called
                         ..................................... referencing.

                     Ans. 1. MAX( )   2. Operator   3. Filtering   4. Legend    5. Mixed
                 C.   Case Based MCQs
                     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:















                     1.   In cells F4, what is the formula needed to calculate the cost of dinner plates.
                         i.  =ROUND(D4;E4)                                                 ii.  =MOD(D4;E4)
                         iii.  =PRODUCT(D4;E4)                                     iv.  =POWER(D4;E5)
                     2.   In cell F11, what is the formula that computes the total amount?
                         i.  =SUM(F4;F10)                                                   ii.  =SUM(F4:F10)
                         iii.  =COUNT(F4:F10)                                iv.  =SUM(D4:D10)
                     3.   What is the formula to find out the item that costs the minimum out of all the items mentioned?
                         i.  =MIN(D4;D10)                                    ii.  =MIN(E4:E10)
                         iii.  =MIN(D4:D10)                                  iv.  =MIN(F4:F10)



                                                                                                Data Analysis    215
   212   213   214   215   216   217   218   219   220   221   222