Get Coursework Help In Your Essays, Assignments, Homeworks, Dissertation Or Thesis

Professional And Experienced Writers - 24/7 Online Support

Melting point of impure benzoic acid

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

Get Coursework Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework

Professional And Experienced Writers - 24/7 Online Support

Similar Questions

Melting point of urea and cinnamic acid lab report

melting point of urea and cinnamic acid lab report

Recrystallization and melting point lab report

recrystallization and melting point lab report

A sample has an experimental melting point of 100-101

OVERLAKE HOSPITAL MEDICAL CENTER Consolidated Financial Statements June 30, 2012 and 2011 (With Independent Auditors’ Report Thereon) KPMG LLP Suite 2900 1918 Eighth Avenue Seattle, WA 98101 KPMG LLP is a Delaware limited liability partnership, the U.S. member firm of KPMG International Cooperative (“KPMG International”), a Swiss entity. Independent Auditors’ Report The Board of Trustees Overlake Hospital Medical Center: We have audited the accompanying consolidated balance sheets of Overlake Hospital Medical Center (the Hospital) (a Washington not-for-profit corporation) as of June 30, 2012 and 2011, and the related consolidated statements of operations and changes in net assets and cash flows …

How to increase leverage in capsim

About Their eyes were watching God is widely considered to be the best novel written by Zora Neale Hurston. It was published in 1937, after the waning of the cultural openness that had allowed the Harlem resistance to flourish. The book was received rather poorly at the time and was criticized for presenting a relaxed and easy view of the life of black people in Southern America. It is believed that the novel was written in a span of seven weeks while Nora pursued her anthropological research in Haiti. Black authors at the time were focused on writing social realism, …

A lockbox plan is most beneficial to firms that

Develop RACI Chart Human resources need to be planned to ensure that the right individuals are onboard and it is clear who is accountable and responsible. Charts such as the RACI chart, named as the chart indi- cates the activity and who is Responsible•, Accountable (A), should be Consulted (C), and who needs to be Informed (I). Typically, only one person should be held accountable for a particular activity, whereas there may be multiple individuals responsible. Project Execution Project execution involves assembling the appropriate project team to accomplish the tasks and coordinating those resources to complete the activities identified in …

Synopsis of the catcher in the rye

Question 1 When religion and morality are considered, [removed] the moral instructions of the world's great religions are often general and imprecise. [removed] most people act rightly only because their religion tells them to. [removed] atheists are likely to be less moral than religious people. [removed] in practice, people who share a religion will agree on all moral questions. Question 2 Accepting a moral principle [removed] is a purely intellectual act like accepting a scientific hypothesis. [removed] generally involves a desire to follow that principle for its own sake. [removed] means you will never go against that principle. [removed] is …

Fred jones positive classroom discipline pros and cons

C h a p t e r 12 Meetings, Conventions, and expositions L E A r N i N G o B J E C T i V E S after reading and studying this chapter, you should be able to: • List the major players in the convention industry. • Describe destination management companies. • Describe the different aspects of being a meeting planner. • explain the different types of meetings, conventions, and expositions. • List the various venues for meetings, conventions, and expositions. M12_WALK2761_07_SE_C12.indd 519 09/24/16 7:49 AM 520 Part iv assemblies, events, attractions, Leadership, and Management Development …

Successful writing at work 11th edition

Technology is only as useful as the accounting data available, and users’ decisions are only as good as their understanding of accounting. Chapter 1 Accounting in Business 5 • Preparation • Analysis • External auditing • Regulatory • Consulting • Planning • Criminal investigation • Preparation • Planning • Regulatory • Investigations • Consulting • Enforcement • Legal services • Estate plans • General accounting • Cost accounting • Budgeting • Internal auditing • Consulting • Controller • Treasurer • Strategy • Lenders • Consultants • Analysts • Traders • Directors • Underwriters • Planners • Appraisers • FBI investigators …

Mla citation practice worksheet with answers

