Excel – is a tabular processor or system for preparing and processing the tabular forms document. - презентация

1 Excel – is a tabular processor or system for preparing and processing the tabular forms document.

2 active cell labels of sheets name of columns name of lines line of formulas Basic elements of the Excel window

3 active cell labels of sheets name of columns name of lines line of formulas Basic elements of the Excel window

4 1. Place the cursor in cell A1. 2. Type John Jordan. Do not press Enter at this time.

5 The Backspace key erases one character at a time. 1. Press the Backspace key until Jordan is erased. 2. Press Enter. The name "John" appears in cell A1.

6 After you enter data into a cell, you can edit the data by pressing F2 while you are in the cell you wish to edit. Change "John" to "Jones." Move to cell A1. Press F2. Use the Backspace key to delete the "n" and the "h." Type nes. Press Enter.

7

8

9 Document Excel presents itself book, consisting of separate sheet. The Tag three sheets are seen left of horizontal band of the rolling. In total sheets can be 255 " Workspace window is under the table, consisting of column and lines, on intersection which are found cells. The Column named letter Latin alphabet or their combinations, there are 256. The lines are designated from 1 to 65536

10 Each cell has an address, consisting of name column and number of the line. The Address be relative, absolute and mixed. Addressing on method left, right, below, above - is identified to be Relative. The relative address will be automatically change The absolute address doesn't change where we wouldn't move it. For indication of the absolute address is used sign $. The mixed addresses is half relative and half absolute The Address of the cell possible to assign four ways: A1, $A1, A$1, $A$1.

11 A1 - a relative address $A1 and A$1 - a mixed address $A$1 – absolute address Change addressing in formula possible by key F4.

12 Formula is the symbols beginning with an equal-sign. These symbols can include constant values, links to cells, names, functions or operators Functions in Excel are used for performance of standard calculations in workbooks. Values which are used for functions evaluation are called as arguments. Values of functions as the answer are called as results. For convenience of work of function are broken on categories: mathematical, logical, statistical, text, financial and others.

13 " numeric (the number with specified by amount decimal sign) " money (with additional sign of the money unit - can be R (the rouble), TG (тенге), $ (the dollar) and etc.) " date (with instruction of the type writing the date - a month by numeral or name) percent (with symbol %) " fractional (in the manner of simple crush ?, 21/25, ) " exponential (in the manner of 5,7Е+03 i.e. 5,7 103) and etc.

14 Read the text once very attentively and try to understand and remember as much as you can

15 For performing operation with cell, their it is necessary to select. The Separation possible to execute several ways: drawing mouse; cursor under pressed key Shift; for choice all columns and lines use the markers a column or lines on edge of the workspace. if hold the pressed key Ctrl, that possible selects the unbounded area.

16 1. Excel - a text processor. T/F 2. Each cell has an address, consisting of name column and number of the line. T/F 3. The document of Excel is called as a book. T/F In total sheets can be 255. T/F There are 3 addresses of cells. T/F The lines are designated from 1 to 256. T/F If hold the pressed key Ctrl, that possible selects the unbounded area. T/F

17 Sorting of data is an arrangement of data in a certain order. Sorting can be on increase or on decrease order For undertaking the sorting it is necessary: select the part of table, for which is required sorting; give the command Main – Sorting and Filter; in appeared window of the dialogue to choose the necessary column for sorting (or line); then choose the variant of the sorting (on increase or on decrease) Snap on button OK. Filtration of data - selection of data on certain criteria. For performing the filtering it is necessary: select the necessary line; give the command Main - a Sorting and Filter - Filter; in chosen column will appear button, snap on her and choose necessary, for instance, condition: in appeared list to indicate the condition and write importance; confirm the choice a snub on button OK.

18 The Formulas present itself expressions, on which are executed calculations on page. The Formula begins with equal sign (=). Is it Below cited an instance formulas, multiplying 2 on 3 and adding to result 5. =5+2*3 The Formula also can include the following elements: functions, references, operators and constants.

19 In Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you enter a number or a formula, you can reference the cell when you perform mathematical calculations such as addition, subtraction, multiplication, or division. Use the following to indicate the type of calculation you wish to perform: + Addition - Subtraction * Multiplication / Division ^ Exponential

20 You can use the AutoSum button on the Home tab to automatically add a column or row of numbers. When you press the AutoSum button, Excel selects the numbers it thinks you want to add. If you then click the check mark on the Formula bar or press the Enter key, Excel adds the numbers. If Excel's guess as to which numbers you want to add is wrong, you can select the cells you want.

21

22 When your cell contains this error code, the column isn't wide enough to display the value.

23 1. Click on the right border of the column A header and increase the column width. Tip: double click the right border of the column A header to automatically fit the widest cell in column A.

24 The #NAME? error occurs when Excel does not recognize text in a formula.

25 1. Simply correct SU to SUM.

26 Excel displays the #VALUE! error when a formula has the wrong type of argument.

27 1a. Change the value of cell A3 to a number. 1b. Use a function to ignore cells that contain text.

28 Excel displays the #DIV/0! error when a formula tries to divide a number by 0 or an empty cell.

29 1a. Change the value of cell A2 to a value that is not equal to 0. 1b. Prevent the error from being displayed by using the logical function IF. Explanation: if cell A2 equals 0, an empty string is displayed. If not, the result of the formula A1/A2 is displayed.

30 Excel displays the #REF! error when a formula refers to a cell that is not valid. 1. Cell C1 references cell A1 and cell B1.

31 2. Delete column B. To achieve this, right click the column B header and click Delete.

32 3. Select cell B1. The reference to cell B1 is not valid anymore.

33 4. To fix this error, you can either delete +#REF! in the formula of cell B1 or you can undo your action by clicking Undo in the Quick Access Toolbar (or press CTRL + z).