Module 2 - End of Module Project 1 #part2
Description
In this video we'll be covering following steps:
- Copy the formatting of the merged cell in the range A7:A9, then paste the formatting in the range A10:A18 to create three more merged cells.
- In the range B7:B18, apply the Percentage number format with two decimal places, then copy this format to the range D7:D18.
- In the range C7:C18, apply the Number number format, then increase the decimals to show three decimal places.
- Change the background color of the range A7:D9 to Green, Accent 6, Lighter 80% (10th column, 2nd row of the Theme Colors palette).
- Copy the formatting of the range A7:D9, then paste the formatting in the range A13:D15.
- In the range A6:D18, add a border around all cells using the All Borders option. Buy us a coffee: https://www.buymeacoffee.com/taandar ---
Disclaimer: This video is intended for educational purposes only. The purpose of this video is to help students understand how to solve problems in the Cengage business spreadsheet course. However, please note that any attempt to copy or replicate the solutions shown in this video may be considered a violation of academic integrity policies at your college or university. We strongly encourage you to use this video as a guide and to complete the assignments on your own, without resorting to cheating or plagiarism. We are not responsible for any consequences that may result from the use of this video in violation of academic integrity policies.
Transcript
1 00:00:00,060 --> 00:00:04,140 now let's have continuing from this type
2 00:00:01,979 --> 00:00:07,020 6 it is saying copy the formatting of
3 00:00:04,140 --> 00:00:10,019 the most cell in the range A7 through A9
4 00:00:07,020 --> 00:00:12,200 so this is a seven through A9 then paste
5 00:00:10,019 --> 00:00:15,780 the formatting in the range 18 through a
6 00:00:12,200 --> 00:00:18,420 18. so let's just copy it Ctrl C or you
7 00:00:15,780 --> 00:00:22,680 can right click and hit copy and then
8 00:00:18,420 --> 00:00:25,740 drag from cell 10 to 18 and then right
9 00:00:22,680 --> 00:00:28,140 click and then paste options
10 00:00:25,740 --> 00:00:29,820 and then here you can hover and it will
11 00:00:28,140 --> 00:00:33,120 say formatting so we just want
12 00:00:29,820 --> 00:00:36,600 formatting so just click there and it
13 00:00:33,120 --> 00:00:39,360 will just copy the formatting so step
14 00:00:36,600 --> 00:00:42,300 6 is done in the range B7 through B18
15 00:00:39,360 --> 00:00:48,140 apply the percentage number format with
16 00:00:42,300 --> 00:00:48,140 two decimal prices so B7 through B18
17 00:00:48,420 --> 00:00:54,600 resistive it escape to remove this so
18 00:00:51,120 --> 00:00:56,460 this is not B7 through B18 and we shall
19 00:00:54,600 --> 00:00:59,039 convert this into the percentage format
20 00:00:56,460 --> 00:01:01,559 so let's just see this icon in the
21 00:00:59,039 --> 00:01:03,480 numbers group and then find the
22 00:01:01,559 --> 00:01:05,760 percentage and it is saying two decimal
23 00:01:03,480 --> 00:01:07,460 places so this is just good so let's
24 00:01:05,760 --> 00:01:11,100 just hit OK
25 00:01:07,460 --> 00:01:13,439 and then after that is it is saying
26 00:01:11,100 --> 00:01:15,900 oh step seven
27 00:01:13,439 --> 00:01:20,759 uh then copy this format to the range
28 00:01:15,900 --> 00:01:26,880 d17 D7 through the 18 so let's just copy
29 00:01:20,759 --> 00:01:29,640 it Ctrl C and then D7 through d18
30 00:01:26,880 --> 00:01:31,020 and then right click and then paste just
31 00:01:29,640 --> 00:01:33,360 the format
32 00:01:31,020 --> 00:01:34,880 so this is done hit escape to remove
33 00:01:33,360 --> 00:01:38,939 this
34 00:01:34,880 --> 00:01:41,460 it is in the top right top left of the
35 00:01:38,939 --> 00:01:44,159 keyboard so in the number 8 it is saying
36 00:01:41,460 --> 00:01:46,259 in the range C7 through c18 apply the
37 00:01:44,159 --> 00:01:48,540 number of number format then increase
38 00:01:46,259 --> 00:01:53,280 the decimal to show three decimal places
39 00:01:48,540 --> 00:01:57,060 so C7 through C7 c18
40 00:01:53,280 --> 00:02:01,259 so C7 through
41 00:01:57,060 --> 00:02:02,520 C7 through C8 in the selected all and
42 00:02:01,259 --> 00:02:04,320 then
43 00:02:02,520 --> 00:02:07,140 here
44 00:02:04,320 --> 00:02:09,660 if there should be a number and it is
45 00:02:07,140 --> 00:02:12,480 saying three decimal format so click
46 00:02:09,660 --> 00:02:15,060 three and then click ok so this is done
47 00:02:12,480 --> 00:02:17,640 and in number nine it is saying change
48 00:02:15,060 --> 00:02:19,080 the pattern color of the range is 7
49 00:02:17,640 --> 00:02:23,940 through D9
50 00:02:19,080 --> 00:02:27,120 so the A7 through D9 and green accent 6
51 00:02:23,940 --> 00:02:29,160 lighter eighty percent and it is in 10th
52 00:02:27,120 --> 00:02:31,280 column second row let's see if that
53 00:02:29,160 --> 00:02:35,340 matches or not
54 00:02:31,280 --> 00:02:39,599 so three six in the tenth column we have
55 00:02:35,340 --> 00:02:42,180 run what and so in some case it couldn't
56 00:02:39,599 --> 00:02:45,060 match it I I'm not sure like I actually
57 00:02:42,180 --> 00:02:47,340 keep shuffling this position so just
58 00:02:45,060 --> 00:02:50,580 focus on the focus on this information
59 00:02:47,340 --> 00:02:52,879 it is saying green accent 6 lighter 80
60 00:02:50,580 --> 00:02:52,879 percent
61 00:02:52,920 --> 00:02:58,620 so
62 00:02:54,060 --> 00:03:02,540 whoops so click here and then green
63 00:02:58,620 --> 00:03:05,280 and lighter 80 percent
64 00:03:02,540 --> 00:03:08,160 so the percentage
65 00:03:05,280 --> 00:03:11,040 so yeah this is the required one green
66 00:03:08,160 --> 00:03:13,140 lighter 80 percent
67 00:03:11,040 --> 00:03:15,959 after that copy the formatting of the
68 00:03:13,140 --> 00:03:19,700 range A7 through T9
69 00:03:15,959 --> 00:03:19,700 so let's just
70 00:03:19,920 --> 00:03:24,120 copy it
71 00:03:21,420 --> 00:03:27,300 and then paste the formatting in the
72 00:03:24,120 --> 00:03:30,780 range a13 through D15
73 00:03:27,300 --> 00:03:34,260 so a 13 through D15 right click and here
74 00:03:30,780 --> 00:03:36,840 is the best formatting now that hit
75 00:03:34,260 --> 00:03:38,120 Escape after that it is saying in the
76 00:03:36,840 --> 00:03:41,819 range
77 00:03:38,120 --> 00:03:45,599 A6 to the 18 and the border around all
78 00:03:41,819 --> 00:03:47,220 cell using all border options so Asic
79 00:03:45,599 --> 00:03:52,040 through d18
80 00:03:47,220 --> 00:03:55,319 so A6 and the 18 add border
81 00:03:52,040 --> 00:03:58,440 using all products options
82 00:03:55,319 --> 00:04:01,799 so here is the all borders option
83 00:03:58,440 --> 00:04:05,659 oh here is the algorithms option
84 00:04:01,799 --> 00:04:05,659 so all borders
85 00:04:08,519 --> 00:04:13,379 and then switch to the money market
86 00:04:10,500 --> 00:04:15,980 worksheet so these four steps we will do
87 00:04:13,379 --> 00:04:15,980 in next video
