DELHI PUBLIC SCHOOL BANDIKUI

Class IX – IT (402)

Practical File-2022-23

Submitted By: SAGAR SAINI

Class & Section: 9

Roll Number: 37

Teacher Name: Mr. Rajneesh Shrivastava

Teacher Sign: _________________________

SN Practical Name Teacher's Sign

1. Open the liber office writer software and write some
paragraph to perform the following: (use page setup dialog
box)
1. Prepare your page as follows:
Size-14 Orientation Margin-2 from
Landscape left and right 1.5
from top and
bottom
2. Use Bold, italic, underline, change case, Font color and
Format the text.
2. Use mail merge for data source/address list enter data of 10
people as shown in the table below
Title FirstName LastName Addres City Country Mobil
s e

3. Draw all the icons of standard toolbar of writer and write as

uses in your practical notebook.
4. Draw all the icons of formatting toolbar and write its uses in
your practical notebook.
5. Write one Paragraph and perform the operations stated below:
(a) Write steps to count total words in a document.
(b) Is it possible to select the vertical block? If yes then write
the steps.
(c) What are the steps to select a non-consecutive text in
writer?
(d)What document t is special character in writer and how will
you insert in a.
6. Create a mark sheet for calculating the following:
(a) Total
(b) Percentage
(c) Average
(d) Max
(e) Min
(f) Count
(g) Pass/Fail
7. Make a table given below and sort the data according to
their name and write the steps for this:
Sid Sname SClass Scity Smarks

8. Define the following:(With their Picture)

(a) Workbook
(b) Worksheet
(c) Table
(d) Cell
(e) Cell Range
(f) Name Box
(g) Formula bar
9. Draw the IDE of Liber Calc window.
10. Define the following:
(a) Presentation
(b) Slide
(c) Slide Show
(d) Slide Sorter
(e) Slide Layout
(f) Note Pane
(g) Slide Pane
11. Draw the IDE of Liber office impress in your practical
notebook.
Create one presentation in liber impress and apply animation,
12. transition and proper image. (You can take any topic)
Ans 1 – 2 :-

Apply Bold, Italic, or an Underline :-

 Select the text you want to change.

 Select Bold, Italics, or Underline. Shortcuts: To bold: Ctrl + B. To italicize:

Ctrl + I. To underline: Ctrl + U.
Ans 1 – 1 :-
Ans -2 :-

Ans 3 :-

1. New Document Icon - The new document icon is used to create a new file or document. - It is usually
represented by a blank sheet of paper with a folded corner.
2. Open Document Icon - The open document icon is used to open an existing file or document. - It is usually
represented by a folder with an arrow pointing upward.
3. Save Document Icon - The save document icon is used to save changes made to a document. - It is usually
represented by a floppy disk.
4. Print Document Icon - The print document icon is used to print a document. - It is usually represented by a
printer.
5. Cut Icon - The cut icon is used to remove a selected item and save it to the clipboard. - It is usually represented by
a pair of scissors.
6. Copy Icon - The copy icon is used to make a duplicate of a selected item and save it to the clipboard. - It is
usually represented by two sheets of paper.
7. Paste Icon - The paste icon is used to insert an item from the clipboard into a document. - It is usually represented
by a clipboard with a downward arrow.
8. Undo Icon - The undo icon is used to undo the last action. - It is usually represented by a curved arrow pointing
left.
9. Redo Icon - The redo icon is used to redo the last action. - It is usually represented by a curved arrow pointing
right.
10. Bold Icon - The bold icon is used to make text bold. - It is usually represented by a letter "B" in bold.
11. Italic Icon - The italic icon is used to make text italic. - It is usually represented by a letter "I" in italic.
12. Underline Icon - The underline icon is used to underline text. - It is usually represented by a letter "U" with an
underline.

Ans 4 :-
Ans 5 b) –
A vertical block list graphically represents a task, process, or
workflow, each step of which contains multiple sub-steps or
points of interest. By using a SmartArt graphic in Excel, Power-
Point, or Word, you can create a vertical block list and include it
in your worksheet, presentation, or document.

STEP TO CREATE VERTICAL BLOCK LIST:-

1. On the Insert tab, in the Illustrations group, click Smar-
tArt.

2. In the Choose a SmartArt Graphic gallery, click List, and

then double-click Vertical Block List.
3. To enter text in a box, do one of the following:
 Click [Text] in the Text pane, and then type your text.
 Copy text from another location or program,
