Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Cengage excel 2016 data files

17/11/2021 Client: muhammad11 Deadline: 2 Day

Shelly Cashman Excel 2016 | Module 5: SAM Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Shelly Cashman Excel 2016 | Module 5: SAM Project 1a

11th Gear Bike Rental

Working with Multiple Worksheets and Workbooks

GETTING STARTED
Open the file SC_EX16_5a_FirstLastName_1.xlsx, available for download from the SAM website.

Save the file as SC_EX16_5a_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.

To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

· Support_SC_EX16_5a_2019HelmetSurvey.xlsx

With the file SC_EX16_5a_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.

· When opening your file or the Graded Summary Report, you may be prompted to Update the links. Select Don't Update in the dialog box.

PROJECT STEP
Emelia Tapia is the owner of 11th Gear and Spoke Bike Rental. Each of her location managers sent her their 2019 rental and revenue data. To make the data easier to understand, Emelia wants to consolidate and standardize the format of each location’s data.

Apply the Office theme to the workbook.

Group the Santa Monica, Venice Beach, and Marina Del Rey worksheets. With all three worksheets selected, make the following formatting changes to the merged range A1:N1.

a. Change the font to Arial.

b. Change the font size to 18 pt.

c. Change the font color to White, Background 1 (1st row, 1st column of the Theme Colors palette).

Do not ungroup the worksheets.

With the Santa Monica, Venice Beach, and Marina Del Rey worksheets still grouped together, make the following updates:

d. Apply the Heading 3 cell style to the range A2:N2.

e. Apply the Accounting number format with zero decimal places and $ as the symbol to the range B16:N16. (Hint: Depending on how you complete this action, the number format may appear as Custom instead of Accounting.)

f. Apply the Comma number format with zero decimal places to the range B17:N21. (Hint: Depending on how you complete this action, the number format may appear as Custom.)

Do not ungroup the worksheets.

Emelia notices two typos in the worksheets for each location.

With the Santa Monica, Venice Beach, and Marina Del Rey worksheets still grouped together, make the following updates:

g. In cell A8, edit the cell text to read Street (instead of Stret).

h. In cell A9, edit the cell text to read Tricycle (instead of Trycycle).

Ungroup the worksheets.

Now that a consistent format is applied to each location’s worksheet, Emelia wants to create a template worksheet. She’ll use a copy of this template for any new location that she opens, rather than formatting a new worksheet.

Select the Marina Del Rey worksheet and create a copy of it between the Marina Del Rey and the All Locations worksheets. Update the worksheet as described below:

i. Rename the new worksheet using New Location as the name.

j. Clear the contents (but not the formatting) in the merged range A2:N2.

k. Clear the contents (but not the formatting) in the range B7:M12 and B16:M21.

Go to the All Locations worksheet. In cell B3, enter a formula using the TODAY function to display the current date.

Emelia wants to display the total number of monthly bike rentals from all of 11th Gear Bike Rental’s locations in one table.

In cell B7, enter a formula using the SUM function, 3-D references, and grouped worksheets to total the values in cell B7 on the Santa Monica:Marina Del Rey worksheets.

Copy the formula you created in cell B7 to the range B7:M12 without copying any cell formatting. (Hint: Use the Paste Gallery.)

Emelia created a 3-D pie chart showing how rental of each bicycle type contributed to her total revenue in 2019. Now she wants to format it to make the important information stand out better.

Resize and reposition the 3-D pie chart (with the title 2019 Total Revenue) so that the upper-left corner is located within in cell C24 and the lower-right corner is located within cell L44.

Explode the slice of the 3-D pie chart representing the revenue from the Tandem bike rentals by 25%.

Modify the data labels of the 3-D pie chart as described below:

l. Update the data labels to contain only the Category Name and the Percentage values.

m. Change the data label’s position to Outside End.

n. Update the data label’s number format to display using the Percentage number format with 1 decimal place.

Add a header to the All Locations worksheet using the text For Internal Distribution to the center header section.

Using Header & Footer Elements, add a footer that displays the Current Date in the left footer section and the Sheet Name in the center footer section.

Change the margins of the All Locations worksheet so that the left and right margins are set to 0.2. Do not change the top or bottom margins.

Emelia is very concerned about safety and has conducted a study to determine how many bike helmets were replaced at each location last year. She wants to include the survey results in this spreadsheet.

Switch to the Helmets Per Location worksheet.

Open the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook, and then switch back to Helmets Per Location worksheet. Link the data to the Helmets Per Location worksheet as described below:

o. In cell C3 of the Helmets Per Location worksheet, create a formula without using a function that contains a relative reference to cell D2 of the 2019 Damaged Helmet Survey worksheet in the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook.

