402 – CLASS IX

PART – B
Unit - 1 (INTRODUCTION TO ITeS INDUSTRY)
Chapter Answer 1. 2. 3. 4. IT processing enable of Business organisation as Digital
government taxes, examples citizens UMANG, WhatsApp, services. the products follows:
helps a. b. c. d. e. Following – exchange 1: people India Transaction Document Order
Accounts Technical are Process a and of APPLICATION orders. business through
Facebook, Bharat that services the MyGov. and Management to Questions Outsourcing
Management work is Support apps of Management e-governance Business an and the
Interface organisation information online, expert from Instagram launched Internet. Payment

K services services communications anywhere. such (BPO) in for services

services handling OF Processing by initiative with Money and by as is government IT

 I
facilitating a document Twitter E-commerce citizens, practice IN such (BHIM), of

services
 P
through ITeS government kind are of and processing marketing, of

Swachh outsourcing of some or India INDUSTRY e-mail, other processes. online for of
Bharat have for government product video shopping the digital a driving Some
 S
part resulted most Abhiyan, conferencing, empowerment

browsing, of of allows licenses, popular a the departments. business in GST BPO buying
providing shopping, social collection Rate and services to of or another mobiles
Finder, selling
Indian
media many
Some and
are
of
BRAIN DEVELOPER
SECTION 1: OBJECTIVE TYPE QUESTIONS-(SOLVED) SECTION 2: THEORY
QUESTIONS-(SOLVED) SECTION 3: APPLICATION BASED QUESTIONS-(SOLVED)
SECTION 4: APPLICATION BASED QUESTIONS-(UNSOLVED) 1. WhatsApp 2. a)
Banking b) Product services c) Bill payment 3. Electrocardiogram (ECG) Machine, Cardiac
Screening Machine
SECTION 5: SHORT ANSWER TYPE QUESTIONS-(UNSOLVED)
© Kips Learning Pvt. Ltd. 2020
1. The services enabled by the use of Information Technology can be termed as ITeS. These
services improve the efficiency of an organisation and help in reducing cost. 2. The companies
within the IT-BPM industry are classified on the basis of the following
parameters:
a. The area to which the company is serving b. The type of services the company is providing c.
The geographical reach of the company d. Scope of operations and profit earned by the
company
Service Example
Service Example Online Banking Transferring money between accounts using IMPS,
3. 4. SECTION 1. 2. A to Some A For E-learning Library Hospital 6: typical Learning plan,
each a. b. c. d. e. f. a. b. c. d. LONG of Paying Reading Playing Using Booking Online A
customer When the To experts With centre implement, management the call ITeS
management customer ANSWER Management make customer. ways centre the service,
e-mail, a is shopping bills games create online hotel, call located increase support we sure
online functions and uses reaches TYPE social use there on the railway, newspapers system

that assess in System K IT a smartphones centre. technology

QUESTIONS-(UNSOLVED) in the media, contact are in the the as world-wide our a flight local
two follows: specific call (LMS) highest RTGS, Accessing Recording Managing everyday video
number things city or centre, to and movie is and of learning calling, support standards a
 I
connectivity, required: the software PCs educational lives Computerised book NEFT
 P
(usually a tickets trained customer etc. are: the process. issuance of

application a call customer toll-free it customer videos or centre. makes appointments and
 S
anywhere through collection number) or no service service Web

difference else YouTube representative based with information that are in the doctors is
delivered, whether technology connected world. answers the the used to call IT a
a. Technology that enables the service b. A communication device The combination of the
correct technology and communication channel results into very high degrees of improvement
in the service quality. 3. Some of the factors stating the benefits of IT in the insurance sector
are:
a. Recording the dates of starting, maturity and next instalment of policies b. Calculating
interest dues and bonus c. Keeping records of survival benefits 4. E-commerce or online
shopping allows us to search and compare various products and services, which we can buy at
competitive prices. The products are delivered right at our doorstep, thus
© Kips Learning Pvt. Ltd. 2020
saving time and money. E-commerce offers a range of products from home appliances to
apparels, toys, and electronic goods. 5. E-banking facilitates us for
a. transferring money between accounts b. using IMPS, RTGS, and NEFT c. viewing account
details d. opening fixed deposit accounts e. making online payments for products and services
f. withdrawing money at any time through ATM (Automated Teller Machine) g. using debit and
credit cards 6. Some of the uses of IT in the field of scientific and engineering are :
a. Large computations, calculation
 Chapter Answer 1. 2. 3. 4. The While minimises avoid Mechanical (semicolon). A select,
play pointing home games the health typing, open, Unit b. c. d. e. f. g. h. i. j. k. Following –
device both row on Mouse: 2: complications. Speed, Distance, Observations, Apart Storing
Performing Computer Computer Simulating Visualising and it the - USING keys is static 2 is
even important computer. from an cost (DATA The large Questions: for new and input
aided aided drag 3-d and the mechanical complex and your amount DATA analysis, dynamic
avenues objects testing uncountable device an for design manufacturing

K left ENTRY item the calculations of hand used the and of mouse

ENTRY (CAD) user muscle data on science designs collaboration. the are to uses, to used
applications point has AND maintain loads. (CAM) screen. A, exploration, computers
I
for a S, TOOLS at rolling D, research Correct applications an
 P
KEYBOARDING The and the object rubber pointing correct F are

and position work and on also real-time ball the your posture devices used under of computer
 S
right the for: record as the are body hand the SKILLS) case

also screen. of ideal helps are of used the typing You J, to to mouse. K, make can draw L,
posture and point, and
The you ;
movement of the pointer is controlled by the ball. Optical Mouse: The optical mouse uses laser
to control the movement of the pointer. It does not have a ball. You can see the light by tilting
the mouse.
Chapter – 3: GETTING STARTED WITH TYPING SOFTWARE
Answer the Following Questions: 1. Touch typing is a wonderful technique which provides a
variety of customized exercises that help you
to improve your professional keyboard skills in a step-by-step way. Two benefits of touch typing
are:
© Kips Learning Pvt. Ltd. 2020
a. Speed: One of the most attractive reasons to learn the touch typing skill is the significant
increase
in speed and efficiency. b. Accuracy: The second most important benefit of learning touch
typing comes with typing correctly and with accuracy. If you are typing with good speed but are
not typing accurately, no one would understand what you are trying to convey. 2. Computer
ergonomics provide the logistic support for efficient and effective computer usage. They work to
alleviate the following conditions that can result from spending a lot of time on the computer.
Some of the factors include:
a. Sitting posture b. Positioning of hands c. Monitor placement d. Mouse and keyboard
placement e. Chair and table placement 3. Gross speed is a calculation of exactly how fast you
type with no error penalties. The Gross typing speed is calculated by taking all words typed and
dividing it by the time it took to type the words. WPM = (Words without errors + Words with
errors) / Time spent in minutes Net speed is a calculation of exactly how fast you can type
error-free. It is arguably the most useful tool in gauging typing abilities.
Net WPM = WPM – (words with errors / Time spent in minutes) 4. Accuracy in typing means
that you type the words accurately and correctly. Typing accuracy is defined as the percentage
of correct entries out of the total entries typed. So, if you typed 90 out of 100 characters
correctly, you typed with 90% accuracy.
Accuracy % = 100% - ((words with errors × 100%)/Total number of words) Example, A person
typed 50 words per 2 mins. with errors in 6 words. Accuracy = 100 - ((6 * 100)/50) = 88%
BRAIN DEVELOPER
SECTION 1: OBJECTIVE TYPE QUESTIONS-(SOLVED) SECTION 2: THEORY
QUESTIONS-(SOLVED) SECTION 3: APPLICATION BASED QUESTIONS-(SOLVED)
SECTION 4: APPLICATION BASED QUESTIONS-(UNSOLVED)
1. Rapid Typing. 2. Each time you complete a lesson, the Results window displays your
achievements. The Results window is divided into two parts: Rating Pane and Three tabs: Next
step, Detailed statistics, and Errors overview. It tracks your progress, and allows you to evaluate
your own performance at any time. 3. WPM = (Words without errors + Words with errors) / Time
spent in minutes
a. CPM = (Characters without errors + Characters with errors) / Time spent in minutes b. KPM =
(Keystrokes without errors + Keystrokes with errors) / Time spent in minutes c. WPS = (Words
without errors + Words with errors) / Time spent in seconds d. CPS = (Characters without errors
+ Characters with errors) / Time spent in seconds e. KPS = (Keystrokes without errors +
Keystrokes with errors) / Time spent in seconds 4. We can add a course in Rapid Typing
software through the following steps:
a. Select the Lesson editor option present on Title bar or Press (Ctrl+3). b. Click on the Course
menu button located on the Toolbar. A dropdown menu will
appear.
 IPS
