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

