|
Қатынас отношение
|
Дата | 10.12.2019 | өлшемі | 4,3 Mb. | | #53367 |
| Байланысты: ¦Ъ¦-¦¬¦¬TП 2.2 Formulas Краткосрочный план урокаFORMULAS. How to calculate the area of rectangle in spreadsheet? How to calculate the area of rectangle in spreadsheet? You will:
- learn how to use formulas
- use relative and absolute
values
expression
өрнек
выражение
relation
қатынас
отношение
to enter
енгізу
вводить
type
түрі
тип
undefined анықталмаған неопределенный
to resolve шешу решать
Formulas Formula is an expression which calculates the value of a cell. We can add, subtract, multiply, divide and calculate the power operation.
1
+
|
Addition
|
-
|
Subtraction
|
*
|
Multiplication
|
/
|
Division
|
^
|
Exponents
|
Mathematical operations
Enter a Formula
To enter a formula, do the following steps:
1. type ‘7’ in cell A1 and ‘3’ in cell A2;
2. select a cell A3;
3. type an equal sign (=) to start a formula;
4. then, type ‘A1 + A2’.
The cell ‘A3’ contains a formula which adds the
value of cell A1 to the value of cell A2.
Tip: instead of typing ‘A1’ and ‘A2’ separately, just
click on cell ‘A1’ and cell ‘A2’
Relative and Absolute Values
- By default, all cell references are relative references.
- For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
- An absolute reference never changes.
- It is marked in a formula by the addition of a dollar sign ($).
Practice 1
Let us create a formula that calculates the area and perimeter of a rectangle.
Our inputs are length and height of the rectangle.
Practice 2
Getting started with Spreadsheets
Google Sheet Task
Thanks! ANY QUESTIONS?
Достарыңызбен бөлісу: |
|
|