K
© Kips Learning Pvt. Ltd. 2020
c. Now, select the Create new course option. You will notice that a new course has
been added in the Navigation Tree. 5. Type a name and title of your course and press Enter. The
status bar displays the progress. 6. Gross Speed : 80/4 = 20 WPM
Net Speed : 20-(12/4) = 20-3 = 17 WPM Accuracy : 100% - (12*100%)/80) = 100% - 15% =
85%
SECTION 5: SHORT ANSWER TYPE QUESTIONS-(UNSOLVED)
1. The home row keys for your left hand are A, S, D, and F and your right hand are J, K, l, and
; (semicolon). 2. To delete a letter:
• Place the cursor just after the letter.
• Press the Backspace key once.
• Alternatively, place the cursor just before the letter and press the Delete key.
• For deleting a word or sentence, select the text and press the Delete or Backspace key. 3.
Four common mouse actions are:
• Click or left-click: It is used to select an item. Place the mouse pointer on the item to be
elected, then press the left mouse button once with your index finger. The desired item gets
selected.
• Double-click: It is used to start a program, open a file, or trigger an action. You have to click
the left mouse button twice quickly.
• Right-click: It is used to display the Context menu or properties. Move the mouse pointer to
the desired position and press the right button of the mouse. The Context menu will open.
• Drag and Drop: It allows you to select and move an item from one location to another. Position
the mouse on an object, hold down the left mouse button of the mouse, and drag the object to
the position where you want to place it and release the button. You can see the item at a new
location. 4. Combination keys are used in combination with other keys to perform an action.
Ctrl, Alt, and Shift are known as combination keys. 5. 1) Always remember to keep your back
straight.
2) Keep your elbows bent at the right angle. 6. Error % = (words with errors *100%)/Total
number of words 7. Rapid Typing 8. 1) Microsoft Windows 2) Linux 3) Mac 4) Ubuntu 9. To
open the New Lesson dialog box:
• Click on the Lesson menu option from RapidTyping Toolbar.
• Now select the course level in which you want to add a new lesson.
• In the next step, you can either choose Create new lesson option from the Lesson menu or
right- click on any course level and select the Create new lesson option from the pop up menu
that appears 10. The lesson statistics table shows the following details:
• Overall rating
• Speed in CPM
• Accuracy characters
• Slowdown characters
• Done percentage
• Total time spent in seconds
• Words typed
• Words fixed
 IPS
K
© Kips Learning Pvt. Ltd. 2020
SECTION 6: LONG ANSWER TYPE QUESTIONS-(UNSOLVED)
1. Accuracy in typing means that you type the words accurately and correctly. Typing accuracy
is defined as the percentage of correct entries out of the total entries typed. So, if you typed 90
out of 100 characters correctly, you typed with 90% accuracy.
Accuracy % = 100% - ((words with errors × 100%)/Total number of words) Example, A person
typed 50 words per 2 mins. with errors in 6 words. Accuracy = 100 - ((6 * 100)/50) = 88% 2.
Gross speed is a calculation of exactly how fast you type with no error penalties. The Gross
typing speed is calculated by taking all words typed and dividing it by the time it took to type the
words. WPM = (Words without errors + Words with errors) / Time spent in minutes 3. 4. • • • • 5.
• • Net useful Typing correlates keyboard. The Statistics statistics, Course Lesson lesson
Lesson the muscle his BENEFITS Touch help listed Speed: increase working Accuracy: Touch
or keyboard. detailed speed you below: her tool typing in typing Diagrams/Statistics: Statistics
rhythm One Diagram/Statistics: memory on in to the Toolbar: and hands OF The in the speed is
the improve of Net statistics course TOUCH is gauging a is customizing However, second the
shows a wide-ranging calculation manner a through on WPM Table: wonderful method and
most Statistics the diagram. your TYPING typing most efficiency. screen whether = It keyboard
attractive WPM the and rigorous shows K professional of the It of important

It technique sense abilities. typing shows toolbar data-entry shows rhythm shows exactly
statistics – the the (words Touch and training. reasons of without the keystrokes full the the has
touch does how in benefit keyboard which typing common display with statistics following:

I
projects. statistics which buttons to This not fast is the errors provides learn a of is
 have are options. little way, you use an certain skills learning statistics of for for

P
the coming / the of individual can to involved a Time each in choosing

user a the touch look selected to variety a type touch step-by-step for sense spent character
offer can at at typing since all error-free. equal any presses type of typing the courses, lesson in
 S
lessons of customized of minutes) this sight, skill most

spontaneously intervals. or the comes way. keystroke in typing and is of keys. It or removing
productive the the the is simply Some releases with course arguably exercises method
significant This current of of typing by methodology by the the diagram. method them keys
feeling placing utilizes course. the that selected
selected
are
most
on for a
correctly and with accuracy. If you are typing with good speed but are not typing accurately, no
one would understand what you are trying to convey.
• Time: Another benefit of touch typing is accomplishing the work within a given time frame. The
more the typing speed is, the less will be the time taken to type and accomplish the task.
• Focus: When you type with two fingers, the focus gets diverted between finding the keys on
the keyboard and the work you are doing on the computer system. Learning touch typing allows
you to focus on one thing instead of two and thus increases the productivity.
6. System requirements for installing touch typing software are:
Hardware: A computer system with physical keyboard, mouse, and speakers.
© Kips Learning Pvt. Ltd. 2020
Operating System Software: Windows XP, Windows 7, Windows 8, or Windows 10, Linux,
Mac, Ubuntu. 7. To insert a New Lesson:
• Click on the Lesson menu option from RapidTyping Toolbar.
• Now select the course level in which you want to add a new lesson.
• In the next step, you can either choose Create new lesson option from the Lesson menu or
right-click on any course level and select the Create new lesson option from the pop up menu
that appears
• The New Lesson dialog box appears. 8. The Detailed statistics screen shows the lesson
statistics, which displays the details like typing
speed, errors, and slowdown for each character/keystroke. In the text area, you can check the
mistakes you made, in different colours. The colour indication is as follows:
9. 10. Chapter APPLICATION a. b. c. Introduction The following a. b. c. d. e. f. g. –
4:
The The was The has Course Lesson Pause Current Current Current Restart GETTING
been green bad orange exceeded and commands Unit Button Selection Selection The
Lesson Lesson Lesson result Beginner exceeded dashed colour Lesson - by is Speed
Accuracy

Time 3 depicted the are K STARTED line, (DIGITAL depicts

courses by shown user. the shown in the user. are in red above incorrect available the colour
 I
WITH DOCUMENTATION) interface depicts and character I Rapid
P
A yellow of the WORD the Typing good and lesson colour result. time

software.
PROCESSOR
 S
editor: depicts for typing the time a character frame which which

Answer the Following Questions

1. A Word processor is application software, which is capable of creating, editing,
saving
and printing documents. 2. Three popular Word Processors are:
a. LibreOffice Writer – Desktop Utility b. Microsoft Word – Desktop Utility c. Google
Docs: Internet based utility 3. Four major operations which are possible with LibreOffice
Writer are:
a. Creating and Saving a Document
© Kips Learning Pvt. Ltd. 2020
b. Opening an existing document c. Editing and formatting a document d. Previewing
and printing a document 4. The various options to save a document are:
a. Saving a document normally on storage device. b. Saving a document using a
password protection c. Setting a password to modify a Writer Document 5. The vertical
blinking line in the Document window is called Cursor. You can move the cursor in a document
by using the Cursor Control Keys (Arrow keys). There are four Arrow keys — Left, Right, Up
and Down on the keyboard. Apart from the arrow keys, there are some other keys on the
keyboard that helps to navigate the document easily. They are: 6. 7. ▪ ▪ ▪ ▪ ▪ ▪ The situation, over
LibreOffice Home: Ctrl End: Ctrl Page Page a. b. c. d. e. f. g. h. i. j. mouse the File: close Edit:
View: document. Insert: document. hyperlink, Format: document. Styles: text Table: text Tools:
document, Window: Help: + + text It Up: Down: Home: End: it moves It Writer pointer, is
document. document. These This moves and It The referred the This Contains Shows It The
Contains scrolls Contains It moves This Contains clicking application. the menu Help has scrolls
comments, menu This as Insert commands when the combination cursor commands up the well to
menu the cursor spelling contains includes commands as one down on

K contains brought menu commands following as commands cursor a the to

page. Text allows tools symbols, to the one apply desired contains tools, the images, commands to
over Select to of commands end page. menus: for to insert, the keys you beginning to for a
configuring set, for the of text footnotes, the gallery cursor. end formatting to commands the
I
moves media, manipulating text, create, edit, start current to of for current for edit of the
 P
generally One of and editing the and charts, controlling the object and

menus, edit, it. document. document, the can cursor delete line. for control current sections. layout
update, and the edit inserting and art changes and to a contents displaying that the the the line.
 S
objects table the and open setting load, text on-screen LibreOffice you

