• Share this —

sam capstone project 1a excel modules 1 3

  • Watch Full Episodes
  • Read With Jenna
  • TODAY Table
  • Newsletters
  • Citi Music Series
  • Pets & Animals
  • Asian American Voices
  • Black Voices
  • Latino Voices
  • LGBTQ Voices
  • Listen All Day

Follow today

More Brands

Live From Studio 1A: TODAY Gets Simpsonized

This morning, Matt Groening, creator of "The Simpsons," stopped by to talk about the upcoming Simpsons movie and to teach Al -- and the viewers at home -- how to draw Bart. WATCH VIDEO

Plus, the Simpsons team created a special surprise, bestowing upon Matt, Meredith, Al and Ann one of the greatest honors in American pop culture today -- our cast has been Simpsonized!

Check out the individual shots:

Meredith Vieira

logo

Excel 2019 Capstone 1-3 Project A

sam capstone project 1a excel modules 1 3

Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.

sam capstone project 1a excel modules 1 3

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

sam capstone project 1a excel modules 1 3

Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.

Follow the instructions and do the work for excel

User Generated

Business Finance

Description

Easy work, follow the instructions of Instructions_SC_EX16_CS1-3a.docx and do step by step in the document attatched SC_EX16_CS1-3a_IkerMoure_1.xlsx, Need good work please, thank you.

Unformatted Attachment Preview

sam capstone project 1a excel modules 1 3

Explanation & Answer

sam capstone project 1a excel modules 1 3

Attached. Author: Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a Campus Fitness Center MODIFY A SERVICE REPORT AND CREATE A CHART Iker Moure not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Total Revenue by Month $80,000.00 $72,880.00 $75,220.00 $74,360.00 $70,710.00 $68,380.00 $70,000.00 $61,520.00 $63,590.00 $60,570.00 $60,260.00 $60,000.00 $56,010.00 $50,000.00 $40,000.00 $30,000.00 $25,270.00 $21,960.00 $20,000.00 $10,000.00 $September October November December January February March April May June July August Fall Semester Class Attendance 120 100 Number of Attendees 80 60 40 20 September October November Fall Semester Months December January 2018 Class Statistics ...

sam capstone project 1a excel modules 1 3

24/7 Homework Help

Stuck on a homework question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

sam capstone project 1a excel modules 1 3

Similar Content

Related tags.

Cost of Capital personal budget excel assignment albany technical Summary accountant "J.D Salinger" "J.D Salinger" excel for time sheets at animal service excel CPMGT/303 Version 10 Project Estimating and Control Techniques Income Statement excel

All the Kings Men

by Robert Penn Warren

The Dispossessed

by Ursula Kroeber Le Guin

The Sun Is Also a Star

by Nicola Yoon

The Calcutta Chromosome

by Amitav Ghosh

The Restless Wave

by John McCain

Death on the Nile

by Agatha Christie

Narrative of the Life of Frederick Douglass

by Frederick Douglass

Treasure Island

by Robert Louis

sam capstone project 1a excel modules 1 3

working on a homework question?

Studypool, Inc., Tutoring, Mountain View, CA

Studypool is powered by Microtutoring TM

Copyright © 2023. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

sam capstone project 1a excel modules 1 3

Access over 20 million homework documents through the notebank

sam capstone project 1a excel modules 1 3

Get on-demand Q&A homework help from verified tutors

sam capstone project 1a excel modules 1 3

Read 1000s of rich book guides covering popular titles

sam capstone project 1a excel modules 1 3

Sign up with Google

sam capstone project 1a excel modules 1 3

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

i have homework in Excel and i need help

Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a

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.

Save the file as SC_EX16_CS1-3a_ FirstLastName _2.xlsx by changing the “1” to a “2”.

0. 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 SC_EX16_CS1-3a_ 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

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:

a. Use AutoFit to change the width of column A to make all the contents visible.

b. Change the row height of row 1 to 42.00 pts .

c. Change the widths of columns B through M to 10.25 characters.

In the merged range A1:M1, apply the formatting options described below:

d. Change the font to Tw Cen MT and the font size to 26 pt .

e. Change the font color to Turquoise, Accent 3, Darker 50% (7th column, 6th row of the Theme Colors palette).

