Objective:

• learn how to perform operations on creating and formatting tables in a document; table data processing operations: sorting, calculation;
• learn to create tabular model based on a text description and implement it in a text editor environment.

Required software: installation and setting the necessary software parameters Windows, MS Office.

Exercise 1.

1. Create a table in a new document with the specified formatting (see Table 1).
2. Save the document under your last name, indicating the number of the practical work. For example, Ivanov_work3.

Table 1

Quest key:

1. Insert a table using the command Insert-Table, having previously determined the number of columns - 6, rows - 9.
2. Set column width: 1-4.5cm, 2-5-1.8cm, 6-2.4cm.
To do this, use the command Table properties from context menu selected column. Another way to set column widths is to drag the column border with LMB while holding down the ALT key. In this case, the ruler displays the width of the table columns in centimeters.

3. Frame the table using the command Borders and shading from the context menu, having previously selected the entire table (see Figure 1).

Picture 1

Having done the above operations, we got the table:

Figure 2

4. Combine cells 2-3, 4-5, 1 and 7, 6 and 12 in pairs. To do this, select a pair of cells and run the command Merge Cells from the context menu.
5. Enter the table text.
6. Format the text of the table according to the sample Table 1. For the cells of the table header (rows 1-2), align to the center and in the middle of the cell. To do this, run the context menu command Cell alignment(Figure 3).

Figure 3

7. Compare the table you received with the sample Table 1.

Task 2. Sort the table by sorting the rows by country area in ascending order.

Quest key:

To perform sorting, you need:

Figure 4

Note that the rows in the table are rearranged according to the sort parameter.

Task 3. Create a table and evaluate expressions according to the algorithm below.

In this example, you want to sum the values ​​in a table. For convenience, add a row and column for numbering. You will need to insert formulas into empty cells the last column (column G) and bottom line(line 6) to calculate the totals across rows and columns. In column G, the sums of numbers for each month will be located, and in line 6 - the sums for each of the regions.
In the lower right corner (cell G6), you need to insert a field that calculates the total result for the quarter for all regions.

	2 quarter

To calculate a total that sums numbers across multiple rows, insert a formula field that contains the sum function and one of the four special cell references. In our example, we need links LEFT and ABOVE( a reference to the cells located to the left of the cell containing this formula and a reference to the cells located above the cell containing this formula) .

1. Place the insertion point in the last cell of the second row (cell G2) and enter "Monthly Totals" as the heading of the last column of the table.
2. Go to cell G3.
3. Run the command Layout-formula and enter the formula =SUM(LEFT).

Figure 5

The table should then look like this:

table 2

4. Go to cell G4 and enter the formula =SUM(LEFT).
5. Enter the formulas in cell G5 in the same way.
6. Place the insertion point in the last cell of the second column (cell B6) and enter Regional Totals as the title of this row.
7. In cell C6, enter a formula that calculates the sum of the results for three months for this region. In our case, we need to use the expression =SUM(ABOVE).
8. Similarly, set formulas for cells D6-F6.
9. In cell G6, you can insert either the expression =SUM(ABOVE), which calculates the sum of monthly totals, or the expression =SUM(LEFT), which calculates the sum by region (the result will be the same). The finished table should look like this:

Table 3

Task 4.

Costs for planting 1 hectare of orchards and berry fields
in the central regions of Russia in 1980
Remuneration for planting gooseberries - 167 rubles.
Fuel, pesticides and herbicides for planting strawberries - 116 rubles.
Fertilizers for planting blackcurrant - 585 rubles.
Material for trellis when planting raspberries - 780 rubles.
Fuel, pesticides and herbicides for planting blackcurrant - 90 rubles.
Planting material for planting strawberries - 1750 rubles.
Remuneration for planting blackcurrant - 150 rubles.
Fertilizers for planting raspberries - 532 rubles.
Fertilizers for planting gooseberries - 555 rubles.
Fuel, pesticides and herbicides for planting raspberries - 89 rubles.
Planting material for planting gooseberries - 594 rubles.
Other expenses for planting strawberries - 584 rubles.
Remuneration for planting raspberries - 235 rubles.
Fuel, pesticides and herbicides for planting gooseberries - 92 rubles.
Fertilizers for planting strawberries -313 rubles.
Other expenses for planting blackcurrant -- "260 rubles.
Planting material for planting raspberries - 1200 rubles.
Salary for planting strawberries - 316 rub.
Other expenses for planting gooseberries - 388 rubles.
Planting material for planting blackcurrant - 1100 rubles.
Other expenses for planting raspberries - 474 rubles.

Task 5. Perform calculations and sorting:

1. Using the Planting Costs table, calculate the total amount of material costs for each crop
2. Based on the Landing Costs table, sort on the Total Costs column in ascending order.

Task 6. Create a table using the following data:

Production of the main types of ferrous metallurgy products in the Perm region

In 1960, 1283 thousand tons of coke were produced. In 1913, 285 thousand tons of steel were produced. In 1940, 124 thousand tons of pig iron were produced. In 1950, 772 thousand tons of rolled products were produced. In 1994, 494 thousand tons of pig iron were produced. In 1960, 1482 thousand tons of steel were produced. In 1940, 386 thousand tons of rolled products were produced. In 1992, 642 thousand tons of coke were produced. In 1950, 1027 thousand tons of steel were produced. In 1980, 523 thousand tons of coke were produced. In 1940, 428 thousand tons of steel were produced. In 1960, 1259 thousand tons of rolled products were produced. In 1970, 716 thousand tons of pig iron were produced. In 1940, 149 thousand tons of coke were produced. In 1950, 360 thousand tons of pig iron were produced. In 1913, 203 thousand tons of rolled products were produced. In 1980, 1,771 thousand tons of steel were produced. In 1994, 368 thousand tons of coke were produced. In 1960, 502 thousand tons of pig iron were produced. In 1970, 1658 thousand tons of steel were produced. In 1913, 155 thousand tons of pig iron were produced. In 1980, 1442 thousand tons of rolled products were produced. In 1992, 664 thousand tons of pig iron were produced. In 1970, 1161 thousand tons of coke were produced. In 1992, 1371 thousand tons of rolled products were produced. In 1994, 615 thousand tons of steel were produced. In 1980, 913 thousand tons of pig iron were produced. In 1970, 1358 thousand tons of rolled products were produced. In 1992, 1037 thousand tons of steel were produced.

Task 7. Perform calculations:

Using the table "Production of the main types of ferrous metallurgy products", find out how much coke, iron, steel and rolled products were produced in the years under consideration, the average amount of coke, iron, steel and rolled products produced.

Task 8. Create a table and format as shown in Figure 6:

Figure 6

Quest key:

To change the text direction, use the context menu command Text direction Figure 7.

Figure 7

Task 9. Create a table, format the table as shown in Figure 8, perform the necessary calculations:

Figure 8

Task 10. Create and format the table like this:

Figure 9

Figure 10

Task 11. Create a table, format the table as shown in Figure 11, perform the necessary calculations:

Figure 11

Task 12. Create a table using the following data:

Large reservoirs in Russia

The average depth of the Kama reservoir is 6.5 m. The area of ​​the Gorky reservoir is 1400 square meters. km. The volume of the Rybinsk reservoir is 25 cubic meters. km. The pressure of the Tsimlyansk reservoir is 26 m. The area of ​​the Bratsk reservoir is 5300 sq. km. The average depth of the Kuibyshev reservoir is 10.4 m. The volume of the Tsimlyansk reservoir is 24 cubic meters. km. The area of ​​the Rybinsk reservoir is 4650 sq. km. The volume of the Bratsk reservoir is 180 cubic meters. km. The area of ​​the Kama reservoir is 1700 sq. km. The pressure of the Kuibyshev reservoir is 28 m. The average depth of the Tsimlyansk reservoir is 9.2 m. The pressure of the Kama reservoir is 21 m. The area of ​​the Kuibyshev reservoir is 5000 sq. m. km. The pressure of the Rybinsk reservoir is 25 m. The average depth of the Bratsk reservoir is 34 m. The volume of the Kuibyshev reservoir is 52 cubic meters. km. The head of the Gorky reservoir is 18 m. The average depth of the Rybinsk reservoir is 5.5 m. The volume of the Kama reservoir is II cubic meters. km. The pressure of the Bratsk reservoir is 104 m. The area of ​​the Tsimlyansk reservoir is 2600 sq. km.

Task 13. Sort the table of task 12 by the parameter reservoir area. Arrange the data in the rows in ascending order of the area parameter.

Test your knowledge and skills:

Did you know:

• Name of table elements?
• Table creation algorithm?
• Algorithm for selecting table elements?
• How to change height and width of table elements?
• What is table framing and algorithm for its creation?
• How are cell union and cell splitting used?
• Algorithm for performing the operation sorting data in a table?
• Formula input algorithm?