beginning its new the and shape a by of can from and elements new program contents document
its the moving add manage elements other into display document, current of Help to the I-beam.
the preferences. of applications, in your
windows. system. document.
your your styles of document. I-beam
inside the or In in this
a
a
8. Navigator in Writer is a useful tool which is used for working with large and complex
documents. A large document has multiple objects like tables, headings, sections, hyperlinks
and comments associated with it. The Navigator facilitates easy access and navigation between
these objects. In the Navigator window, all the objects are displayed in the form of a list. To
access an object, simply double-click on the object name.
© Kips Learning Pvt. Ltd. 2020
Chapter – 5: EDITING A DOCUMENT
Answer the Following Questions
1. Editing text means making corrections to it, and manipulating text in a manner that would
lead to the desired end result. Editing process includes inserting, deleting, copying, moving,
finding and replacing a particular text in a document. 2. Entire paragraph can be selected by
triple clicking anywhere in the paragraph, or double
clicking in the left margin of the paragraph. 3. Copying and pasting text means to keep the
text at the original location as well as copy it to another location. Whereas, cutting and pasting
allows you to change the position of the selected text from one place to another. 4. While
looking for certain words or formats in a large document, it is very inconvenient to go 5. 6. 7. 8.
Chapter Answer 1. 2. 3. 4. 5. 6. 7. through well The Non-printing basically processors
paragraph The word vocabulary, Shift+F7 Formatting Different While continue Bold: In left
order. before There There the a Following Go bulleted Thesaurus of as – Ctrl+B, substitutes,
are are creating Numbered the replacing 6: the to the used with types two four Page mark
FORMATTING list list means are and Italics: entire list characters for the point. categories
Questions entry. types feature of a helps (¶). command each space a formatting new
formatting default list particular changing and Ctrl+I, text. of In new can you document is

horizontal (.), alternative a are The of a K page Underline: to numbered be

entry is built-in non-breaking text the the text the better used are Find said settings. overall
characters alignment is document. A — or you text to identified and dictionary or spellings.
understand text DOCUMENT format directly Ctrl+U. list defined need alignment look
 I
Replace For formatting, this space — that with this, The of to by jump that horizontal

This is a as define the do a feature another. most document.

 P
replaced you : (o), "bullet" the enables from feature not text. paragraph

use common tab list the appear one and automates the where - by character page you often
increases page vertical. Page a in formatting, non-printable to number/alphabet, settings,
 S
numbers/alphabets a a to look Style printed small the another.

(→), your up dialog process circular if synonyms, and document. Line writing you characters
box. page do break of symbol in abilities searching not formatting. come antonyms, sequential
These (↵), want in - to word
first and
and
the are as
to
a. Left Alignment: This is the default alignment of text in a document. The text is aligned
along the left margin while leaving a little space towards the right margin. b. Right Alignment:
The text is aligned along the right margin while leaving a little space
towards the left margin. This alignment is mostly used to put dates on letter heads. c. Center
Alignment: The text is aligned centrally between the left and right margins. It is
mostly used for titles. d. Justified Alignment: The text is aligned evenly between the left and
right margins. 8. The distance between the text boundaries and the page margins is called
Indent. 9. Page Break allows you to insert a break in the page, and moves the cursor on the
new page. When you fill a page with text or graphics, LibreOffice Writer inserts an automatic
page break and starts the new page. But, if you want to move to the next page forcefully, you
can insert a
© Kips Learning Pvt. Ltd. 2020
page break. Even if you have a large document and you want to move some text to the
beginning of the next page, then you can insert a page break. 10. Header and Footer are the
identifiers that respectively run across the top and bottom of the document. They include
information like, page numbers, date, title of a book or chapter, author's name, and slide show
theme, etc.
BRAIN DEVELOPER
SECTION 1: OBJECTIVE TYPE QUESTIONS-(SOLVED) SECTION 2: THEORY
QUESTIONS-(SOLVED) SECTION 3: THEORY QUESTIONS-(UNSOLVED) 1. 2.
LibreOffice Its productivity. and processing), The clean • • • • • LibreOffice Open Title current
Minimize, Menu The various menu-specific you arrow Standard the Copy, Formatting commonly
Font Highlighting Rulers: ruler settings alignment interface Source is select commonly Calc
drop-down Bar: LibreOffice Size, a measures Paste, next Bar: Rulers powerful Writer ways.
document (spreadsheets), and The Toolbar: Maximize, and of a Font office This used to

Toolbar: icons menu, etc., text. K Title To the indentation. are window