click [Text] in the Text pane, and then paste your text.
Note: If the Text pane is not visible, click the control.
 Click in a box in the SmartArt graphic, and then type your
text.
Note: For best results, use this option after you add all of the boxes that you want.

STEPS TO COUNT WORDS IN A

Ans 5 a) –

DOCUMENT :-
1]. Launch Microsoft Word. This can be done by double clicking on the Word icon on your
desktop, in your Taskbar (Windows) or Dock (Mac). If you don't see an icon, click on the
'Start" menu in the lower left of your PC's screen. Click on the 'All Programs" drop down and
select Microsoft Word.
• On Mac, click on the Launchpad (a gray rocketship) icon in your dock. Type
'Word' in the search bar at the top of the screen.
2.
2]. Navigate to an existing document. To open a document, go to the File
menu, and then click on Open. A dialog box will appear with a list of
available documents.

3]. Select a document. In the dialog box, navigate to the document you
wish to open. Select the document, and once it's highlighted, click on
Open in the lower right of the dialog box.

4]. Select Tools. Once your document is open, select the Tools menu at the
top center of the window.
5]. Scroll to Word Count. In the Tools menu dropdown, click on "Word
Count."
 If you're not using a Mac, you won't see any Tools heading at the top. In this case, go to
the Review tab at the top of your document. Once there, you'll see "Word Count" on the
left-hand side of the section.

6]. Review your word count. A box will open displaying the number of
words, as well as the number of characters, paragraphs, lines and pages,
contained in your document.
1. In many documents, the word count is displayed live on the left side of the bottom bar of
the document window. Click on this word count to get additional information, such as the
number of pages and characters.
Ans 5 c). –STEPS TO SELECT NON CONSECUTIVE ITEMS USING
WRITER OR KEYBOARD :-
1.Select the first piece of text. (For more information about keyboard selection of text, see the topic “Navigating
and selecting with the keyboard” in the Apache OpenOffice Help (F1).)

2. Press Shift+F8. This puts Writer in "Add" mode. The word ADD appears on the status bar.

3. Use the arrow keys to move to the start of the next piece of text to be selected. Hold down the Shift key and
select the next piece of text.

4. Repeat as often as needed.

Now you can work with the selected text.

Press Esc to exit from this mode.

Ans 5 d).- Place

your cursor in the file at the spot where you
want to insert the symbol.
1. Go to Insert > Symbol.
2. Pick a symbol, or choose More Symbols.
3. Scroll up or down to find the symbol you want to insert.
Different font sets often have different symbols in them
and the most commonly used symbols are in the Segoe UI
Symbol font set. Use the Font selector above the symbol
list to pick the font you want to browse through.
4. When you find the symbol you want, double-click it. The
symbol will be inserted in your file.
5. Select Close

ANS 6-

Ans 7- STEPS TO CREATE SORT DATA

1]. In first column for roll no.
2]. In second column write name .
3]. In third column write class name.
4]. In fourth column write the city name of students.
5]. In fifth column write the marks of students.

Ans 8 a).- Workbook- A workbook is a spreadsheet program file that you create in
Excel. A workbook contains one or
more worksheets.

Ans 8 b).- Worksheet - A worksheet (also known as a spreadsheet) consists of cells

in which you can enter and calculate data. The cells are organized into columns
and rows. A worksheet is always stored in a workbook.

Ans 8 c).- Table - Tables are essential objects in a database because they hold all the information or
data. For example, a database for a business can have a Contacts table that stores the names of their
suppliers, e-mail addresses, and telephone numbers. Because other database objects depend so heavily
on tables, you should always start your design of a database by creating all of its tables and then creating
any other objects. Before you create tables, consider your requirements and determine all the tables that
you might need.
Ans 8 d).- Cell - Cells are the basic building blocks of a worksheet. You'll need to learn the
basics of cells and cell content to calculate, analyze, and organize data in Excel.
Ans 8 e).- Cell Range - A cell range in MS Excel is a collection of chosen cells. It
can be referred to in a formula. This is defined in a spreadsheet with the reference
of the upper-left cell as the minimum value of the range and the reference of the
lower-right cell as the maximum value of the range.
Dark part in the box is cell range

