Nuts. We shall continue with the lesson number four, which is adding rows and columns. That is clear protecting the sheets using foreign Ras, which we have not yet done on socking data. Now we shall once again review protecting cheats and selecting data and then we shall go to farm labs. Now, let's open Google, as usual, know how to open the desktop we can straightaway open that. Now we've considered an example sheet here.

Ready for working Play our talking system and perfecting the sheet. First we should see how we can start in the last week we have done it last Tuesday we have done it and we should do it and that is we will review it. So you select the cells you want to the entire sheet you want to cite then you go to click later. And here SOT rain you click on this and then it will ask you column you but you have a data had an ad yet host when and the first one is hey dad. So you click on that that means you are saying that there is a data header. Now we shall consider hospital we can return container host countries Wash country Okay, this is the first sorting let us see how it comes that is we are starting from A to Zed okay.

So, Argentina is the first alphabetical letter and it is dead I know once again I will do the other way that to you You just watch how we can change to click on this talking horse country that to a non profit alphabet came first Okay. Now, we should start multiple sorting that is first one row and then second and then third like that how it works out let us see you select host country Yeah, you select host country once again okay and then it is starting from A to Zed and another sorting is yourself. I will tell you why we select here Yeah, okay. Now you click on this see you have we have started here you observe 1958 Argentina only once 19 Brazil only ones Brazil is 20 1950 and 2014 to me once in grade ones and France twice, gentlemen twice, Italy twice, Mexico twice and so on so forth.

Okay, now you notice France twice. First he won in the year 1938 and then it won Yeah, it won't happen in the World Cup happened in 1998. Of course, it didn't run in the first year, but it won in 1998 this column will not bother about now, we should consider these two runs has offered particularly a B, C, E these neither there are two occurrences in France in these two occurrences, the Euro current 1930s and 1998. Suppose in France, we want to have these things these two things we changed cluster 119 98 and again it should be 1938 that we can do it similarly, Germany 2006 and 1974 it will be changed. So, in all these cases it is from ascending 1938 comfort 1998 through 1970 For 2006 suppose you want to make a descending order, but this remains the same adjective alphabetical, then what we have to do is, you go to your host country pot select host country that is A to Zed it's already there and second selection is the year you see this Yeah, your is now in this for example, France 1938 and 1936 that is it is from A to Zed.

So, I want to make it that way you know how we drop our changes the T 1938. c, France 1998 and then 1930 it is interchange because this is descending first, higher value indents Okay, lawyer, blue, Germany auto higher value Then lawyer you okay you can you are so loyal when you hire a new alphabet it is from attending this is from recently we also do one more like this suppose we untagging worst country and we change it to this and this we can Yeah, we can do that and then you notice everything has changed. Now we can see from here you just come lower because you and Zagat stops. So descending and this is ascending, this is descending this also we can make descending what we have to do is once again click with this watch country, that can be written year and then you make this that change see not get Now we will now see the same thing how we can select the target every see first is the reason what country and second will have on third one you see what we can now suppose you have when what we can now what we didn't have a cake winner.

We range from A to Zed okay. Ah Zack Do You Do you notice I didn't finish faster see winner has changed what a great kids okay. Argentina remains as it is. and France, Italy here you just see who are there. Italia in France to Italian France. 1938 and 98 Italian France can we get changed?

First I put it in descending support we make it ascending France come first. Second I eat Come similarly Germany also first Italy first Germany Italy and then when we change it it becomes the other way. Okay, so this is now descending descending Lulu we had to split this first because we're ready to start including gratitude heading also as a column or a row. So host country then you consider yes person can you continue this I know we have made it faster Yep I can suck wash country. Yeah. Now who is the first winner, you see was subject to you take it says come now we shouldn't go to next object that is protect the sheet one to read I will review once again this is all we can suck, I suck second track, I will explain briefly one thing, suppose in 1958 50 and this is sorted out.

And in 1958 itself. There are many other things Brazil, Argentina and Argentina, then that could be taken second talking, then each one of this Brazil if there is some other occurring is there other winners, then that could be taken third, right here, that's our 1938 Here we select transposed. So, France has given alphabetical order and this is given in ascending order if you want to change it, we have seen that 1992 become here and it took years to come here that is a second sorting. Okay. We also see on the directory then also where changes can be made. But in third session Top squatting is with this there are many other occurrences various occurrences in the alphabetical order we want to change then it is possible in the third tracking but he really no such occurrences the top 1998 France is one and France is the host country in France as one okay and the same here there is no other things to sorrow.

