Answer key New Revised Excel In Information Technology – 9

Chapter
Unit :2 :1 Data Entry And Keyboarding Skills

SESSION-1
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (b) 2. (a) 3. (b) 4. (b) 5. (a) 6. (b) 7. (b) 8. (b) 9. (c)
B. Answer the following
Ans-1 : To type capital letters you need to press and hold the Shift key then press the Alphabet keys. Capital letters can also
be typed using the Caps Lock key.
Ans-2 : Touch Typing Techniques
XX Put your left hand fingers on the keys ASDF and right hand fingers on the keys JKL; as shown. This is the base
position of your fingers. Try to return to base position after each stroke.
XX Colour coding as shown below indicates which finger is used to press each key.
XX The base position on the numeric pad is the number 5 key for the middle finger, 4 for the index finger, and 6 for
the ring finger of the right hand.
XX Upper-case letters and symbols appearing on the number keys are typed by one hand, with the little finger of the
other hand holding down the Shift key.
XX Do not look at the keyboard. Try to locate the right key with your fingers.
Ans-3 : 
Guide Keys : ‘F’ and ‘J’ are called guide keys on a computer keyboard. F is the guiding key for left hand and J is
the guiding key for right hand. Both contain a small raised tangible mark with the help of which the touch typist can
place the fingers correctly on the home keys without looking at the keyboard.
Ans-4 : Control key
Ans-5 : Tab key
Ans-6 :  he Num Lock key on Numeric keypad is used to switch ON or OFF the numeric keypad. When Num Lock key
T
is switched OFF, the keys on Numeric Keypad perform other functions like directional arrows instead of typing
numbers. If Caps Lock key is switched on, you will get capital letters and if you press it again, the letters will go back
to lower case (caps lock off).
Ans-7 : Mouse is a pointing device that is used to select and point at things. There are other functions that you can perform
with a mouse like:
(a) Single click (b) Double click
(c) Scroll (d) Hover
Ans-8 : I-beam is a type of mouse pointer that shows up in areas where text can be inserted. It also provides various
functionality like selecting and highlighting text.
C. Practical Work
Ans. : To be done by the students.
Session 2
Self Assessment
A. Multiple Choice Questions
Ans. : 1. (a) 2. (b) 3. (a) 4. (b) 5. (a) 6. (d) 7. (a)
B. Answer the following
Ans-1 : After downloading and installing the software, you can start it by following these steps:
Step-1: Click the Start button.

Computers-9 1
 Step-2: Click RapidTyping 5 folder from the Start menu.
Step-3: Again click RapidTyping 5 application. The Rapid Typing screen appears.
Ans-2 : Errors overview tab is used to check the errors that occurred during the lesson. The colours indicate the following :
XX Green shows correct characters.
XX Yellow characters show that the time frame has been exceeded.
XX Red shows incorrect characters.
XX Orange shows incorrect characters and the time for typing a character has been exceeded.
Ans-3 : Statistics Panel, consists of four parts :
XX Statistics toolbar has buttons to choose courses, remove selected statistics and customise the statistics display
options.
XX Course diagram shows the common statistics for all lessons of the current course.
XX Lesson diagrams show the statistics for each character or keystroke of the selected lesson in the course diagram.
XX Lesson statistics table shows the full statistics of the selected lesson in the course diagram.
Ans-4 : Student accounts, consists of three parts :
XX Student toolbar for adding, removing, inserting (import), saving (export) existing student accounts and student
groups and saving student statistics in different formats : PDF, HTML, XML, CSV, etc.
XX Student accounts is the area to select the current student account or student group.
XX Property panel is the area where you can edit or group student properties of the selected item in the Navigation
Tree.
Ans-5 : CPM = the number of characters typed in one minute
CPM = (Characters without errors + Characters with errors) / Time spent in minutes
Ans-6 : Click Course menu on the Toolbar.
XX You can add new courses using Course menu → Create new course.
XX You can insert an existing course from a file or library using Course menu → Add courses → From file/From
library.
XX You can save the selected course using Course menu → Save selected courses.
C. Practical Work
Ans. : To be done by students.
EXERCISE
SECTION–A
Multiple Choice Questions
Ans : 1. (d) 2. (b) 3. (c) 4. (d) 5. (a)
6. (a) 7. (c) 8. (d) 9. (c) 10. (b)
11. (c) 12. (d)
SECTION–B

Very Short Answers

Ans-1 : (a) Punctuation keys: These keys refer to all the keys having punctuation marks, like comma, period, semicolon
and so on. They also refer to all the mathematical operators.
(b) Return key: It is used to move the cursor to the beginning of the next line.
Ans-2 : Touch Typing is a method to type text on a computer, without looking at the keyboard.
Ans-3 : The Num Lock key on Numeric keypad is used to switch ON or OFF the numeric keypad. When Num Lock key
is switched OFF, the keys on Numeric Keypad perform other functions like directional arrows instead of typing
numbers.
Ans-4 : Typing ergonomics refer to the logistic support for efficient and effective type writing.

