Note that you are saving the document with the same name that you set earlier when you created it.

Independent work

Exercise: Calculate, using ET, will 130 rubles be enough for you to buy all the groceries that your mother ordered for you, and will it be enough to buy chips for 25 rubles?

No. Name Price in rubles Quantity Price
Bread 9.6 =C2*D2
Coffee 2.5 =С3*D3
Milk 13.8 =С4*D4
Dumplings 51.3 =С5*D5
Chips =C6*D6

Exercise technology:
o In cell A1, enter “No.”
o In cells A2, A3, A4, A5, A6, A7, A8, enter “1”, “2”, “3”, “4”, “5”
o In cell B1, enter “Name”
o In cell C1, enter “Price in rubles”
o In cell D1 enter “Quantity”
o In cell E1, enter “Cost”, etc.
o In the “Cost” column, all formulas are written in English!
o In formulas, instead of variables, cell names are written.
o After pressing Enter instead of the formula, a number immediately appears – the result of the calculation

After doing the work, we get:

No. Name Price in rubles Quantity Price
Bread 9.6 19.2
Coffee 2.5 12.5
Milk 13.8 27.6
Dumplings 51.3 51.3
Chips
Total 135.6

Answer: 130 rubles is not enough for chips.

Workshop No. 3
“Selection of areas in a spreadsheet MS Excel 2003”

By completing this topic, you will learn:

Select cells, rows, columns, blocks and sheets.

Task: To get acquainted practically with the methods of selecting the main elements of MS Excel 2003.

Task execution technology:

1. Create a new document (workbook) and save it in your folder as a file named Table (command File – Save as) .

2. Try different ways to highlight sections of your spreadsheet.

Attention! Ways to select fragments of a spreadsheet:

No. Select object Operation technique Exercise
Cell Click on a cell Highlight cell C21
Line Click on the corresponding number in the row header Select line15
Column Click on the corresponding number (letter) in the column heading Highlight column E
Block (range) of adjacent cells 1. Place the cursor at the beginning of the selection (in the upper left cell of the selected block). Press the left mouse button. Drag the cursor, painting over the selection area (move the pointer to the lower right corner of the selected block). 2. Click on the end cell of the selected block, press the Shift key and click on the opposite end cell. Highlight blockE5:J14
Block (range) of nonadjacent cells Select a block of adjacent cells. Press the Ctrl key. Select the next block of cells. Select block A5:B9 and D3:F6

3. Make Sheet 2 active by clicking on its tab.

4. Select cell C6 with the mouse. Return to cell A1 using the cursor keys.

5. Make current (active) Sheet 5 . Delete Sheet 5 using the context menu.

6. Insert a new sheet using the main menu command Insert-Sheet. Please note that the name of the new sheet is Sheet 6.

7. Rename Sheet 6 to Sheet 5 and use the mouse to move its tab after the Sheet 4 tab (To do this, hold down the left mouse button and drag the sheet to the desired location).

8. Return to Sheet 1. Use the context menu to name it Table.

9. Go to Sheet 2. Select row 3. Deselect by clicking on any unselected cell with the left mouse button.

10. Select column D.

11. Select columns B, C, D together. Deselect.

12. Select the range of cells (block) C4: F9 with the mouse. Deselect.

13. Select block A2:E11 while holding down the Shift key.

14. Select simultaneously non-adjacent blocks A5: B5, D3: D15, H12, F5: G10.

15. Save the results of your work with the File–Save command or click the Save button on the Standard toolbar.

Note that you are saving the document with the same name that you set earlier when you created it.

Workshop No. 4
“MS Excel 2003. Creating and editing a spreadsheet document1”

By completing this topic, you will learn:

Create and populate a table with data;

· Format and edit data in a cell;

Use simple formulas in the table;

· Copy formulas to another location.

Task: Create a table containing the train schedule from Nyu-Vasyuki station to Novobobanovsk station. The general view of the “Schedule” table is shown in the figure.

Task execution technology:

1. Start the Excel 2003 spreadsheet.

2. Fill in the table in accordance with the sample shown in the figure. To do this, follow these steps:
• select cell A1 (click on it with the left mouse button) where you will enter text;
• type the text and press the key Enter ;
• fill in column A ;

Attention! Text in cells is left-aligned, and numbers are right-aligned!

• Select cell B1 , type the text according to the picture. Fill in column B. The text of column A is closed by column B, do not be afraid and leave everything as it is, then we will format everything.
• Complete column C.

3. Justify the width of column A so that all the text placed in the cells is visible. To do this, follow these steps:

With the mouse:
• Move the mouse pointer to the top line of the table where the column headings (letters) are placed, place the pointer on the border (line) of cell A so that the pointer changes to a black vertical line with a double-sided horizontal arrow ; Double-click on the separator line, as a result of which the column width will be aligned with the longest line placed in it (the name of the station).
• You can achieve the same by pressing the left mouse button and dragging the column border to the right or left.

Through the main menu:
• Select column A by clicking on its heading;
• Execute the main menu command Format – Column – AutoFit Width;
• Equalize the widths of columns B and C in the same way.

4. Edit the name of the station in cell A3 . To do this, follow these steps:

• Select cell A3 ;
• To switch to edit mode, press the F2 key, change the word “Small” to “Great” and press the Enter key.
• Select cell A5 , double-click on it with the left mouse button and replace “Velikomyshkino” with “Lower Myshkino”
• Select cell A4 , go to the formula bar and replace “Nuzhino” with “Nuzhino”.

5. Save the table in the folder My Documents _ 83 _ Petrov_Poezd

Answer the following questions in your notebook:

1. How is the cell address determined?

2. List three ways to align column widths.

3. List three ways to edit data entered in a cell.

Be First to Comment

Leave a Reply

Your email address will not be published.