Қатынас отношение

жүктеу/скачать 4,3 Mb.

Дата	10.12.2019
өлшемі	4,3 Mb.
	#53367

Байланысты:
¦Ъ¦-¦¬¦¬TП 2.2 Formulas
Краткосрочный план урока

Formulas
Practice 2 Getting started with Spreadsheets Google Sheet Task Thanks!

FORMULAS.

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.

+	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?

жүктеу/скачать 4,3 Mb.

Достарыңызбен бөлісу: