2.2 Tasks for Independent Work

1. Start the application Libreoffice.Witer. Create new document and type two paragraphs from first laboratory work.

2. Select second paragraph and change font and size of it.

3. Save this document in your folder.

4. Add to document the table 3.2 from third laboratory work.

5. Add to document formulas according your variant from third laboratory work.

6. Add to document picture you create in first laboratory work.

7. Save document with other name in your directory.

2.3 Test Questions

1. Enumerate main functions of word processors.

2. How to align text?

3. How to check spell in your document?

4. How to add pages numbering to document?

5. How to add tables to document?

6. What information are usually placed in headers and in footers?

7. How to arrange text in two columns?

8. What parameters can you change in menu item File/Page Parameters?

9. How to move part of text to another place?

10. How to replace one word to another in all text?

11. What typefaces do you know? How to select typeface?

3 Laboratory work № 3

Introduction to the calc spreadsheet

3.1 The Basic Opportunities of Spreadsheets

3.1.1 Calc’s Environment

A spreadsheet is a grid divided into rows that run across the spreadsheet from left to right, and columns that run from top to bottom. The leftmost column is often used for descriptive labels that identify the name of the information that is stored in each of the cells in any particular row in the spreadsheet.

Fig. 3.1 Think of the spreadsheet as a grid divided into rows and columns

The Calc screen is thus a window onto a large grid of rows and columns into each cell of which data are entered, usually from the keyboard. You can build formulas into selected cells which automatically carry out calculations on designated sets of data. The spreadsheet is most used for business accounting and data analysis.

• Menu Bar – displays the commands you use to work with Calc.

• ToolBars – provide quick access to commonly used commands. You can see on Fig. 3.1 two toolbars: Standard and Format. Additional toolbars can be toggled on or off from the Toolbars command on the View menu.

• Data Entry Bar – displays the data or the formula that is stored in active cell.

• Spreadsheet – the main window in Calc. It consists from cells. You can store data in cells. Every cell has address – letter of the column and number of the line, for example, A1, D4.

• Shortcuts of Sheets – are used to select sheet you work with. The names of sheets by default are Sheet1, Sheet2, … You can change it by double click on shortcut of sheet and type new name.

• Status Bar – displays the mode of operations of Calc. Usually you see mode Ready.

Figure 3.2 - Calc’s window

Calc creates files with extension .ods , these files are called documents and are received names Untitled1, Untitled 2, … by default. Every document consists from sheets, it may be worksheets, diagram sheets and so on. You can add new sheet using menu Insert/Sheet (Вставка/Лист), and you can delete sheet using menu Edit/Delete sheet (Правка/Удалить лист).A cell is where information, in the form of either a label, or a number, or a formula for calculation, will be entered.

• Labels are where you use text to describe the data in the columns and rows.

• Numbers are just that—numbers, as in mathematics. Numbers are what spreadsheets are all about.

• Formulas (and Functions) are mathematical expressions built into certain cells that instruct the spreadsheet to carry out calculations on specified sets of numbers in the rows and columns.

Each cell (a location in the spreadsheet) has an address which begins with a letter to indicate the column, followed by a number to indicate the row. For example, G6 identifies the cell at the intersection of column G, row 6.