a. iii. b. ii.
1. Tick [ü] the correct answer.
a. F b. T
2. Write 'T' for True and 'F' for False statements.
3. Fill in the blanks.
a. 1024 b. hard copy
4. Answer the following questions.
a. Graphic tablet, also called Digitizer, is an input device which has a special pen (stylus) to write on it. It is used to draw images on the computer as well as to give instructions to the computer.
b. A bar code is a set of lines of different thickness that gives information about the product like its price, manufacturing date, etc.
Bar code reader, also called a bar code scanner, is used to input data from bar codes.
c. Computer memory is the basic unit where data and instructions are stored temporarily. Memory usually consists of one or more chips on the motherboard.
d. RAM is a type of primary memory that can be read from and written to by the processor and other devices. RAM is called volatile memory.
It can store data or information temporarily till the computer is working or switched ON. Once the computer is switched OFF, everything is lost from it. ROM is another type of primary memory used for storing the data that can be read only and cannot be written or changed. ROM is a non-volatile memory as its contents do not get lost even when the computer gets switched OFF.
28
UNIT TEST - 2
Chapters 3 - 5
a. ii. b. i.
1. Tick [ü] the correct answer.
a. F b. F
2. Write 'T' for True and 'F' for False statements.
3. Fill in the blanks.
a. LET b. View
4. Answer the following questions in brief.
5. Answer the following question.
a. A macro is a series of commands that is recorded so that it can be played back or executed later.
b. Adobe Acrobat Reader.
a. The PRINT statement is used to display the output on the screen. The text messages can also be displayed by using PRINT statement.
Whatever message we want to display, we must put it in double quotes after the PRINT command.
The INPUT statement is used to assign the value or data to variable at the time of execution. INPUT command waits for the user to type a line of text into the text output window.
4. Answer the following questions.
a. It appears when the column is too narrow to display the result of the calculation.
b. The different number formats in Excel are General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and Custom.
c. An Active cell has a dark border around it. Whatever data we will enter appears in the Active cell.
d. There are 1048576 rows and 16384 columns in a worksheet.
a. iii. b. iii.
1. Tick [ü] the correct answer.
a. T b. F
2. Write 'T' for True and 'F' for False statements.
3. Fill in the blanks.
a. Ctrl + S b. Arrow keys
30
UNIT TEST - 4
Chapters 8 - 9
a. ii. b. iii.
1. Tick [ü] the correct answer.
a. F b. F
2. Write 'T' for True and 'F' for False statements.
3. Fill in the blanks.
a. meta b. cell reference
4. Answer the following questions.
a. An e-mail address is a combination of a user name and a domain name that identifies the user so that he or she can receive messages.
b. A search engine is a software program which helps in finding websites, web pages and Internet files.
c. A message written in capital letters is annoying and hard to read. This is called shouting.
d. A Formula is a sequence of cell reference, mathematical functions or operators of existing value to give new value.
A function is a built-in formula that you can use to perform a calculation on the data in your worksheet.
a. i. b. iii. c. ii. d. iii.
1. Tick [ü] the correct answer.
a. Cloud b. nibble, byte c. 1 d. user
2. Fill in the blanks.
3. Answer the following questions in brief.
4. Answer the following questions.
a. A computer system is a collection or combination of many devices which work together to perform a task.
b. Byte is the basic storage unit of memory.
c. Macro is a series of commands that is recorded so that it can be played back or executed later.
d. REM (Remarks) is a non-executable statement that is ignored by the computer during execution of a program. It is used at the beginning of the program to give it a title.
a. The INPUT statement is used to assign the value or data to variable at the time of execution. INPUT command waits for the user to type a line of text into the text output window. LET statement is also used to assign a value or data to the variable, but the value of a LET statement cannot be changed at the time of execution.
b. We can use the Mail Merge feature to produce a personalized letter for each person on our mailing list. Performing a mail merge is useful if we want to send the same document, such as an announcement or greetings card, to many people.
c. The Primary memory is the main memory of the computer which resides in the computer. The data which is in the main memory is only processed by the computer. RAM and ROM are the types of primary memory.
Secondary memory is also called an external memory. It can store the data permanently and data can be edited any time, if required. The different types of secondary memory, such as Hard disk, Floppy disk, CD/DVD-ROM, Pen drive, etc., are used in the computer.
d. Dot-matrix printer contains movable print head with pins that strike the ribbon, placing a dot on the paper. These printers are less expensive but are very noisy.
Laser printer uses laser technology to print text or images on paper. It gives the best quality output and is the most expensive.
32
Model Test Paper - 2
Chapters 6 - 9
a. iii. b. ii. c. iii. d. ii.
1. Tick [ü] the correct answer.
a. Undo b. Arithmetic c. AutoFill d. @
2. Fill in the blanks.
3. Answer the following questions in brief.
4. Answer the following questions.
a. .xlsx file extension.
b. A cell is referred to by its unique address or cell reference, which is the coordinate of the intersecting column and row.
c. Spider, also called a crawler or bot, reads pages on websites in order to create a list or index of hits for our search.
d. Packets are the small chunks which are broken by the Internet while sending the e-mail message from one computer to another.
a. E-mail is an (electronic mail), is the most frequently used application of the Internet. It has become a powerful tool of communication because it is an economical, convenient and fast way of sending and receiving messages. All types of messages from simple text to pictures, sound and video files can be sent through it. The message sent through e-mail can reach within a few minutes.
b. Arithmetic Operators are used to perform mathematical calculations like addition, subtraction, division, multiplication and exponential.
Logical Operators are used to combine two or more relational expressions. The logical operators are AND, OR, NOT.
c. The Internet is one of the largest networks that links millions or trillions of computers all over the world. Internet is one of the major reasons why people buy computers these days.
Some of the uses of internet are:
i. E-mail: E-mail is the fastest way of sending and receiving messages from one computer to another all over the world.
ii. Chat: The chat feature allows us to exchange the typed messages with another person on the Internet.
iii. Buy and Sell: We can buy or sell products on the Internet, even
music.
d. A search engine is a software program which helps in finding websites, web pages and Internet files. Search engines are particularly helpful in locating web pages on certain topics or in locating specific pages for which we do not know the exact URL (web address).
Search engines require that we enter a word or phrase, called search text, that describes the item we want to find.
