CBSE Class 5 Computer Science Worksheet Set A

FILL IN THE BLANKS :

Topic : Microsoft Excel 2007

New Words

ARRANGE

SPREADSHEET

DRAGGING

WORKSHEET

WORKBOOK

REFERENCE

COLUMNS

POINTER

FORMULA

INFORMATION

ARITHMETIC

OPERATOR

BOUNDARY

HIGHLIGHTED

INTERSECTION

ANSWER THE FOLLOWING QUESTIONS:

Question : What is a spreadsheet software?
Answer : A spreadsheet or worksheet is a file made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas and the data in cells. Examples: Microsoft Excel, Lotus.

Question : Explain the difference between a workbook and a worksheet.
Answer : The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook).

Question : What do you understand by cell reference?
Answer : A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a variable in a formula. Ex. cell D5 refers to the column D and the 5th row.

Question : What is the use of AutoSum function?
Answer : The AutoSum feature of excel provides a shortcut to adding up columns or row of number in an excel spreadsheet. It helps to carry out the task at a great speed. When you want to total a particular row or column you use this function. Without inserting a formula in the formula bar you can directly total the row or the column by just clicking on AutoSum.

Question : What is a formula?
Answer : Formula in Excel is an expression that operates on values in a range of cell addresses and operators. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

Q. A: FILL IN THE BLANKS:

1. Microsoft Excel is a _________ software widely used to perform mathematical calculations.

2. A __________ is a file that opens when you start MS Excel.

3. Each new workbook comes with _________ .

4. A worksheet is divided into ___________ and _____________.

5. Each column has an _________ heading at the top.

Q. B: STATE TRUE OR FALSE:

1. There are 10485 rows in a worksheet.

2. When a new workbook is opened, it displays 3 Sheet tabs.

3. Enter key is used to move to the next adjoining cell.

4. The Enter button works like an Enter key in Excel.

Q. C: Answer in one word:

1. How many rows are there in a worksheet?
Ans. _____________

2. What are the row headings indicated with?
Ans. _____________

3. Which box shows the address of the active cell?
Ans. _____________

4. Which Symbol indicates that a formula is entered in a cell?
Ans. _____________

Fill in the blanks: (Scroll down for answers)

1. Two types of System software are _______________________ and ____________________.

2. Programs are written in ________________ languages.

3. An _____________________ manages the working of the processor by allocating various jobs to it.

Match the following:

1. Father of Pentium MicroPro

2. Inventor of QWERTY keyboard layout Prof. Seymour Rubinstein

3. Founder of MicroPro Vinod Dham

4. Developer company for WordStar Sir Christopher Latham

Encircle only one appropriate option of the following :

Question. Of the following who received Turing award for his outstanding contribution in Database technology :
(a) Seymour Rubinstein
(b) Charles W. Bachman
(c) Vinod Dham
(d) Sir Christopher Latham

Question. Which software let you manage and organize numerical data?
(a) Word Processor
(b) Presentation Software
(c) DBMS
(d) DTP

Question. Which software lets you easily create, add, find, update, sort, search, print and retrieve the information stored in a database?
(a) Word Processor
(b) DTP
(c) Electronic Spreadsheet
(d) DBMS

Answer the following:-

1. Write any five uses of an Operating System.

2. Write the importance of Utility programs in a computer.

3. What is a Back Up?

Differentiate between each of the following :

1. System software and Application Software

2. Graphics Software and Multimedia software

3. Program and Software

Answers :

Fill in the blanks:

1. Two types of System software are SYSTEM and APPLICATION SOFTWARE

2. Programs are written in computer languages.

3. An OPERATING SYSTEM manages the working of the processor by allocating various jobs to it.

Match the following:

1. Father of Pentium 4 MicroPro

2. Inventor of QWERTY keyboard layout 3 Prof. Seymour Rubinstein

3. Founder of MicroPro 1 Vinod Dham

4. Developer company for WordStar 2 Sir Christopher Latham

Encircle only one appropriate option of the following :

1. Of the following who received Turing award for his outstanding contribution in Database technology : Charles W. Bachman

2. Which software let you manage and organize numerical data? Electronic Spreadsheet

3. Which software lets you easily create, add, find, update, sort, search, print and retrieve the information stored in a database? DBMS

Answer the following:-

1. Write any five uses of an Operating System.

2. Write the importance of Utility programs in a computer.

3. What is a Back Up?

Differentiate between each of the following :

1. System software and Application Software

2. Graphics Software and Multimedia software

3. Program and Software

Question. Popular email program from Microsoft is/are
(a) Microsoft outlook
(b) Mail
(c) Both a and b
(d) None of these

Question. _______is used to search files from specific author
(a) Kind
(b) Other properties
(c) Date modified
(d) Size

