Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN: 9781337508841
Author: Carey
Publisher: Cengage
bartleby

Concept explainers

Fundamentals of Robotics
Robotics is a branch of computer science and engineering that deals with designing, constructing, functioning, and use of robots. The objective of robotics is to create machines that assist humans. Robotics engineering incorporates several engineering fi…
Question

Provide a suitable chart for the 4 spread 

Instructions For this assignment, there are four different types of charts that you will need to create. also have needed to have determined which chart type fits the best for each question (there could be more than one answer, but you only need to choose one for each question). You will also need to create the chart based upon the data in the Excel spreadsheet. There are four tabs in the worksheet below. NNNNNNNN 18 19 20 21 23 24 25 Design Development 26 Documentation www 1 Hourly Category 2 Attend Training 3 Conduct Training 4 Configuration 5 Content Development 6 CRM Configuration 7 CRM Data Migration 8 CRM Design 9 10 11 12 CRM Integration Implementation 13 CRM Project Management 14 CRM Report Customization 15 CRM Scoping 16 CRM Support 17 CRM Testing CRM Upgrade Installation CRM Upgrade Scoping CRM Workflow Customization Data Migration 1. For the "Hour Totals By Consultant" tab, I need for you to pick a chart type that will allow me to see the distribution of the types of time entries entered by consultant. There are four types of possible hour types, "PTO", "Travel Hours", "Non-Billable Hours", and "Billable Hours". The title of the chart should be "Total Hours by Consultant by Hour Type". Please create this chart and put it on that tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 2. For the "total hours by consultant by mo" tab, I need for you to pick a chart type that shows the trend by month. The chart should show the months in the correct order. Also, I need to see that trend by consultant. Create this chart on the same tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 3. For the "total hours by category" tab, I need for you to pick a chart type that will allow for me to determine the total hours by category and its percentage of the whole. Make sure the chart is easy to read. You can choose whatever format you like. However, make sure that the format you choose accomplishes the goal of the chart. 4. For the "totals sales by month by cust." tab, I need for you to create a chart that looks like this: Total Sales by Month by Customer 31 800 700 600 500 400 Links Disabled - Links to external wo 22 Database/Company Set Up Demonstration 300 200 100 fx 0 27 Form Customization 28 Holiday 29 Installation 30 U A CRM Development CRM Form Customization CRM Installation fx 32 33 34 35 36 37 38 Research 39 Sales Support 40 Scoping 41 Scribe Installation Integration Design Office Time Onsite Support Preparation/Planning LO Project Management PTO 42 Scribe Integration Support 43 Self Study 44 Status Meeting 45 Subject Matter Expert Consulting 46 Support 47 48 49 50 51 Upgrade Testing 52 Workflow Customization 53 Grand Total 54 Remote Service Pack Deployment Report Customization System Administration Team Meeting Testing Upgrade Installation 7 1 Months 2 7 3 8 4 9 5 10 6 11 7 12 8 Grand Total 9 10 A 1 Months 2 7 3 8 4 9 5 10 6 11 fx tant A Company 1 # Company 2 Company 3 Company 4 Enter text or formula | Links Disabled - Links to external workbooks are not supported and have been disabled. A B Sum of total Hours 149.2 38.9 20.5 182.3 44.8 10.4 57.2 25.3 42.7 0.5 6.6 164.2 12.6 34.9 349.9 19.7 12 1.3 23.8 10.6 5.6 16.3 5.9 1.6 27.3 49.5 136 20.5 1.3 687.1 14.5 8.7 76.4 117.2 2.3 56.4 8.7 4.5 64.2 0.4 0.8 113.7 15.4 1 Consultant 2 Anderson, Brant 3 Johnson, Andrea 4 5 Total Hours By Category Smith, Kade Stewart, Travis 6 Grand Total 7 8 fx 107.3 379.7 7.1 35.4 54.3 2.3 38.3 6 3272.1 A 1 Months 2 3 4 C B 10 Company 1 7 9 8 10 11 12 5 6 7 8 Grand Total fx 167.9 691.9 859.8 II Enter text or formula here Company 5 Company 6 D B 11 Company 1 E B с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. 87.2 458.7 Enter text or formula here 87.2 458.7 545.9 167.9 12 24 172.1 178 184 168 178.7 904.8 Hour totals by Consultant 364.1 598.8 652.6 1615.5 Enter text or formula here total hours by consultant by mo C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. C 246.2 Hour totals by Consultant 364.1 598.8 652.6 89.4 197.1 171.6 181.2 639.3 Enter text or formula here F B с D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 4 270.4 357.4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Links Disabled - Links to external workbooks are not supported and have been disabled. D 1.7 1.7 F Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 36 167.9 171.7 184.4 167.9 176.2 904.1 Company 6 Total Sales By Month By Custome E F Total Hours By Category G 24.3 169.4 176.3 179 119.1 155.8 823.9 4.6 7.5 0 0 12.1 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G F + > Tota + > |
expand button
Transcribed Image Text:Instructions For this assignment, there are four different types of charts that you will need to create. also have needed to have determined which chart type fits the best for each question (there could be more than one answer, but you only need to choose one for each question). You will also need to create the chart based upon the data in the Excel spreadsheet. There are four tabs in the worksheet below. NNNNNNNN 18 19 20 21 23 24 25 Design Development 26 Documentation www 1 Hourly Category 2 Attend Training 3 Conduct Training 4 Configuration 5 Content Development 6 CRM Configuration 7 CRM Data Migration 8 CRM Design 9 10 11 12 CRM Integration Implementation 13 CRM Project Management 14 CRM Report Customization 15 CRM Scoping 16 CRM Support 17 CRM Testing CRM Upgrade Installation CRM Upgrade Scoping CRM Workflow Customization Data Migration 1. For the "Hour Totals By Consultant" tab, I need for you to pick a chart type that will allow me to see the distribution of the types of time entries entered by consultant. There are four types of possible hour types, "PTO", "Travel Hours", "Non-Billable Hours", and "Billable Hours". The title of the chart should be "Total Hours by Consultant by Hour Type". Please create this chart and put it on that tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 2. For the "total hours by consultant by mo" tab, I need for you to pick a chart type that shows the trend by month. The chart should show the months in the correct order. Also, I need to see that trend by consultant. Create this chart on the same tab. You can format it however you like. However, make sure that the format you choose accomplishes the goal of the chart. 3. For the "total hours by category" tab, I need for you to pick a chart type that will allow for me to determine the total hours by category and its percentage of the whole. Make sure the chart is easy to read. You can choose whatever format you like. However, make sure that the format you choose accomplishes the goal of the chart. 4. For the "totals sales by month by cust." tab, I need for you to create a chart that looks like this: Total Sales by Month by Customer 31 800 700 600 500 400 Links Disabled - Links to external wo 22 Database/Company Set Up Demonstration 300 200 100 fx 0 27 Form Customization 28 Holiday 29 Installation 30 U A CRM Development CRM Form Customization CRM Installation fx 32 33 34 35 36 37 38 Research 39 Sales Support 40 Scoping 41 Scribe Installation Integration Design Office Time Onsite Support Preparation/Planning LO Project Management PTO 42 Scribe Integration Support 43 Self Study 44 Status Meeting 45 Subject Matter Expert Consulting 46 Support 47 48 49 50 51 Upgrade Testing 52 Workflow Customization 53 Grand Total 54 Remote Service Pack Deployment Report Customization System Administration Team Meeting Testing Upgrade Installation 7 1 Months 2 7 3 8 4 9 5 10 6 11 7 12 8 Grand Total 9 10 A 1 Months 2 7 3 8 4 9 5 10 6 11 fx tant A Company 1 # Company 2 Company 3 Company 4 Enter text or formula | Links Disabled - Links to external workbooks are not supported and have been disabled. A B Sum of total Hours 149.2 38.9 20.5 182.3 44.8 10.4 57.2 25.3 42.7 0.5 6.6 164.2 12.6 34.9 349.9 19.7 12 1.3 23.8 10.6 5.6 16.3 5.9 1.6 27.3 49.5 136 20.5 1.3 687.1 14.5 8.7 76.4 117.2 2.3 56.4 8.7 4.5 64.2 0.4 0.8 113.7 15.4 1 Consultant 2 Anderson, Brant 3 Johnson, Andrea 4 5 Total Hours By Category Smith, Kade Stewart, Travis 6 Grand Total 7 8 fx 107.3 379.7 7.1 35.4 54.3 2.3 38.3 6 3272.1 A 1 Months 2 3 4 C B 10 Company 1 7 9 8 10 11 12 5 6 7 8 Grand Total fx 167.9 691.9 859.8 II Enter text or formula here Company 5 Company 6 D B 11 Company 1 E B с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. 87.2 458.7 Enter text or formula here 87.2 458.7 545.9 167.9 12 24 172.1 178 184 168 178.7 904.8 Hour totals by Consultant 364.1 598.8 652.6 1615.5 Enter text or formula here total hours by consultant by mo C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 Links Disabled - Links to external workbooks are not supported and have been disabled. C 246.2 Hour totals by Consultant 364.1 598.8 652.6 89.4 197.1 171.6 181.2 639.3 Enter text or formula here F B с D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 4 270.4 357.4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Links Disabled - Links to external workbooks are not supported and have been disabled. D 1.7 1.7 F Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 36 167.9 171.7 184.4 167.9 176.2 904.1 Company 6 Total Sales By Month By Custome E F Total Hours By Category G 24.3 169.4 176.3 179 119.1 155.8 823.9 4.6 7.5 0 0 12.1 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G F + > Tota + > |
Expert Solution
Check Mark
Step 1

Let's do the chart one by one from the beginning

 

bartleby

Step by stepSolved in 5 steps with 8 images

See solution
Check out a sample Q&A here
Blurred answer
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Text book image
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
SEE MORE TEXTBOOKS