Okay, that's how we can have a sighting land only two sighting is possible if the number of things are innumerable number of UN travel hundreds of millions and in each first year change and then host country then we know that so many things are there then you will have that she will the average also average is traveling second year third is see here. The average is this is here highest average is not there. Here. DNS is not there because it just criterias here is alphabetical order this is accordingly this change is human on this basis post country, Argentina first then in Argentina what are the related things all these things will come in that is Argentina with your salt on this all this column all these rows 123456789 these are all belongs to Argentina only, so, they go together. Similarly, Brazil when this product is low this this this all this loss data belongs to Brazil only So, they go together.

Similarly, Brazil here once again 2014 whatever the occurrences are that goes in or belongs to this Brazil in 2014. So, they all go together, okay, that is, suppose we want to sort this average attendance, the highest study Lawyers hire two rows of lawyers lawyers either way we can sign you have to click once again data now, we have to start the data please attend average attendance. So, we select this average attendance reading is this one, select this and see the noise has come forth I guess has gone to last. Similarly, we can also have themes see here and then as a formulated 16 1616 teams or so, many things are brought in. Suppose, we take the good team then we click it on the clip here. So, this has come tracting into lawyers.

Then accordingly these are all set. Suppose attacked in second sorting will be directing acting against participation is also ascending support you want to make this descending all these things are descending order then what we have to do is select this select like this setting a sorting will be used to make tracking will be okay and second on sorting is attendance I recommend to look for psychic water in ascending order. So, here both are in ascending order. Suppose we want to make this one the second sorting is this is one The second Don't you want to make it as descending to just change? I think that that remains ascending would be practice among first came 32 seconds sooner in 15 years, how many occurrences 15 only one one only 3128 2872 and $16 harmonica is 1234567 This is the same, then it comes 24 but in the 60 51st camp that is the maximum okay then it descending okay.

This is how we can do Santi now I will take up protecting your filing or remove the protecting files, protecting sheets. So see in order to protect the sheet We have studied what are we can do here to click on this and then it will ask custom and only you you can click, you will get for copy permission from another range also you can have custom means, you can use any option both of them and only you means only you can do it. So, we have studied that and no show a warning, you know here the protections cheap means, only editor can edit the owner machine and then the person with whom you share he cannot do anything it will be protected, he cannot delete and do anything. It may be applicable for the entire sheet or it may be applicable second rows and columns and complete your shoe offsets also in content like that.

So, this we didn't do yesterday I will show the warning when editing, do range ranges and achieve whatever it may be. You can click on this, click here. It is no so this means when you want to change the value in the sheet then it is quick to choose the one you're trying to take the part of still should not be changed action create anyway it asked you but it's a warning but it won't rescue from changing. Just give a warning like if you want to okay good otherwise you can cancer it is that is you're not doing similar to this one you can do a specific number of sheets also very cancer. And this is unusual. You want to remove the productivity rate.

Yes, you see anymore. It has been removed. Okay now Similarly, we can do a test. Second says, say yeah, we'll say C two four. And I'll do one call I 230, c two for I 230. What do you want to protect Whoo.

Type in cells, that is equal to true. And then click permission. Here you click on this cell. That means if you want to change anything on this cell then it gives a one add to it if you can only see for it has started from C code. Now we'll see how we can correct the second search only. Yet I'm selecting c that is up to h3 to this tool you want to protect it You have to select a range range and click on this.

See it shows that it gives a warning here. Similarly it gives a warning okay. When you really want to within that certain range usually suppose you want to change here because you because we didn't select the set so that we can take any names and so in order to remove the production work Change Are you sure you want to remove the protective age removing cancer mythical comes back to protection removed Okay, this is all we can do it now next we'll go to talking is over perfection is also one hiding process to navigate sufficiently know you will learn about using a few file Okay. Now open the sheet here see there are certain formulas, mathematical formulas are there some logic functions are there some areas are there, some engineering farmers are there some mathematical logical reasons I told you not so much Farmers are they sign up for Costco it was caught etc too many farmers on Etsy there are more than 100 200 farmers more than 200 farmers the tang tang square road sign Hicks Hyperloop site sign in sequence equals of arranging round up round loves figure round up the number of power whatever power you want to raise by you and you're so good at things in mathematics also, we learn a few of these things and also there are many great functions database date month because we can This is our deal now, we will deal when we come into that field okay.