Can you:

• Embed a table in a document?
• Select elements of a table?
• Change height and width of cells?
• Insert and delete table elements?
• Copy table elements?
• Frame a table?
• Change border line type?
• Merge and split cells?
• Sorting a table?
• Perform calculations in a spreadsheet?

Program Microsoft Excel- a very powerful tool, thanks to which you can create large tables with a beautiful design and an abundance of various formulas. Working with information is facilitated precisely because of the dynamics that are missing in the Word application.

This article will show you how to create a table in Excel. Thanks to step by step instructions even a “teapot” can deal with this. At first, novice users may find this difficult. But in fact, with constant work in the Excel program, you will become a professional and be able to help others.

The training plan will be simple:

• first consider various methods creating tables;
• Then we are engaged in design so that the information is as clear and understandable as possible.

This method is the simplest. This is done in the following way.

1. When you open a blank sheet, you will see a large number of identical cells.

1. Select any number of rows and columns.

1. After that, go to the "Home" tab. Click on the "Borders" icon. Then select "All".

1. Immediately after that, you will have the usual elementary plate.

Now you can start filling in the data.

There is another way to manually draw a table.

1. Click on the "Borders" icon again. But this time, select Draw Grid.

1. Immediately after that, you will change the appearance of the cursor.

1. Make a left mouse click and drag the pointer to another position. As a result, a new grid will be drawn. The upper left corner is the initial position of the cursor. The lower right corner is the end.

The sizes can be any. The table will be created until you release your finger from the mouse button.

Auto mode

If you do not want to "work with your hands", you can always use ready-made functions. To do this, do the following.

1. Go to the "Insert" tab. Click on the "Tables" button and select the last item.

Pay attention to what we are prompted about hot keys. In the future for automatic creation you can use the keyboard shortcut Ctrl + T .

1. Immediately after that, you will see a window in which you need to specify the range of the future table.

1. To do this, simply select any area - the coordinates will be substituted automatically.

1. As soon as you release the cursor, the window will return to its original form. Click on the "OK" button.

1. As a result of this, a beautiful table with alternating lines will be created.

1. To change the name of a column, just click on it. After that, you can start editing directly in this cell or in the formula bar.

pivot table

This type of information presentation serves for its generalization and subsequent analysis. To create such an element, you need to do the following steps.

1. First, we create a table and fill it with some data. How to do this is described above.

1. Now go to the main menu "Insert". Next, we choose the option we need.

1. Right after that, you will have a new window.

1. Click on the first line (the input field must be made active). Only after that we select all the cells.

1. Then click on the "OK" button.

1. As a result, you will have a new side panel where you need to set up the future table.

1. At this stage, you need to transfer the fields to the desired categories. The columns will be months, the rows will be the purpose of the costs, and the values ​​will be the amount of money.

To transfer, left-click on any field and, without releasing your finger, drag the cursor to the desired location.

Only after that (the cursor icon will change appearance) can the finger be released.

1. As a result of these actions, you will have a new beautiful table in which everything will be calculated automatically. Most importantly, new cells will appear - “Grand Total”.

You can specify the fields that are of interest for data analysis.

Sometimes it is not possible to correctly select fields for columns and rows. And in the end, nothing worthwhile comes out. For such cases, Microsoft developers have prepared their own data analysis options.

It works very simply.

1. First of all, we select the information we need.

1. After that, select the appropriate menu item.

1. As a result, the program itself will analyze the contents of the cells and offer several options.

1. By clicking on any of the proposed options and clicking on the "OK" button, everything will be created automatically.

1. In the case of the example, we got the sum of the total costs, excluding months.

Ready-made templates in Excel 2016

For the lazy ones this program allows you to create truly "cool" tables with just one click.

When you open Excel, you have the following options to choose from:

• open recent files with whom you have worked before;
• create a new empty workbook;
• see tutorial from detailed information about the capabilities of this software;
• pick one ready template default;
• continue searching on the Internet if you don’t like any of the proposed designs;
• log in under your account Microsoft.

We are interested in ready-made options. If you scroll down a bit, you will see that there are a lot of them. But these are the default templates. Imagine how many you can download them on the Internet.

Click on any option you like.

Click on the "Create" button.

As a result of this, you get a ready-made version of a very large and complex table.

Decor

Appearance is one of the most important parameters. It is very important to focus on some elements. For example, a header, title, and so on. Everything depends on the specific case.