Question. Shortcut key to duplicate the slide is ___________
(a) Ctrl+A
(b) Ctrl+B
(c) Ctrl+C
(d) Ctrl+D

Question. The popular antivirus programs are
(a) Norton antivirus
(b) McAfee VirusScan
(c) NOD32
(d) All of the above 

Question. Wild card characters include the following
(a) Asterisk(*)
(b) Question mark(?)
(c) Both ‘a’ and ‘b’
(d) None of these 

Question. Which of the following is the correct way to set picture password ?
(a) Settings > Personalization
(b) Settings > Change PC settings
(c) Devices > Picture password
(d) All of the above 

Question. To search image of specific size and color, click _____ in google images search result page
(a) Search tools
(b) More image
(c) Both a and b
(d) None of these

Question. Nimbuzz, AIM are all examples of
(a) Chat rooms
(b) Instant messengers
(c) Both a and b
(d) None of these

Question. Which of the following is not a gesture for picture password in Windows 8.1 ?
(a) Single click or tap
(b) Circles
(c) Straight lines
(d) Squares 

Question. When the picture is selected, _______ gets activated
(a) Review tab
(b) Picture tools
(c) View tab
(d) None of these

Question. When you want to hold a private chat, you can use an application called
(a) Instant messenger
(b) Internet chat
(c) Both a and b
(d) None of these 

Question. Shortcut to run the slide show is
(a) F2
(b) F3
(c) F4
(d) F5  

Question. A software that is loaded on your computer without your knowledge and runs against your wishes is called
(a) Virus
(b) Antivirus
(c) Bad software
(d) Antispyware

Question. ______is the latest search engine from Microsoft
(a) Bing
(b) Archie
(c) DuckDuckGo
(d) None of these

Question. Google allows up to _____ sizes of files to be exchanged through email
(a) 10MB
(b) 25MB
(c) 30MB
(d) 40MB

Question. The application that helps us search information on internet is known as
(a) Search engine
(b) Search companion
(c) Search option
(d) None of these

Question. ______ programs are designed to remove or block spyware
(a) Antivirus
(b) Popup blocker
(c) Firewall
(d) Anti-spyware

Question. Obtaining unauthorized access to other’s systems in a network or internet through skills, tactics and detailed knowledge is called
(a) Hacking
(b) Tracking
(c) Mailing
(d) Sharing 

Question. A new presentation can be created from
(a) Blank Presentation
(b) From existing presentation
(c) From Design template
(d) All of the above 

Question. You can also download _________ toolbar to block popup.
(a) Google
(b) Yahoo
(c) Both a and b
(d) None of these

Question. Powerpoint 2013 presentation can be run from current slide using
(a) F5
(b) Ctrl+f5
(c) Alt+f5
(d) Shift+f5

Question. Search engines are able to search __________ type of information
(a) Images
(b) Documents
(c) Videos
(d) All of these

Question. _________ is a software program installed on a computer to capture and record user’s keystroke
(a) Keylogger
(b) Keystroker
(c) Spyware
(d) Virus

Question. On your desktop computer, ______ offers the most direct way to locate a file on your computer
(a) Internet search
(b) File explorer
(c) Both a and b
(d) None of these 

Question. With the ___________ turned on , most popup ads are automatically blocked
(a) Antivirus
(b) Popup blocker
(c) Firewall
(d) None of these 

Fill in the blanks:

Question. Click __________ button to close the email account.

Question. _______ is the latest search engine from Microsoft.

Question. _________ is a computer software that is installed on a personal computer to intercept or take partial control over the user’s interaction with the computer.

Question. The most widely used search engine is ____________.

Question. Query to search all word files. ____________  

Question. The wildcard characters are _____ and _______.

Question. When you want to hold a private chat you can use an application called _______. 

Question. _______ is used to search files from specific author. 

Question. There are more than ______ search engines, but the best is __________. 

Question. You can also talk to your friend live in ______ using Hangouts.

Question. The top most result is the __________ in search engines. 

Question. To write a new email click the _______ button/link. 

Question. You must ______ a file before opening it.

Question. Query to search all files beginning with the letter S. __________  

Question. Search query to find all files beginning with the letter A and has the extension‘.bmp’.___________

A. Check the Right Answer

1. How many types of Software are there?
a. 2
b. Two
c. 2 types
d. Two types
Answer : Two types

2. Name some compression programs that shrink files to consume less space.
a. WinZip
b. 7-Zip
c. PkZip
d. All of these
Answer : All of these

3. Which software helps us to create professional looking documents quickly and efficiently?
a. Microsoft Word
b. WordPad
c. Word Processing Software
d. Word Processor
Answer : Word Processor

4. Name any one anti-virus software.
a. Avast
b. AVG
c. Norton
d. All of these
Answer : All of these

B. Fill in the blanks :

