Page 115 - IT-802_class_12
P. 115

11.  The  contents  of  cell  A1,  A2,  A3,  and  A4  in  a  Spreadsheet  application  are  10,  15,  20,  25  respectively.  If  the  formula
                 =COUNT(A1:A4) is entered in cell A5, ............................ value will be displayed in A5.   [CBSE Sample Paper 2022]
                 i.  70                                            ii.  4
                 iii. 45                                           iv.  65
              12.  What will be displayed, if the following formula is entered in cell A1 in a spreadsheet application:
                  =6^2+15/3*2-7                                                                [CBSE Sample Paper 2022]
                 i.  39                                            ii.  15
                 iii. -14                                          iv. -38
              13.  Which of the following functions can be performed with the help of spreadsheets?           [NCERT]
                  a. Maintaining records
                 b. Creating videos
                 c. Analysing data
                 d. Performing financial calculations
                 e. Writing letters
                 i.  a, b, c, d, e                                 ii.  a, c, d
                 iii. a, c, e                                      iv.  c, d, e
              14.  Which of the following features is used to  perform addition in spreadsheets?              [NCERT]
                 i.  Format option                                 ii.  Charts
                 iii. Graphs                                       iv.  Formula
              15.  What happens when you change the layout of a slide?                                        [NCERT]
                 i.  The format of the text changes
                 ii.  New slide is inserted
                 iii. The arrangement of content (text, images, shapes) changes
                 iv. The title gets aligned to the center of the slide

                  Ans.  1. ii   2. iii   3. i     4. ii     5. iv     6. ii    7. i     8. iv    9. i      10. i
                     11. ii    12. i    13. ii    14. iv   15. iii


            B.  Fill in the blanks.
               1.  ............................... refers to the use of technology for communication and processing information.
               2.  A ............................... is a computer application for computation, organization, analysis and storage of data in tabular form.

               3.  A ............................... is the intersection of a row and a column in the worksheet where data is entered by the user.
               4.  All the data that is entered by the user appears in the ............................... .
               5.  To perform a calculation, the ............................... symbol is used, which indicates a formula has been used and the calculation
                 is to be done.

                 Ans.  1.  ICT           2.  spreadsheet      3.  cell          4.  formula bar
                       5.  ‘=’



                                                            Section B
                                                    (Subjective Type Questions)
            A.  Answer the following questions:
               1.  Write a short note on ICT.
             Ans.  Information and communications technology (ICT) skills refer to one’s ability to converse with people through various
                 technologies. Similar to information technology (IT), ICT refers to the technology used for regular, everyday tasks like sending
                 an email, making a video call, searching for information on the internet, using a tablet or mobile phone, and more.


                                                                                                   ICT Skills-IV  113
   110   111   112   113   114   115   116   117   118   119   120