Hello and welcome to our new video
In this video we are going to do
SUM, we have already done SUM
SUBSTRACTION, MULTIPLICATION
DIVISION, PERCENTAGE
we have already done this, when did we do this?
there was a video of OOTOSUM, in that we were taking maximum
we were taking minimum, sir we can do in that
do you remember? in last video
there was a video in which we
emphasized the name of the cell in the name box
I told you how to know the name of any cell
without looking at the name box, how can we know
what is the name of this cell, in that video
you will know the importance of that in this video
let's do it today
I have given some data, how is this data?
there are some serial numbers, names of students
marks of sociology, marks of geography, marks of English
marks of Hindi, and this is the total
because there are 4 subjects out of 100, so how much is it?
now what is here? SUM
SUBSTRACT, MULTIPLICATION
DIVIDE, PERCENTAGE
so if I tell you SUM, you will say this is very easy
we are experts in SUM
so what do we have to do to get SUM?
we will get it ourselves, this is very easy
so what did we do? we wrote SUM
and then we put a bracket, then we have to see
what is the name of the first cell and what is the name of
the last cell
what we have to do to them? we have to put a plus
when we put a colon, what happens when we put a colon?
when we put a colon, what happens to all the cells in the
middle? they get automatically selected
so we do it, this is called C2
and this is called F2, so we do C2 plus F2
and this is done easily
or will we do C2 plus F2? remember, no
you see here, only 2 cells are selected, not C2 plus F2
what will happen with C2 plus F2? this cell will be
selected and this cell will be selected
the other 2 cells will not be selected, so what we have to
do here?
we have to put a colon, now what happens when we put a
colon?
all the 4 cells are selected, so what we have to do? we
have to enter
our answer is here, now what we have to do?
we have to take out the remaining data, we have to take out
the data of Imran, we have to take out the data of Shivam
how will we do that? sir, will you put the formula of SUM
again?
no, we will not put the formula of SUM again, we know the
smart way
that we have put the formula once, now what we have to do?
here we have to see the plus sign and what we have to do?
we have to drag it down
and we saw that it automatically calculated everything
and gave it to us, so you said ok
now if we see the SUBSTRACT, now it is possible that
there is a formula of SUBSTRACT also, so you tried it
what did you write? Equals to SUB
but what is this? here it is written SUBSTITUTE and here it
is written SUBTOTAL
this formula is not found
ok, let us see the multiplication of SUM
what did I do? I put the Equals to and I wrote MUL
what is this? MULTINOMIAL
this is not MULTIPLE
so I am trying to tell you that without the formula
how can you use the formula of CELLS
you should know the name of CELLS
we don't need any formula
when we were doing SUM, we saw a way
we were not putting the data in the bracket
what we were doing there?
I don't even remember the formula of SUM
I only remember the name of CELLS
I know the name of CELLS
so I wrote F2
You asked me to output the SUM
I know it how to do it
I wrote C2 plus D2 plus E2 plus F2
I did C2 plus D2 plus E2 and F2
I entered
it gave me the RESULT
we got the result
and we dragged it
now we got to know
what is it
now what we have to do
we were told to do a subscript
what is subscript
what you do from your total marks
remove the Hindi marks
we don't want Hindi marks
so we said okay we will remove it
it is easy, how easy
we did, we put equals to sign
we saw
what is the name of the column
as we know
if we remove the result of the first one
then how will we remove the result of the rest
we will drag and remove
formula will be applied on the rest
so what we did
I have to find this
so what I did, what will be the name of this
G2 and in G2 minus
what I have to do, I have to reduce the marks of Hindi
so which cell will be this
F2
what I did, G2 minus F2
what I did, I entered
so I got the result
now I don't have to write here again and again
I went here
and what I did
I dragged this plus sign
and I got the result
now we have to check
is it correct or not
as I selected on any cell
so what should have been
here should have been G4
here is G4
and what should have been in minus
of Hindi, F4
is this thing clear
so
we got to know
whose importance we should know
name of the cell should be known
we will handle the rest
we don't have to worry about the formula
then someone
told you to do multiplication
so now you are excited
tell me which cell
to do multiplication
should I do with the Hindi of geography
or with the English
of sociology
I will do it now
I have put the equation
and now I will multiply the marks of English and sociology
so I saw
I have to see the first one
what will be the name of this cell
its name will be C2
and here what will be the name of the English
E2 so C2
and multiply
and then what happened
its easy
if someone doesn't know
how to multiply
so let me show you
on your keyboard
this sign
this sign is called
multiplication sign
and here this small
sign is called
minus sign
and this is plus sign
in the same way
let me show you
this sign
is called divide sign
is everything clear
so let's
remove it
so now we know
how to do multiplication
but your friend told you
let's test it
he did it this way
but let's do it in another way
he told you to do one thing
multiply 2
how to do it
we saw
that one cell
is multiplied by another cell
or one cell is
added by another cell
so what you have to do in multiply
simple
someone told me
multiply 2 in sociology marks
so I said let's do it
I put equals
what is the name of the first cell
multiply
sign
2
enter
drag
simple
result
divide
so now what we will do is
we know that the name of the first one
should be known
so what we did is
I saw column G
and here I saw 2
so what happened G2 and here I have put the divide sign
and see it is selected and highlighted
G2 and now I have to divide it with the help of sociology
mark
so here what I will do is C
and here what happened is 2
so G2 divided by C2
and here what I have done is entered and this is my result
now you can see after this decimal point
how many decimal places
my numbers are coming
see how many values are coming
after this decimal point 9, 0, 3, 2, 2, 6
now what to do for this
if I do this plus
so this is my result
but this number
how does it take so many places
generally what we see
after decimal we see up to 2 places
so I will tell you the solution for this
select this whole and see here
you can see this sign
in the number group
what we see
increase decimal and decrease decimal
so what we have to do
after decimal the places
what to do
decrease
so what we will do
here we clicked
one less
one place less
do it again
one more place less
then one more less
see magic
so what happened
decreased
now if increase
what to do
select this whole
click here
increase
do it again
increase
understand
so for now what we do
keep it up to 2 decimal places
not more
this much is clear
after that
last is
we have to calculate percentage
now how percentage is calculated
tell me how percentage is calculated
percentage is calculated
whatever is the total
141 marks
multiply it by 100
and divide it by total
so let's do it
so what we have to do
we have to put equal sign
we don't have to put formula
we just have to know
the name of the cell
so what we did
ok
find the name of the first cell
what is it
H
and what is here
2
so what is this
H2
and what we do
for formula of percentage
multiply it by 100
and divide it by
total marks
so what is the name of column of total marks
what is the name of cell
what is the column
G column
and what is the name of first cell
G
and what is here
2
so what I did
100
divide by G2
and what I did
enter
and what is this
35.25 percentage
now what I have to do
now I have to drag it
simply
and I got the result
now how far it came
upto 2 decimal places
I don't want 2 decimal places
someone told you
do it upto 4 decimal places
ok
so we said
let's do it
we know
so where did we go
we went to increase decimal
not increase
what is this
decrease decimal
what is here
increase decimal
so what we did
click once
from 12
what happened
after decimal
places
increase
ok
so we can
decrease and increase
it
upto here
it is clear
what all things
we did
what we did
we did sum
without formula
we did subtract
we did multiplication
we did divide
and percentage
we did
we saw
one common thing
in this
if we know
name of cell
which name
is written
here
in name box
it is written
ok
so we
in name box
without seeing
name of any cell
we can tell
only we know
name of that cell
so what we can do
easily
we can do
any sum
subtract
multiplication
we can do
all things
and if we want to
find out
in this cell
which formula
is there
so we can
find that also
how to find
we took mouse
and clicked here
and found
ok
C4
plus D4
plus E4
plus F4
so it is clear
so in today's video
that's all