Module 2 - End of Module Project 1 #part3
Description
In this video, we'll cover following steps:
- Switch to the Money Market worksheet. For the range A1:D1, merge and center the contents and apply the custom cell style FM Heading. For the range A2:D2, merge and center the contents and apply the custom style FM Subheading.
- Copy the content and formatting from the range A4:B4 in the Mortgage worksheet, then paste them on the range A4:B4 in the Money Market worksheet.
- To format the money market rate table, for the range B7:B11, apply the Currency number format with two decimal places, then repeat for the range C7:C10. For the range D7:D11, apply the Percentage number format with two decimal places.
- Change the tab color of the Mortgage worksheet to Purple (10th column of the Standard Colors palette). Change the tab color of the Money Market worksheet to Dark Red (1st column of the Standard Colors palette). 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:02,220 --> 00:00:06,299 all right so continuing from the step 12
2 00:00:04,620 --> 00:00:09,000 it is saying switch to money market
3 00:00:06,299 --> 00:00:12,480 worksheet so let's switch
4 00:00:09,000 --> 00:00:18,480 for example rails or further range A1
5 00:00:12,480 --> 00:00:20,160 through D1 so a 1 through T1 more than
6 00:00:18,480 --> 00:00:22,140 Center the content and apply the custom
7 00:00:20,160 --> 00:00:24,300 FM heading okay
8 00:00:22,140 --> 00:00:27,660 so first of all it's more than Center
9 00:00:24,300 --> 00:00:30,060 and then FM reading from the sales
10 00:00:27,660 --> 00:00:32,940 Styles all right
11 00:00:30,060 --> 00:00:37,020 after that it is saying for range A2
12 00:00:32,940 --> 00:00:39,600 through D2 so A2 through D2 margin
13 00:00:37,020 --> 00:00:42,840 Center contains and applies the custom
14 00:00:39,600 --> 00:00:45,540 style FM sub waiting so more than
15 00:00:42,840 --> 00:00:48,079 central silly style like a film
16 00:00:45,540 --> 00:00:48,079 sovereign
17 00:00:48,739 --> 00:00:54,480 copy the content and formatting from the
18 00:00:51,180 --> 00:00:59,520 range A4 through B4 in the mortgage
19 00:00:54,480 --> 00:01:01,860 worksheet so if 4 through B4 so let's
20 00:00:59,520 --> 00:01:05,519 hit Ctrl C or you can just right click
21 00:01:01,860 --> 00:01:07,560 and it click copy and then go to
22 00:01:05,519 --> 00:01:10,380 paste them on the Range A4 through
23 00:01:07,560 --> 00:01:13,740 before in the money market with it so A4
24 00:01:10,380 --> 00:01:15,360 through B4 you can see trlv or you can
25 00:01:13,740 --> 00:01:16,940 just right click right click and then
26 00:01:15,360 --> 00:01:17,460 hit paste
27 00:01:16,940 --> 00:01:18,240 [Music]
28 00:01:17,460 --> 00:01:20,340 um
29 00:01:18,240 --> 00:01:22,860 and then first name okay this is done to
30 00:01:20,340 --> 00:01:26,759 format the money market money market
31 00:01:22,860 --> 00:01:30,500 rate table further is B7 through b11 so
32 00:01:26,759 --> 00:01:33,900 B7 through b11
33 00:01:30,500 --> 00:01:35,820 V7 through b11
34 00:01:33,900 --> 00:01:39,060 um apply the correlation over permit
35 00:01:35,820 --> 00:01:43,100 with two decimal places so currency
36 00:01:39,060 --> 00:01:43,100 number format let's expand this
37 00:01:43,340 --> 00:01:51,540 with two decimal questions hit okay
38 00:01:47,479 --> 00:01:54,659 and then it is saying then repeat for
39 00:01:51,540 --> 00:01:58,439 the range C7 through shift tape so let's
40 00:01:54,659 --> 00:02:04,259 Ctrl C let's copy this and then C7
41 00:01:58,439 --> 00:02:08,940 through C10 so C7 through c c 10
42 00:02:04,259 --> 00:02:11,220 let's see 10 and then do right click and
43 00:02:08,940 --> 00:02:13,560 then for the paste don't just paste it
44 00:02:11,220 --> 00:02:17,420 but we just want to paste the formatting
45 00:02:13,560 --> 00:02:20,580 so let's control C and then paste
46 00:02:17,420 --> 00:02:24,260 formatting okay this is done and hit
47 00:02:20,580 --> 00:02:27,660 Escape key to remove to get rid of this
48 00:02:24,260 --> 00:02:32,040 uh then repeat the that is done further
49 00:02:27,660 --> 00:02:34,560 in D7 through d11 so D7 through d11
50 00:02:32,040 --> 00:02:37,980 apply the percentage number format with
51 00:02:34,560 --> 00:02:41,819 two decimal places so percentage number
52 00:02:37,980 --> 00:02:44,519 for weight percentage with 27 plus is it
53 00:02:41,819 --> 00:02:47,340 okay after that change the tab color of
54 00:02:44,519 --> 00:02:50,640 the mortgage worksheet to purple so
55 00:02:47,340 --> 00:02:52,800 mortgage worksheet just right click and
56 00:02:50,640 --> 00:02:55,920 then here is the Tapper it is saying
57 00:02:52,800 --> 00:02:59,040 purple tenth column
58 00:02:55,920 --> 00:03:01,680 so 10th column is the purple of the
59 00:02:59,040 --> 00:03:03,300 standard palette change the outlet
60 00:03:01,680 --> 00:03:04,860 this is done
61 00:03:03,300 --> 00:03:06,540 and then it is saying change the time
62 00:03:04,860 --> 00:03:09,900 color of the morning micro works it to
63 00:03:06,540 --> 00:03:12,659 dark red First Column of distance so
64 00:03:09,900 --> 00:03:15,239 dark red First Column let's overrun it
65 00:03:12,659 --> 00:03:16,440 and it will set the upgrade so just
66 00:03:15,239 --> 00:03:20,180 click here
67 00:03:16,440 --> 00:03:20,180 so this is it thank you
