Deana in the last session that is lesson one, we have evolved using various commands such as explaining gloss or minuchin explained the bunnies functions if you have them in that way, I will explain to you now and define sheet area that will be defined. I'm showing you different rows and columns that I've shown you have shown you adding rows and columns you can see that I also have sharing the sheet also be indebted and getting help also having dealt with insert command in any cell optimizing and also I will get okay now we will walk you through lesson number two. Yeah. What command that is using the keyboard for certain operations from rubber ribbon editing the self formatting, merging the column, rows and columns, setting cells width and height adding removing the checkbox merging and merging. Okay, these are sent out No, we cannot read the merge cell electron.

What is it? Now, I will just give you a brief about some of the key moments. That is absolutely, most moments, I will just open the Google Chrome. Here, I will open Google Drive and we can open the Google Drive and it will show the Google Drive. And here is a file which is visited file we used. We can take up unified for explanation but now, right now, I will tell you the user Most have already you most but many of you may be doing most functions, what do you suppose you want to move yourself, you have to click the right click the mouse like this and down also you focus on that great right click always likely okay Once you have selected the moves like that you have to right click or the left people then select in a different way then you have to do a left click and like this right is really very focused and write Okay, which is how we can do it.

That is about it. And similarly, I will explain a few key word keyboard functions. If you do page though, the next now you will get yourselves being going down focusing really naturally. If you break up next evolution okay again this is towards right towards right of you and disease Oh car and keyboard will do differently you can correct like this is the function to do it and you enter some data Yes. And you enter some data and then click return on Enter, it goes to the next downward and you can also set it so that it worked what is it that will explain you how to make settings that I will explain later on session? No, it is just dead it was out like that.

But it is also by entering it was a portal and also there is a multi zone also you can shift the focus or the next will be the next column Saturday, actually rose Also, you can like write the words Rosales Like to search for an FM right? So we know that these things are universal, that is sufficient for timing. Okay, and one more thing, what there is x mega. So you want to erase either you can see Greek on that and then Backspace, backspace you can use edits like that. Like that you can back it or you can, or you can see right here is, so these are the two key functions they have used. Later on, you'll see many other key functions.

Okay. Now, we'll go back. Using keyword, a certain operand has been a bottleneck. Blah, blah blah. He's Yeah, she's called just below the ribbon. The Nova advantage is called engine you can hide unhide like this she moves upward moves upward Well, you know, like this long blah blah, we can I will tell you hope.

Can I hear these are robots. So, to do this you function you have suppose you want to remotely farm robot Congress and once again want to highlight To show you how you can farm lava, you can either type your text Matt said you said did you repeat it and he said okay. Now you focus as you focus during that cell there and if you type retro type here like that we can use our robot our robot then you use longer extractors, arm Ross etc It could be much more useful than this. Similarly, these are all the lines, right rights gray lines are the vertical boundary within the vertical and blue vertical and to regulate itself and we are going on so, now suppose you want to hide That's absolutely reject, but the tenants will move energy, but the grid rents up up and down. Here you can enter the values moving like this.

So, we want to see the grid right. I know we will see freezing what is meant by freezing okay. Suppose this one suppose you want to freeze Row on a approve. So here we have it. So, we have to freeze it suppose we click it here. So, it shows us that means when you have a long text okay What is happening?

You cannot see the top headings. So in such cases we will have to use this function. So, unknown current current row it will unfreeze. Okay. This is how we can use an example. Oh we can Oh it looks yeah good dates on optional should show you where you want to display and exactly how I really like to see.

You can blank also we can you know suppose here there's a farmer How would you say record in suppose with Moodle, no foul Rama just see what happens and wind down. So here what is happening? You cannot average more words more Matches teams. These are giants you want to see where you're at when the tree is very long then you don't see this. Suppose you have protested. See suppose you want to enter here you can't see the top.

So by mistake into here what we do is we focus here like this and then we click here view and row one row one. So now we just see how it works. See, the rows are hidden like adding etc. This is how we can do the reading the Roseville region. You can reach any point Any point, suppose you want to remove the V normals we really want to face then you can click here we have to know what is happening up to 1954 that create sixth row you can see all the other rows are not seen really then if you have more number of columns, you can have all that hundred columns. Okay, we'll see how that come to the end and yet, these cash flow No you can move in top bottom Okay, similarly farm robots also can be used.

See the side description patient side this also want to see this also in a spreadsheet. You have pocket backcountry geeks are GoPros rush to drop rows. first column descriptions are given and really various items required each level see here actually learn cup or a 90 was was played maybe what I'm picking up on some of the match was another cup with average I'm going to use not only matches was average was good okay? Each country and main items are again these are the countries with us World Cup countries and we are we have seen one which was straight winners. So, we want to see when you want to enter you want to see both abroad So, then what we have to do is, you already have wasn't capitals, no, no you can see. You can of course we can act like this, we can Like this similarly we can select on the shift key, move towards like that's the shift then insert seven columns incomes and all other ways.

