Name : ________________________

Roll No : ________________________
Date of Submission : ________________________
Grade/Sec : IX
Subject : Information technology (402)

Unit- III ICT Skills and Unit-IV Electronic Spreadsheet

Fill in the blanks
1. One Tera Byte is equal to 1024 GB.
2. POST stands for Power-On Self-Test
3. Ctrl+N key combination is used to insert a new workbook
4. Hard Disk is made up of a collection of disks known as platters.
5. Labels entered in the cell are automatically left aligned
6. The Recycle bin is used by Windows computers to store deleted items.
7. Fill handle allows the user to extend a series of data and thus results into speeding of data entry.
8. Web browser is an Interface between a user and the World Wide Web.
9. The extension of Excel file is .xlsx
10. Inbox folder of an e-mail account contains all the received mails.
State True or False
1. iOS mobile operating system has been developed by Google. [ F ]
2. GUI stands for Graphical User Interface. [ T ]
3. E-mail address is a unique identifier of your E-mail account. [ T ]
4. Parental Control and Safety Mode features are available on YouTube. [ T ]
5. A range is specified using (;) symbol. [ F ]
6. No video, music or text file can be attached to an E-mail. [ F ]
7. Linux operating system was developed by Microsoft Corporation. [ F ]
8. LED monitors offer better colour quality, clarity and display than LCD’s. [ T ]
9. A monitor is also called Visual Display Unit (VDU) [ T ]
10. AC, DR, AR and PC are types of Registers. [ T ]
Answer the following Questions:
1. List ICT services in a. Education b. Health Care c. Governance d. Business
Education:
ICT enables the use of innovative educational resources and the renewal of learning methods, establishing
a more active collaboration of students and the simultaneous acquisition of technological knowledge.
 Healthcare:
The fundamental use of ICT in Hospital is for electronic storage of medical data. This helps to retrieve
the information easily. Through ICT the data can be transferred to the patient or to the Doctors for
consultation.
Governance:
Businesses and individuals are able to carry out transactions with the government safely and easily online.
Business:
ICT includes all digital technology that assists individuals, businesses and organizations in using
information.
It covers all electronic products that deal with information in a digital form. Therefore, ICT is concerned
with digital data storage, retrieval and transmission.
2. What is a chart? Name four types of charts.

A chart is a graphical representation of data in a worksheet. It helps us to understand and compare large
quantities of data easily. They also make it easier to draw comparison, see growth and relationships among
the values and trends in data. They provide accurate analysis of information.
Types of Charts: Bar, Column, Line, Area, XY(Scatter) and Pie Chart.

3. Mention any five ICT tools that are used in day-to-day life.
● Mobile Phone
● Tablet.
● Interactive Whiteboard.
● E-Reader.
● Newspaper.
● Radio
● TV
● E-Mail

4. What are the three main components of a CPU?

Arithmetic and Logic unit (ALU), Memory Unit, and Control Unit.
5. What is the difference between RAM and ROM?
RAM is volatile memory that temporarily stores the files you are working on.
ROM is non-volatile memory that permanently stores instructions for your computer.
6. Name four functions of Excel?
The important functions of Excel are Sum(), Count( ), Min( ), Max( ), Average( ) etc.

7. Give three examples for each of these a. input devices b. output devices c. storage devices
Input Devices: keyboards, mouse, scanners
Output Devices: Monitor, Printer, Speakers
Storage Devices: Hard Drives, CD-ROM & DVD-ROM drives, floppy disk drives
8. What is a Scanner? What are its types?
A scanner is a device that captures images from photographic prints, posters, magazine pages and similar
sources for computer editing and display.
Types: Drum scanner, flatbed and handheld scanners.
9. List the different types of operating systems.
● Multitasking operating systems.
● Single user operating systems.
● Graphical User Interface operating systems.
● Multi-User operating systems.
● Multi-Threading Operating System
10. What is the difference between a workbook and worksheet?

Workbook Worksheet

A worksheet is composed of a very large A workbook is a collection of one or more worksheets,

number of cells which are the basic in a single file. Each workbook has a single theme and
storage unit for data in a file or workbook. contains at least one worksheet
Each sheet contains cells arranged in grid
pattern using rows and columns.

11. What is cache memory? What are its advantages?

It is a Special high speed memory which can either be inserted on motherboard or made a part of the CPU.
The CPU uses cache memory to store instructions that are repeatedly required to run programs, thus
improving the overall system speed.

12. What is Social Media.

A.It is a network of different people who form communities among themselves to share sentiments,
relationships topics, ideas etc of common interests.

13. Write Advantages of a chart?

A. Charts are visually appealing and make it easy for the users to compare and understand about
information
These help to forecast the trends on the basis of comparisons done

14. Write the full forms for the following

● DOS Disk Operating System
● ICT Information and Communications Technology.
● CRT Cathode Ray Tube
● LCD Liquid-crystal display
● LED Light-emitting diode
● CPU Central processing unit
● PROM Programmable read-only memory
● ALU arithmetic-logic unit
● CU Control Unit
● MU Memory Unit
● CD-RW-Compact Disk Re Writable
● ROM Read Only Memory
● RAM Random Access Memory
 ● HTTP Hypertext Transfer Protocol
● Cc Carbon copy
● BCC Blind Carbon Copy
Application based questions:
1. Mahitha’s uncle stays in another country. How can she stay connected with her uncle’s family.
By Using Social Networking sites and Video conference calls.
2. Vaibhav’s father works in the Healthcare industry. Name any few ICT services that he will use.
Hospital Management, diagnose, treat and monitor patients.
3. Pragathi wants to transfer data such as audio, video files from one computer to another. Suggest her a
device to accomplish her task.
USB, External Hard Drive.
4. Mr. Dev wants to send an E-mail to his boss. At the same time he wants to send a copy of the same to his
colleague also but doesn’t want his boss to know about that. What should he do now?
By Using BCC Option in email.
5. Observe the following picture and write
a) The formula to calculate Minimum and maximum of Oral.
= Max (C5:C11), =Min (C5:C11)
b) The formula to find Average of Oral and Written marks
= Average (C5:C11), =Average (D5:D11)