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

Merge and center the contents of cells a2 e2

13/10/2021 Client: muhammad11 Deadline: 2 Day

Computer Science 5

Shelly Cashman Excel 2013| Chapter 1: SAM Project 1a

Shelly Cashman Excel 2013

Chapter 1: SAM Project 1a

Flex Cab Company

MODIFY A SERVICE REPORT AND CREATE A Chart

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION
Mike Chen is the director of information systems for Flex Cab Company, a taxi service in Toronto, Ontario. Mike would like you to complete a report he has started to present statistics on the company’s on-time record for picking up passengers over a four-year period.
GETTING STARTED
· Download the following file from the SAM website:

· SC_Excel2013_C1_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· SC_Excel2013_C1_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file SC_Excel2013_C1_P1a_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
Open the Pickup Analysis worksheet and use AutoFit to adjust the width of Column A.

In cell A1, enter the text Flex Cab Company and then merge cells A1:E1 and center their content.

Apply the Heading 1 cell style to the merged cell A1:E1 and then change the font to Verdana.

1. Enter the text Number of Pickups in cell A2 and merge and center the contents of cell A2:E2.

Bold the content of merged cell A2:E2, change the font size to 12 pt., and change the font color to Gold, Accent 4, Darker 50% (8th column, 6th row in the Theme Colors Section of the Font Color Palette).

Clear the contents of cell F3.

Apply the Accent4 cell style to the range A3:E3.

Enter the data shown in Table 1 into the range B8:E8.

Table 1: Data for range B8:E8
© 2014 Cengage Learning.

Cell

Value

B8

6694

C8

6747

D8

6402

E8

6698

In cell B9, create a formula that uses the SUM function to calculate the total of the range B4:B8.

Using the fill handle, fill cells C9:E9 with the formula from cell B9.

Bold the text in the merged cell A12:E12.

Apply the Accent4 cell style to the range A13:E13.

Change the tab color of the Pickup Analysis worksheet to Standard Orange (3rd column, 1st row in the Standard Colors section of the Tab Color palette).

Select the 3-D pie chart with the title On-Time Pickup Percentages in 2015 and move it to its own chart sheet. Use 2015 On-Time Percentages as the name for the new chart sheet. Change the chart style of the 3-D pie chart to Style 6.

Switch back to the Pickup Analysis worksheet. Create a 3-D pie chart based on the range A13:B18 and then do the following:

a. Change the title of this chart to On-Time Pickup Percentages in 2012.

b. Move the 3-D pie chart you just created to its own chart sheet. Use 2012 On-Time Percentages as the name for the new chart sheet.

c. Change the chart style of the 3-D pie chart you just created to Style 6.

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

Final Figure 1: Pickup Analysis worksheet

Microsoft product screenshots used with permission from Microsoft Corporation.

Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 2: 2012 On-Time Percentages

Copyright © 2014 Cengage Learning. All Rights Reserved.

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:

Top Academic Tutor
Supreme Essay Writer
Top Class Results
ECFX Market
Quick Finance Master
Math Exam Success
Writer Writer Name Offer Chat
Top Academic Tutor

ONLINE

Top Academic Tutor

Give me a chance, i will do this with my best efforts

$50 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$33 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I have read and understood all your initial requirements, and I am very professional in this task.

$39 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I will cover all the points which you have mentioned in your project details.

$25 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$43 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

Give me a chance, i will do this with my best efforts

$28 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

DISCUSSION - Citrix exam 1y0 203 - Miles and snow typology ppt - Feast watson glass finish - Respect for acting author hagen - COSO Framework - Short essay on iron man - Plop plop fizz fizz lab answers - Nitrogen trihydride bond type - Clr woolworths au web faces pages security login - One page assignment - How to respond to a case study in apa format - Patophysiology Topic 1 DQ2 - Week 6 Research paper - Grid organizational development ppt - Tutoring toy salt lake city - Chance enterprises leased equipment from third bank - How to write formulas for binary ionic compounds - Health promotion model nursing theory - Opposites attract and likes repel - Junk food's popularity relies on marketing ppt - Erikson's stages of development chart - Political environment of old spice - Kath murdoch inquiry cycle example - Checking out me history poem - Health and gender interviw - Leadership development programs in hsos - Week 5 project nursing care plan part 1 - Eco schools lesson plans - Foner eric give me liberty pdf - 5/9 tristania street rivett - Public Administration Unit 5 Discussion - Citibank plus everyday account - Houses to rent in melton mowbray that accept housing benefit - Management Finance - After hours doctor moonah - Sociology chapter 8 quiz answers - Software development aptitude test - Wound clinic liverpool hospital - What is the difference between independent and mutually exclusive projects - Create a Graphic Representation of your Research my topic is does abouse cause juvinel crime - 20 sided 3 dimensional shape - Silicon valley of india - Three to Five Page Essay - Balance sheet of johnson and johnson company - The analysis of biological data second edition assignment problems - Annual inventory holding cost formula - Https www youtube com watch v kudhiats36a - Postulates of special theory of relativity ppt - Texas instruments scientific calculator ti-30xb multiview - High school geometry midterm practice test - Imperial jewelers is considering a special order - Where is the love lyrics - How to critique a journal article nursing - Blood donation speech for students - Rare and precious things epub - 688a pacific highway belmont - Statistics and Data Analysis - The handsomest drowned man in the world summary - Flowchart for student information system - Where was i answers brian smith - Countable and uncountable sets in discrete mathematics - Ediscovery pst export repeatedly prompts for credentials - 1.2 6 maximizing motor power vex answer key - Draw the monomer for the following polymer - 750 10 unc 2a - Distraction vs happiness in fahrenheit 451 - Please submit your final assignment for the semester, your completed Student Success Plan, here. You should have completed all sections of the plan using what you've learned in this course. - Write a paper in APA 6th style - Which of the following is the weakest acid - Https mailna jnj com owa - Heuristic optimization of query trees examples - 7/9 as a recurring decimal - Cengage diet and wellness plus login - Assignment: Assessing a Healthcare Program/Policy Evaluation - Difference between the role of the Nursing Professional (RN) and Advance Practice Register Nurse (APRN) - Capability statement template powerpoint - 87 1/2 percent as a fraction - Oral history interview essay example - Nrs 490 capstone project change proposal - Priority Queue - Fail Companies - Clinical Decision making - Capstone - Liq fusion 7000 fbe - Past perfekt in german - The real troy maxson - Rmit mechanical engineering and business management - Daphnia heart rate temperature lab report - Structure of cousin kate - On her loving two equally - Photosynthesis lab answer key - Gale force surfing case study - Fundamentals of financial management brigham houston pdf - Mythbusters ice bullet - Draw a diagram for a monopolist precisely labeling the portion - What is cbr in ns2 - Wesley family services das program - Metropolitan east school sport - Light independent stage location