Page 80 - KEC Khaitan C6 Flipbook
P. 80

test sheet 1



                                  test sheet                                                  (Based on chapters A1 to A6)






                  1.  Tick ( ) the correct option.

                    a. What appears around a cell when it is selected?

                         (i)  A green border                         (ii)  A red border

                       (iii)  A blue border                          (iv)  A yellow border


                     b. What type of operator is the colon (:) in Excel?
                         (i)  Arithmetic                             (ii)  Comparison


                       (iii)  Reference                              (iv)  Logical

                     c.  Name the tab you select for changing the type of an existing chart in Excel.

                         (i)  Insert                                 (ii)  Design

                       (iii)  Format                                 (iv)  Chart Design

                     d.  Which of the following is used to check a condition and take action based on the results in
                        Excel?

                         (i)  SUM()                                  (ii)  AVERAGE()

                       (iii)  IF()                                   (iv)  COUNT()

                     e.  Which of the following acts refers to sending unwanted e-mails repeatedly?

                         (i)  Phishing                               (ii)  Hacking

                       (iii)  Spamming                               (iv)  Plagiarism

                     f.  What is the graphical representation of a process and its logic called?

                         (i)  Algorithm                              (ii)  Program

                       (iii)  Flowchart                              (iv)  Data Chart



                  2.  Fill in the blanks.

                     a. When we select more than one cell at a time, these contiguous cells form a  ____________.
                     b.  The feature of entering sequential data in the cells of a worksheet is called ____________.

                     c.  The ____________ axis is also known as the category axis.
                     d.  ____________ can be either horizontal or vertical lines that make it easier to read and
                        understand values in a chart.





                                                                                                                                                                                                                                              79
                   78   Premium Edition-VI                                                                                                                                                                                        Test  Sheet  79
                                                                                                                                                                                                                                  Test Sheet
   75   76   77   78   79   80   81   82   83   84   85