f. Change the fill color of the cell to Turquoise, Accent 3, Lighter 80% (7th column, 2nd 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.

Apply the following formatting options, as described below:

g. Bold and center the content of cell B4.

h. Use the Format Painter to copy the formatting of cell B4 to the range C4:G4.

i. Use Merge Cells to merge the contents of the range B4:B5.

j. Apply the All Borders border style to the range B4:G5.

Move the content of cell H6 to cell G7 and then apply the formatting options described below:

k. Merge and center the range G7:K7.

l. Apply the fill color Blue, Accent 2, Lighter 60% (6th column, 3rd 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.

Calculate the revenue for the two remaining unfilled classes (Yoga and Zumba) as described below, using absolute references to the cells in the range F5:G5 :

m. 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.

n. 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 (5th column, 1st row of the Standard Colors palette) and Dark Blue font color (9th column, 1st 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.

The center needs to bring in $13,400 a month to stay on budget. In cell B26, use the IF function to check whether the value of cell B23 is greater than 13,400 .

o. If this condition is true, the cell value should be set to Over ( Hint : For the value if true, use “Over”).

p. 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 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.)

Format the worksheet for printing as described below:

q. Change the orientation to Landscape .

r. Change the worksheet margins to Narrow .

s. Insert a header in the center section with the text 2018 Class Statistics .

t. Set the print area as the range A4:M28.

u. 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.

On the Monthly Revenue Chart worksheet, format the line chart with the following options:

v. Change the chart title to Total Revenue by Month .

w. Format the data labels using the Above positioning option.

Switch back to the Class Statistics worksheet. 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.

On the Fall Attendance Chart worksheet, format the clustered column chart with the following options:

x. Change the chart style to Chart Style 2 .

y. Change the chart title to Fall Semester Class Attendance .

z. Add Number of Attendees as the primary vertical axis title.

aa. 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:

ab. Rotate the labels in the range B3:B17 to 0 degrees .

ac. 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.

ad. 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 (7th column, 1st 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

Accessibility Links

Google

Filters and Topics

Search results, web results, ppt module 2 sam end of module project 1 - youtube, powerpoint module 1 end of module project 2 - youtube, word module 2 sam end of module project 1 - youtube, power point (powerpoint module 2 sam project 1), [solved] powerpoint module 2 sam end of module project 1, word module 2 sam end of module project 1, sam end of module 2 project 1 (part 2) - screencast-o-matic, powerpoint module 2 sam end of module project 1, powerpoint module 2 sam project a, page navigation, footer links.

IMAGES

  1. New Perspectives Excel 2019 Modules 5 8 SAM Capstone Project 1a a For the range

    sam capstone project 1a excel modules 1 3

  2. Solved: Illustrated Excel 2019

    sam capstone project 1a excel modules 1 3

  3. Illustrated Excel 2019

    sam capstone project 1a excel modules 1 3

  4. Excel Capstone 2 Projects Helps

    sam capstone project 1a excel modules 1 3

  5. Excel 2016 Module 10: SAM Project 1a

    sam capstone project 1a excel modules 1 3

  6. Illustrated Illustrated Word 2019 Modules 1 3 SAM Capstone Project 1a Figure 1

    sam capstone project 1a excel modules 1 3

VIDEO

  1. Excel Module 4 Video

  2. Access 1A and 1B Simulation Exam

  3. 06 New Perspectives Word 365 2021 Module 1 SAM Project 1a

  4. Modules 1

  5. SAM Module 8 Project A

  6. Excel Module 1 Project 2: Retail Pro

COMMENTS

  1. What Are the Elements in Groups 1a to 8a Called?

    The elements of the periodic table in groups 1A to 8A are called the main-group elements. They are sometimes also called the representative elements and they are the most abundant in the universe.

  2. Live From Studio 1A: We Want YOU!

    WATCH VIDEO.Send us your application Keep your kitchen clutter free with these 14 organizational must-haves Sections Shows More Follow today More Brands WATCH VIDEO.Send us your application © 2022 NBC UNIVERSAL

  3. Live From Studio 1A: TODAY Gets Simpsonized

    This morning, Matt Groening, creator of "The Simpsons," stopped by to talk about the upcoming Simpsons movie and to teach Al -- and the viewers at home -- how to draw Bart. WATCH VIDEOPlus, the Simpsons team created a special surprise, best...

  4. EXCEL 2019 SAM MODULES 1 3 CAPSTONE PROJECT A

    MRS. ROMERO PUT THE WRONG FORMATTING ON STEP 7 AND 8. MAKE SURE YOU CORRECT HER MISTAKE BY USING THE COMMA STYLE FORMAT IN THE NUMBER GROUP

  5. Excel Module 3 SAM Project 1a: Raybridge Recruiting Linda's

    Follow along as Linda Sessions completes the Excel Module 3 SAM Project 1a: Raybridge Recruiting on Linda's Take.

  6. Excel 2019 Capstone 1-3 Project A

    Excel 2019 Capstone 1-3 Project A. 09/29/2021 | 23:50. Excel 2019 Capstone 1-3 Project A. Created: 09/29/2021. Transcript. Notes. No notes currently found.

  7. Shelly Cashman Excel 2019 Modules 1 3 SAM Capstone Project 1a

    Shelly Cashman Excel 2019 Modules 1 3 SAM Capstone Project 1a 12 Carla also from ACCOUNTING 143 at University of the Fraser Valley.

  8. Follow the instructions and do the work for excel

    Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a Campus Fitness Center MODIFY A SERVICE REPORT AND CREATE A CHART GETTING STARTED • Open the

  9. Illustrated Excel 2019

    A B C С G H 1 J K L M N 0 DE Cello Worldwide 1 2 3 4 Analysis Number of

  10. 11

    1 (480) 866-1691 ; Shelly Cashman Excel 2019 | Modules 1-3: SAM Capstone Project 1a. $ 20 ; Shelly Cashman Excel 2019 | Module 3: End of

  11. shelly cashman

    Shelly Cashman PowerPoint 2016 Modules 1-3: SAM Capstone Project 1a

  12. I have homework in excel and i need help

    C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\ Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a. Campus Fitness Center.

  13. Powerpoint module 2 sam end of module project 1

    task to - Excel Module 3 SAM End of Module Project 1 Ask a Question Now.

  14. Word Excel PPT

    Unit 2 Word Project 3 Capstone https://youtu.be/X9NO_RWfk0Q. Going Green. 1. New Perspectives Excel 2013 Tutorial 1: SAM Project 1a. Unit 2 Excel Project 1A.