Module 3 - SAM Project 1a #part2
Description
Questions covered: 9. Switch to the Profit Projections worksheet. In cell H5, use the TODAY function to insert the current date. 10. In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells H5 and H6. Leave the Holidays argument blank. 11. Use the values in the range B12:C12 to extend the incremented percentages to the range D12:H12. 12. Use the values in the range A13:A14 to extend the list of years to the range A15:A17. 13. In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from cell B6 and then multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13. 14. In cell B14, create a formula without using a function that adds 1 to the value in cell B12 and then multiplies the result by the value in cell B13. In this formula, use a mixed reference for cell B12 by including an absolute reference to row 12. Copy the formula from cell B14 to the range B15:B17 and then copy the formulas from the range B14:B17 to the range C14:H17. 15. Delete row 19.
#cengage #solutions #sam #excel ---
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,000 --> 00:00:04,380 all right continuing from this step 9 it
2 00:00:02,340 --> 00:00:07,560 is saying switch to the pro feed
3 00:00:04,380 --> 00:00:10,980 projection worksheet so just click here
4 00:00:07,560 --> 00:00:12,840 in sale ads 5 use today function to
5 00:00:10,980 --> 00:00:15,299 insert the content so to enter function
6 00:00:12,840 --> 00:00:17,100 will restart with equals to sign and
7 00:00:15,299 --> 00:00:19,440 then today and then open parenthesis
8 00:00:17,100 --> 00:00:23,100 close parenthesis and then enter
9 00:00:19,440 --> 00:00:25,380 so step 9 is done now step 10 in cell S7
10 00:00:23,100 --> 00:00:28,140 so at 7
11 00:00:25,380 --> 00:00:32,040 create a formula that uses Network days
12 00:00:28,140 --> 00:00:33,600 functions so Network days and then to
13 00:00:32,040 --> 00:00:36,660 calculate the number of working days
14 00:00:33,600 --> 00:00:39,180 between the tits in S5 and S6
15 00:00:36,660 --> 00:00:41,820 so as 5
16 00:00:39,180 --> 00:00:42,840 as 5 is the current date so this is the
17 00:00:41,820 --> 00:00:46,020 starting date
18 00:00:42,840 --> 00:00:47,940 and then add six okay
19 00:00:46,020 --> 00:00:50,280 and then it is saying leave over it is
20 00:00:47,940 --> 00:00:52,620 argument blank so reduce is optional so
21 00:00:50,280 --> 00:00:54,719 we can just do close parenthesis and
22 00:00:52,620 --> 00:00:57,180 then hit enter
23 00:00:54,719 --> 00:01:01,079 after that it is saying use the value in
24 00:00:57,180 --> 00:01:03,840 the range B12 through C12 so B12 through
25 00:01:01,079 --> 00:01:05,159 C12 to extend the incremented percentage
26 00:01:03,840 --> 00:01:08,460 to the range
27 00:01:05,159 --> 00:01:13,140 D12 through S12 so just go to the kernel
28 00:01:08,460 --> 00:01:13,140 and then drag it until S12
29 00:01:13,159 --> 00:01:17,520 citizen
30 00:01:14,760 --> 00:01:21,900 use the value in the range a13 through
31 00:01:17,520 --> 00:01:25,439 A14 so same thing a 13 through 4 A14 to
32 00:01:21,900 --> 00:01:27,540 extend up to a 15 through a 17 so go to
33 00:01:25,439 --> 00:01:30,140 the corner plus sign up here and then
34 00:01:27,540 --> 00:01:30,140 drag it
35 00:01:30,180 --> 00:01:35,640 in cell B13 so B13
36 00:01:33,780 --> 00:01:38,220 it is saying create a formula of the
37 00:01:35,640 --> 00:01:40,320 formula means equals to sign so start
38 00:01:38,220 --> 00:01:43,979 with equals design without using a
39 00:01:40,320 --> 00:01:46,979 functions we are in this step so in B13
40 00:01:43,979 --> 00:01:49,799 create a formula without usually using a
41 00:01:46,979 --> 00:01:52,500 function okay uh
42 00:01:49,799 --> 00:01:57,299 using absolute reference that subtracts
43 00:01:52,500 --> 00:01:59,640 the value of shell V5 and V7 from B6 so
44 00:01:57,299 --> 00:02:02,820 from B6 means we should enter B6 first
45 00:01:59,640 --> 00:02:07,799 and then subtract and then it is saying
46 00:02:02,820 --> 00:02:10,380 P5 and B7 so B5 plus B7 and then it is
47 00:02:07,799 --> 00:02:16,140 saying and then multiply the result
48 00:02:10,380 --> 00:02:19,680 and by B8 so B8 let's just wrap it
49 00:02:16,140 --> 00:02:21,360 so we get the result and then multiply
50 00:02:19,680 --> 00:02:23,640 it by V8
51 00:02:21,360 --> 00:02:26,160 so it is saying using absolute reference
52 00:02:23,640 --> 00:02:28,800 so for absolutions just double click
53 00:02:26,160 --> 00:02:31,440 here and then click on F4 or you can
54 00:02:28,800 --> 00:02:34,440 just wrap it with dollar sign
55 00:02:31,440 --> 00:02:34,440 foreign
56 00:02:36,239 --> 00:02:42,420 and then hit enter
57 00:02:38,879 --> 00:02:46,080 now copy the formula from cell B13
58 00:02:42,420 --> 00:02:48,239 to range up to s13 so
59 00:02:46,080 --> 00:02:49,080 again same thing go to the corner and
60 00:02:48,239 --> 00:02:52,200 then
61 00:02:49,080 --> 00:02:54,599 drag it up to s13 so same value will
62 00:02:52,200 --> 00:02:56,700 appear because everything is absolute so
63 00:02:54,599 --> 00:03:00,720 it will remain constant
64 00:02:56,700 --> 00:03:02,760 now in cell b14
65 00:03:00,720 --> 00:03:05,160 so be fitting create a formula without
66 00:03:02,760 --> 00:03:08,580 using a function so formula is usually
67 00:03:05,160 --> 00:03:13,140 start with equals to sign that adds 1 to
68 00:03:08,580 --> 00:03:15,360 the value in cell B12 so B12 plus 1 and
69 00:03:13,140 --> 00:03:16,379 then multiply the result so let's wrap
70 00:03:15,360 --> 00:03:19,700 it
71 00:03:16,379 --> 00:03:19,700 in the parenthesis
72 00:03:20,280 --> 00:03:26,519 and then it is saying then multiply the
73 00:03:22,920 --> 00:03:28,860 result by this value in cell p13
74 00:03:26,519 --> 00:03:30,959 in this formula use the mixed reference
75 00:03:28,860 --> 00:03:33,599 for B12
76 00:03:30,959 --> 00:03:36,480 we have visual by including an absolute
77 00:03:33,599 --> 00:03:38,459 reference to row 12. so this time we
78 00:03:36,480 --> 00:03:40,319 just need to enter dollar sign ahead of
79 00:03:38,459 --> 00:03:43,680 the row 12
80 00:03:40,319 --> 00:03:45,500 and copy the formula so it is done hit
81 00:03:43,680 --> 00:03:49,620 enter
82 00:03:45,500 --> 00:03:53,159 now copy the formula from cell b14 to
83 00:03:49,620 --> 00:03:57,060 range B15 through B17
84 00:03:53,159 --> 00:03:59,280 so B15 through B17
85 00:03:57,060 --> 00:04:02,299 this time the value is value will change
86 00:03:59,280 --> 00:04:05,340 because only rho is constant
87 00:04:02,299 --> 00:04:08,819 after that it is saying this will be 14
88 00:04:05,340 --> 00:04:11,400 through B17 this is done and the range C
89 00:04:08,819 --> 00:04:14,400 14 through S 17.
90 00:04:11,400 --> 00:04:14,400 so
91 00:04:14,879 --> 00:04:20,459 let's select it and then it is saying
92 00:04:17,639 --> 00:04:23,639 c14 through s17
93 00:04:20,459 --> 00:04:26,639 so drag it until s17
94 00:04:23,639 --> 00:04:29,520 all right this is done everything and
95 00:04:26,639 --> 00:04:33,360 delete row 19 so just click here right
96 00:04:29,520 --> 00:04:36,740 click and then delete
97 00:04:33,360 --> 00:04:36,740 so let's check our result
98 00:04:37,080 --> 00:04:42,960 and notice here the this this value is
99 00:04:41,280 --> 00:04:45,000 different because its current rate is
100 00:04:42,960 --> 00:04:47,880 different but its formatting is quite
101 00:04:45,000 --> 00:04:50,759 different here we have 2023 but it has
102 00:04:47,880 --> 00:04:53,699 only 18 so let's just quick convert it
103 00:04:50,759 --> 00:04:57,000 into the same format
104 00:04:53,699 --> 00:04:57,780 so just click here and then here is the
105 00:04:57,000 --> 00:05:01,199 numbers
106 00:04:57,780 --> 00:05:04,080 or you can just click this both cell and
107 00:05:01,199 --> 00:05:06,540 then go to numbers and then date and for
108 00:05:04,080 --> 00:05:09,060 date we want this format
109 00:05:06,540 --> 00:05:11,160 so hit okay
110 00:05:09,060 --> 00:05:14,720 so again let's take it again
111 00:05:11,160 --> 00:05:14,720 so this is done