hotkey feature-rich bar used Color, the commands menus includes open and suite icons
submenu on present The This bar and a contains width and it. submenu free commands. It
(which numbers a appears Alignment has on appear bar application. allow menu, is Impress
Close several office on the the of tools present name, is The to all both appears present
 I
the on following the market. format buttons. appears. on click the present suite,

vertical help (presentations). the applications icons, By which document the top user menu on
 P
below On default, Standard you below used top and as and the Some on

Some to components: Bullets the indicates ruler an options unleash of left beautify vertical
menu interact the by underlined the Title the page. of Save, that submenu side millions toolbar.
allows and Standard screen. its Menu name present that your Bar ruler of make the It with
 S
applications Undo, Numbering the displays there extreme you of

creativity text. or bar. indicate letter items It it the people document. in toolbar. press displays
Redo, the to It is the It Writer show another in displays margin displays format most right, the
the Writer icons, are: around the and New, the It Alt position right The menu). application
enhance versatile Writer you contains settings, submenu. name the Indents the Font key
application. Open, the horizontal hand will icons and vertical Name, of world. of When (word
your Free
side
Cut,
text find
and the
the
the
tab of in
on that page.
• Document Area: It is the large area where you can type, edit, and format the text.
• Scrollbars: There are vertical and horizontal scrollbars on the right side and bottom of the
Writer window, respectively. You can move the screen display towards up and down with the
help of vertical scrollbar, and shift it right or left using the horizontal scrollbar.
• Status Bar: It displays the page number, number of words and characters, active working
mode, current dictionary in use, a button to save the current document, view buttons, and zoom
slider. It is located at the bottom of the document window.
• View Buttons: LibreOffice Writer provides different views. Three views are available on the
Status bar, such as Single page view, Multiple-page view and Book view, and
© Kips Learning Pvt. Ltd. 2020
other three views are available in the View menu, such as Normal, Web, and Full Screen. To
change the view, select the menu and click on the required view option, or click on the required
view available on the Status bar.
• Zoom Slider: By moving slider handle in or out you can adjust the zoom percentage of the
workspace displayed.
• Sidebar: It contains six buttons — Sidebar Settings, Properties, Page, Animation, Master
Slides, Styles, Gallery, and Navigator. These buttons enable you to make changes in settings of
Sidebar, and allow you to format the document. 3. The larger window is called the Application
window and the smaller window, which is inside the application window, is called the Document
window. The Application window helps the user to communicate with the LibreOffice Writer
program. The Document window is used for typing, editing, and formatting the text. 4. 5. You
save Once When existing If another a • • • • • • • • • can document a a no file, Press Under Click
If and If re-saved If then existing Click Choose Press Click Use Click Locate Click or document
document. document: save document you the the new do location, File on on on the on click
Ctrl+S. Ctrl+O a file one file have the your window is document File file the Open Open. >Open
the Open with is has already on of File is done new, with > Save file Open is on Or the and

K saved the Open already the File menu, The open, icon /Recent the and

(if a following: the icon some Save click same button. or new open, a by Open /Open on
keyboard. on select document Remote Save then choose using on been on the As name,
changes your name Documents dialog the the Save. The option As it. follow Remote Standard
 I
saved either Standard computer, Save. Files dialog second and and selected is The

box in already under any then settings. in will a the File Or file to appears. appears. toolbar.
 P
saved the document one keep select toolbar. Save from file will nothing

the it main open). of can file will be the command File the Or the the Enter startup and saved be
open original else Menu menu. opens file below retrieved want the you needs immediately with
 S
window bar. or file This file mentioned in to want the the a name,

save Or as to will any new extension Save it be of is. it ask time LibreOffice. done. in verify
window. with As steps existing you command. it a The .odt. the is to new to required. To save
open file file window Or
name,
open type
gets
the To
an
6. Navigator in Writer is a useful tool which is used for working with large and complex
documents. A large document has multiple objects like tables, headings, sections, hyperlinks
and comments associated with it. The Navigator facilitates easy access and navigation between
these objects. In the Navigator window, all the objects are displayed in the form of a list. To
access an object, simply double-click on the object name. 7. The mouse pointer, when brought
over the text, generally changes its shape into I-beam. In this situation, it is referred to as a Text
Select cursor. One can edit the text by moving the I- beam over the text and clicking on the
desired text to edit it. 8. The Find feature only searches for a particular text or format in the
document, whereas, the
Find & Replace feature can also replace the found text or format with another text/format.
© Kips Learning Pvt. Ltd. 2020
9. Replace option replaces each occurrence of the found one by one (asks before each
replacement) with the desired text, whereas, Replace All option replaces all the occurrences of
the found text at once with the desired text. 10. Text formatting is applied in a document to
enhance the appearance of text and individual characters. It increases the readability of the
document. From font sizes to font styles, text positioning to text attributes, text formatting
includes all attributes that can be used to define the arrangement and visual display of text. To
apply formatting, you first select the text and then apply the required text formatting. 11.
Superscript: It places the selected text slightly above the line of text. Subscript: It places the
selected text slightly below the text baseline. 12. The distance between the text boundaries and
the page margins is called Indent. The indenting feature is used to move the complete
paragraph or the first line to a specific 13. 14. 15. SECTION SECTION 1. 2. number steps:

Open Page Page the To • • • • Ctrl+N: Ctrl+S: Subodh 4: 5: insert page, • • • Place Click The

Choose at a. b. c. APPLICATION APPLICATION option. break the the to to Select Click shift
Click inch Type Select Press Special of should on a the and save LibreOffice cursor's create

symbol, places is the the closer 1⁄2 The on on the cursor Ctrl+C moves an the the inch a

Character Insert desired the use the Writer Page important slogan a paragraph position.
between slogan. to BASED BASED follow new away Increase at Decrease copy to the

K the Writer menu Style the copy symbol document Writer “Keep cursor

from left dialog these and QUESTIONS-(SOLVED) QUESTIONS-(UNSOLVED) position

dialog feature the and to Indent on margin. Indent paste the Your be on document steps: and

your box left select box indented, the left where button of click appears. or method School
 I
button computer. appears. new LibreOffice margin. the right on you Special on page.
 P
Clean”. or the on margins. to want the place copy the Click Insert

Character Formatting Writer. to Formatting the the on insert To button. cursor the slogan indent
It allows option.
 S
a Format toolbar. symbol. Selected before toolbar 50 a

paragraph, you times. menu The the to to symbol selected paragraph. move insert and follow
choose will the a break text appear text these will
the
in 1⁄2
d. Press Ctrl+V 50 times to paste the slogan. 3. Select the paragraph to be moved and
press Ctrl+X to cut it. Move the cursor to the end
of the document and press Ctrl+V to paste it there. 4. Press F7 to check spellings for the
article and correct them. Use bullets and numberings
to mention any topic point-wise. 5. Select one line of the poem and apply a desired font
style from the formatting toolbar.
Do this for each line. 6. Find and Replace feature should be used. Find ‘Mrs’ and replace
with ‘Mr’. Use Replace
All to make quick replacements.
© Kips Learning Pvt. Ltd. 2020
Chapter – 7: CREATING AND USING TABLE
1. A table is organized arrangement of text in the form of rows and columns. It is an efficient
and
useful way of organizing and presenting large amount of data and Information in tabular form. 2.
Columns are the vertical section of the table whereas Rows are the horizontal sections of the
table. 3. Intersection of a row and a column is known as a cell. 4. The different ways to Insert a
table in Writer are:
a. Using Table tool from Standard toolbar b. Using Insert Table option from Table menu c. Using
keyboard shortcut Ctrl+F12 5. To delete row(s), follow these steps: 6. Chapter 1. 2. 3. 4. 5.
Chapter To A Print helps Print Standard Click Standard printed split a. b. c. a. b. c. d. e. f. –
– on Preview Preview you 8: 9: a Select The Click option, the Place Click Select The Select
Click table toolbar toolbar. output to PRINTING USING Table File preview Split on on on of
helps the row(s) the into the if the menu your the OK. of you Table toolbar cursor Split Copy
two, a you Rows Table Table the which document document do MAIL and dialog Table to

follow heading not inside overall K appears. button menu. check will select

A is/are want option. DOCUMENT box MERGE be these a or shows formatting whether
cell to the option, split to appears. any an delete be from steps: Print image headings into that
 I
deleted. if the where option, selected two you of how is written your called tables. want
 P
on the you or the document. rows.

final a Press headings want text hard table. printout falls spilt Ctrl+P, copy. within on the will the
 S
or table.

click the look. split page on table, the margins Print or No tool or heading not. from It
1. The Mail Merge feature is used to combine a data source with the main document. It saves
our time and energy to send letters at multiple addresses. It primarily enables automating the
process of sending bulk mail to customers, subscribers or general individuals. 2. Two benefits
of mail merge are:
a. Produce mass mail b. Make changes in letters easily 3. Data source consists of mailing list.
For example, name, address, city, PIN, telephone number, etc., whereas, the main document
that contains the text that you wish to send to all the recipients. 4. Choose Tools menu and
select the Mail Merge Wizard option. 5. Choose Tools menu and select the Mail Merge Wizard
option.
© Kips Learning Pvt. Ltd. 2020
• Observe, by default the second checkbox under the Insert address block section is selected.
• Click on the Select Address List button.
• The Select Address List dialog box appears.
• Now, click on the Create button to create a new address list.
• The New Address List dialog box appears.
• Click on the Customize tab to add or remove fields.
• Now, enter the data in the respective fields, and click on the New button.
• Enter records of your friends and relatives. Click on OK.
• You will get the Save dialog box. Specify a name in the Name box and click on the Save
button.
• The Select Address List dialog box will appear.
BRAIN SECTION SECTION SECTION SECTION SECTION 1. 2. 3. 4. 1. 2. 3. 4.
DEVELOPER
• Use By Mail In A To Data number, Click 1: 2: 3: 4: 5: table the merge adding The a. b. c.
OBJECTIVE THEORY SHORT APPLICATION APPLICATION Table Merge on source Data
is Place spacing. Select Click merged. dialog the etc. an two new feature Source ANSWER
File organized on QUESTIONS-(SOLVED) consists the tables any box rows TYPE the menu
pointer cell displays BASED BASED by Table to to

K QUESTIONS-(SOLVED) TYPE in adding of arrangement and make the

the mailing in menu QUESTIONS-(SOLVED) QUESTIONS-(UNSOLVED) the select

QUESTIONS-(UNSOLVED) table
 I
table. between it the address one, and the contacts list. of follow select Print two text
 P
For file added these in option, tables example, to the the the Merge

steps: form by and Recipient or you. name, Press press of Table Select rows Ctrl+P, List the
 S
option. address, and it Delete and columns. or Both click click

city, key the on OK. PIN, to the tables remove telephone Print will tool the
be
from Standard toolbar. 5. The Mail Merge feature is used to combine a data source with the
main document. It saves our time and energy to send letters at multiple addresses. It primarily
enables automating the process of sending bulk mail to customers, subscribers or general
individuals.
SECTION 6: LONG ANSWER TYPE QUESTIONS-(UNSOLVED) 1. To directly insert a table
with the default properties, follow these steps:
• Click on the Table icon on the Standard toolbar.
• A grid of rows and columns will be visible.
• Drag the mouse over the grid to select the required number of rows and columns.
© Kips Learning Pvt. Ltd. 2020
Mention your subjects in rows and total marks in the last row. Mention maximum marks and
marks obtained in the columns corresponding to each subject. 2. To insert a row/column, follow
these steps:
• Click anywhere in the row/column, adjacent to which you want to add the new
row(s)/column(s).
• The Table toolbar appears. Click on any of the following buttons as per requirement:
• Rows Above: Click on the Rows Above button to insert a new row above the selected row.
• Rows Below: Click on the Rows Below button to insert a new row below the selected row.
• Columns Before: Click on the Columns Before button to insert a new column before the
selected column.
• Columns After: Click on the Columns After button to insert a new column after the selected
column. a) To insert a row above the second row, click on the second row and select Rows
Above
from the Table toolbar. b) To insert a column left to the first column, click on the first column and
select Columns
Before from the Table toolbar. 3. In LibreOffice Writer, you can easily create a copy of table and
paste it into another part. To
copy a table, follow these steps:
• Click anywhere in a table.
• Click on Table menu.
• Choose the Select option then the Table option.
• Click on the Edit menu and select the Copy option or press Ctrl + C. Selected table will be
copied into the clipboard.
• Place the cursor where you want to insert a copied table.
• Click on the Edit menu and select the Paste option or press Ctrl + P. Selected table will be
inserted at the cursor's position. 4. Choose Tools menu and select the Mail Merge Wizard
option.
• Observe, by default the second checkbox under the Insert address block section is selected.
• Click on the Select Address List button.
• The Select Address List dialog box appears.
• Now, click on the Create button to create a new address list.
• The New Address List dialog box appears.
• Click on the Customize tab to add or remove fields.
• Now, enter the data in the respective fields, and click on the New button.
• Enter records of your friends and relatives. Click on OK.
• You will get the Save dialog box. Specify a name in the Name box and click on the Save
button.
• The Select Address List dialog box will appear.
• The dialog box displays the address file added by you. Select it and click OK. 5. Click on the
File menu and select the Print option. You will see the Print dialog box.
• Choose the desired number of copies and page settings.
• Select the name of the printer under Printer.
• Under the Range and Copies section, select All pages to print all the pages of a document.
 IPS
K
© Kips Learning Pvt. Ltd. 2020
• Select the Pages option to print the specified range of pages from the document (like 5- 10).
• Selecting the Selection option will print only the selected text from the document.
• You can select the "Print in reverse page order" option, if you want to print from the last page
to first page. This leads to easy arrangement of hard copies of the pages.
• Once you have finished, click on OK.
• The printer will print a copy of your current document.
Chapter 1. 2. 3. 4. 5. Chapter A single multiple is workbook. There A small starting
example, Right-click Before Right-click composed range workbook a. b. c. – – as are theme
Current 10: 11: You Choose OK.
You contains is cell worksheets a a 1,048,576 on a on single Each range will will CREATING
group EDITING address of is and the the UNIT Sheet a a the get sheet see only very cell
starting collection desired contains, sheet of the new row, in that from followed or one
 contiguous large contains order 4: Move/Copy tab as document K 1024

worksheet from a worksheet, DATA the ELECTRONIC big at number new of of to A

least, Insert one columns C3 by cells as Sheet2 organise workbook SPREADSHEET cells,
and an the or Sheet option arranged IN one of tab Sheet entire i.e., ending more ending cells,
 I
and which and A and worksheet. and the dialog dialog from SPREADSHEET

