sam capstone project 1a excel

View SAM Project Answer Keys

View the correct answers for SAM projects.

• Click SAM assignments .

• Click the file under Solution File to download it to your computer.
• Open the solution file.

Illustrated Excel 2016 Modules 5-8 – SAM Capstone Project 1a

• March 1, 2024
• Do my Online Course

Illustrated  Excel 2016 Modules | 5–8: SAM Capstone Project 1a

  Illustrated Excel 2016 | Modules 5–8: SAM Capstone Project 1a

Paterson Arts Center

mANAGING FORMULAS, DATA, AND TABLES

GETTING STARTED

· Open the file  IL_EX16_CS5-8a_ FirstLastName _1.xlsx , available for download from the SAM website.

· Save the file as  IL_EX16_CS5-8a_ FirstLastName _2.xlsx  by changing the “1” to a “2”.

2. If you do not see the  .xlsx  file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

· With the file  IL_EX16_CS5-8a_ FirstLastName _2.xlsx  still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

· If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

You are an intern at the Paterson Arts Center in Paterson, New Jersey, and work closely with Gwen Rayburn, the executive director of the center. Gwen is seeking a bank loan to expand the center. In preparation for meeting with a bank officer, she asked you to analyze data about the center’s group classes, lessons, and students, and to compare the terms and payments of three loan options.

Switch to the  Group Classes  worksheet, which Gwen has protected. Start by correcting data as follows:

a. Unprotect the worksheet.

b. In cell C9, change the value to  1:00 PM .

To reduce the chance of input error, Gwen wants you to make the Location column a dropdown list. Use data validation to create an in-cell dropdown list that restricts data in the Location column in the table (the range E4:E13) to the values  Basie Hall, Cassatt Studio, Chopin Room .

Unhide the  Students  worksheet to prepare for working with student data.

Gwen added her name to the footer in each worksheet and now wants to remove it. Use the Document Inspector to remove only footer information from the workbook. ( Hint : Do not save data when the dialog box appears.) [Mac Hint: The Document Inspector is not available on Excel for Mac, so manually remove all footers from the workbook.]

To organize the worksheets more logically, move the  Private Lessons  worksheet so it appears between the  Group Classes  and  Students  worksheet.

Display the full name of the arts center as a header on all the worksheets except the  Documentation  worksheet as follows:

c. Group the  Group Classes ,  Private Lessons ,  Students , and  Expansion  worksheets.

d. In cell A1, type  Paterson Arts Center  as the worksheet title.

e. With the worksheets still grouped, add the  Sheet Name  to the center header section.

Switch to Normal view, if necessary. Ungroup the worksheets.

To make it easier to navigate the workbook, add hyperlinks as follows:

f. In the  Group Classes  worksheet, add a hyperlink to the text in cell G16 that links to cell  A1  of the  Students  worksheet.

g. Include  View weekly revenue  as the ScreenTip text.

h. Copy the hyperlink from cell G16 in the  Group Classes  worksheet to cell G16 of the  Private Lessons  worksheet.

In the  Private Lessons  worksheet, use data validation to create an in-cell dropdown list that restricts data in the Location column in the table (the range E4:E13) to the values  Basie Hall, Chopin Room .

Gwen is adding two new private lessons on Saturdays and needs that reflected in the schedule.

In the ranges A14:G14 and A15:G15, add two records for the new private lessons using the data shown in Table 1 below. Use the in-cell dropdown list to enter the location information.

Table 1: Data for Private Lessons Worksheet Table

Gwen asks you to create a separate list of piano lessons on the  Private Lessons  worksheet. Create the list as follows:

i. Enter the text  Piano  into cell A18.

j. Using the range A17:A18 as the Criteria range, create an advanced filter that extracts records from the Lessons table in the List range A3:G15 to the range beginning in cell A20. Use the Copy to another location option.

Gwen asks you to create a worksheet showing the Monday group classes organized by the instructor name. Create this worksheet as follows:

k. Create a copy of the  Group Classes  worksheet and position it immediately before the  Students  worksheet.

l. Use  Monday Classes  as the name of the new worksheet.

m. In the  Monday Classes  worksheet, filter the Day column to display only Monday classes.

n. Sort the filtered table in ascending order by Instructor.

Switch to the  Students  worksheet. Gwen offers a $5.00 discount to repeat students. Apply this discount as appropriate to the student data as follows:

