Cells and formulae

Содержание и основные понятия

Address
B3
means the intersection of column B and row 3.
=B3*C3
does not remember the final answer: it keeps a rule that will be recalculated after a change in price or quantity.
Grade 9
Table data
OGE No. 14
EEG No. 9
01
What's in the box
Meaning
Number
12
the word "March" or the date is what is inserted into the cell.
Formula
Recording of the sign
=
It refers to other cells and calculates the result.
Format
The view on the screen: percentage, rubles, date. The format should not change the meaning of the number.
Procedure
Normal: first brackets, then multiplying and dividing, then adding and subtracting.
=A1+B1*C1
and
=(A1+B1)*C1
They usually have different results.
02
Formula Trainer
fx
Fold the calculation
The training simulator understands only three cells and arithmetical operations; this is not a table processor: it does not store a sheet or maintain functions.
Training table with cells A1, B1 and C1
#
A
B
C
1
Cell A1
Cell B1
Cell C1
Results formula
references: A1, B1, C1
Operations: + - * / ( )
03
How to Don't Lose a Mistake
Check one line manually, then check that the formula in the final cell covers all the data and only the right data. The numbers levelled by appearance can be text; then the sum or average will produce an unexpected result.