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