Consider briefly the basic manipulations with cells.

Create a header

Let's use a simple table as an example.

1. First, go to the "Home" tab and click on the menu item "Insert Rows to Sheet".

1. Select the line that appears and click on the "Merge Cells" menu item.

1. Next, write any title.

Changing the Height of Elements

Our header is the same size as the header. And it's not very pretty. In addition, it looks inconspicuous. In order to fix this, you need to move the cursor to the border of lines 1 and 2. After its appearance changes, left-click and drag it down.

As a result, the row height will be larger.

Text alignment

Our title is at the bottom of the cell and stuck to the header. In order to fix this, you need to use the alignment buttons. You can change the text position both vertically and horizontally.

We click on the button "In the middle" and we get the desired result.

Now the title looks much better.

Style change

Or use predefined styles. To do this, first select the line. Then, through the menu, select any of the proposed design options.

The effect will be very beautiful.

How to insert a new row or column

In order to change the number of elements in the table, you can use the "Insert" button.

You can add:

• cells;
• lines;
• columns;
• whole sheet.

Removing elements

You can destroy a cell or something else in the same way. There is a button for this.

Filling cells

If you want to highlight any column or line, you need to use the fill tool for this.

Thanks to it, you can change the color of any cells that were previously selected.

Element Format

You can do whatever you want with the table. To do this, just click on the "Format" button.

As a result of this, you will be able to:

• manually or automatically change the height of the rows;
• manually or automatically change the width of the columns;
• hide or show cells;
• rename sheet;
• change label color;
• protect the sheet;
• block the element;
• specify the cell format.

Content Format

If you click on the last of the above items, the following will appear:

With this tool, you can:

• change the format of the displayed data;
• specify alignment;

• choose any font;

• change table borders;

• "play" with the fill;

• set protection.

Using formulas in tables

It is thanks to the ability to use the auto-calculation functions (multiplication, addition, and so on) that Microsoft Excel has become a powerful tool.

In addition, it is recommended to read the description of all functions.

Consider the simplest operation - cell multiplication.

1. First, let's prepare the field for experiments.

1. Make active the first cell in which you want to display the result.

1. Enter the following command there.

=C3*D3

1. Now press the Enter key. After that, move the cursor over the lower right corner of this cell until its appearance changes. Then hold down the left mouse click with your finger and drag down to the last line.

1. As a result of autosubstitution, the formula will fall into all cells.

The values ​​in the "Total cost" column will depend on the "Quantity" and "Cost per 1 kg" fields. That's the beauty of dynamics.

In addition, you can use ready-made functions for calculations. Let's try to calculate the sum of the last column.

1. First, select the values. Then click on the "Autosums" button, which is located on the "Home" tab.

1. As a result of this, the total sum of all numbers will appear below.

Use of graphics

Sometimes photos are used in cells instead of text. It is very easy to do this.

Select an empty element. Go to the "Insert" tab. Select the "Illustrations" section. Click on "Pictures".

1. Specify the file and click on the "Insert" button.

1. The result will not disappoint you. Looks very nice (depending on the selected pattern).

Export to Word

In order to copy data into a Word document, it is enough to do a couple of simple steps.

1. Select the data area.

1. Press the hotkeys Ctrl +C .
2. Open Document
3. Now use the buttons Ctrl + V .
4. The result will be as follows.

Online Services

For those who want to work in real mode” and share information with friends or work colleagues, there is a great tool .

Using this service, you can access your documents from any device: computer, laptop, phone or tablet.

Printing methods

printout Word documents is usually an easy task. But with tables in Excel, everything is different. The biggest problem is that "by eye" it is difficult to determine the boundaries of the print. And very often in the printer appear practically blank sheets, which contain only 1-2 rows of the table.

Such printouts are inconvenient for perception. It is much better when all the information is on one sheet and does not go anywhere beyond the borders. In this regard, developers from Microsoft have added the function of viewing documents. Let's see how to use it.

1. We open the document. He looks quite normal.

1. Next, press the hot keys Ctrl + P . In the window that appears, we see that the information does not fit on one sheet. We have lost the column "Total cost". In addition, at the bottom we are prompted that 2 pages will be used for printing.

In the 2007 version, for this you had to click on the "View" button.

1. To cancel press hot key Esc. As a result, a vertical dotted line will appear, which shows the borders of the print.

You can increase the space when printing as follows.

1. First of all, we reduce the margins. To do this, go to the "Page Layout" tab. Click on the "Fields" button and select the most "Narrow" option.