choose has 1,073,741,824 worksheet. which choose worksheets, consolidate in same in are
cell grid J10 been box. the SPREADSHEET box. selected
P
address, are Insert worksheet would the pattern The 'To created Click the

Move You document' workbook data in Sheet be basic cells or on both using a can written
efficiently. denoted or with that single OK. in option storage Copy specify separated rows a
 S
has is the Calc drop-down file. as designed Sheet been

collectively. and from name B2:H8. worksheet. unit a Whereas, Each range columns.
moved. option. by for the Untitled to workbook list a data menu. by hold colon A and It writing
worksheet in can together 2, a click Choose (:). which file has be the For
on or
as a
1. The text entered in a cell by using the keyboard is called a label. A label can be a
combination of both numeric and non-numeric data along with spaces. By default, the labels are
left-aligned in a cell and are never used for calculation purposes. Whereas, the numeric data is
called value in Calc and can contain the digits 0-9. By default, the values are right-aligned in a
cell. 2. Data validation can be used to restrict user from invalid data input. To apply data
validation on
your worksheet cells, follow the below mentioned steps:
• Select the cells on which data validation is to be applied.
• Choose Data > Validity.
• The Validity dialog box opens.
• In the Criteria tab, click the Allow drop-down list and choose the type of data you want to allow
in the selected cells.
© Kips Learning Pvt. Ltd. 2020
• Choose the Data and Value criteria accordingly.
• In the Input Help tab, a help message can be entered that will be displayed while entering data
in the cells.
• In the Error Alert tab, an Error message along with an Action can be entered that will take
place if an invalid entry is made in the cells. 3. To insert a blank row above row 5:
• Right-click on the row header of row 5, where you want to insert a new row.
• From the Context menu, select the Insert Rows Above option.
• A new row will be inserted just above the row 5. 4. ‘If’ is a conditional function. It returns first
value succeeding the condition, if the condition
evaluates to TRUE; and second value if it evaluates to FALSE. Example, =IF(A1>100,250,200)
BRAIN SECTION SECTION SECTION SECTION 5. 1. 2. DEVELOPER This else
Functions eliminate Arguments Functions eliminate Arguments Arguments True The general of
parenthesis. =FUNCTION Count() formulas, 1: 2: 3: 4: arguments OBJECTIVE THEORY
APPLICATION THEORY Structure it means or will False), function syntax and the the return
are are and and are that NAME A QUESTIONS-(SOLVED) QUESTIONS-(UNSOLVED)
chance chance date of range function pre-designed pre-designed of separated input Structure.
Structure. TYPE if counts 200. a functions. the BASED (argument1, function entries of values

K QUESTIONS-(SOLVED) to to value cells, must the write write by in

QUESTIONS-(SOLVED) number to defines The in constants, begin a formulas formulas

commas wrong functions. given wrong the argument2, structure with cell its of range formulas.
 I
formulas. values to to basic A1 formulas (semicolon the These perform perform begins
 P
is of ‘=’ argument3 greater skeleton, cells. such sign. can The The or with

as simple simple be even in functions functions than numeric numbers, which the case .........)
 S
other 100, function and and of forms entries, are are functions.

the complex complex range text, made made function the name logical logical of basis up up
calculations. calculations. followed cells) of of will values values, of two two return writing within
parts parts (such by They They a 250, the
the list —
—
as
3. a) Average() b) Max() c) Sum() d) Min() 4. Some important features of spreadsheet are:
• Functions and Formulas: Functions are the built-in formulas which are used for making
calculations such as calculating percentage, interest, average, etc., in Calc. Formulas are
mainly used for performing simple and complex calculations.
• Formatting Features: These features are used for improving the appearance of data.
• Auto-calculation: The data is automatically recalculated in the whole worksheet, if any change
is made in a single cell. Some popular spreadsheet software are: a) Microsoft Excel
b)LibreOffice Calc c) Gnumeric d)OpenOffice Calc
© Kips Learning Pvt. Ltd. 2020
5. a) Cell : A cell is an intersection of a column and a row in a worksheet. It is rectangular in
shape. Each cell is identified by its column letter and row number, which is known as Cell
Address, for example, A1, G2, etc. b) Workbook: A workbook is a collection of one or more
worksheets, in a single file. Each workbook has a single theme and contains, at least, one
worksheet. The workbook is designed to hold together multiple worksheets in order to organise
and consolidate data efficiently. c) Worksheet: A worksheet is composed of a very large number
of cells, which are the basic storage unit for data in a file or workbook. Each sheet contains
cells arranged in grid pattern using rows and columns. 6. In Calc, each sheet can have
220=1,048,576 rows and a maximum of 210=1024 columns. The
address of the first cell of a worksheet is A1 and last cell is AMJ1048576. 7. The Formula bar is
located at the top of the sheet in the Calc workspace. It is located to the 8. 9. right active side
address. To To To The combination are data aligned For move/copy rename delete example,
left-aligned in text is of cell. the called in • • • • the For a • • • • • • • entered a It a Formula
worksheet: cell. Right-click Choose Assign The example, Name worksheet: of shows
98Hello42, In worksheet OK. You You You Right-click You To value a both in worksheet
worksheet: the delete can will can will a a in box. the the cell in bar. new numeric Move/Copy

K A1, see get also also a on Calc Rename the actual and This on A2Z cell

above This name the a B6, that opt drag will dialog selected and the are are by bar and Sheet
etc. area content to the be for desired which the can Sheet never labels. using move shows
Sheet non-numeric renamed. box desired the displays Sheet tab worksheet, contain
I
you asking option. worksheet used of the this worksheet which Whereas, dialog the

the tab want worksheet worksheet the keyboard for the characters for cell. and you You
P
data box, location calculation to click confirmation digits 7902 and drop

Whereas, want will and move along from on has click see is to choose 0-9. is it to Yes. and of
the in a the called moved with the the rename. on value. purposes. the By its Name current
 S
formulas end to OK. Rename new the default, Insert spaces.

cell a delete. to of Delete label. box location. pointer its the worksheet Whereas, before new
that By Sheet is the list. located Sheet A default, place. values by you label list, dialog
displaying option. the and enter on select can the are numeric box. click the labels
right- in be left the on an
its
a
10. The four basic mathematical operations supported by Calc are: addition, subtraction,
multiplication, and division. 11. ‘If’ is a conditional function. It returns first value succeeding the
condition, if the condition
evaluates to TRUE; and second value if it evaluates to FALSE. Example, =IF(A1>100,250,200)
This means that if the value in the cell A1 is greater than 100, the function will return 250, else it
will return 200. 12. A range is a group of contiguous cells, which are selected or denoted
collectively. It can be as small as a single cell or as big as an entire worksheet. You can specify
a range by writing the starting cell address followed by the ending cell address, both separated
by a colon (:). For example, a range starting from C3 and ending in J10 would be written as
B2:H8.
© Kips Learning Pvt. Ltd. 2020
13. Sum (C7:F15) Average (C7:F15) 14. Joining two or more text values together is called
Concatenation. You can use the
ampersand symbol (&) for addition. Follow the steps to concatenate the text values:
• Enter two string type values in cell A1 and B1, say Kips in A1 and India in B1.
• Enter the formula = "Kips"&"India" in cell C1 and press Enter key.
• It will display KipsIndia in the cell C1.
SECTION 5: APPLICATION BASED QUESTIONS-(UNSOLVED)
1.
(i) D2 shows 2430 (ii) The formula becomes =B6+C6, the cell D6 shows 3335 (iii) The value
shown in D6 remains the same , i.e., 3335
2. 3. 4. Chapter 1. 2. In In (i) (ii) clicking (iii) (iv) (i) (ii) (iii) Wrapping Calc other Sometimes
These increasing – cell cell 12: In (iv) (v) =AVERAGE(C9,D9) In In In In In = =MAX(E5:E11),
can Click cells. cell E1 F1 AVERAGE(C5:C11), cell cell signs 490 cell cell cell on The
FORMATTING type type help E3 the on F3 C10 the D10 E10 F10 the you formula indicate
type type cell =(E1/100)*100. =C1+D1. text column you respective type type type type see
=((C3+D3)/100)*100. E9 =IF(E3>=90,”A+”,”B”). means display =MAX(C3:C7)
=AVERAGE(D3:D7) =AVERAGE(C3:C7) =MIN(E5:E11)

hash =MAX(D3:D7) in K and that width D3 Copy signs cell

=AVERAGE(D5:D11) press displaying shows the lengthy one cell and Copy DATA column
 I