And now we shall see some of the some of the formulas related to simple activity. Say for example, some so in order to find some This is why it some people Ask here. So what you have to do is where you want to some what column you want to some that you have to go okay. Suppose you want to summarize this entire thing that is from if you select this then it shows wrong error is 22 from 22 that is headship to catch 22 Okay. You can do two ways. One is select the sum, it appears here, it equals one and select the range.

We can select the range like this. Setting the range from where it is. remember which one Crude has to come from h2 okay your selected cell h2 you right? That's true it will be capital and not need not be Kappa Easter you put it an approval you have to give extra okay then it maps it here as you can see that is true to this you will get this okay. Similarly suppose you want to sum only up to that to select only up to the V. So, I will show you how suppose you want to I will add a row here. Here I want some here that is from two to 70 in what you have to do here Doesn't matter whether it's Captain Monica, you do some of these tips okay.

So, don't be doing it as you see here from kick to edge decision value h2 in de Sena number, first you have to spell first column columns are already alphanumeric, and rows are in numeric. Maybe should you are called as alphanumeric, this will get you out in alphabetical manner, and this is in numerical manner together is it is an alphanumeric that we both alphabetical and numeric is called alphanumeric. Okay, hatch. Two is an alphanumeric so similarly To use in our fundamental, g six is an alphanumeric but G's alphabetical and this is your Okay. Now let us see, we want from here 22 to 21 that's what you can do you need not use it, you remember if you remember the formula called was put equal, then you call some you type some, the capital not necessarily to be capital itself highlight if you're typing wrong then put a bracket then you pitch to them then is to have to put which is what then you have to close the bracket we don't do fully which was earlier.

So, like that you can either type it or you can directly select similarly here he wants to some Yeah the case I do I used to do this is all we can do this is one this time explain to numbers or decimal, indentation increasing, I will not be average we can see average average cost, you know I bought is average just total value, number of values. So, here how many venues are there 1-234-567-8910 1112 1314 1530 whatever. So, what is Suppose we say average, click average once again always you have to put an average click equal sign you have to always put to average to see, come up here and rich. Get average coke or some limited number come from. Similarly The beauty here is this is evident i do i don't even get the sale from Ryan Cranford. next row the column to select this particular CTR see then copy that is copy you can even copy from here copy and paste it here.

See, it gives me this this value. This is this column, say it is J two j two. Yet again i don't i don't i do i totally support your answer here. Similarly, the ditch, copy and paste it here. Copy copy exceed good average this current page called average h two h two for like average we do some we do next come in just count the number of rows the rows that you have to say. Suppose you want the discrete counts 123 right that is 20 suppose you want to count only up to 20 years to 90 Either counting champion count we can also transfer Yeah, exactly.

Copy copy to the top. This is how we can Next use maximum maximum of three same relative bound by the measurement to get the maximum of these suppose matches, which is the maximum of these values that could use because I want to say maximum, you have to give the rows and columns select the column. I want to find the maximum age true to extract one. So what you have to do here you have to do one Gives maximum security to the maximum okay. Similarly, minimum minimum or distinctive minimum wage This is 70 Okay. So we have we're going to be moving this first all these things and then tomorrow we should take up more foreign money coming in from Russia.

And next after completing this onra we'll do some examples. No loose on workups on mathematical problems and some simple mathematical and logical functions. Some engineering problems mechanical, electrical, electrical, some electrical, some civil engineering problem, mechanical, we deal with all structures machine design everything we need to look at. And also we do some graphics, graphics soldering, soldering game processing structure by using this method kangra for all those things. That is basically we started with statics and some iconic stuff so we can do the full we can do some thermodynamic other things we can do, coming closer to today's class. This covers lesson four lesson four material lesson polls continue for another half an hour and I want to make it non stop it thanks bye