2 Computers-9
Ans-5 : Rapid typing is similar to a gaming software that helps to learn the concept of touch typing. It is simple and easy to use.
Ans-6 : When mouse pointer turns to this icon, it means computer is busy in processing some task.
Ans-7 : Rhythm in typing is very important which means the first character and the next character must be typed in
approximately same time gap. You can calculate the slowdown in words, character and keystrokes using the formulae
listed below.
SECTION–C

Short Answers
Ans-1 : (a) You can create a new lesson using Lesson menu → Create new lesson.
(b) You can import lessons using Lesson menu → Add existing lessons.
(c) To delete a lesson, select the lesson which is to be deleted from the Navigation tree and click on the button
from the Toolbar.
Or
Select the lesson which is to be deleted from the navigation tree and press the Delete key.
Ans-2 : Stages of touch typing
(a) The process begins with memorising the home row of the keyboard. The row that begins with the Caps Lock
key is called Home Row. Looking at the keyboard is strictly forbidden. This is followed by learning the lower
and upper rows, the numbers row, upper-case letters and special symbols.
(b) It involves memorising frequently used syllables and typing words containing these syllables.
(c) It involves typing actual text to perfect the skills acquired.
Ans-3 : Backspace key: It is used to erase anything typed on the left side of the cursor.
Delete key: It is used to erase anything typed on the right side of the cursor.
Ans-4 : (a) Shift key: It is mostly used to type the characters in uppercase or symbols marked on the number keys.
(b) Esc: It is used to exit (or escape) from programs and tasks.
(c) Page Up/Down Keys: They are used to scroll through one page up or one page down respectively.
Ans-5 : The Shift key is used to type capital letters, punctuation marks and other symbols. It is also used in combination with
Function keys or Ctrl keys. The Alt key is used with the Ctrl key and Delete key for special functions like it is used to
open Windows. Ctrl+Alt+Delete opens the Task manager. Alt can be used with F4 (ALT+F4) to Exit from Writer.
Ctrl+F10 will maximise the document window.
Ans-6 : Points To Be Remembered While Using The Keyboard
The following points may be kept in mind for successful keyboarding techniques.
(a) Do not put pressure on the keys and try to press the keys gently .
(b) Always rest your fingers on the Home row while typing.
(c) While typing, release the key immediately after pressing. Holding the pressed key for a long time will repeatedly
type the same character.
(d) Do not look at the keyboard while typing.
(e) While practicing, slowly pronounce the name of the key .
(f) Do not take any mental stress while typing and practising typing ergonomics.
(g) Be patient if you commit a mistake at initial stage.
Maintain a balance between speed and accuracy, as both are equally important. Do not sacrifice accuracy for speed.
Focus on the technique, speed comes.
(Any Four)
Ans-7 : Typing Accuracy: Typing accuracy is defined as the percentage of correct inputs typed out of the total inputs typed.
The following table lists the different formulae for the typing accuracy calculation.
Description Formula
Accuracy in the words, percent Accuracy = (100% – Words with errors * 100%) /
Total number of words

Computers-9 3
 Accuracy in the characters, percent Accuracy = (100% – Characters with errors * 100%)
/ Total number of characters
Ans-8 : Holding the mouse : Grip side of the mouse with the thumb and the other side of the mouse with the ring finger.
Rest your index finger on the left click button, and the middle finger on the right click button without clicking. Place
your palm comfortably on the table. By default the mouse is held in the right hand. From the settings, it can be made
suitable for the left hand too.
Ans-9 : At the right hand side of the keyboard, you must have seen a calculator like keypad. This is the numeric keypad. Look
at it carefully. It contains numbers from 0 to 9 and some symbols i.e., addition (+), subtraction (–), multiplication
(*) and division (/) symbols, a decimal point (.), Num Lock and Enter keys. Usually, some laptop’s keyboards do not
have a numeric keypad to save space.
SECTION–D

