Hi, everyone, and welcome again.
This is a very important lecture in our course, it's about cell writing and cell operations.
The objectives are writing text and numbers, how to writing operators, how to write and combined operators,
OK.
Still writing in the Microsoft Excel, the cell can be written by three types Teguest Numbers, Formula,
Teguest like welcome to Microsoft Excel.
This is thickest.
You can also enter a number.
Such as four seven, five, four, seven, or you can enter formula, but if you want to enter a formula,
you just write firstly equal sign.
Let's get practical here.
This is a Microsoft Excel, and I want her to write something.
You can write text such as Smart or Excel.
This is a text book also you can write just numbers seven, four, five, two, three, 10, whatever
this is.
And Amber, also you can write formula, but if you want to write a formula, firstly write equal sign
and write whatever formula you want.
If you want to add two numbers, you can add this number plus this number.
So you're right, a former OK, so you can write three type of things, text number or formula, if
you want to write the formula, you must know three things.
First operator like plus minus multiplication division and so on.
This is operators to make mathematical operation.
So there is a key question and the key concept here, what is the difference between reference and constant
on the other meaning?
What are the difference between dynamic and static?
Let's take example.
Well, if you want to add two numbers, but you want to use just constants, press equals sign and the
first constant will be two and the second constant will be.
To there is the final result will be for OK.
OK, this is going to stand.
Plus, consistent, and this is fixed, static can't be changed.
Well, let's write this formula by another way, right equals sign and select the reference for the
first number.
See, aid and the operation will be additions, right, plus and the second reference here will be.
S. nine, the final result will be four.
So what is the difference between this four and this four?
This is a good question.
The first four is a static can't be changed because it consists of two constants.
However, the second formula consists of two references.
Once you change only one reference automatically, the final result will be updated.
So if you change this reference to three, the final result will be five, OK, and so on.
If you change the second reference to B, then the final result will be 13.
This is the key difference between cell reference and constant, OK, whatever I want to write one contestant
and one cell reference.
Let's try.
I write equal sign.
The first contestant will be due and the process will be addition.
Right.
Plus sign.
And I want to add that second term of this equation as reference like C.
Ed, the final result will depend on the reference if you update the reference by, for example, for
automatically the final result will be changed.
OK, so you can add constant and constant or you can add cell reference and reference, or you can add
one constant and still references.
OK, basic mathematical lubricator addition.
The operator symbol is plus subtraction.
That operator symbol is minus multiplication.
That operator symbol is asterisk.
The vision Briatore symbol is forward slash exponent, the operator symbol is power, saying you can
write exponent by using, you can write the exponent sign power sign by using shift plastics.
OK, ok.
So let's take a simple example about these operations here, if I want to add variable X and variable
Y, let's write formula.
This is a reference plus this to reference, and the result will be 14.
Let's subtraction for minus 10.
The result will be minus six.
Let's multiplication first the reference and.
By the second reference and the result will be 40 division.
Let's divide first a reference for Slash and the second reference point for and for the first cell reference
and shift six.
Power sign and the second cell reference.
OK, this is huge, no.
OK, OK, if you want to write the answer in the answer column, just press equals sign and reference
to this cell or formula cell and use.
Dreg.
To repeat the formula.
And now this is formula of addition, this is formula of subtraction, this is formula of multiplication.
This is formula for division.
And this is formula for power.
OK, OK.
What if I want to change these variables?
Let's change X and see the results.
If I want to change X by two and X will be six.
So automatically all functions have been updated based on the entered formulas, if I want to change
Y to be to automatically or the results have been updated based on the entered formula.
And this is the bar of Microsoft Excel and this is the power of references.
Once you change one reference or the reference is the final results will be updated.
OK.
Let's revise this lecture, we have discussed how to enter a value to excel, and this value can be
thickest no or formula, and we have discussed the key difference between reference and consistent.
And we have also discussed operator and we have answered this key concept of operations in Microsoft
Excel and in and in programming in general.
What is the difference between reference and constant?
And we have discussed basic mathematical operators such as addition, subtraction, multiplication,
division, exponent.
Also, we have to take a simple example about these operations in the next lecture.
We will discuss that sequence of these operations and how to write a combined operations and operators
in Microsoft Excel.
Thank you.
If you have any questions.
We are ready.
Just contact us.
Thank you.
And see you in the next lecture.
Goodbye.