I'm the most you want select number of press the right side. I'm most the most the most press and hold it correctly. This is all if you are using the computer and you know the mouse shot you can easily do all these things. Okay, no, see yeah you can see both the top row there nice to see Yeah suppose VPP ag so yeah he's already there. And once you move this you can always you can see okay. Suppose we remove, we remove Ross Ross is removed cannot see anything upgradable once we remove this view you reach ban columns, no column support removed something like this The thing you want the description you cannot see.

So, when you want and then you have to see what. So in that case, you have to select we do here at Richmond, second row, second. Suppose you want to see up to here, then you click on this. You click once again up to one column, two columns, the columns you can be up to be here. We can always see. See, you can always see is it being seen because of the beginning?

Then we can next autumn Rob relativity ribbon now in the last lesson, I have already explained a little bit about ribbon, no more details, I will close this okay we can keep this empty because some betas are also interior which are easier to understand. So we'll use a ribbon See, this is called ribbon there are in blue paint format Zoo how much you want to see more as we reduce moving average hundred percent increase like June like this individual will keep 100% This is a room. You can walk or whatever and this is called automatic currency that we will use of our currency This is zero. This is more fun. This is fine. This is fine.

More inclined to color through color borders, you can create borders and centuries or percentages centering, vertical align text wrapping. See extra location, this exact link. See here he has given us shortcut key shortcut CTR means instead of, we can insert clicking on insert link you can also press C on J s and insert comment, this is CTR m Hardesty emerging economy and the largest economy and is in surcharge This is free Ted Do you think this is functions where you see the ribbon there are so many functions available. Even callback functions are commented on. Now let us come one by one there's a percentage Farmar percentage. So all the things you can come, this is all you can see here.

Okay automata See, suppose we have an activity to support the playing game second second fastest increase, but there is some more than nine zero okay increase but the increasing rate okay 3.91 all the things basically dumped a numerical value accuracy claims accuracy increasingly accurate similarly we have suppose you don't Rikiya like a boy you want to record that ritual it back no this you see what you can use plain text suppose I said I want to work only I use for only text it's not plain text plain text type we can add my text back okay, that is my keyboard you can type focus the most are by using left right connects up along the keyboard people can look at the next one like the different things you can suppose you want numbers What the heck they can select now much Number one no thinking we are here Rebecca By practice you will love many of the commands used to candle Swami command and everything is difficult to explain.

So by usage, ribbon usage this percentage, you click on this, on this, we have focused on this particular cell Yeah, on the ribbon this one so this person is supposed to be interviewed like this just next year, yet Geico remembers what you have, I think gonna be here is not there, because percentages are that you had to add a suitcase sign. can suppose you want to you can hide ad or attention that you can do it because you want to act by simply saying in columns numbers are simply the percentage Hello If you can do that more scientific Thank you If you want to add value for whatever You want to have numbers and thank you to all our apologies Right clicking 62 polar suppose we have this scientific integrity is always my number and then you to show the power. This you know by name, we didn't show the accuracy of an accuracy.

Acquisitions because they find in because they have To increase for like 8.904 that means you convert it to numbers. This is 8.92. Learned. Yeah. Formatting numbers, prime numbers, you can add prospect. Scientific that is always expressed in terms of our register to represent 25 to the power of two that is the abbreviation E. That's true.

A positive wind, you know wind Suppose this you want to express emotion image multiplied by the power of n minus two is nice. That is why I will explain how you can consider this to zero, because the minus sign is. That's why it was minus two is supposed to mean you can have 000 but you should one digit. So, it can be like this. Suppose we have 40 here is power 100 over to this number one digital and that will be raised whereas in the case of flat point one is always one minus 0.0 0.0 minus is always one digit is 567899. It will be their next point and then in the next video Suppose you want to see what you play.

So that would be five times more for that is because you want to increase it. Just do one more digit, the pipeline before 500 I'm just going to use it Napoleon I missed this I wonder if that means make it very clear once again This will be becomes pipeline. So, you bring it to 5.789 and then multiply by four or three we have to multiply this by point 75.739 might be pain at this point single entity power I think next because I explained a lot about these things and accounting currency will come currency here suppose we collected data Morning currency, morning currency Australian dollar this video this square US dollars off getting off a good play a video like that. Like that you get that sign and this is selected Jake detention time. Come to date next Keep you open this cheap find it next time on a remote site.

Thank you because us automatic means whatever you're in next session. Think you're supposed to proceed You see, keep pressing. Next If you ain't dead some other automatically will be there. functions, numbers, plain text, we just went through the keyboard next, next function the next clause register next time