p. In the Helmets Per Location worksheet, copy the formula in cell C3 to the range C4:C5 without copying the formatting.

q. Close the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook and switch back to the Helmets Per Location worksheet.

Emelia now wishes to calculate how many helmets should be available at each location, accounting for the percentage of damaged helmets returned at each location. Emelia will need to use the ROUND function in her calculations, since her customers won’t accept a fraction of a helmet.

In cell E3, enter a formula using the ROUND function to calculate the number of helmets per location. The formula should multiply cell B3 (the max daily rentals) by cell D3 (the total helmets required), and be rounded to 0 decimal places. Copy the formula, but not the cell formatting, from cell E3 to the range E4:E5. (Hint: Use the Paste gallery.)

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

Final Figure 1: Santa Monica Worksheet

Final Figure 2: Venice Beach Worksheet

Final Figure 3: Marina Del Rey Worksheet

Final Figure 4: New Location Worksheet

Final Figure 5: All Locations Worksheet

Final Figure 6: Helmets Per Location Worksheet

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Smart Tutor
Unique Academic Solutions
Solution Provider
Math Exam Success
Supreme Essay Writer
Engineering Guru
Writer Writer Name Offer Chat
Smart Tutor

ONLINE

Smart Tutor

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$33 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$43 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$20 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$18 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$24 Chat With Writer
Engineering Guru

ONLINE

Engineering Guru

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Case study 5.1 predicting harry's work effort - A tennis player makes a successful first serve - Infinite automation systems aircrete - Stages of life essay and interview - 2d shapes sides and angles - Pangzitv - John o groat journal acknowledgements - After the mayflower questions and answers - What is an integrated belief system - Integumentary case study - You decide to sell short 100 shares - Derek bok protecting freedom of expression on the campus analysis - When did mcdonald's open in italy - Mornington peninsula national park walk - Pfizer management structure - Exercise 1 7 direct and indirect costs lo1 1 - Molar mass of bornite - Grid connected pv system design - Oracle cloud applications price list - Dulux duramax spray paint colours - Start page numbering on specific page word - 17731 edgerton rd jamaica ny 11432 - Healthcare marketing essay - Zappos culture book 2019 pdf - The iris center case study answers - Common investment banking questions - UNIT 2 ASSIGNMENT - Please circle your answer - Standardization of sodium hydroxide naoh solution - HELP - Ati teamwork and collaboration case study - Broome advertiser digital edition - Norse mythology family tree - How do iron ore deposits form chegg - A pediatrician uses the model above - You can grow your intelligence answers - Person vs supernatural definition - Appealing centrelink decisions fact sheet - CSCI 457 Assignment 2 – Hexadecimal Calculator - What are three ways heat is transferred - Leadership Applications CRJ-565-MCOL3 - Product failure case study - Use of weighted pencils to improve handwriting legibility - Does guaifenesin cause frequent urination - Psychological Theories of Crime - JCCMI- Phil - Critical Paper - The chimney sweeper songs of innocence summary - Auditing black box models for indirect influence - CIS450 Assignment Mod 6: - Will preventive maintenance eliminate all breakdowns - Ian viner cv writing - Apply tort and criminal law irac case brief - The road to winter essay - Batteries series vs parallel - Blank level questions elklan - Time and distance overcome analysis - What is the shortest stopping distance at 30mph - What branches of science - Brian foster chest pain objective - Mcgraw hill enzyme lab - Feast watson sanding sealer - Indirect approach letter example - Abington memorial hospital maternity - Anatomy drill level 1 anatomical models heart structures internal view - The looming threat of cyber warfare - Ksao interview questions - What is emerson's main point in this essay - Rsnetworx for ethernet ip - Values of plate element slenderness limits - Breaching the aicpa code of professional conduct - The hunting ground citation - No pude leer mis correos porque (perder) mi contraseña. - The kings mead ware - Label the following neurons in figure 19.3 - Performance education melbourne contact - Unit IV Assessment, Unit IV Article Review, - Composition of everyday life 6th edition - Highlight construction company income statement - Exsum - Topic: Energy Budget and Habitability (CIP3) - Too big to fail full movie - As a madman shakes a dead geranium - Separation of a mixture lab answers - Segmentation solutions nielsen zip code - There will come soft rains by ray bradbury summary - Criminal Law - International conference on harmonization guidelines for good clinical practice - According to the rokeach value survey - Marley dry ridge batten section - Stewart road car park sheffield - Myshift creative activation com au - Naf strong or weak - American nurses association florence nightingale pledge - Compass records case study - Acid base titration lab report answers - What are the aacn essentials - Compare and contrast the hippocratic oath and the nightingale pledge - The mask you live in essay - Phoenix dog kennels westbury - Literary analysis happy endings by margaret atwood