Module 1 - End of Module Project 1 | #Part1

1 00:00:00,000 --> 00:00:03,720 all right so this is the question of

2 00:00:01,680 --> 00:00:05,580 module one so in this video we will

3 00:00:03,720 --> 00:00:08,460 cover the question number one through

4 00:00:05,580 --> 00:00:11,160 five so in question number one it is

5 00:00:08,460 --> 00:00:13,139 saying uh begin on the project worksheet

6 00:00:11,160 --> 00:00:15,780 so we are on the Project's worksheet by

7 00:00:13,139 --> 00:00:19,320 increasing the font size of range A2 to

8 00:00:15,780 --> 00:00:22,740 A3 to 12 points so

9 00:00:19,320 --> 00:00:24,660 A2 and A3 solids selected I just I just

10 00:00:22,740 --> 00:00:26,840 click here and hold my mouse and drag

11 00:00:24,660 --> 00:00:30,060 here so it will select both

12 00:00:26,840 --> 00:00:31,140 so let's maximize it and it will sync 12

13 00:00:30,060 --> 00:00:33,840 points

14 00:00:31,140 --> 00:00:35,760 so this is increased now let's go to

15 00:00:33,840 --> 00:00:38,460 number two when it is saying enter the

16 00:00:35,760 --> 00:00:40,200 values shown in table one and to the

17 00:00:38,460 --> 00:00:43,739 corresponding cell in the range B A

18 00:00:40,200 --> 00:00:48,420 through C Level so B8 through C11 we

19 00:00:43,739 --> 00:00:50,879 should so let's just copy it Ctrl C Ctrl

20 00:00:48,420 --> 00:00:52,440 B so here is the problem see if we do

21 00:00:50,879 --> 00:00:54,539 like this then the style will be

22 00:00:52,440 --> 00:00:56,160 interrupted and if we submit this

23 00:00:54,539 --> 00:00:58,559 project then it might not meet the

24 00:00:56,160 --> 00:01:00,600 requirement so what we should do instead

25 00:00:58,559 --> 00:01:03,180 is

26 00:01:00,600 --> 00:01:05,760 we can just click here in the status bar

27 00:01:03,180 --> 00:01:08,460 or whatever is this so let's just paste

28 00:01:05,760 --> 00:01:10,680 here ctrlv and then it will preserve our

29 00:01:08,460 --> 00:01:14,040 style

30 00:01:10,680 --> 00:01:16,460 and so let's just copy this and then

31 00:01:14,040 --> 00:01:16,460 click here

32 00:01:16,490 --> 00:01:19,550 [Music]

33 00:01:21,060 --> 00:01:28,140 and here is 2018

34 00:01:25,380 --> 00:01:31,040 and 2020

35 00:01:28,140 --> 00:01:35,220 2021

36 00:01:31,040 --> 00:01:37,140 2021 all right so what is this saying is

37 00:01:35,220 --> 00:01:38,820 the address the width of the column B

38 00:01:37,140 --> 00:01:41,280 using autofit okay

39 00:01:38,820 --> 00:01:43,860 so for this we have multiple way of

40 00:01:41,280 --> 00:01:46,619 doing this we can also double click here

41 00:01:43,860 --> 00:01:49,740 and it will automatically address its

42 00:01:46,619 --> 00:01:51,740 width using autofit so let's undo that I

43 00:01:49,740 --> 00:01:54,540 just click Ctrl G

44 00:01:51,740 --> 00:01:56,700 so another way of doing is you just

45 00:01:54,540 --> 00:01:59,579 click in the in here and it will select

46 00:01:56,700 --> 00:02:02,100 all this row and just search

47 00:01:59,579 --> 00:02:04,100 or two feet and just click Auto hit

48 00:02:02,100 --> 00:02:08,160 selection and it will out of it

49 00:02:04,100 --> 00:02:11,220 so this is done in cell E6 enter the

50 00:02:08,160 --> 00:02:14,540 following so let's in copy this and then

51 00:02:11,220 --> 00:02:17,340 E6 and then paste in this status bar

52 00:02:14,540 --> 00:02:19,980 okay when it is saying select the range

53 00:02:17,340 --> 00:02:22,800 E6 through E11 then use the Flash Fill

54 00:02:19,980 --> 00:02:25,020 button which is in the editing group on

55 00:02:22,800 --> 00:02:27,120 the Home tab so automatically enter code

56 00:02:25,020 --> 00:02:29,300 in the remaining cell uh you must use

57 00:02:27,120 --> 00:02:32,640 plus field okay

58 00:02:29,300 --> 00:02:35,520 which is in the editing group

59 00:02:32,640 --> 00:02:37,980 uh we we still is it such thing to

60 00:02:35,520 --> 00:02:43,140 select e6311

61 00:02:37,980 --> 00:02:46,140 all right E6 through E11 and in the

62 00:02:43,140 --> 00:02:48,180 editing group there is a flash field

63 00:02:46,140 --> 00:02:50,940 option so let's click on the maps class

64 00:02:48,180 --> 00:02:52,800 field and it automatically entered fill

65 00:02:50,940 --> 00:02:55,560 the code

66 00:02:52,800 --> 00:02:57,780 so let's go to Next Step hide column C

67 00:02:55,560 --> 00:03:00,360 so this is the easy step just click on

68 00:02:57,780 --> 00:03:03,420 the heading of the

69 00:03:00,360 --> 00:03:05,400 column C oh I I thought I should Row in

70 00:03:03,420 --> 00:03:07,980 the previous for this so this this is

71 00:03:05,400 --> 00:03:10,260 the column and then this this section is

72 00:03:07,980 --> 00:03:14,760 the row this is row and this is column

73 00:03:10,260 --> 00:03:17,040 all right so it is saying hide column C

74 00:03:14,760 --> 00:03:19,019 now here must be the head outside here

75 00:03:17,040 --> 00:03:21,959 is it so hide

76 00:03:19,019 --> 00:03:25,400 so this is done so we will continue from

77 00:03:21,959 --> 00:03:25,400 the next step in next video