IT 2

Question 1

Steps to start LibreOffice Calc

Answer 1

1. The first thing you need to ensure is that
   LibreOffice must be installed on your computer.
2. Type LibreOffice Calc in the search bar
   of Windows.
3. Select LibreOffice Calc from the search results
4. You can start typing and entering data as soon as
   you open the spreadsheet.

Question 2

Steps to enter data

Answer 2

1. Click on the cell where you want to enter data.
2. Type text or number.
3. The cursor is set on the next cell, in this case A2.
4. Notice that data in the cell will automatically
   (by default) be left aligned
   If you enter numbers, they are right
   aligned in the cell.
5. You can enter a formula in a cell by starting
   with ‘=’ equal-to symbol

Question 3

There are three main type of data

Answer 3

text, numbers
and formula

Question 4

Editing data in a cell

Answer 4

Method 1
1. Double click on the cell you want to edit.
Then, type additional text in the cell or in the
Formula Bar.
2. Press Enter.
Method 2
1. Click on the cell you want to edit.
2. Correct the text in the Formula Bar.
3. Press Enter
Method 3
1. Click on the cell.
2. Type the new text.
3. Press Enter.

Question 5

Deleting data in a cell

Answer 5

1. Click on the cell.
2. Press Delete key on the keyboard.
   This deletes the text entry of that
   cell making it blank.

Question 6

Selecting multiple cells

Answer 6

After selecting multiple cells, a function
will be performed on the cells that are selected. When
a single cell is selected it is called active cell. When a
number of cells is selected, it is called cell range

Question 7

Saving the spreadsheet in various formats

Answer 7

Click File,
and then, Save
Save As dialog box.
file name and click Save.
The default Save as type

Question 8

Opening a spreadsheet

Answer 8

Click File, and then, select Open.

Question 9

Printing the spreadsheet

Answer 9

you can click File, and
then, select Print from the drop-down or press
Ctrl+P.
A Print dialog box appears. Select the
printer, range of pages and number of copies
to be printed, and click OK

Question 10

Using mouse to select values in a formula

Answer 10

1. Type ‘=’ in the cell where you
   want to calculate the total.
2. Click the cell, which has English marks for
   Rohit. B2 will appear in the formula.
3. Type ‘+’.
4. Click the cell, which has maths marks for Rohit.
   C2 will appear in the formula.
5. Type ‘+’.
6. Click the cell (D2), which has science marks
   for Rohit.
7. Press Enter.

Question 11

formatting

Answer 11

Electronic spreadsheets have many options to make
your content look neat and and easy to read. This is
called ‘formatting’.

Question 12

Tool Bar

Answer 12

You can use the given icons on the
Tool Bar to align the text.

Question 13

sorting

Answer 13

This sorting or arrangement
of words in order can help one find a particular word or
name easily.

Question 14

The steps to sort data are as follows

Answer 14

1. Select all rows and columns that have to be sorted.
2. Click on Data, and then, select Sort
3. This will give a Sort dialog box as
   shown in Click on Sort
   Key 1 and select total from the
   drop-down. By default the order is
   Ascending, which means from the
   lowest to the highest. We will change
   it to Descending. This will sort the
   data in the total field.
4. Click on OK.

Question 15

filter

Answer 15

1. Click on the
   the Tool Bar.
   AutoFilter icon on
2. This will put filters at the top of each
   column
3. Click on the filter for ‘class’ column.
4. The drop-down will show a list of all
   the values in that column
5. By default, all values are checked or
   selected.

Question 16

Protecting spreadsheet with password

Answer 16

1. Click on Tools and select
   Protect Spreadsheet
2. A Protect Document
3. Type in a password.
4. Type the same password in the
   Confirm textbox.
5. Click on OK.
6. Now, when you close the file and open
   it again, it will ask for the password.
   Remember this password so that you can
   open the file.

Question 17

Another way of protecting a spreadsheet is
as follows

Answer 17

1. Click on File, and then, Save As.
2. A Save As dialog box will appear
3. Type the file name and click Save with password.
4. Click on Save.
5. A Set Password dialog box
6. Type a password in the first
   textbox, and then, type the
   same password in the
   Confirm textbox.
7. Click on OK.
8. Now, when you try to open
   the file, it will ask for a
   password.
9. Type the password and
   click on OK.

Question 18

Steps to save a presentation

Answer 18

1. Click on File.
2. Select Save As or Save from
   the drop-down.
3. You can select a folder where
   you want to save the file, for
   example Desktop.
4. By default, the File name is ‘Untitled#’ (# is
   a number). You can change it to the name of
   your choice.
5. The default Save As type is .ods. You can select
   other file types from the Save As type drop-down.
   You can save the file as MS Excel or HTML or
   text file.
6. Click on Save.

Question 19

Steps to close a presentation

Answer 19

1. Click on File.
2. Select Close from the drop-down

Question 20

Steps to open a presentation

Answer 20

1. Open LibreOffice Impress.
2. Click on File.
3. Then, select Open from the
   drop-down.
4. This will display the Open dialog box
5. Browse and select the folder
   where your file is saved, for
   example Desktop.

Question 21

Steps to print a presentation

Answer 21

Before you try to print a file, please make sure that a
printer is connected to the computer. The steps to print
a presentation are as follows.

1. Click on File.
2. Select Print from the drop-down or you can press
   Ctrl+p on the keyboard.
3. A Print dialog box is displayed.
4. A printer attached to the computer is displayed
   in the dialog box.
5. Select the number of copies you want to print.
6. Select All, if you want to print all slides.
7. Select Slides, if you want to print few of them and
   provide the slide numbers.
8. Click on OK

Question 22

To add a new slide, do the following

Answer 22

1. Click on Slide.
2. Select New Slide from the
   drop-down as shown in Figure 3.43.
3. You can also press Ctrl+M on
   the keyboard.
4. This will add a blank New Slide to
   the presentation.
5. The layout or arrangement of
   textboxes, etc., will be similar to
   the previous one.

Question 23

The steps to delete a slide are as follows.

Answer 23

1. Select the slide that you want
   to delete.
2. Click on Slide.
3. Select Delete Slide from the
   drop-down
4. The selected slide will be deleted.
5. You can press ‘Del’ key on the keyboard to delete
   the selected slide

Question 24

Adding and formatting text

Answer 24

Insert>Textbox
Click on the Font Style drop-down
to select a different style.

Question 25

Font Size

Answer 25

You can also change the size of the text by clicking on the Font Size

Question 26

Inserting shapes in presentation

Answer 26

to insert an arrow, you must click on Insert, and then, select Shape. This has several options. Choose Arrow to see different types of arrow. Select the one required for the presentation, for example, ‘Circular Arrow’. Once a shape is inserted in a slide, you can use the Properties tab to make changes to the properties of the shape, such as colour, size, position, direction, etc.

Question 27

Inserting clipart and images in presentation

Answer 27

1. Click on Insert from the menu. 2. Select Image as shown in Figure 3.51. 3. An Insert Image dialog box 4. Browse through folders and select the image you want to use 5. Click on Open.