1. After that, reduce the width of the columns until the dotted line is outside the last column. How to do this was described above.

You need to reduce it within reasonable limits so that the readability of the text does not suffer.

1. Press Ctrl+P again. Now we see that the information is placed on one sheet.

Microsoft Product Version Differences

It should be understood that Excel 2003 has long been obsolete. There is missing great amount modern features and capabilities. In addition, the appearance of various objects (graphs, diagrams, and so on) is much inferior to modern requirements.

Working example Excel areas 2003.

In modern 2007, 2010, 2013, and even more so 2016 versions, everything is much “cooler”.

Many menu items are in different sections. Some of them even changed their name. For example, the “Formulas” familiar to us were called “Functions” back in 2003. And they didn't take up much space.

Now they have a whole tab dedicated to them.

Limitations and features of different versions

On the official website of Microsoft, you can find online help, which contains all specifications created books.

An example of the most basic parameters.

This list is quite long. Therefore, it is worth clicking on the link and familiarize yourself with the rest.

Please note that the 2003 version is not even considered, since its support has been discontinued.

But in some budgetary organizations this office suite is used to this day.

Conclusion

This article has reviewed various ways creating and presenting tables. Particular attention was paid to giving a beautiful appearance. You should not overdo it in this regard, since bright colors and a variety of fonts will scare away a user who is trying to familiarize himself with the contents of the table.

Video instruction

For those who have any questions, a video is attached below, which includes additional comments on the instructions described above.

Images - these are graphic objects executed by third-party software. They are inserted into the document by linking or embedding on command. Insert + Picture + From file (detailed in Section 2).

4.18.2.1. Interaction of image with text. The main part of the tools for adjusting the image in a text document is located on the toolbar called by the command View + Panel tools + Setting Images .

According to the way of interaction with the text, two types of images are distinguished: embedded in a line and free. Images of the first type can be conditionally considered as separate characters: when text moves during editing, the image moves with it. The position of the free image on the page is not related to text input. It interacts with the text through wrapping.

To control how the image interacts with text, use the tab Position in the dialog box Format drawing , which is opened by the command Format +Picture or button Format drawing on the panel Setting Images . Control element AT text ensures that an image is embedded in a text string. Other elements serve to select wrapping methods.

If the image is inserted into the document as a free image, additional wrapping tools can be obtained by clicking the button wrap around text on the panel Setting Images . Paragraph Change circuit allows you to create curved contours.

4.18.2.2. Image editing. The internal image editing tool has relatively few capabilities. Using it does not change the original, but changes the way it is displayed in the document. On the toolbar Setting Images configuration tools are represented by the following buttons:

increase contrast , decrease contrast ;

increase anddecrease brightness segment ;

install transparent color .

4.19 Working with tables

Table - this is information ordered in rows and columns, intersecting, columns and rows form cells. Information is placed in the cells of tables: text, numbers, graphics, drawings, formulas.

Table cells have addresses formed by the column name (A, B, C, ...) and the row number (1, 2, 3, ...). Cells in a row are labeled from left to right, starting with column A.

4.19.1. Creating tables

Method 1. To place a table in a document, execute the menu command Table +Add table . A dialog box will appear Insert tables , where you enter the number of columns and the number of rows. In field Width column the default setting is Auto , and the width of all columns will be the same.

If the panel has a button Master , then Master tables by using dialog boxes allows you to quickly create a standard structure.

To decorate the table with a frame and format it, you can use the button Auto Format .

Button click OK inserts the table at the location in the document where the text cursor is.

Method 2. You can create a table using the button Add table on the standard toolbar. After clicking on the button, an auxiliary table appears next to it. Dragging the mouse button over rows and columns determines the size of the table. After releasing the mouse button, the table will be inserted into the text at the cursor position.

Part 1. Working with the book

1. Create book for subsequent execution on its sheets of all practical work. Name this book Educational_Surname I.O., where instead of Surname I.O. enter your last name. Save this book in your folder.

2. Assign Sheet 1 name Cells. Select cell A1. Use the scroll bars to find cell P37 and make it active. Activate cell A1, ( ctrl+home).

3. Selection of sheet areas:

· Select area A1:D9 with the mouse.

· Select column of sheet B (by clicking on the column heading).

· Select any five columns of the worksheet in a row.

· Select five even lines on the sheet.

· Select the area B6:D8, (use the keys Shift and Arrows).

4. Paste into the workbook a new sheet and give it a name Formats.