Title ABC/123 Version X 1 Week 1 Assignment Worksheet PSY/203 Version 1 5 University of Phoenix Material Week 1 Assignment Worksheet Matching Match the following descriptions to the correct perspective: 1. ___B.___ perspective focuses on how learning experiences affect behavior, and focuses on behavior that is observable. 2. __E___ perspective focuses on the effect of unresolved conflicts from childhood, and how those conflicts unconsciously shape behavior. 3. __D___ perspective focuses on free will, conscious choices, and self-awareness, and views humans as distinct individuals with unique characteristics. 4. ___C__ perspective examines the mental processes used to obtain knowledge, and focuses on …

What is a major problem with the original milgram study

New Promotion Cycle MAY 2021 Active Component (AC) U.S. Army Active Guard Reserve (AGR) Semi-Centralized (SGT-SSG) Junior Enlisted Promotions Information Paper As of 24 February 2021 (All previous information papers are obsolete) Guidance contained therein should be treated as policy and directive in nature since all answers are derived from Army Regulation 600-8-19, Enlisted Promotions and Reductions or other policy references. The information paper clarifies answers to assist the field. Note: Please ensure your web browser is open when attempting to Ctrl+click on a hyperlink located within this document. U.S. Army Human Resources Command Enlisted Promotions AHRC-PDV-PE Fort Knox, KY …

How does the book the giver end

the usefulness of templates Our templates also have a generative quality, prompting stu- dents to make moves in their writing that they might not oth- erwise make or even know they should make. The templates in this book can be particularly helpful for students who are unsure about what to say, or who have trouble finding enough to say, often because they consider their own beliefs so self-evident that they need not be argued for. Students like this are often helped, we’ve found, when we give them a simple tem- plate like the following one for entertaining a counterargument (or …

When sally eats healthy foods and exercises

Although set during the Great Depression, August Wilson's The Piano Lesson depicts a variety of contemporary themes and conflicts in America, some very prevalent to this day! The central theme concerns the importance of history - understanding the historical context of the world in which we live. As noted by The Merriam-Webster Encyclopedia of Literature, The Piano Lesson is a play "in two acts by August Wilson, produced in 1987 and published in 1990. The play, which was awarded a Pulitzer Prize in 1990, is part of Wilson's cycle about African-American life in the 20th century. The action takes place …

How do air masses interact to form a hurricane

Develop RACI Chart Human resources need to be planned to ensure that the right individuals are onboard and it is clear who is accountable and responsible. Charts such as the RACI chart, named as the chart indi- cates the activity and who is Responsible•, Accountable (A), should be Consulted (C), and who needs to be Informed (I). Typically, only one person should be held accountable for a particular activity, whereas there may be multiple individuals responsible. Project Execution Project execution involves assembling the appropriate project team to accomplish the tasks and coordinating those resources to complete the activities identified in …

The current period's ending inventory is

Multiple Choice Quiz 1 Which of these statements about organizational structure is(are) true? A) It refers to the division of labour. B) It refers to patterns of coordination. C) It refers to patterns of work flow and formal power that direct organizational activities. D) Organizational structure reflects cultural and power relationships. E) All of the above statements are true. 2 Organizational structure refers to coordination and: A) division of labour. B) delegation of authority. C) assumption of authority. D) decentralized decision making. E) chain of command. 3 Work is divided into specialized jobs because: A) it potentially increases work efficiency. …

In the context of marketing research curbstoning occurs when

Develop RACI Chart Human resources need to be planned to ensure that the right individuals are onboard and it is clear who is accountable and responsible. Charts such as the RACI chart, named as the chart indi- cates the activity and who is Responsible•, Accountable (A), should be Consulted (C), and who needs to be Informed (I). Typically, only one person should be held accountable for a particular activity, whereas there may be multiple individuals responsible. Project Execution Project execution involves assembling the appropriate project team to accomplish the tasks and coordinating those resources to complete the activities identified in …
Top Grade Tutor

ONLINE

Top Grade Writer

10374 Orders Completed

Top Academic Guru

ONLINE

Top Academic Guru

9345 Orders Completed

Top Essay Writer

ONLINE

Top Essay Writer

8379 Orders Completed

A-Grade Writer

ONLINE

A-Grade Writer

7812 Orders Completed

Get Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework