Hi, everyone, and welcome again.
Today's lecture is about cell concept, the objectives or cell concept, cell navigation and cell selection.
Like our human body, human body consists of group of cells, cell for brains, cells for blood cells,
for heart cells, for muscles, cells for kidney stones, for liver, and so on.
Macross of the Cell also consists of group of cells and these cells formulate Excel sheet.
So our Microsoft Excel consists of a group of rows and group of columns and each intersection column
with row a row with a column.
There is a cell.
So for example C five, C five is an M of cell, C is a column index and five is a rule index and C
five is a cell index.
So every cell in Microsoft Excel consists of two elements.
The first element is column index and second element is no index.
Let's go practically to our Microsoft Excel sheet, for example.
This is C five here, so.
If you check the name books, you will find C five, C five is the name of the cell and this is the
intersection between Colon C and RO five.
So this intersection formulate C five.
So, OK, let's take another example, if we take this cell, this cell is nine G nine is the intersection
between column G and row nine.
And this is our cell here, C, G, nine.
And if you go to netbooks, you can find its name.
OK, this is about cell index.
Until then, also, you can navigate cell by using arrow down, right, left, up and so on.
Also you can use scroll bars, horizontal scrollbar and vertical scrollbar.
Also you can get the end of the sheet by using control arrow controlled, owned or controlled.
Right.
OK.
Controlled or controlled, right?
Like this.
If I want to get that last caller, just press control, right, and if you want to get the last through,
just press control.
Now, this is the boundaries of our seat.
This is the last column and this is the last row.
And all these are so OK.
Can select few good line two to view the great lines of cells.
OK, ok.
This is all I can select.
I can navigate the cell by using arrow.
Up lift.
Right down, up and down, if I want to get back to our shit area, original sheet area, just press
control left and control up from Arrow and this is our sheet, OK, if you want to remove grid lines
from view on a check to get line and this is our sheet, OK?
Also, if you want to select all cells, all cells in this worksheet, just press here.
So now you are select all the cells in this sheet.
Let's make an simbel experiment.
Right.
Click, Gobbi, make a new sheet and right.
Click based all these cells.
So this is all the cell here in our template sheet.
OK, ok.
Let's summarize this literature we have discussed that our body is consists of a group of cells, also
Microsoft Excel, as consisting of a group of cells.
Also, we have discussed the cell index and cell index consists of two terms column index and row index,
for example, C five is consists of C and five.
C is a colon index and five is an index.
Also, a cell is just the intersection between a colon and arrow and you can check its name from name
box.
Moreover, you can navigate the navigate between cells using arrow forward, backward, up and down
and so on.
Also, you can use crowbars to navigate the cell.
You can use control arrows to get the boundary of your sheet and to get the last column in your sheet
and last row in your sheet.
Also, if you want to select all cells in the sheet, just select here to select all the cell.
For the next lecture, we will discuss how to enter a value to the cell, to use the cell and to make
the cell in action.
OK.
This is our summary.
Thank you and see you in the next lecture.