5. Customize active cell transition when entering data to the right.

6. Change column width :

Enter in cell B2 of the sheet Formats word World, and in cell C2 the word Organization.

· 1st way. Move the mouse pointer over the line separating the headings of columns B and C and double-click.

· 2nd way. Move the mouse pointer to the right border of the column heading (for example, C) and drag this border to the right or left until the desired size of the column is given.

· 3rd way.

Ø Select five columns of the sheet at the same time in a row, starting with column D.

Ø Right-click on the selected area and in the KM execute the command Column Width. Set the column width to 2.5 characters.

· Line height is set in the same way: Format - Line - Height…”, or by dragging the line separation lines.

7. Save changes to the workbook.

Part 2: Create a table

8. Filling the table with data :

Insert a new sheet into the workbook and name it Table 3.1.

· Select area A1:D9 of this sheet and set it border type All borders.

in cells A1:D1 enter the column headings of the sample table.

Place the entered headings in the center of your cells: ( Format - Cells - Alignment - Center, Horizontal - Center, Vertical).

Insert into cell D1 Note « CEO's order», ( Insert - Note).

Enter the date in cell A2 27.01.2007 , do not put a dot after the date !!!

· Set the entered number date format . (Format - Cells - Number). In field Numeric formats choose the date- in field Type of select sample date: DD.MM.YY, OK. Try other date formats as well, but leave DD.MM.YY.

Make cell A2 active and using autocomplete marker , drag and drop to enter data in the first column of the table.

Filling in the column Name of product”, pay attention to the possibility of autocomplete. You can agree with him or not.

Fill in the column " Customer Index". Note that the numbers in the cell are pressed to the right edge of the cell, and the text to the left. Set the entered data text format .

Fill in the column " Volume of sales". Set the entered data number format .

· Set column B to 20 characters wide, and columns C and D to 15 characters each (see step 6).

· Change the contents of cell D7 to 10057.

9. Copying cells, tables

Select area A1: D9 and copy it to BO (book. Copy).

Make cell G1 active and click the button Insert. The copied area is placed in the G1:J9 area. Note that cell widths are not copied.

Insert a new sheet into the workbook and give it a name Ice cream. Place the copied table on this sheet as well. For this on the sheet Ice cream do active cell A1 and click on the button. Insert.

・Return to sheet Table 3.1, select the copy of the main table and delete it.

· Cell cleaning : Activate sheet Ice cream, select cells A1:A10 on it. Execute " Edit - Clear - All". Restore A1:A10 by canceling the previous command (button Cancel).

Part 3: Table Formatting

10. Entering text in a cell on multiple lines.

1st way(only when typing).

Enter text more than 9 characters in a cell (for example, Unit price).

2nd way. (The text in the cell is already fixed).

Select such a cell.

Execute and check the box Move by word.

11. Font style:

Enter the sheet " Ice cream”, highlight A1:D1. click on the button " Bold».

Place the table column headings in the center of the field and in several lines ( Format - Cells - Alignment).

12. Entering and formatting headings above a table .

Insert three empty lines for headings above the table, to do this, select on the sheet Ice cream lines 1, 2 and 3.

・Complete "Insert - Rows". 3 lines will be added at the top.

Enter cell A1 and enter the text " Preliminary sales analysis».

Select area A1:D1 and click on the button Merge and center.

· For the created header, execute " Format-Cells”, and from the tab “ Font» set the table header font format: « Bold», « The size»-14, font color is blue.

· In cell A2 and enter the text "1st quarter of 2004" and merge this cell with three adjacent cells on the right.

New heading format: " Bold italic», « The size»-12, font color is red.

13. Setting and copying formats and styles :

In cell D5, set the monetary format (you can click on the button " Money format "). Fit the required width to column D if the number has become lattice

· , Press the button Decrease bit depth”, make the numbers integers.

Highlight D5 and click on the " Sample Format. A brush appeared next to the mouse pointer.

· Drag the mouse pointer with the brush over the area D6:D12 and release the mouse button.

· Save your work.

Part 4. Additional tasks

1. Create a table Schedule of duty .

Make borders for individual table fields (Format - Cells - Border) and fill them with different colors (Format - Cells - View).

Task 4.1. Entering characters

