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

4.   What is the formula to find out the most costly item in the list?
                          i.  =MAX(D4:D10)                                             ii.  =MAX(D4;D10)
                          iii.  =MAX(F4:F10)                                                 iv.  =MAX(F4;F10)
                      5.   What is the data type for the field ‘Items purchased’?
                          i.  Numeric                                         ii.  Alpha–Numeric
                          iii.  Date/Time                                                        iv.  Formula

                      Ans. 1. iii    2. ii   3. iii    4. i   5. i

                                                                 PART B

                  A.  Short answer type questions.
                      1.   What is meant by sorting data?
                      Ans.  Sorting refers to the process of arranging data in ascending or descending order based on a certain
                          criteria.
                      2.   State the purpose of TODAY() and NOW() functions.
                      Ans. TODAY() produces the current date, it contains no argument.
                          NOW() produces the current date and time, it contains no argument.
                      3.   What is meant by Gridlines in a chart?
                      Ans.  Gridlines refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart
                          to enhance its readability.
                      4.   What does a #REF! error indicate?
                      Ans. #REF! occurs when a cell reference is not valid.
                      5.   Give difference between column chart and a bar chart.

                      Ans.                Column chart                                 Bar chart
                           A column chart represents the data over a   A bar chart represents the data in horizontal
                           period of time in columns.                  columns.
                           The measurement values are shown vertically   The measurement of values are organized
                           as Y-axis.                                  horizontally.

                      6.   What is a chart? List any three advantages of a chart.
                      Ans.  Charts and graphs are visual or graphical representation of data from a worksheet which is very useful for
                          instant analysis and decision making. Three advantages of charts are:
                          ●  Charts summarize large data set in visual form and estimate key value at a glance.
                          ●  Charts are visually appealing and it is easy for the users to compare the information.
                          ●  Charts help to forecast the trends on the basis of comparisons done.
                  B.  Long answer type questions.
                      1.   Discuss the components of an Excel formula using an example.
                      Ans.  A formula in a spreadsheet package may consist of the following:
                          ●   Cell Address: A1, C11, A24:B36, etc.
                          ●   Functions: SUM, MAX, MIN, etc.
                          ●   Equal to’ operator: A formula always starts with an ‘=’ operator.
                          ●    Operators: + (Addition), - (Subtraction), * (Multiplication), / (Division), Exp (Exponent) are mathematical
                              operators. >(Greater than), <(Less than), = (Equal to), <>(Not equal to), <= (Less than or equal to),
                              >=(greater than or equal to) are relational operators.
                          ●   Parenthesis: ().


                   216    Touchpad Computer Applications-IX
   213   214   215   216   217   218   219   220   221   222   223