The standard Microsoft Office package includes Microsoft Excel, which is a ready-made spreadsheet. It is mainly used to create various calculations. Excel contains many mathematical functions, but before you can start using them, the program must be properly configured.
Necessary
- - PC;
- - Microsoft Office;
- - Microsoft Excel.
Instructions
Step 1
By default, the main menu of the program displays only frequently used parameters. Enable hidden functions in the menu "Tools", "Settings", then "Options" and check the box next to the line "Always show full menus".
Step 2
When performing calculations, the program uses formulas, but Excel will only take into account those that start with the "=" sign. For example, write in the cell = 2 + 2 and press Enter on the keyboard. The result of the expression will appear in the same cell. At the same time, the typed expression does not disappear anywhere - it can be viewed by double-clicking the left mouse button on the same cell. If you press F2 after double-clicking on the keyboard, the expression appears on the toolbar in the formula bar, where you can edit it. If text is used in a formula, it must be enclosed in double quotation marks, for example: "=" mom ".
Step 3
In Excel, you don't have to retype expressions every time. Just copy the previous entry by highlighting the cells you want. The program will set its color for each copied record, and the formula will look something like this: = A1 + D1. To see the expression, double-click on the selected cell with the left mouse button and press Enter. You can find the formula by looking at the color of the cell - multi-colored links indicate the line and letter numbers of the columns of the corresponding expression.
Step 4
Expressions in Excel can be arithmetic or logical. Write down in the formula bar: = DEGREE (3; 10) and press Enter, you get the number 59049. To solve logical expressions, special codes or blocks are used. They must be recorded strictly according to the rules. For example, a logical expression written in the formula bar will look something like this: = MIN (SUM (A22; DEGREE (C10; B22)); PRODUCT (SUM (A22; B22); DEGREE (SUM (A22; C10); 1 / B22)) Complex formulas can be written using the function wizard.
Step 5
Start it by pressing the ƒ͓͓ͯ button located at the beginning of the function line. In the window that appears, select the desired formula and click OK. To make it easier to find it, use the category filter. By selecting a function, you will be taken to the next window. Paste one more in the first one or click "Cancel". Nest one formula inside another using the "˅" button on the taskbar. Then, from the drop-down list, select the required one. Do not forget to rearrange the text cursor over the data cells.
Step 6
Excel recognizes the simplest mathematical formulas: MIN, MAX, AVERAGE, DEGREE, SUM, COUNT, PI, PRODUCT, SUMIF, COUNTIF. If you write: SUMIF ("˃5" A1: A5), the sum of cells with a value greater than 5 will be taken into account. Several conditions can be fulfilled simultaneously using the "AND" function. Use the OR value when testing one of the many conditions. If the table with numbers is very large, use the functions VLOOKUP - vertical first equality, HLOOKUP - horizontal first equality. By applying them, you will automatically find the desired range of cells and save yourself the trouble of manually copying data.
Step 7
To make it easier to work with the functions, use the "Ʃ" button. Count the sum of several numbers, find their arithmetic mean, the number of numbers used in the list, the largest and smallest number in the table.