1. Enter using the keyboard:

   Letters of the Russian alphabet: Aa Bb Cv Gg Dd Her Yoyo Zhzh Zz Ii Yy Kk Ll Mm Nn ​​Oo Pp Rr Ss Tt Uu Ff Xx Ts Chh Sh Sh Shch b Yy b b Ee Yuyu Yaya

   Letters of the English alphabet: Аа Bb Сс Dd Her Ff Gg Hh li Jj Kk LI Mm Nn ​​Oo Pp Qq Rr Ss Tt Uu VvWwXxYy Zz

Alphabet decimal system reckoning: 01 23456789

Roman numeral alphabet: 1(1) V(5) X(10) L(50) C(YO) D(500)M(1000)

Special characters (Russian keyboard layout): ! " No ; %:?*()_+/-=\

Special characters (English keyboard layout): ! @ # $ % l & * () _ + | -=\

Custom text about yourself (name, age, class, etc.)

1. Save the file in your personal folder as Symbols.rtf.

Task 4.2. Text entry rules

1. Launch the word processor installed on your computer.
2. Enter text:

   When entering text, adjacent words are separated by a single space. Punctuation marks (comma, colon, period, exclamation and question marks) are written together with the preceding word and separated by a space from the next word.

   Quotation marks and brackets are written together with the corresponding words.

   A dash is separated by spaces on both sides.

   The hyphen is written together with the words it connects.

3. Enter the text, paying attention to the following rules:

   The topic is “Text Entry Rules”, the Malachite Hotel, Alyonka chocolate, the novel “War and Peace”.

   Stages of creation text document: input, editing, formatting.

   Information during world wide web organized in the form of pages (Web pages).

   Still, Mamin-Sibiryak, firebird, northeast, Rostov-on-Don, New York. Willy-nilly, I had to stay here for the night. To be afraid of grief is not to see happiness. Moscow is a huge city, a city-country. The end of the 17th century - the first half of the 19th century.

4. Save the file in your personal folder as Input Rules.rtf.

Task 4.3. Inserting symbols

1. AT word processor open file Insert.rtf:

   Prsnlny kmpyutr: sstmny blk (mtrnsk plt, tsntrlny prtssr, prtvn pmt, hard deck), external strstv, clvtr, mouse, mntr, prntr, kstchsk klnk).

2. AT right places insert letters denoting vowel sounds so that you get the names of personal computer devices.

Task 4.4. Character substitution

1. In a word processor, open the 3amena.rtf file:

   K*litka, k*morka, k*vychka, k*bluk, b*grovy, f*thunder, s*tira, ur*gan, *kv*lang, n*v*zhenie, sr*zhenie.

2. Replace the "*" characters with the letters "a" or "o" so that the words are spelled correctly.
3. Save the file in your personal folder as Words.rtf.

Task 4.5. Automatic replacement

1. In a word processor, open the 100.rtf file:

   At the pro100th Yuorozha
   Non-pro100 house:
   Often there are 100 legs in it
   Wanders under 100 scrap.
   Cherishes 100 leg
   Chi100 feet
   And 100 personal polish
   Cleans 100 boots.

2. For greater expressiveness, the author of the poem, L. Kondratenko, “inserted” numbers inside the words. See how this poem will look after replacing "100" with "one hundred" (use the replace operation).
3. Save the modified document in your personal folder as CTO.rtf.

Task 4.6. Deleting Fragments

1. In a word processor, open the Delete.rtf file:

   Keyboard, joystick, scanner, printer.

   Monitor, plotter, printer, mouse.

   Hard disk, flash memory, CD, processor.

   Printer, acoustic speakers, headphones, microphone. System unit, CPU, RAM, HDD, power unit.

   System unit, keyboard, mouse, monitor, speakers.

   video card, expansion card, sound card, Network Card. Enter, End, Esc, Delete.

   Color printer, laser printer, matrix printer, jet printer.

2. In each group, find an extra word (phrase) and delete it.
3. Save the file in your personal folder under the name No_too.rtf.

Task 4.7. Moving Fragments

1. In a word processor, open the Move.rtf file:

   CPU-
   RAM-
   HDD-
   videocard-
   soundcard-

   RAM, CPU, video card, hard drive, sound card.

2. Create pairs by placing a Russian equivalent next to each English term.
3. Save the file in your personal folder as Pairs.rtf.

Task 4.8. Copying fragments

1. Using copy and paste operations, type the text of the poem in English:

   Meet me in the morning.
   Meet me at noon.
   Meet me in September
   Or the middle of June.
   Meet me at midnight.
   Meet me in the hall.
   Meet me in the summer.
   Meet me in the fall.
   Meet me in the evening.
   Meet me at eight.
   I'll meet you anytime you want
   But, please, don't be late.

