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

If,  Temperature  in  Fahrenheit  =  9  ÷  5  ×  (Temperature  in  Celsius  +  32).  Also,  name  the
                       referencing techniques that can be used to copy the formula to the other cells to obtain the
                       result for C3, C4.                                                                           [2]
                  20.  Write down the steps to hide columns in spreadsheet.                                         [2]

                  21.  Write down the steps to perform the following operations:                                    [3]
                       i.  Report incidents to CERT-In

                       ii.  Report vulnerability to CERT-In

                  22.  Explain the functional elements of CPU with diagram.                                         [3]
                  23.  What are the common types of media used in guided networking? Explain them briefly.          [3]

                  24.  Define spyware. What measures can we take to prevent attacks of spyware?                     [3]
                  25.  Describe the term ‘Line spacing’. Explain various Line spacing options available.            [3]

                  26.  Create the following table in electronic spreadsheet and do the following:                   [5]










                       i.   Insert 5 more records in similar way. The maximum marks is written along with the given subject
                          names.

                       ii.   Calculate the total marks scored in science and social studies and store it in column N3 and O3
                          respectively for the first student.
                       iii.   Copy the formulas of cells N3 and O3 to calculate the total marks in science and social studies
                          for the rest of the students.

                       iv.   Calculate the percentage for the first student and copy the formula to the rest of the cells.

                       v.   Find the maximum and minimum marks obtained in each subject and store it in row 10 and 11
                          of respective subject column.




























                   232    Touchpad Computer Applications-IX
   229   230   231   232   233   234