1. ………………… software allows us to accomplish specific tasks.
Answer : APPLICATION

2. ………………… program helps us to create professional looking documents, such as letters and reports.
Answer : MICROSOFT WORD

3. MS stands for …………………
Answer : MICROSOFT

4. A process that shrinks files, so that less disk space is occupied is known as ……………………………
Answer : COMPRESSION

C. State True (T) or False ( F)

1. A computer program is a set of instructions.
Answer : TRUE

2. Operating system is an example of Application Software.
Answer : FALSE

3. The full form of DBMS is DataBase Management System.
Answer : TRUE

4. Microsoft Excel is used to prepare documents.
Answer : FALSE

D. Application Based the following

1. Radhika wants to provide protection to her computer system against virus attacks. Which software will you suggest her to install?
Answer : ANTI-VIRUS UTILITY

2. Surabhi has made a project on Water pollution. She wants to mail it to her sister for further improvement, but it does not upload due to its over size. Which utility program will you suggest her for this task?
Answer : WINZIP, PKZIP, 7ZIP

A. State whether the following statements are True or False.

1. Search engines are a set of rules followed for communicating data in the networking environment - ______________.

2. Internet is a software - _____________.

3. Web server contains all the websites. - ____________.

4. Internet Explorer is a web browser - ___________.

5. HTTP is a protocol - ____________.

B. Fill the correct word in the blanks.

1. __________ is a device that allows communication with other computers.

2. ____________ stands for Uniform resource locator.

3. ____________ are a set of rules followed for communicating data in the networking environment.

4. _____________ allows you to communicate with others in real time.

5. WWW stands for ___________________________.

C. Write the full form of the following:

1. HTTP

______________ 

2. WWW

_______________ 

3.W3C

__________________ 

4. URL

________________ 

World wide web, protocols, URL, modem, chatting

D. Answer the following questions:

1. Define search engine. Name the various search engines.

Ans: _______________

2. What do you mean by video conferencing?

Ans: _______________

3. What is a modem? Explain its types.

Ans: ________________

4. Explain some of the search techniques while using a search engine.

Ans: ______________

A. Check the Right Answer

1. Which type of computers do we use in schools?
a. Personal
b. Micro computers
c. Micro
d. Personal computers
Answer : Micro computers

2. What was the source of input in Hollerith’s machine?
a. Punched cards
b. Loom Machine
c. Mini Computers
d. Typewriter
Answer : Punched cards

3. Which was the first automatic sequence controlled calculator?
a. ENIAC
b. Mark I
c. Mark II
d. Pascaline
Answer : Mark I

4. In which country was the Abacus developed?
a. China
b. Japan
c. Thailand
d. Russia
Answer : China

B. Fill in the blanks :

1. The two parts of Abacus are called Heaven and ……………
Answer : EARTH

2. The fourth generation computers used ……… as its basic circuitry.
Answer : MICRO PROCESSORS

3. ……………... was the first electronic computer.
Answer : ENIAC

4. The frame of an Abacus is divided into …..parts.
Answer : TWO

5. The third generation computers were the first to use ……………
Answer : INTEGRATED CIRCUITS

6. ........... is the world’s fastest Super computer
Answer : TIANHE-2

7. The era of first generation computers was ..................
Answer : 1940-1956

8. .............. is an example of supercomputer.
Answer : CRAY1

9. ..................are used in homes, schools, shops, offices, banks etc.
Answer : MICRO COMPUTERS

10. ..................... language was used in first generation of computers.
Answer : MACHINE

C. Answer the following

1. Name the first mechanical device for calculations developed in China.
Answer : ABACUS

2. What was the source of input in Hollerith’s Tabulating machine?
Answer : PUNCHED CARDS

3. Which generation of computers did UNIVAC belong to?
Answer : FIRST GENERATION

4. In which year did Charles Babbage invent the Analytical engine?
Answer : 1837

D. Application Based the following

1. Raman is working in the National Weather Forecasting agency. Which type of a computer is he using to forecast the weather conditions?
Answer : SUPER COMPUTERS

2. Which type of computers does Indian Railways use to interact with the customers for the booking and cancellation of tickets?
Answer : MAINFRAME COMPUTERS

Q1. DEFINE

1. Powerpoint____________________________

2. Title bar______________________________

3. Slide pane___________________________

Q2. Fill ups

1. To load Ms Power point click at

_________________→____________________→__________________→_______________

2.__________________,___________________,____________________ are the three main Views of Power point.

3. Formatting means to change _____________,_________________,_______________etc.

Topic : INTERNET AND E-MAIL

New Words

INFORMATION

ENTERTAINMENT

MAILING

CONFERENCING

BROWSER

HYPERLINK

UNIFORM

RESOURCE

LOCATOR

EXPLORER