In cell H4, create a formula using the  IF  function and structured references to determine the correct amount paid based on the following criteria:

o. If the  Repeat?  value is  “Yes” , calculate the amount paid by subtracting  5  from the  Fee .

p. Otherwise, the amount paid is the  Fee  value.

q. Let Excel copy the formula in cell H4 into the range H5:H49.

r. Format the range H4:H49 using the  Currency  number format with  zero  decimal places and the  $  symbol.

Gwen created an area for retrieving information from the Students table, but it needs to be filled in. In cell K4, enter a formula using the  VLOOKUP  function and structured references to retrieve the class name as follows:

s. Look up the value in cell  K3 .

t. Use the Class Code and Class Name columns in the Students table ( Students[[Class Code]:[Class Name]] ) as the table_array argument.

u. Return the corresponding class name shown in column  2  of the specified columns.

v. Use  FALSE  as the range_lookup value.

In cell J6, enter a formula using the  VLOOKUP  function and structured references to retrieve the instructor’s name as follows:

w. Look up the value in cell  K3 .

x. Use the Class Code through Instructor columns in the Students table ( Students[[Class Code]:[Instructor]] ) as the table_array argument.

y. Return the corresponding class name shown in column  3  of the specified columns.

z. Use  FALSE  as the range_lookup value.

In cell K7, enter a formula using the  DSUM  function and structured references to calculate the total amount paid for a specified instructor as follows:

aa. Use the entire Students table including the header row ( Students[#All] ) as the database argument.

ab. Use the  Amount Paid  header in cell H3 as the field argument.

ac. Use the range  J5:J6  as the criteria.

In cell K8, enter a formula using the  DCOUNTA  function and structured references to count the number of classes taught by a specified instructor as follows:

ad. Use the entire Students table including the header row ( Students[#All] ) as the database argument.

ae. Use the  Class Code  header in cell C3 as the field argument.

af. Use the range  J5:J6  as the criteria.

In her meeting with the bank officer, Gwen wants to show how much revenue the center receives for each class in a typical week. Create a copy of the  Students  worksheet and then modify it to prepare for showing this information as follows:

ag. Create a copy of the  Students  worksheet and position it immediately before the  Expansion  worksheet.

ah. Use  Subtotals  as the name of the new worksheet.

ai. On the  Subtotals  worksheet, clear the contents and formatting from the range J3:K8.

aj. Sort the table on the  Subtotals  worksheet in ascending order by class name.

ak. Apply the  Table Style Medium 6  table style. ( Hint : Depending on your version of Office, the table style may be written as Gold, Table Style Medium 6.)

al. Convert the table to a range.

Include subtotals on the  Subtotals  worksheet as follows:

am. Add subtotals to the range A3:H49 so that for each change in the  Class Name  value, the formula uses the  Sum  function to add subtotals to the  Amount Paid  field. Use the default settings for the bottom checkboxes.

an. Use the outline buttons to display only the Class Name values with subtotals and the grand total.

Verify the grand total by switching to the  Students  worksheet and then adding a Total row to the Students table.

Switch to the  Expansion  worksheet. Gwen wants to expand the arts center into the adjoining vacant office space, and then renovate the new space. On the  Expansion  worksheet, she asks you to help her analyze the loan options to expand the business. Begin by determining the monthly payments as follows:

ao. In cell B9, enter a formula using the  PMT  function to calculate the monthly payment using the loan information in the range B5:B7.

ap. In the formula, divide the rate (cell  B6 ) by  12 .

aq. Use the term in months (cell  B7 ) as the nper.

ar. Use a negative value for the pv (cell  B5 ).

as. Copy the formula from cell B9 into the range C9:D9.

Calculate the total payments as follows:

at. In cell B10, enter a formula without using a function that multiplies the monthly payments (cell  B9 ) by the term in months (cell  B7 ) for Loan Option 1.

au. Copy the formula from cell B10 into the range C10:D10.

Calculate the total interest as follows:

av. In cell B11, enter a formula without using a function that subtracts the loan amount (cell  B5 ) from the total payments (cell  B10 ) for Loan Option 1.

aw. Copy the formula from cell B11 into the range C11:D11.

Your workbook should look like the Final Figures below. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Group Classes Worksheet

Final Figure 2: Private Lessons Worksheet

Final Figure 3: Monday Classes Worksheet

Final Figure 4: Students Worksheet

Final Figure 5: Subtotals Worksheet

Final Figure 6: Expansion Worksheet

Related Services

Cengage SAM Capstone Project Help

Module 3 - SAM Project 1a #part1

Description

Please Subscribe, Please?

Part 2: https://www.youtube.com/watch?v=gSsgpBb_HVM

Topics covered in the video:

• Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld controller for virtual reality gaming. Danilo is building a business plan as he recruits investors and plans logistics for the launch of his new company, Scrub Jay Peripherals, and wants to use Excel to summarize data and create projections.

Switch to the Sales Projections worksheet. Use the values in the range B6:C6 to extend the incremented percentages to the range D6:H6. 2. Use the values in the range A7:A8 to extend the list of years to the range A9:A11. 3. Use AutoFill to fill the range A9:H11 with the formatting from the range A7:H8. 4. In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. In this formula, use a mixed reference for cell B6 by including an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas from the range B8:B11 to the range C8:H11. 5. Switch to the Cost Estimates worksheet. In cell A9, create a formula using the AVERAGE function that calculates the average of the values in the range A5:A7, then copy your formula to cell D9. 6. In cell A10, create a formula using the MAX function that identifies the maximum value in the range A5:A7 and then copy your formula to cell D10. 7. In cell A11, create a formula using the MIN function that identifies the minimum value in the range A5:A7 and then copy your formula to cell D11. 8. In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match. Copy the formula to cell E13.

#cengage #solutions #sam ---

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.

1 00:00:00,000 --> 00:00:05,520 so this is module 3 project 1A so in

2 00:00:02,820 --> 00:00:07,560 this Step 1 it is saying switch to the

3 00:00:05,520 --> 00:00:10,679 sales projects and worksheet use the

4 00:00:07,560 --> 00:00:12,840 value in the range B6 through C6 to

5 00:00:10,679 --> 00:00:17,039 extend the incremental percentage to

6 00:00:12,840 --> 00:00:19,380 range D6 through S6 so from

7 00:00:17,039 --> 00:00:21,660 B6 through C6

8 00:00:19,380 --> 00:00:24,480 going to use this so go to the corner

9 00:00:21,660 --> 00:00:28,500 and this plus sign will appear now hold

10 00:00:24,480 --> 00:00:29,460 it and drag through D6 through F6 so up

11 00:00:28,500 --> 00:00:32,279 to here

12 00:00:29,460 --> 00:00:35,520 so this this this plus sign will appear

13 00:00:32,279 --> 00:00:38,219 hold it and drag it until S6

14 00:00:35,520 --> 00:00:41,579 so it will auto fill after the releasing

15 00:00:38,219 --> 00:00:45,480 use the value in the range A7 through A8

16 00:00:41,579 --> 00:00:47,460 so is seven through eight and to extend

17 00:00:45,480 --> 00:00:52,739 the list of the year in the range A9

18 00:00:47,460 --> 00:00:55,440 through a11 so A9 through 11.

19 00:00:52,739 --> 00:00:57,120 same method just just go to the corner

20 00:00:55,440 --> 00:01:01,320 this type of plus sign will appear and

21 00:00:57,120 --> 00:01:01,320 hold it and drag it until 11.

22 00:01:01,620 --> 00:01:07,320 so after that use autofill to fill the

23 00:01:04,500 --> 00:01:09,900 range a 9 through S11 with the

24 00:01:07,320 --> 00:01:11,040 formatting from the range A7 through

25 00:01:09,900 --> 00:01:13,200 acid

26 00:01:11,040 --> 00:01:15,960 so A7

27 00:01:13,200 --> 00:01:18,360 now hold shift and then click here

28 00:01:15,960 --> 00:01:20,820 and it will select all and it is saying

29 00:01:18,360 --> 00:01:24,720 use this to fill the range A9 through

30 00:01:20,820 --> 00:01:26,040 h11 so A9 3x11 same process just go to

31 00:01:24,720 --> 00:01:29,880 the government plus sign will appear

32 00:01:26,040 --> 00:01:32,939 hold it and drag it until S11

33 00:01:29,880 --> 00:01:34,680 and then release it after that in cell

34 00:01:32,939 --> 00:01:37,079 B8

35 00:01:34,680 --> 00:01:39,060 initial we'll create a formula using a

36 00:01:37,079 --> 00:01:42,960 function that multiplies the value in

37 00:01:39,060 --> 00:01:44,880 cell B7 by the value in cell B6

38 00:01:42,960 --> 00:01:48,500 so

39 00:01:44,880 --> 00:01:52,220 equals to sign after that V7

40 00:01:48,500 --> 00:01:52,220 by B6

41 00:01:52,680 --> 00:01:57,619 and then adds the value in B7

42 00:01:58,079 --> 00:02:02,700 okay

43 00:01:59,700 --> 00:02:04,159 V7 in this formula use the mixed

44 00:02:02,700 --> 00:02:07,380 reference for

45 00:02:04,159 --> 00:02:09,000 B6 by including an absolute reference to

46 00:02:07,380 --> 00:02:12,599 row six

47 00:02:09,000 --> 00:02:15,420 so for B6 going to do the absolute

48 00:02:12,599 --> 00:02:17,400 reference for row 6 so just for row 6

49 00:02:15,420 --> 00:02:18,660 into 100 dollars and it will stay

50 00:02:17,400 --> 00:02:20,420 constant

51 00:02:18,660 --> 00:02:23,340 and then

52 00:02:20,420 --> 00:02:24,720 row six okay so this is done and hit

53 00:02:23,340 --> 00:02:27,300 enter

54 00:02:24,720 --> 00:02:29,760 after that in this formula so this is

55 00:02:27,300 --> 00:02:32,580 done complete the formula from copy the

56 00:02:29,760 --> 00:02:36,480 formula from p8 to the range B9 through

57 00:02:32,580 --> 00:02:39,599 b11 so click on V8 again plus PSI plus

58 00:02:36,480 --> 00:02:43,019 sign in B 9 through v11

59 00:02:39,599 --> 00:02:44,940 after that it is saying and then copy

60 00:02:43,019 --> 00:02:49,920 the formula from the range B8 through

61 00:02:44,940 --> 00:02:52,379 b11 to the range C8 through h11 so

62 00:02:49,920 --> 00:02:53,959 go to the kernel plus signal up here and

63 00:02:52,379 --> 00:02:57,180 then drag it until

64 00:02:53,959 --> 00:02:58,980 c83 has 11 so until here

65 00:02:57,180 --> 00:03:01,620 now it will auto fill out the value

66 00:02:58,980 --> 00:03:03,840 switch to the cost estimates worksheet

67 00:03:01,620 --> 00:03:07,800 so let's do it

68 00:03:03,840 --> 00:03:10,019 and then in cell A9 so A9

69 00:03:07,800 --> 00:03:11,700 create a formula using average function

70 00:03:10,019 --> 00:03:14,940 that calculates

71 00:03:11,700 --> 00:03:16,680 so every time we enter formula or any

72 00:03:14,940 --> 00:03:20,099 mathematical calculation we shall start

73 00:03:16,680 --> 00:03:23,940 with equals to sign and then enter

74 00:03:20,099 --> 00:03:26,340 average so this is case insensitive so

75 00:03:23,940 --> 00:03:28,080 it doesn't matter if we type in capital

76 00:03:26,340 --> 00:03:30,840 case or lowercase

77 00:03:28,080 --> 00:03:33,959 or anything and then that calculates the

78 00:03:30,840 --> 00:03:37,920 average value in the range A5 through A7

79 00:03:33,959 --> 00:03:41,580 so just enter the range A5 through A7

80 00:03:37,920 --> 00:03:44,760 and then hit enter and then copy your

81 00:03:41,580 --> 00:03:49,680 formula to cell D9

82 00:03:44,760 --> 00:03:51,720 so just copy it Ctrl C and then Ctrl V

83 00:03:49,680 --> 00:03:55,560 and then hit Escape

84 00:03:51,720 --> 00:03:58,980 after that in cell 18 create a formula

85 00:03:55,560 --> 00:04:01,739 using the max function so cell a 10

86 00:03:58,980 --> 00:04:04,739 again go to here equals to sign

87 00:04:01,739 --> 00:04:07,920 Max function and it accepts

88 00:04:04,739 --> 00:04:11,840 uh which number so that identify maximum

89 00:04:07,920 --> 00:04:16,799 value in the range a 5 through A7

90 00:04:11,840 --> 00:04:18,720 formula to d11 so just copy it and then

91 00:04:16,799 --> 00:04:22,019 paste it

92 00:04:18,720 --> 00:04:24,960 after that in cell a11 create a formula

93 00:04:22,019 --> 00:04:26,100 using a mean function so again win

94 00:04:24,960 --> 00:04:30,300 function

95 00:04:26,100 --> 00:04:32,100 that identify A5 through A7

96 00:04:30,300 --> 00:04:36,440 same thing

97 00:04:32,100 --> 00:04:36,440 so copies and then paste it

98 00:04:36,900 --> 00:04:42,180 so after that it is saying in cell B13

99 00:04:40,020 --> 00:04:43,199 create a formula using the vlookup

100 00:04:42,180 --> 00:04:47,940 function

101 00:04:43,199 --> 00:04:50,940 okay so peer lookup function that looks

102 00:04:47,940 --> 00:04:55,860 up the value from cell a11 so lookup

103 00:04:50,940 --> 00:04:59,280 value is 11 and then a 5 through B7 and

104 00:04:55,860 --> 00:05:02,100 then in column 2 that is specify and

105 00:04:59,280 --> 00:05:05,280 specifies an exact match

106 00:05:02,100 --> 00:05:06,300 is intervals and then close the

107 00:05:05,280 --> 00:05:08,220 parenthesis

108 00:05:06,300 --> 00:05:11,639 and then hit enter

109 00:05:08,220 --> 00:05:15,440 and then copy the formula to cell e13 so

110 00:05:11,639 --> 00:05:15,440 just copy it and then paste it here

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.

• Solved Assignments
• Request Solution
• Perdisco Request
• Make Payment

Campus Fitness Center

Modify a service report and create a chart, getting started.

• Open the file SC_EX16_CS1-3a_ FirstLastName_1. xlsx , available for download from the SAM website.
• If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

• Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center’s classes.

Open the Class Statistics worksheet. Modify the column widths and row heights as described below:

• Use AutoFit to change the width of column A to make all the contents visible.
• Change the row height of row 1 to 00 pts .
• Change the widths of columns B through M to 25 characters.
• Change the font to Tw Cen MT and the font size to 26 pt .
• Change the font color to Turquoise, Accent 3, Darker 50% (7 th column, 6 th row of the Theme Colors palette).
• Change the fill color of the cell to Turquoise, Accent 3, Lighter 80% (7 th column, 2 nd row of the Theme Colors palette).
• Use Merge Cells to merge the contents of the range A2:M2 and then apply the Heading 1 cell style to the merged range. Format the merged range with the Short Date number format.
• Enter the contents in bold shown in Table 1 below into the range C4:G5.

Table 1: Data for Range C4:G5

• Format the cells in the range C5:G5 with the Currency number format with two decimal places and $ as the symbol.
• Bold and center the content of cell B4.
• Use the Format Painter to copy the formatting of cell B4 to the range C4:G4.
• Use Merge Cells to merge the contents of the range B4:B5.
• Apply the All Borders border style to the range B4:G5.
• Merge and center the range G7:K7.
• Apply the fill color Blue, Accent 2, Lighter 60% (6 th column, 3 rd row of the Theme Colors palette) to the merged range.
• Use the September label in cell B8 to fill the range C8:M8 with the months of the year.
• In cell B14, use the SUM function to total the values in the range B9:B13 . Use the Fill handle to copy the formula from B14 into the range C14:M14.
• In January, the hip-hop class is the center’s least attended class, but Stella’s manager hopes to boost attendance so that they can reach their budget goals.

Perform a Goal Seek analysis to determine the number of hip-hop class attendees needed in January ( F10 ) to change the value in cell F14 to 400 . ( Hint : Cell F10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell F10.

• In cell B15, use the keyboard to enter a formula that multiplies the value in cell B9 (the number of students attending the cardio class) by the value in cell C5 (the cost of each cardio class). Use an absolute cell reference to cell C5 and a relative reference to cell B9 . Copy the formula from cell B15 to the range C15:M15.
• In cell B18, enter a formula that multiples the value in cell B12 by the value in cell F5 . Copy the formula from B18 to the range C18:M18.
• In cell B19, enter a formula that multiples the value in cell B13 by the value in cell G5 . Copy that formula from B19 to the range C19:M19.
• Format the values in the range B9:M14 with the Comma Style number format with zero decimal places. Format the range B15:M20 with the Accounting number format with two decimal places.
• To help see where the most profitable months are, apply a new conditional formatting rule to the range B20:M20. The rule should format only cells that contain cell values greater than $62,000 with Light Green fill color (5 th column, 1 st row of the Standard Colors palette) and Dark Blue font color (9 th column, 1 st row of the Standard Colors palette).
• In cell B23, use the AVERAGE function to calculate the average monthly revenue generated for the range B15:B19 . Copy the formula from cell B23 to the range C23:M23.
• In cell B24, use the MAX function to calculate which value in the range B15:B19 is the largest. Copy the formula from cell B24 to the range C24:M24.
• In cell B25, use the MIN function to calculate which value in the range B15:B19 is the smallest. Copy the formula from cell B25 to the range C25:M25.
• If this condition is true, the cell value should be set to Over ( Hint : For the value if true, use “Over”).
• If this condition is false, the cell value should be set to Under ( Hint : For the value if false, use “Under”).

Copy the formula created in cell B26 to the range C26:M26.

• In cell B28, create a Line Sparkline from the data in the range G11:K11, and then change the style of the Sparkline to Turquoise, Sparkline Style Accent 3 (no dark or light) . ( Hint : Depending on your version of Office, the sparkline style may be written as Sparkline Style Accent 3 (no dark or light).)
• Check the Spelling in the workbook to identify and correct any spelling errors. ( Hint : You should find and correct at least two spelling errors.)
• Change the orientation to Landscape .
• Change the worksheet margins to Narrow .
• Insert a header in the center section with the text 2018 Class Statistics .
• Scale the worksheet so that it prints on one page.

Switch back to Normal View.

• Stella’s manager would like to emphasize certain visuals in the worksheet.

Create a Line chart from the nonadjacent ranges B8:M8 and B20:M20. Move the chart you just created to its own chart sheet. Use Monthly Revenue Chart as the name of the new chart sheet.

• Change the chart title to Total Revenue by Month .
• Format the data labels using the Above positioning option.
• Switch back to the Class Statistics Use the Recommended Chart tool to create a Clustered Column chart based on the range A8:F13. Move the chart to its own chart sheet. Use the name Fall Attendance Chart as the name of the new chart sheet.
• Change the chart style to Chart Style 2 .
• Change the chart title to Fall Semester Class Attendance .
• Add Number of Attendees as the primary vertical axis title.
• Add Fall Semester Months as the primary horizontal axis title.
• Stella’s manager was very impressed with her work and would like her to include and format some other information as well.

Go to the Personal Trainers worksheet and make the following formatting changes:

• Rotate the labels in the range B3:B17 to 0 degrees .
• Copy the range C3:C5, then paste it into the range C6:C17. Use the paste option that pastes the values, but not the cell formatting.
• Set the fill color in cell C3 and the range D6:D8 to No Fill .
• The center uses special codes to keep track of hours and process payments. These codes are made by typing the first three letters of the day followed by a dash, the start and end times separated by a colon, a dash, and then the first two letters of the first and last name of the trainer.

In cell E4, type Mon-11:1-LoWa . Select the range E3:E17, and use Flash Fill to fill the values in the range. [Mac Hint: Flash Fill is not available in Excel 2016 for Mac, so refer to the Final Figures to enter the text.]

• In the Physical Therapists worksheet, select cell B3 and use the Freeze Panes option to freeze the rows and columns above and to the left of cell B3.
• Select the Class Statistics , Personal Trainers , and Physical Therapists worksheets and then change the color of the sheet tabs to Turquoise, Accent 3 (7 th column, 1 st row of the Theme Colors palette).

Your workbook should look like the Final Figures on the following pages. (The value in cell F10 generated by the Goal Seek analysis has intentionally been blurred out in Final Figure 3.) Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Monthly Revenue Chart Worksheet

Final Figure 2: Fall Attendance Chart Worksheet

Final Figure 3: Class Statistics Worksheet

Final Figure 4: Personal Trainers Worksheet

Final Figure 5: Physical Therapists Worksheet

Click on Buy Solution and make payment. All prices shown above are in USD . Payment supported in all currencies . Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly .Solution is available either in Word or Excel format unless otherwise specified.

If your question is slightly different from the above question, please contact us at [email protected] with your version of question.

Choose your currency:

• USD US Dollars ($)

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.