(######) Ctrl+C. E1 can =$B3+$C3, pressing text and cell multiple see is Copy F1

Paste paste in IN in Copy the not and Ctrl+V.

 P
a a value A cell single cell cell lines it the cell wide paste

SPREADSHEET to content E3 instead shown F3 copied cells within cell and enough it and
to E2, without paste of properly. is paste cells cell the E3, 2680 the to cell. it content F2,
 S
E4 it display data to moving to and F3, The cells cells that F4

E5. in Wrap the E4 and the F4 cells you to to cell F5. content Text E7. have F7. E5 content. to
feature entered. E11 to the
By by
in
3. Calc provides a variety of predefined Date and Time formats for different locales. To enter
date type data use ‘/’ to separate month, day and year. To enter time type data use ‘:’ to
separate hours, minutes and seconds. 4. To convert numeric data into labels, do the following:
• Select the range of cells to be formatted as labels.
• Click on Format > Cells. The Format Cells dialog box will appear on the screen.
• Click on the Number tab.
• Select Text under the Category section.
• Click on OK. 5. Fill Handle is a feature that allows the user to extend and fill a series of
numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet,
the Fill Handle is
© Kips Learning Pvt. Ltd. 2020
a small black box at the bottom right corner. Fill Handle tool eases the work of entering data. It
is a shortcut way to fill cells by dragging the Fill Handle in the direction you want to fill. If the cell
contains a number, the number will be filled in the series. If the cell contains text, the same text
will be filled in the direction you choose.
Chapter – 13: CELL REFERENCING
1. A cell reference refers to a cell or range of cells on a spreadsheet, that can be used in a
formula or function from one cell to the next along the row or column.. A cell reference can be
used to refer to the:
2. 3. a. b. c. a. b. c. Relative cells. data data data Sometimes, with this addition $B$24, 6, the
When the according copy become =F7+G7+H7. A combination column $A10:$D16, formula will
column accordingly. Relative the mixed formula case, relative become and from contained on
this the a formula $A$10:$D$16, is other relative will address =C4+D4+E4. absolute of formula
you reference absolute formula one to references a will become you etc. position of the
=$C9+$D9+$E9. dollar can worksheets or will in relative still cell need more

K If relationship will different keep must references =C3+D3+E3 (fixed)

remain you remain sign reference is =$C8+$D8+$E8. If of etc. change not to contiguous the a
the be and copy rows ($) copy reference in If or areas fixed. change, cell =$C$5+$D$5+$E$5.
=$C$5+$D$5+$E$5. same you the preceding absolute the behave with Since is the and when a
 I
address from same copy copied of formula other In formula cells formula a columns.

the that whereas the that If worksheet. row the referencing. a workbook. differently the the is on
constant across position formula condition, column relative formula in refers
P
the 3 is same column =$C7+$D7+$E7 which to pasted The the

worksheet. multiple If row in and formula to (changeable), reference the is =$C$5+$D$5+$E$5

relative In relative when the and the absolute a in copied this it 4, same specific content is cell
 S
cells, cell(s) the the is designated case, copied cell pasted I7,

row row formula from is formula they cell to on the absolute, either reference row for of
referenced, reference another referencing the get row and the in formula example, or is in cell
from changed will one worksheet. cell(s) pasted 7 a column. filled I9, formula therefore, to
changes of automatically cell. row will will the row D$3, e.g., the associated is in to based
Absolute 5 used. become
formula
change row cell to It by 8, If $D$3, $B24,
other itself row
is you the
the
the on I7,
or In
a
references, on the other hand, remain constant no matter where they are copied.
© Kips Learning Pvt. Ltd. 2020
Chapter – 14: INTRODUCTION TO CHARTS
1. A chart is a graphical representation of data in a worksheet. 2. In a Calc worksheet, chart
helps to provide a better understanding of large quantities of data. Charts make it easier to
draw comparison, see growth and relationship among the values and trends in data. They
provide an accurate analysis of information. 3. Column chart 4. Chart Wall is a window within
the Chart area. It contains the actual chart itself and includes
plotted data, data series, category, and value axis.
BRAIN SECTION SECTION SECTION SECTION 1. 2. 3. Formatting helps To The display
following: The particular 1: 2: 3: 4: DEVELOPER format a. b. c. d. e. f. a. b. c. d. e. f.
Scientific Alignment OBJECTIVE THEORY APPLICATION THEORY to Select Click Click
Select Click Observe very Select Click Click Select Click Observe enhance alignment, numbers
features on on on on on on large format the QUESTIONS-(SOLVED)
QUESTIONS-(UNSOLVED)
Text the Scientific tab Format the OK. Format the OK. that that TYPE the range range or under
is into Number Number BASED help (also follow overall the the used very

QUESTIONS-(SOLVED) > > under labels, of of data data K to Cells. Cells.

the referred to cells cells small QUESTIONS-(SOLVED) the beautify look tab. tab. Category
set formatted formatted the follow The The given to to of the numbers. Category be be to
Format Format the the horizontal formatted formatted steps: as these section. workbook.
 I
Standard as in data scientific Cells Cells labels section. steps: To and format as as
 P
and dialog dialog appear or make labels. scientific.

format. Standard vertical box box numbers the left-aligned. will will worksheet alignment Index
 S
appear appear into Form) scientific on on of presentable. the the

data is a screen. screen. compact in format, cells. Formatting way To do set to the
a
• Select the cell or range of cells to be aligned.
• Click on Format > Cells. The Format Cells dialog box will appear on the screen.
• Select the Alignment tab from the dialog box.
• Select the desired horizontal alignment from the Horizontal drop-down list.
• Select the desired vertical alignment from the Vertical drop-down list.
• Click on OK. You can now notice the change in the alignment of the text. 4. To change the text
orientation, do the following:
• Select the cell or range of cells and click on Format > Cells. Open Alignment tab from the
Format Cells dialog box.
• Under the Text orientation section, specify the angle in Degrees. If you enter a positive value,
the text will rotate to the left and vice-versa.
© Kips Learning Pvt. Ltd. 2020
• Select the desired Reference edge to indicate the cell edge from which to write the rotated
text.
• Click on OK and note the change in text orientation. 5. Calc provides a variety of predefined
Date and Time formats for different locales. To enter date
type data use ‘/’ to separate month, day and year. 6. When a large amount of data is entered in
a narrow column, Calc displays hash signs (######) instead of the data that you have entered.
These signs indicate that the column is not wide enough to display the cell content. By
increasing the column width one can see the cell content properly. To change the column width:
• Place the pointer over the column line in the column heading so that the cursor becomes a
double -headed arrow.
• Clicking and dragging the column to the right will increase the column width. Dragging it 7. 8.
Fill text black shortcut contains will A or refer There cell function Handle • be • • • a. b. to to box
reference are filled a to The data data data Absolute the referencing designated row
=$C$5+$D$5+$E$5 the Relative get reference the the: a way desired three at the number, is
from same worksheet. column cell(s) changed in from contained on a the referenced, to left the
feature types other refers fill Referencing: number one bottom formula Referencing: changes
one will direction associated in the cells width is a based cell of worksheets decrease or to that

used. in If formula number cell by more you a K of right different to is will

e.g., itself cell from allows dragging you pasted cells. referencing. the on copy In When with be
Sometimes, contiguous corner. or the by will $D$3, choose. the according this next row
changed range In in the the the areas in this column be the the a relative the case, 5 cell along
user relative formula addition Fill filled $B$24, to formula of same active of They Fill I7,
 I
once row cells Handle cells to to you a width. you the the in Handle worksheet.

position the extend workbook. are: cell 6, =C3+D3+E3 cell the on of the on need $A$10:$D$16,
 P
row can formula must the relationship a reference the tool a series. of

mouse dollar or spreadsheet, in keep and to formula the worksheet. be of the column. eases
copy will fill spreadsheet, fixed. rows If sign is from the direction the a is released. still a the with
will series ($) copied etc. formula cell and cell A In row remain preceding work
 S
that cell remain that the contains address If columns. 3 of you

across reference to can the position numbers, you of condition, in =$C$5+$D$5+$E$5. row
want =$C$5+$D$5+$E$5. which entering be Fill the copy text, multiple constant 4, used Handle
The to the in column can the dates, the fill. the absolute the in relative formula data. be content
cells, same If a is cell(s) and formula formula used and or the a It small even
they it text is will cell
cell
cell the
on to
of
is
If a
automatically become =C4+D4+E4. If the same formula is pasted in cell I7, the formula will
become =F7+G7+H7. c. Mixed Referencing: A mixed reference is a reference that refers to a
specific row or column. It is a combination of relative and absolute referencing. In this case,
either one of the row or column is absolute (fixed) or the other is relative (changeable), for
example, D$3, $B24, $A10:$D16, etc. If you copy the formula =$C7+$D7+$E7 from row 7 to
row 8, the formula will become =$C8+$D8+$E8. If the same formula is pasted in cell I9, the
formula will become =$C9+$D9+$E9. Since the column reference is absolute, therefore, the
column address will not change, whereas the relative row reference will change accordingly.
© Kips Learning Pvt. Ltd. 2020
9. A chart is a graphical representation of data in a worksheet. In a Calc worksheet, chart helps
to provide a better understanding of large quantities of data. Charts make it easier to draw
comparison, see growth and relationship among the values and trends in data. They provide an
accurate analysis of information. 10. Follow these steps to insert a chart in Calc:
• Select the range of cells from the worksheet that contains the source data for the chart.
• Open the Chart Wizard dialog box using one of the two methods:
• Click on the Chart icon present on the Standard Toolbar. Or
• Click on lnsert > Chart.
SECTION 5: APPLICATION BASED QUESTIONS-(UNSOLVED)
a. In cell D4 type =((C4/100)*22)+C4. Drag the fill handle of cell D4 till cell D10. Chapter
ANSWER 1. 2. 3. A motivate, attaching A A THE presentation presentation slide b. c. d. e. a. b.
c. d. e. f. g. h. – FOLLOWING 15: can In In In Select choice. Regular Background Graphical
Audio Transitions Footer
Date Slide the cell cell cell and be INTRODUCTION and number computer E4 F4 C11 and

the UNIT has entertain defined is Text, type type time elements a data type videos
QUESTIONS: the and collection and Lists =AVERAGE(C4:E4). =((C4/100)*30)+C4. following

from =AVERAGE(C4:C10). animation with – as Title K or items 6 a like,

the a to digital (DIGITAL multimedia of provide Clip worksheet, elements: slides or Arts,
 I
TO an arranged information. Drag Shapes, Drag projector. electronic

PRESENTATION Drag and PRESENTATION) the the Click the in Diagrams, fill
P
fill a fill handle page on handle It sequential handle lnsert can of 3D of be
 S
of a > cell of objects, presentation. cell Chart projected cell manner

F4 E4 SOFTWARE C11 till to till Table, cell insert till cell to on F10. cell convey, E10.
A etc. a a slide E11. chart big screen persuade, show of your is by a sequential display of
slides, which is shown to the audience with an objective of providing information and
exchanging ideas/views on a particular topic. 4. Three presentation software are: LibreOffice
Impress, Microsoft PowerPoint and Adobe
Connect. 5. You should follow certain guidelines to create a good quality presentation as listed
below:
a. Well designed b. Less number of textual lines c. Use of bright colours d. Well-aligned and
formatted content e. Use high quality graphics f. Use simple transition and animation effects
© Kips Learning Pvt. Ltd. 2020
g. Avoid language and grammatical errors h. Keep the presentation simple using charts and
graphics i. Minimal use of facts and figures j. Well edited k. Powerful first impression
Chapter – 16: GETTING STARTED WITH LIBREOFFICE IMPRESS
1. You can open the LibreOffice Impress 6.2 on your computer using any of the following ways:
• Open the Start menu on your computer and select the LibreOffice 6.2 > LibreOffice Impress
from the Programs list. Or
• Type Impress in the Search bar, choose application name, and press the Enter key to 2. 3. 4.
5. Workspace slide Slide views Undo operation Standard Redo to You To reverse, create • • • • •
• • • • • • can appears Sorter : by : It It open Double-click Open The When slide. To on Click
Press A Click The The file. create clicking reverses the new reverses upto open the click is
LibreOffice PDF view. Export on on it. the Or Ctrl+N. PDF the in presentation you Standard a on
Or which File the Normal a Options on new blank LibreOffice of the new All the the open dialog
the File > on your presentation these New action you arrow presentation, area suite last the

drop-down menu toolbar view. dialog K Impress, presentation, box > want

LibreOffice will views given in Presentation. window of suite next and You the appears. box the
appear and to to are command using select middle by you can arrow last appears. reverse,
select click the appears. using available Impress change with get follow Undo the Select Redo
 I
the of on of Or

Presentation. any a Start Display the the Export Click the or click command. new these Select
icon the the shortcut of under Title the window drop-down menu on the
 P
on on presentation default location as Slides steps: last Impress the

Slide. the following the PDF the or icon, Or Export where entry To Standard arrow on Search
View option. view Here, select where arrow Presentation the if you it a ways: button. in menu.
 S
that enter next is Standard slide bar. the next Outline available

you typed. Toolbar. contains to Undo is the You to want displayed. the the under title toolbar. To
view, can on step Undo to New select of only the also keep Notes Create. that slide. By icon
desktop. icon one a access default, you your previous view, toolbar.
present on empty want
PDF the
the Or
or a
• Enter the name in the File name box. Click on the Save button. Your presentation will be
saved in the PDF format.
Chapter – 17: WORKING WITH SLIDES
1. Ctrl+M 2. To copy slides, follow these steps:
• Select slides in the Slides Pane. Or
• Switch into Slide Sorter view by clicking on View>Slide Sorter.
© Kips Learning Pvt. Ltd. 2020
• Select slides that are to be copied.
• Now, click on the Edit menu and select the Copy option. Or
• Right-click on selected slides and select the Copy option.
• Paste the slides to the desired location by Clicking on Edit>Paste. Or
• Select the Paste option from the Context menu.
• The slide gets copied at the new location. To move slides, follow these steps:
• Select slides in the Slides Pane. Or
• Switch into Slide Sorter view by clicking on View>Slide Sorter.
• Select slides that are to be moved.
• Now, click on the Edit menu and select the Cut option. Or
• Right-click on the selected slides and select the Cut option.
• Paste the slides to the desired location by clicking on Edit>Paste. Or
• Select the Cut option from the Context menu.
• The slide gets moved at the new location. 3. Cut – Ctrl+X, Copy – Ctrl+C, Paste – Ctrl+V 4.
Zoom slider helps you zoom in or zoom out the slide view as per your requirement. 5. Various
presentation views available in Impress are:
a. Normal view b. Outline view c. Notes view d. Slides Sorter view 6. To insert bullets list, follow
these steps:
• Place the pointer from where you want to start the list item.
• Click on the Toggle Bulleted List or Toggle Numbered List button on the Text Formatting
toolbar.
• A bullet or a number appears in the document. Type your text and press the Enter key.
• The bullet or number will automatically appear on the next line. Or
• Select the items that you want to bullet or number.
• Click on the Toggle Bulleted List or Toggle Numbered List button on the Text Formatting
toolbar.
BRAIN DEVELOPER
SECTION 1: OBJECTIVE TYPE QUESTIONS-(SOLVED) SECTION 2: THEORY
QUESTIONS-(SOLVED) SECTION 3: APPLICATION BASED QUESTIONS-(SOLVED)
SECTION 4: APPLICATION BASED QUESTIONS-(UNSOLVED)
1. Notes view 2. Slides sorter view 3. Normal view 4. Normal view 5. Outline view
 IPS
K
© Kips Learning Pvt. Ltd. 2020
SECTION 5: THEORY QUESTIONS-(UNSOLVED)
1. A presentation is a collection of slides arranged in a sequential manner to convey, persuade,
motivate, and entertain or to provide information. It can be projected on a big screen by
attaching the computer with a multimedia projector. 2. A slide can be defined as a digital or an
electronic page of a presentation. A slide show is a sequential display of slides, which is shown
to the audience with an objective of providing information and exchanging ideas/views on a
particular topic. 3. A presentation is a collection of slides arranged in a sequential manner to
convey, persuade, motivate, and entertain or to provide information. Whereas, a slide can be
defined as a digital or an electronic page of a presentation. 4. A slide layout contains
placeholders, which in turn holds text, such as titles, bulleted lists,
and slide content, such as tables, charts, pictures, shapes and clip arts. 5. 6. 7. Follow • • • To
add • • • • • • Standard the most • • • • • • these a Click Impress name The .odp. Click You Type
same The After case Remember, New Open Save Save name Export file Print opens.
password frequently Toolbar: can presentation will presentation you on on : : steps As the : a in
: text or It It It As It Click password be : the the the receive creates saves displays file opens
forget contains It desired PDF box This viewed to to saves Save check Confirm the used type.
 on K save your the : and bar an the a password It a the the icon the will

commands Set new has password will saves different current box and the existing presentation,
click is password, Print password Save current Password be placed on been be presentation:
Save LibreOffice printed on the saved the saved document. As is icon file the options with set,

I
current case in below Standard in dialog document there from on text with Save the to
Impress. prompt the with password follow sensitive. any document. print box Enter that the box.

P
password your button. file document will the platform toolbar and these

message Menu to in you the be Some Enter system password specified a Portable option, no
then different use active steps: protection. or bar. way of the with will to or box. click select its
and name It take to only remote document. name Document to the tools contains location on
 S
recover then open the original printouts. open OK. 'Eco are and

location. File click text : Friendly the with or the the Format The menu formatting on with box,
document. shortcut extension the Print Save. > a AC' (PDF) and password. Save different
dialog in intact. icons type option. the . will A PDF
box File
the
file for be
In
• Cut : It copies the selection to the clipboard and removes it form its original location.
• Copy : It copies the selection to the clipboard while keeping it in the original location as well.
• Paste : It inserts the contents of the clipboard at the location of the cursor.
• Clone Formatting : First select some text or an object, then click on the Clone Formatting icon
on the Standard toolbar.
• Now, click on an object to apply the same formatting.
• Undo : It reverses the last given command or the last entry you typed. To select a previous
operation upto which you want to reverse, click on the arrow next to the Undo icon on the
Standard toolbar.
© Kips Learning Pvt. Ltd. 2020
• Redo : It reverses the action of the last Undo command. To select the Undo step that you want
to reverse, click on the arrow next to the Redo icon on the Standard Toolbar.
• Spelling : It checks the document or the current selection for spelling errors.
• Insert Hyperlink : It opens a dialog box that enables you to create and edit hyperlinks.
• Fontwork : It opens the Fontwork Gallery dialog box from which you can insert styled text not
possible through standard font formatting into your document. 8. A slide show is a sequential
display of all the slides. The various ways to view a slode show
are: • Click on the Start from first Slide button present on the Standard toolbar. Or
• Press the F5 key to run a slide. Or SECTION 1. 2. 3. 4. LibreOffice LibreOffice text, Features
a. b. c. d. e. A a. b. c. d. e. f. g. h. i. Two a. b. Presentation 6: presentation • Creating Creating
Creating Publishing Giving Regular Background Graphical Audio Transitions Footer Date Slide
Use Well Use LONG characteristics pictures, You of bright designed of and number and
Presentations bright ANSWER Suite. Impress Impress Text, can Vector Slides Presentations
software time elements videos Presentations colours has and charts, also and colours Lists

Impress the of animation Graphics are: is Title start TYPE K

is following like, good diagrams, popular application the allows QUESTIONS-(UNSOLVED)
a items a and

properly Clip quality slide Arts, elements: presentation you show audio, formatted software,
 I
presentation to Shapes, create by videos, clicking Diagrams, which
P
software. content dynamic are on narration, is listed used Slide slide 3D It
 S
comes objects, below: to Show presentations create transitions,

> as Start Table, an multimedia integral from etc. that and first can part animation. Slide.
include of the
presentations in the form of slide shows. The advent of advanced presentation graphics
software has replaced the overhead projectors and transparencies of bygone days. The
conventional method of presenting information is being gradually replaced by digital
presentation. It has become more colourful, comprehensive, and appealing, which has made
the process of delivering information more interactive, effective, and easy to comprehend.
Some popular presentation software are: LibreOffice Impress, OpenOffice Impress, Adobe
Connect, Microsoft PowerPoint, and Google Slides (Part of G Suite). 5. The various formatting
options are:
• The Text Formatting toolbar
• The options available under Format menu
• The keyboard shortcuts
© Kips Learning Pvt. Ltd. 2020
6. To insert a duplicate slide, follow these steps:
• Select the slide in the Slides Pane.
• Click on the Slide menu and select the Duplicate Slide option. Or
• Right-click on the selected slide and select the Duplicate Slide option. Or
• Click-on the Duplicate Slide icon on the Presentation toolbar. 7. Use the Zoom & View Layout
dialog box to zoom in or zoom out the slide view as per your
requirement. 8. Various presentation views available in Impress are:
a. Normal view b. Outline view c. Notes view d. Slides Sorter view
Chapter A. B. 1. 2. Chapter Fill 1. 2. 3. 4. Answer To The the tool. insert in grid table
merge optimize
• • • • • • • • • • table. paragraph – – The the 18: 19: Choose The Define Click A For For
Toggle Spacing Indent the a following Blanks: table To table horizontal vertical following Insert
WORKING INSERTING on apply the : List: properties will Insert : OK. Increase, using
Increase Table number paragraph be alignment: Bulleted the questions: > Insert text displayed

Table. paragraph dialog K Decrease Spacing are alignment: of and menu,

WITH formatting columns used Align box AND according Numbered and formatting,
appears. and follow to Top, Align TABLES Decrease FORMATTING and change
 I
Hanging tools Center these to rows. Left, the are the select steps:
 P
Spacing Align Vertically defined available: alignment the Center, columns
 S
cells and IMAGE settings Align Align and and Right then

Bottom. of rows. IN click and the A

text Justified. on written inside the respective
PRESENTATION
Answer the following questions
1. Follow these steps to insert a graphic from the Gallery:
• Click on the Gallery icon present on Sidebar. Or
• Choose View > Gallery option.
• Select the Theme that contains the image to be inserted.
• Click on the image, then drag and drop the image into the slide.
• You can also right-click on the object and select the Insert option.
© Kips Learning Pvt. Ltd. 2020
2. Yes, it is possible to insert an image as a link in a slide. To do this, follow these steps:
• Click on the Insert menu. Select the Image option. Or
• Apply a layout that contains a picture placeholder. Click on the Insert Image icon.
• You will now see the Insert Image dialog box.
• Select the folder from where you want to insert the picture.
• Choose the desired picture file and click on Open.
• Check the Insert as Link check box. Impress will create a link to the file rather than inserting
the original image. Linking can reduce the size of a document. The linked image and
presentation remain two distinct entities, and a copy of that image is not inserted within the
slide. 3. Hold down the Ctrl/Shift key while dragging the resizing handle of an object to resize it
uniformly. 4. Chapter Answer 1. 2. 3. 4. BRAIN SECTION SECTION SECTION
SECTION 1. A rotated, Themes schemes, Transition make Transition Select particular Insert
bar. A the table group DEVELOPER following – 1: 2: 3: 4: a the Automatically 20: can
OBJECTIVE THEORY APPLICATION THEORY background and are of etc., slide effects
effects slides be shapes WORKING deleted the questions: which inserted stays attractive.
QUESTIONS-(SOLVED) QUESTIONS-(UNSOLVED) sets to are can TYPE the visible.

image, together. after can special of BASED in be slides. be K a

predesigned QUESTIONS-(SOLVED) for slide formatted applied by To WITH effects

automatic QUESTIONS-(SOLVED) choosing give through to that a SLIDE in any formats
 I
presentation advancement Insert the a are presentation way following used Image that
 P
similar MASTER to the include enhance button two and to in
 S
professional order a ways: also single text, from the specify to

enhance interest the layouts, shape. touch, Properties the They duration of background, its you
the appearance. can from audience need for be the which moved, to colour
side and add
a
a. Insert menu b. Title and Content slide layout To insert a table using Insert menu, follow these
steps:
• Choose Insert > Table.
• The Insert Table dialog box appears.
• Define the number of columns and rows.
• Click on OK.
• A table will be displayed according to the defined columns and rows. 2. Insert 3. Link, Open,
and Cancel 4. While inserting image, select multiple images to insert them together.
© Kips Learning Pvt. Ltd. 2020
5. Insert 6. To increase or decrease the size of a shape:
• Select the shape.
• Bring the pointer to any of the eight resizing handles on the selected shape, and drag the
handle inward to decrease and outward to increase the size of a shape.
• If you want to resize the shape uniformly, then hold down the
• Ctrl/Shift key while dragging the resizing handle 7. To add text inside a shape:
• Double-click on the shape.
• The insertion point appears in the shape object. Now, type the text.
• After typing the text, click on the blank area of the slide.
• 8. To add • • • • • • 9. To change • • • 10. To display • • • 11. Color, 12. Format 13. Transition
make Transition 14. To apply • • Gradient, the effects Background. The Select Click The Click
Define corresponding The Click Choose background. From Select Click Under Click Select
sound different effects effects the slides text Area object on on on on Insert the any Slide the
colour Categories, the to effect the the the Load. Bitmap, gets the dialog attractive. palette to a
are audio shape Distance will > background > graphical Format Use Properties the Audio
added of Master Background special to text appear box a slides. shadow file Pattern, object. a

of K theme: select slide: boxes. or menu. colours, between into and

appears. To Slide. effects object, Video. with button styles: give click the checkbox a Hatch.
Click slide Select drop-down a choose shape. that shadow Select Open. a the do from on
 I
presentation design the object the are in OK. the the The your following: the Area

used category. Sidebar. option Shadow and audio Properties desired option
P
to its the enhance icon shadow, and tab. The colour from professional
 S
appears section. Properties select the the for Color, drop-down

the interest on Color the and touch, slide bar slide. Transparency to is of background.
displayed. you menu. the colour audience need the in to their slide
and add
To check how it sounds:
• Select the audio icon on the slide by clicking on it.
• Choose the Properties sidebar.
• Click on Play in the Media Playback section. 15. To set auto-advancement of the slides to 15
minutes, do the following:
• Click on Slide > Slide Transition or click on the Slide Transition tab from the sidebar.
• Select Automatically After for automatic advancement to the next slide.
• Specify the duration of 15 minutes.
• Click on the Apply Transition to All Slides button.
• Click on the Slide Show button to watch the effect.
© Kips Learning Pvt. Ltd. 2020
SECTION 5: APPLICATION BASED QUESTIONS-(UNSOLVED) 1. Open the presentation
and do the following:
• Go to the second last page.
• Click on Insert > Shape > Star > Horizontal Scroll. Drag and create a suitable size banner on
the slide.
• Double-click on the banner and type text “KIPS...The Best School Computer Books”.
• Click on the banner and choose Area Fill from the Properties sidebar.
• Choose Gradient from the Fill drop-down list.
• Select light-green colour. 2. Create a new presentation and do the following:
• Use title slide layout. Type the title summer camp as shown in the figure.
• • • • • • • • • • • • Choose Select Choose Draw Click Similarly Insert Image. Click shape.
Double-click Select Insert Select on on two text the images the the Insert Insert one Insert click
star shape shape text box shape the on > > of shapes > and at Shape Shape Shape shape and

and the balloons, the K and provide other fill fill bottom to > > > to fill its pink

Basic Star write Basic write green shape area musical appropriate and colour of to and ‘FUN
 I
batch in the choose colour select and yellow choose instruments from In slide fill

starting HOLIDAYS’ from an font and orange to properties shade rounded appropriate
P
write style, draw the details. from colour and properties about and a size

rectangle. big sidebar. horse properties ‘COURSES and star from rectangle various
S
colour. riding shape. sidebar. the Drag activities sidebar.

AVAILABLE’ properties shape. by and clicking draw offered. sidebar. in on a them.

rectangle Insert >
© Kips Learning Pvt. Ltd. 2020