REFRESH

ELECTRONIC

COMPOSE

UNIQUE

RECEIVE

ANSWER THE FOLLOWING QUESTIONS:

Q1. What is Internet?
Answer : The Internet is a vast network that connects computers all over the world. Through the Internet, people can share information and communicate from anywhere with an Internet connection. Some uses of internet are
• We can search for anything on the internet.
• The Internet is a handy platform to upload, download, and share data.
• The Internet also provides a good source of entertainment.
• With the internet, we can connect with people all over the world.
• Online banking was possible because of the internet.

Q2. - What is Hot Link?
Answer : A Hotlink or Hyperlink, or simply a link, is a reference to data that the user can follow by clicking or tapping. A hyperlink points to a whole document or to a specific element within a document. Hypertext is text with hyperlinks. The text that is linked from is called anchor text.

Q3. What is E-mail?
Answer : Electronic mail (or e-mail or email) is an Internet service that allows people who have an e-mail address (accounts) to send and receive electronic letters. Those are much like postal letters. Example: rohit13@rediffmail.com, amitkanpur@gmail.com etc.

Q4. What does inbox display?
Answer : An inbox display is what your email looks like in a subscriber's inbox before they even open it. It includes the sender name, subject line and preview text, and is your first and biggest opportunity to motivate the reader to open.

Q5. What is the use of Cc field while you compose an e-mail?
Answer : CC stands for Carbon Copy. The CC field is used to refer to the concept of the carbon copy as it sends additional copies of a single email to one or more recipients. CC field is for those recipients who are receiving the email as a courtesy or so that they are kept in the loop.

Q1)Write two similarities between Files and Folders .

Ans 1) ________________________

Q 2)What is the use of music folder ?

Ans 2 ) _______________________

Q3)Write the steps to Rename a File/Folder.

Ans 3 ) _________________________

Q4 )Write the steps to select multiple files.

Ans 4 ) ________________________

Q5 )Write the steps to empty the Recycle Bin .

Ans 5) ________________________

Q.A- Fill in the blanks:

1. The full form of ENIAC is_______
Answer : Electronic Numerical Integrator And Computer.

2. The full form of UNIVAC I is_______
Answer : Universal Automatic Computer I.

3. PDP-10 is an example of _______ computers.
Answer : Mainframe 

4. The need to keep a track of numbers led to the invention of different_______ calculating 
Answer : devices.

5. Each rod in Heaven has_______ beads and each rod in Earth has _______beads.
Answer : 2, 5

6. Lady Augusta Ada Lovelace, was an _______ and writer
Answer : English mathematician

7. _______ Boole was an English mathematician.
Answer : George

8. CRAY-1, CRAY-2, PARAM, ETA -10, etc . are example of _______  computer.
vSuper

9. IBM Z series, PDP-10 and System Z10 are example of _______  computer.
Answer : Mainframe

10. Wrong input leads to  _______ output.
Answer : wrong

Q.B- Multiple Choice Questions:

1. The era of first generation computers was ……………………………
a. 1920- 1936
b. 1940- 1956
c. 1950- 1958
d. None of these
Answer : B

2. …………………………. Invented a machine called Tabulating machine.
a. Howard Aiken
b. Von Neumann
c. Herman Hollerith
d. None of these
Answer : C

3. Abacus was the first mechanical device for calculations, developed in ……………………. .
a. America
b. China c. India
d. None of these
Answer : B

4. ………………………. consisted of 18,000 vacuum tubes and was 1000 times faster than the Mark I.
a. ENIAC
b. Abacus
c. UNIVAC
d. None of these
Answer : A

5. The era of second generation computers was ……………………………
a. 1920- 1936
b. 1940- 1956
c. 1956- 1963
d. None of these
Answer : C

6. Augusta Ada was the ______ programmer..
a. First
b. Second
c. Third
d. None of these
Answer : A

7. IBM 1400 computers are developed in _____ generation of computers.
a. First
b. Second
c. Third
d. None of these
Answer : B

8. Magnetic Tapes were used as storage devices in ______ generation of computers.
a. First
b. Second
c. both a and
b d. None of these
Answer : C

9. __________ is the world's fastest supercomputer.
a. PDP 10
b. Tianhe -2
c. System z10
d. None of these
Answer : B

10. Name any one anti-virus software.
a. Avast
b. AVG
c. Norton
d. All of these
Answer : D

Q. C- State True or False:

1. Each software is created by writing programs in computer languages.
Answer : True

2. Augusta Ada was the first programmer.
Answer : True

3. ENIAC was the first general purpose electronic digital computer, invented in 1956.
Answer : False

4. MARK I was the first computer to handle both numeric and text data.
Answer : False

5. Computers are categorized into four types with respect to their speed, storage capacity, size and cost.
Answer : True