2. Save the file in your personal folder as Verse.rtf.

Task 4.9. Gluing and cutting strings

1. In a word processor, open the Strings.rtf file:

   You can't hide an awl in a bag. Every day is not Sunday. Finished the job - walk boldly. Prepare the sleigh in summer and the cart in winter. Steam doesn't break bones. Without effort, you can not catch a fish from a pond. Not all that glitters is gold. Word is silver, silence is gold. The earlier you get up, the earlier you finish your work. Do not count your chickens before they are hatched. Business - time, fun - hour. Think first, then start. Try on seven times, cut once. Work is terrible not to the hands, but to the eyes. The work of the master is afraid.

2. Edit the contents of the file so that each proverb takes up exactly one line.
3. Save the file in your personal folder as Proverbs.rtf.

Task 4.10. Change the size and font of characters

1. In a word processor, create new file and save it in your personal folder as Fontl.rtf.
2. Type the phrase "I'm learning a word processor." Make nine copies of this phrase, placing each one on a new line.
3. Set the first two lines to 12 point font, Times New Roman font.

   For the second pair of lines: font size 14 points, font type Courier New.

   For the third pair of lines: font size 16 points, font type Comic Sans MS.

   For the fourth pair of lines: font size 18 points, font type Tahoma.

   For the fifth pair of lines: font size 20 points, font type Arial.

4. Close the Font1.H^ file, saving the changes.

Task 4.11. Changing the color of characters

1. In a word processor, open the Color.rtf file.
2. Perform text formatting as described below:
   • for the title, set the font size to 16 points, the font color is red;
   • for color names, set the font color corresponding to them, style - bold, size - 14 points;
   • for color descriptions, set the style to italic and the font size to 12 pt.

1. In a word processor, create a new file and save it in your personal folder as Indexes.rtf.
2. Select Arial font type, font size 14, italic style.
3. Type the following text:

   Units for measuring the amount of information:
   1 byte = 8 bits 1 kilobyte = 210 bytes
   1 Megabyte = 210 KB = 220 bytes 1 GB = 210 MB = 220 KB = 230 bytes

4. Save the changes to the file and close it.

Task 4.13. Character Formatting Options

1. In a word processor, open the Effects.rtf file.
2. Change the character format as shown:

   There are many possibilities for character formatting.

   You can change the font(Apa1) and the font size(24), you can change the style of the font, for example, use bold, italic, or bold italic. Available additional features, such as single underline, underline only words, double underline, dashed underline. Text can also be struck out, superscripted or subscripted, moved up or down, written in small caps, or simply in all caps. Text can be condensed (by 1.4 pt) or sparse (by 1.8 pt). The font color can be different, for example red. The text can be hidden, i.e. not printed or displayed on the screen.

3. Save the file with changes in your personal folder and close it.

Task 4.14. Underline Options

Task 4.15. Paragraph formatting

Task 4.16. Paragraph formatting

Task 4.17. Insert special characters and formulas

Task 4.18. Creating lists

1. In a word processor, create a new document.
2. Create multilevel list"Devices of a modern computer":

   1. Processor
   2. Memory

   
   2.1. Inner memory
   2.2. External memory
   
   2.2.1. HDD
   2.2.2. Diskette
   2.2.3. Flash memory
   2.2.4. Optical discs
   
   2.2.4.1. CD
   2.2.4.2. DVD
   3. Input devices
   3.1. Keyboard
   3.2. Mouse
   3.3. Scanner
   3.4. Graphics tablet
   3.5. Digital camera
   3.6. Microphone
   3.7. Joystick
   4. Output devices
   
   4.1. Monitor
   
   4.1.1. LCD Monitor
   4.1.2. CRT Monitor
   4.2. Printer
   
   4.2.1. Matrix printer
   4.2.2. Jet printer
   4.2.3. Laser printer
   4.3. Acoustic speakers
3. Save the file in your personal folder as Devices.rtf.
4. Reformat the list by putting bullets instead of numbers. Possible variant layout is shown below:
   • CPU
   • Memory
     • Inner memory
     • External memory
       • HDD
       • Diskette
       • Flash memory
       • Optical discs
5. Save the file in your personal folder as Devices2.rtf and close it.

Task 4.19, Creating tables

Task 4.20. Creating diagrams

Task 4.21. Inserting pictures

Final work: preparation of the essay "History of the development of computer technology"