Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 84 - 2612 Digimind C6
P. 84

    test sheet 1

                                    test sheet 1                                                 (Based on chapters 1 to 6)

                      1.  Tick ( ) the correct option.

                         a.  While preparing a marksheet, Meena selects a continuous range of cells from A1 to A10
                            using the symbol A1:A10. Which type of operator is she using in Excel?

                             (i)  Arithmetic                             (ii)  Comparison

                           (iii)  Reference                              (iv)  Logical

                         b.  Rahul has already created a chart in Excel, but now he wants to change it from a column
                            chart to a pie chart. Which tab should he select to change the type of an existing chart?

                             (i)  Insert                                 (ii)  Design

                           (iii)  Format                                 (iv)  Chart Design

                         c.  Rahul tries to divide a number in a cell by another cell that is empty or contains zero. Excel
                            displays an error message. Which error message appears in this situation?

                             (i)  #DIV/0!                                (ii)  #NAME?
                           (iii)  #VALUE!                                (iv)  #REF!

                         d.  A school management  system  uses  a set  of steps  to  find a student’s  roll  number  from
                            thousands of records. What is the main use of the algorithm here?

                             (i)  Data processing                        (ii)  Searching data

                           (iii)  Data manipulation                      (iv)  Logical operation

                         e.   Rohit uses a diamond shape to ask, “Is marks ≥ 40?” in a flowchart for checking pass or fail.
                            What does this symbol indicate?

                             (i)  Decision                               (ii)  Input/Output

                           (iii)  Process                                (iv)  Connector

                         f.   Aarav wants to find information about planets for his homework by typing keywords and
                            getting a list of web pages. Which of the following should he use?

                             (i)  Skype                                  (ii)  Dropbox

                           (iii)  Google                                 (iv)  Amazon
                         g.  Rohan keeps receiving promotional emails every day from unknown senders, even though

                            he never signed up for them. Which cyber activity does this situation describe?

                             (i)  Phishing                               (ii)  Spamming
                           (iii)  Hacking                                (iv)  Plagiarism

                       82
                                                                                                                                                                                                                                                  83
                       82   Premium   Edition-VI                                                                                                                                                                                     Test  Sheet  1  83
                                                                                                                                                                                                                                     Test Sheet 1
                            Premium Edition-VI

| 79 80 81 82 83 84 85 86 87 88 89 |