1 00:00:13,600 --> 00:00:15,010 Hi, everyone, and welcome again. 2 00:00:16,150 --> 00:00:25,690 Today's lecture is about cell concept, the objectives or cell concept, cell navigation and cell selection. 3 00:00:27,430 --> 00:00:34,510 Like our human body, human body consists of group of cells, cell for brains, cells for blood cells, 4 00:00:34,510 --> 00:00:39,880 for heart cells, for muscles, cells for kidney stones, for liver, and so on. 5 00:00:40,840 --> 00:00:48,730 Macross of the Cell also consists of group of cells and these cells formulate Excel sheet. 6 00:00:50,120 --> 00:01:01,210 So our Microsoft Excel consists of a group of rows and group of columns and each intersection column 7 00:01:01,360 --> 00:01:03,450 with row a row with a column. 8 00:01:03,520 --> 00:01:04,320 There is a cell. 9 00:01:05,410 --> 00:01:17,980 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 10 00:01:17,980 --> 00:01:19,870 five is a cell index. 11 00:01:20,680 --> 00:01:26,230 So every cell in Microsoft Excel consists of two elements. 12 00:01:26,540 --> 00:01:32,170 The first element is column index and second element is no index. 13 00:01:32,440 --> 00:01:37,540 Let's go practically to our Microsoft Excel sheet, for example. 14 00:01:38,500 --> 00:01:41,710 This is C five here, so. 15 00:01:42,980 --> 00:01:52,640 If you check the name books, you will find C five, C five is the name of the cell and this is the 16 00:01:52,640 --> 00:01:58,250 intersection between Colon C and RO five. 17 00:01:58,910 --> 00:02:04,010 So this intersection formulate C five. 18 00:02:05,750 --> 00:02:16,340 So, OK, let's take another example, if we take this cell, this cell is nine G nine is the intersection 19 00:02:16,340 --> 00:02:21,550 between column G and row nine. 20 00:02:22,250 --> 00:02:27,340 And this is our cell here, C, G, nine. 21 00:02:27,830 --> 00:02:31,960 And if you go to netbooks, you can find its name. 22 00:02:32,150 --> 00:02:35,250 OK, this is about cell index. 23 00:02:35,360 --> 00:02:46,060 Until then, also, you can navigate cell by using arrow down, right, left, up and so on. 24 00:02:46,760 --> 00:02:53,900 Also you can use scroll bars, horizontal scrollbar and vertical scrollbar. 25 00:02:55,070 --> 00:03:03,650 Also you can get the end of the sheet by using control arrow controlled, owned or controlled. 26 00:03:04,910 --> 00:03:05,530 Right. 27 00:03:05,540 --> 00:03:06,010 OK. 28 00:03:07,170 --> 00:03:10,430 Controlled or controlled, right? 29 00:03:13,040 --> 00:03:13,610 Like this. 30 00:03:15,630 --> 00:03:24,630 If I want to get that last caller, just press control, right, and if you want to get the last through, 31 00:03:24,780 --> 00:03:26,720 just press control. 32 00:03:26,890 --> 00:03:30,990 Now, this is the boundaries of our seat. 33 00:03:31,440 --> 00:03:36,060 This is the last column and this is the last row. 34 00:03:36,540 --> 00:03:39,400 And all these are so OK. 35 00:03:40,800 --> 00:03:47,950 Can select few good line two to view the great lines of cells. 36 00:03:48,060 --> 00:03:49,290 OK, ok. 37 00:03:49,900 --> 00:03:51,270 This is all I can select. 38 00:03:51,660 --> 00:03:55,200 I can navigate the cell by using arrow. 39 00:03:58,260 --> 00:04:00,750 Up lift. 40 00:04:01,600 --> 00:04:11,530 Right down, up and down, if I want to get back to our shit area, original sheet area, just press 41 00:04:11,530 --> 00:04:22,810 control left and control up from Arrow and this is our sheet, OK, if you want to remove grid lines 42 00:04:23,200 --> 00:04:29,530 from view on a check to get line and this is our sheet, OK? 43 00:04:32,580 --> 00:04:41,890 Also, if you want to select all cells, all cells in this worksheet, just press here. 44 00:04:43,140 --> 00:04:50,050 So now you are select all the cells in this sheet. 45 00:04:50,730 --> 00:04:53,190 Let's make an simbel experiment. 46 00:04:53,860 --> 00:04:54,150 Right. 47 00:04:54,150 --> 00:04:59,580 Click, Gobbi, make a new sheet and right. 48 00:04:59,580 --> 00:05:02,180 Click based all these cells. 49 00:05:02,610 --> 00:05:07,350 So this is all the cell here in our template sheet. 50 00:05:07,460 --> 00:05:08,570 OK, ok. 51 00:05:11,180 --> 00:05:19,700 Let's summarize this literature we have discussed that our body is consists of a group of cells, also 52 00:05:19,700 --> 00:05:23,220 Microsoft Excel, as consisting of a group of cells. 53 00:05:23,920 --> 00:05:33,140 Also, we have discussed the cell index and cell index consists of two terms column index and row index, 54 00:05:33,140 --> 00:05:36,650 for example, C five is consists of C and five. 55 00:05:36,650 --> 00:05:40,100 C is a colon index and five is an index. 56 00:05:40,670 --> 00:05:50,600 Also, a cell is just the intersection between a colon and arrow and you can check its name from name 57 00:05:50,720 --> 00:05:51,250 box. 58 00:05:52,250 --> 00:06:03,230 Moreover, you can navigate the navigate between cells using arrow forward, backward, up and down 59 00:06:03,800 --> 00:06:04,550 and so on. 60 00:06:05,300 --> 00:06:09,550 Also, you can use crowbars to navigate the cell. 61 00:06:11,630 --> 00:06:17,840 You can use control arrows to get the boundary of your sheet and to get the last column in your sheet 62 00:06:17,840 --> 00:06:19,460 and last row in your sheet. 63 00:06:20,450 --> 00:06:28,640 Also, if you want to select all cells in the sheet, just select here to select all the cell. 64 00:06:30,510 --> 00:06:38,510 For the next lecture, we will discuss how to enter a value to the cell, to use the cell and to make 65 00:06:38,510 --> 00:06:40,010 the cell in action. 66 00:06:40,630 --> 00:06:41,030 OK. 67 00:06:45,260 --> 00:06:46,280 This is our summary. 68 00:06:48,080 --> 00:06:51,280 Thank you and see you in the next lecture.