Ans 8 f).- Name Box - The Name Box in Excel is located on the left side of
the Excel window. It is used to give a name to a table or any cell. For any
normal cells, by default, the name is the row character and the column
number, such as cell A1. However, we can check it when we click on the
cell. It shows in the Name Box as A1, but we can input any name for the
cell, press the “Enter” key, and refer to the cell with the name we put in the
Name Box. A Name Box is a tool that shows the active cell address. For
example, if you have selected cell C1, this Name Box will show the active
cell address as C1.

Ans 8 g).- Formula bar - Alternatively referred to as a formula box, the formula
bar is a section in Microsoft Excel and other spreadsheet applications. It shows
the contents of the current cell and allows you to create and view formulas. The
two pictures below are examples of what the formula bar looks like in Microsoft
Excel.To start creating a formula, click the mouse cursor in the formula bar and
enter an equal sign (=). In both of the examples below, we're using the =SUM,
which tells Excel to add each of the cells.

Formula bar

Formula bar in MS Excel

Ans 10 (a) Presentation - In computing, a presentation program (also called

presentation software) is a software package used to display information in the form of
a slide show. It has three major functions: an editor that allows text to be inserted and
formatted. a method for inserting and manipulating graphic images and media clips.
(b) Slide - In the digital age, a slide most commonly refers to a single page developed
using a presentation program such as MS PowerPoint, Apple Keynote, Google Slides,
Apache OpenOffice or LibreOffice. It is also possible to create them with a document
markup language, for instance with the LaTeX class Beamer.

(c) Slide Show - A slide show, or slideshow, is a presentation of a series of still images
(slides) on a projection screen or electronic display device, typically in a prearranged
sequence. The changes may be automatic and at regular intervals or they may be
manually controlled by a presenter or the viewer.

(d) Slide Sorter - The slide sorter lets you see your slides on the screen in a grid that
makes it easy to reorganize them, or organize them into sections, just by dragging and
dropping them where you want them

(e) Slide Layout - Slide layouts contain formatting, positioning, and placeholder boxes
for all of the content that appears on a slide. Placeholders are the dotted-line containers
on slide layouts that hold such content as titles, body text, tables, charts, SmartArt
graphics, pictures, clip art, videos, and sounds.

(f) Note Pane - The Notes pane is where you put supplemental information that doesn't
appear on-slide during a presentation. You may want to make key words in the notes
bold so that you can see them better, or use a smaller font size if you have a lot of
notes.

(g) Slide Pane - A slide pane is a feature available in some programs, usually found on
the left side of the window. It displays thumbnails of files or features available in the
program. For example, the slide pane in Microsoft PowerPoint presentations displays
all of the slidesin a presentation.

Ans 12 – Adding transition

1. In the Sidebar, select the Slide Transition icon to open the Slide
Transition section
2.In the Slides Pane select the slide or slides to apply the transition
3.In the Sidebar select one of the available transitions. When you click in
a transition you preview the effect in Impress workspace.
4.Modify the selected transition by changing the speed or adding a sound,
in the Modify transition section. If you decide to play a sound during
transitions, select a sound from the Sound list.
5.If a sound is selected, the Loop until next sound option becomes active.
Select this option to play the sound repeatedly until another sound starts.
If there are no subsequent sounds in your slide show, the selected sound
will play continuously for the remainder of the show.
6.Select how to advance to the next slide: manually (On mouse click)
or automatically (Automatically after). If you select an automatic advance,
you can specify how long the slide remains visible before it automatically
advances to the next slide.
7.If you want the transition to apply to all slides, click Apply to All Slides.
If the Automatic preview checkbox is marked, the effect of a selected
transition is immediately displayed in the work area. You can replay the
effect at any time by clicking Play

Removing transition
remove a slide transition:
1. Select the slides from where you want to remove the transitions.
2. Select None transition in the Slide Transition pane.

Applying animation effect

Select the slide and the object (text box, image) you want to apply the
animation effect to.
In the Sidebar, select Custom Animation icon to open the Custom An-
imation section.
Click Add to open the Custom Animation dialog

Select the animation effect types from one of the tabbed pages on the
Custom Animation dialog. More than one type of animation effect can be
applied to an object.
As you add animation to objects they appear on the Custom Anima-
tion list in the Sidebar.
Using the buttons you can add, delete, edit or move animations.

In the Effect Plus section you can set how the animation will start
 On click − the animation does not start until you click the mouse.
 With previous − the animation runs at the same time as the previous
animation.
 After previous − the animation runs as soon as the previous anima-
tion ends.
Select the Duration of the animation effect from the Speed drop down
list.
If required, select Automatic preview so you can check the animation ef-
fect on the object.