Page 81 - KEC Khaitan C6 Flipbook
P. 81

e.   To sort data in ascending order, you would select the option ____________ in the Sort &
                      Filter menu.
                    f.   Unauthorised copying or stealing of software is known as ____________.

                    g. Machine language consists of two digits: 0 and ____________.


                 3.  Write 'T' for true or 'F' for false.

                    a. The SUM() function is used to calculate the average of a given set of values.


                    b. Sorting data in Excel cannot be done in descending order.


                    c.  Phishing involves sending legitimate offers and rewards via e-mails.


                    d. Plagiarism is considered academic dishonesty and literary theft.

                    e.  Flowcharts use geometrical shapes and arrows to represent steps and their flow.



                 4.  Answer in one words.

                    a. The Paste option is present under which tab?                                   ____________

                    b. Which toolbar contains the Undo and Redo buttons?                              ____________
                    c.  Which chart type is used to show correlations between two sets of values?  ____________

                    d. What language is known as the computer's native language?                      ____________
                    e.  Which feature helps you view only specific data in Excel?                     ____________

                    f.  What are the online or Internet-based illegal acts called?                    ____________


                 5. Think and answer.

                    a.  You have a worksheet with students names, but some names have spelling mistakes. How
                      can you correct all the errors quickly without manually checking each one?

                    b.  Adhyay entered a ten-digit number in Excel. He now wants to extract the last three digits of
                      this number. Which function should he use for this? Also write the syntax.

                    c.   Ramesh wants to show how two different variables, such as advertising spend and sales
                      revenue, are related to each other. Which type of chart is most suitable for this purpose?

                    d.  You are given a list of students’ scores. How can you automatically highlight scores below 40
                      to identify weak students?
                    e.   You are receiving an e-mail from a bank asking for your account details. What steps will you

                      take to ensure that this is not a phishing attempt?
                    f.   Which tool would you use to plan the steps for creating a school project before starting the
                      actual work?




                                                                                                                  79
                                                                                                       Test Sheet
                                                                                                       Test  Sheet  79
   76   77   78   79   80   81   82   83   84   85   86