Long Answers
Ans-1 : Rapid typing is similar to a gaming software that helps to learn the concept of touch typing. It is simple and easy to
use. Let us learn how to use it.
Starting Rapid Typing
After downloading and installing the software, you can start it by following these steps:
Step-1: Click the Start button.
Step-2: Click RapidTyping 5 folder from the Start menu.
Step-3: Again click RapidTyping 5 application. The Rapid Typing screen appears.
Some areas on the screen and their names are as follows :
XX Tab buttons on the top-left corner are used to switch between basic program modes- Current lesson, Student
statistics and Lesson editor.
XX Text area in center of the window, displays the text to be typed.
XX Toolbar at the top of the window lets you to select the current course and lesson.
XX Status bar includes tips for the current lesson.
XX Virtual keyboard will help you to learn touch typing.
Ans-2 : Click Student statistics tab from the top-left corner of the main window. The Student statistics window appears.
The Student statistics window is composed of the following controls :
XX Student accounts, this area consists of three parts :
•  tudent toolbar for adding, removing, inserting (import), saving (export) existing student accounts and
S
student groups and saving student statistics in different formats : PDF, HTML, XML, CSV, etc.
• Student accounts is the area to select the current student account or student group.
•  roperty panel is the area where you can edit or group student properties of the selected item in the
P
Navigation Tree.
XX Statistics Panel, this area consists of four parts :
•  tatistics toolbar has buttons to choose courses, remove selected statistics and customise the statistics display
S
options.
• Course diagram shows the common statistics for all lessons of the current course.
•  esson diagrams show the statistics for each character or keystroke of the selected lesson in the course
L
diagram.
• Lesson statistics table shows the full statistics of the selected lesson in the course diagram.
XX Characters used in the current lesson statistics are highlighted in red/black on the Virtual keyboard (press F9 key)
Ans-3 : (a) Ctrl key: It is used to perform special tasks alongwith other keys.
(b) Shift key: It is mostly used to type the characters in uppercase or symbols marked on the number keys.
Punctuation keys: These keys refer to all the keys having punctuation marks, like comma, period, semicolon
(c) 
and so on. They also refer to all the mathematical operators.

4 Computers-9
 Functional keys: They are labeled from F1 to F12. These keys have different meanings depending on which
(d) 
program is running.
Arrow keys/Cursor Control keys: These keys are used to control the movement of the cursor on the monitor.
(e) 
Ans-4 : To be done by students
Ans-5 : (a) CPM is the number of characters typed in one minute
CPM = (Characters without errors + Characters with errors) / Time spent in minutes
Net CPM is the CPM without characters with errors
Net CPM = CPM - (Characters with errors/Time spent in minutes)
(b) KPM is the number of keystrokes in one minute
KPM = (Keystrokes without errors + Keystrokes with errors)/Time spent in minutes
Net KPM is the KPM without keystrokes with errors
Net KPM = KPM - (Keystrokes with errors/Time spent in minutes)
Ans-6 : The Lesson Editor window is composed of the following controls :
XX Course and lesson list
•  oolbar includes buttons for adding, removing, inserting (import), and saving (export) existing courses and
T
lessons.
• Navigation Tree includes the current keyboard layout choose, current course, section and lesson.
• Properties is the area where you can edit course/section/lesson properties.
XX Editing panel is the area where you can edit the course options or text of the selected lesson in the Navigation
Tree.
XX Table analysis text displays the number and percentage of words, characters, spaces and specific characters in
the lesson.
XX Virtual keyboard (press F9 key) highlights the characters used in the selected lesson.
Ans-7 : Typing Ergonomics : Without thinking about the impact on the body, many people use computer for a long time,
or they have a working schedule in which they cannot avoid computer usage for long hours. So it is important to
place wrists, shoulders, hands, computer monitor, etc in a proper way. The logistic support for efficient and effective
typewriting is provided by Typing ergonomics. It is important to attain accuracy and speed. Some of the factors
which affect these are listed below.
Good sitting posture : Good sitting posture means your shoulders are relaxed, your feet are flat on the
(a) 
floor, and you can sit up straight to do your work. A supportive chair that helps you keep your normal spinal
curvature.
Your elbows should stay close to your sides. Sit on breathable, padded seat. Your elbows to be bent about 90
degrees and keyboard should be at that height.
Monitor Placement : Keep the upper border of screen at eye level and do not bend your neck while working
(b) 
on the monitor. The distance of screen from the user depends on the size of the screen. Keep an approximate
distance of about 60–65 cms for a 17 inches screen. Face the screen with your head slightly tilted forward.
Mouse and keyboard placement : For smooth and effortless operation of keyboard, keep the keyboard and
(c) 
mouse together at an approximate distance of 20 cms. The keyboard, mouse and elbows must be at the same
height.
Chair and table placement : Adjust computer chair and table to an optimal height. The chair of the computer
(d) 
user must be supportive to his/her lower back. Vibrating devices such as printers, should be on separate tables.
The computer table should also have sufficient space for your legs. With the correct ergonomics, typewriting
becomes a natural phenomenon without causing unnecessary fatigue.
Ans-8 : Middle row on the keyboard is called Home row. In the home row, little, ring, middle and index finger of the left hand
is placed on the key A , S , D , F respectively.
Similarly, little, ring, middle and index finger of the right hand is placed on the key ; , L , K , J , respectively.
The remaining keys ‘G’ and ‘H’ are operated by the forefingers (Index finger) of left and right hand respectively.

Computers-9 5