Module 4 - SAM Project 1a #part1
Description
We've covered following topics:
- Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to apply a function to calculate the potential monthly and yearly costs to the city of different bond scenarios.
Switch to the Spending worksheet. In the range E5:E10, add Conditional Formatting to show Solid Blue Data Bars. 2. In the range F5:F10, add Line sparklines based on the data in the range B5:E10. 3. Apply the Blue, Accent 1, Darker 25% (5th column, 5th row in the Theme Colors palette) sparkline color to the range F5:F10.
#sam #spreadsheet #excel 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,299 --> 00:00:05,279 this video we'll be covering from step
2 00:00:02,159 --> 00:00:06,720 one through three so switch to the
3 00:00:05,279 --> 00:00:09,240 spending worksheet we are on the same
4 00:00:06,720 --> 00:00:11,700 worksheet in the range A5 through 18 and
5 00:00:09,240 --> 00:00:14,040 conditional formatting too slow to show
6 00:00:11,700 --> 00:00:16,440 solid blue data bars
7 00:00:14,040 --> 00:00:18,900 so if I am through E10
8 00:00:16,440 --> 00:00:21,260 let's select E5 through E10 and then
9 00:00:18,900 --> 00:00:23,699 conditional formatting using Home tab
10 00:00:21,260 --> 00:00:26,039 conditional formatting and then data
11 00:00:23,699 --> 00:00:27,779 bars and then in solid fill and then
12 00:00:26,039 --> 00:00:30,300 here is blue data bar so this is our
13 00:00:27,779 --> 00:00:33,780 required bar
14 00:00:30,300 --> 00:00:36,300 so in Step 2 in the range you have 5 3
15 00:00:33,780 --> 00:00:38,520 F10 so F five three I have 10 add this
16 00:00:36,300 --> 00:00:40,340 pipeline based on the runs the range V5
17 00:00:38,520 --> 00:00:45,000 through E10
18 00:00:40,340 --> 00:00:49,500 so you have five through F10 and then B5
19 00:00:45,000 --> 00:00:52,140 to be releasing insert spark lines right
20 00:00:49,500 --> 00:00:54,800 yeah line is power class based on the B5
21 00:00:52,140 --> 00:00:56,539 through E10
22 00:00:54,800 --> 00:00:59,100 so
23 00:00:56,539 --> 00:01:02,160 where is this pipeline so you can search
24 00:00:59,100 --> 00:01:03,840 from this this Source action uh and you
25 00:01:02,160 --> 00:01:06,060 can just type Linux pipeline if it will
26 00:01:03,840 --> 00:01:08,000 appear here or you can just go to insert
27 00:01:06,060 --> 00:01:12,479 and then here is the line sparkline
28 00:01:08,000 --> 00:01:14,119 interesting V5 through E10 and they need
29 00:01:12,479 --> 00:01:17,460 in the
30 00:01:14,119 --> 00:01:20,939 so B5 through ethane and then apply blue
31 00:01:17,460 --> 00:01:23,759 accent 1 dark 25 percent Spike line
32 00:01:20,939 --> 00:01:26,100 color so
33 00:01:23,759 --> 00:01:28,619 yeah here is this pipeline color and
34 00:01:26,100 --> 00:01:31,560 blue accent one
35 00:01:28,619 --> 00:01:33,119 so the reaction dark at 25 percent
36 00:01:31,560 --> 00:01:34,619 yeah this is the driver you can just
37 00:01:33,119 --> 00:01:36,479 hover over it and you will give the
38 00:01:34,619 --> 00:01:39,600 information or you can go through the
39 00:01:36,479 --> 00:01:42,060 fifth column feed through like that way
40 00:01:39,600 --> 00:01:43,619 so this is our required color so that's
41 00:01:42,060 --> 00:01:46,880 it for the video we will continue from
42 00:01:43,619 --> 00:01:46,880 this step for in the next video
