IT 2 Flashcards
Steps to start LibreOffice Calc
- The first thing you need to ensure is that
LibreOffice must be installed on your computer. - Type LibreOffice Calc in the search bar
of Windows. - Select LibreOffice Calc from the search results
- You can start typing and entering data as soon as
you open the spreadsheet.
Steps to enter data
- Click on the cell where you want to enter data.
- Type text or number.
- The cursor is set on the next cell, in this case A2.
- Notice that data in the cell will automatically
(by default) be left aligned
If you enter numbers, they are right
aligned in the cell. - You can enter a formula in a cell by starting
with ‘=’ equal-to symbol
There are three main type of data
text, numbers
and formula
Editing data in a cell
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.
Deleting data in a cell
- Click on the cell.
- Press Delete key on the keyboard.
This deletes the text entry of that
cell making it blank.
Selecting multiple cells
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
Saving the spreadsheet in various formats
Click File,
and then, Save
Save As dialog box.
file name and click Save.
The default Save as type
Opening a spreadsheet
Click File, and then, select Open.
Printing the spreadsheet
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
Using mouse to select values in a formula
- Type ‘=’ in the cell where you
want to calculate the total. - Click the cell, which has English marks for
Rohit. B2 will appear in the formula. - Type ‘+’.
- Click the cell, which has maths marks for Rohit.
C2 will appear in the formula. - Type ‘+’.
- Click the cell (D2), which has science marks
for Rohit. - Press Enter.
formatting
Electronic spreadsheets have many options to make
your content look neat and and easy to read. This is
called ‘formatting’.
Tool Bar
You can use the given icons on the
Tool Bar to align the text.
sorting
This sorting or arrangement
of words in order can help one find a particular word or
name easily.
The steps to sort data are as follows
- Select all rows and columns that have to be sorted.
- Click on Data, and then, select Sort
- 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. - Click on OK.
filter
- Click on the
the Tool Bar.
AutoFilter icon on - This will put filters at the top of each
column - Click on the filter for ‘class’ column.
- The drop-down will show a list of all
the values in that column - By default, all values are checked or
selected.
Protecting spreadsheet with password
- Click on Tools and select
Protect Spreadsheet - A Protect Document
- Type in a password.
- Type the same password in the
Confirm textbox. - Click on OK.
- 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.
Another way of protecting a spreadsheet is
as follows
- Click on File, and then, Save As.
- A Save As dialog box will appear
- Type the file name and click Save with password.
- Click on Save.
- A Set Password dialog box
- Type a password in the first
textbox, and then, type the
same password in the
Confirm textbox. - Click on OK.
- Now, when you try to open
the file, it will ask for a
password. - Type the password and
click on OK.
Steps to save a presentation
- Click on File.
- Select Save As or Save from
the drop-down. - You can select a folder where
you want to save the file, for
example Desktop. - By default, the File name is ‘Untitled#’ (# is
a number). You can change it to the name of
your choice. - 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. - Click on Save.
Steps to close a presentation
- Click on File.
- Select Close from the drop-down
Steps to open a presentation
- Open LibreOffice Impress.
- Click on File.
- Then, select Open from the
drop-down. - This will display the Open dialog box
- Browse and select the folder
where your file is saved, for
example Desktop.
Steps to print a presentation
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.
- Click on File.
- Select Print from the drop-down or you can press
Ctrl+p on the keyboard. - A Print dialog box is displayed.
- A printer attached to the computer is displayed
in the dialog box. - Select the number of copies you want to print.
- Select All, if you want to print all slides.
- Select Slides, if you want to print few of them and
provide the slide numbers. - Click on OK
To add a new slide, do the following
- Click on Slide.
- Select New Slide from the
drop-down as shown in Figure 3.43. - You can also press Ctrl+M on
the keyboard. - This will add a blank New Slide to
the presentation. - The layout or arrangement of
textboxes, etc., will be similar to
the previous one.
The steps to delete a slide are as follows.
- Select the slide that you want
to delete. - Click on Slide.
- Select Delete Slide from the
drop-down - The selected slide will be deleted.
- You can press ‘Del’ key on the keyboard to delete
the selected slide
Adding and formatting text
Insert>Textbox
Click on the Font Style drop-down
to select a different style.
Font Size
You can also change the size of the text by clicking
on the Font Size
Inserting shapes in
presentation
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.
Inserting clipart and images in presentation
- Click on Insert from the menu.
- Select Image as shown in
Figure 3.51. - An Insert Image dialog box
- Browse through folders and
select the image you want to use - Click on Open.