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

Inset smartart style

29/03/2021 Client: saad24vbs Deadline: 2 Day

Internships and Travel Template

Project Description:

In the following project, you will assist Ann Takei, Internship Coordinator, in tracking the number of internships by industry at each job fair. You will insert and format sparklines, a line chart, and SmartArt graphics. You will also create a template to use for travel expenses.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Download and open the Excel workbook named GO_e06_Grader_h3.xlsx.

0

2

On the Internships by Industry worksheet, in the range G4:G10, insert line Sparklines using the values in the B4:F10.

10

3

Format the Sparklines to show the high point and the last point. Apply the Sparkline Style Accent 4, (no dark or light).

10

4

Create a line with markers chart using the ranges A3:F3 and A7:F7. Position the chart so that the upper left corner of the chart aligns with the upper left corner of cell A13.

11

5

Change the chart title to Internships Available in Technology.

6

6

Edit the Vertical (Value) Axis to set the Minimum to 35 and the Major unit to 5.

6

7

Format the plot area with a Green, Accent 6, Lighter 80% solid fill. Format the chart area with a Green, Accent 6, Lighter 40% solid fill.

8

8

Insert a linear trendline and change the width of the line to 2.5 pt.

6

9

On the List Chart worksheet, insert a SmartArt graphic using the Pyramid List style. Position the SmartArt so that the upper left corner of the graphic aligns with the upper left corner of cell A3.

7

10

In the SmartArt, type Paid in the top text box. Type Work-Study in the second text box, and Unpaid in the last text box.

1

11

Apply the Inset 3-D SmartArt style to the graphic. Change the colors to Colored Fill – Accent 1.

6

12

On the Organization Chart worksheet, insert a SmartArt graphic using the Hierarchy List style. Position the SmartArt so that the upper left corner of the graphic aligns with the upper left corner of cell A3.

7

13

In the SmartArt, on the left, type Ann Takei, Internship Coordinator in the top box and Dennis Maslin, Specialist in the second box. On the right, type Shani Kuhlman, Work-Study Coordinator in the first box and Anand Singh, Specialist in the second box. Leave the bottom boxes as they are.

2

14

Save the workbook as a template with the name GO_e06_Grader_h3_template.xltx. On the Travel Expenses worksheet, in cell H22 enter a formula that will add the contents of the range H15:H21. Apply the Total cell style to cell H22.

5

15

Remove the Locked formatting from the ranges D8:D10 and A15:G21. Protect the worksheet using the default selections and the password goseries.

15

16

Save the template as an Excel workbook with the file name, GO_e06_Grader_h3.xlsx. Ensure the worksheets are in this order: Internships by Industry, List Chart, Organization Chart, Travel Expenses. Close the workbook. Exit Excel. Submit the GO_e06_Grader_h3.xlsx workbook as directed. Do not submit your template file.

0

Total Points

100

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 Grade Tutor
Isabella K.
Academic Master
Top Academic Tutor
Financial Solutions Provider
Study Master
Writer Writer Name Offer Chat
Top Grade Tutor

ONLINE

Top Grade Tutor

I have read your project details. I can do this within your deadline.

$35 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I have read your project details. I can do this within your deadline.

$32 Chat With Writer
Academic Master

ONLINE

Academic Master

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

$64 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

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

$59 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$51 Chat With Writer
Study Master

ONLINE

Study Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

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

Corp root word meaning - Bachelor of clinical exercise physiology griffith - READING LOG - York machinery sales 2017 - Corpse bride death scene - Solve x 2 10 - Kaufman test of educational achievement subtests - Reading A Qustion of Intent (Book) and Writing Essay About It - K 10 history syllabus - Stock order book viewer - Being the leader - Bianca elouise net worth - New perspectives excel 2016 module 8 sam project 1a - Umass lowell math department - Touchstone 3 student book answer key pdf - The ethical process of decision-making involves consideration of three key elements - Microarray Paper - Arrange the following atoms in order of decreasing electronegativity - Clayton industries peter arnell country manager for italy - Discussion - Aneko company reports the following - Edexcel gcse mathematics linear 1ma0 coordinates answers - Leading and managing in nursing 7th ed - Staffing issues interactive case study - Reflection - For Guru Olivia Only - Blog - COVID-19 (CRISPR and EPIGENETICS) - Snhu accounting and finance - Post office world zones - 4 wallendbeen avenue port hacking - North shore hospital visiting hours - Presenting problem case study example - Mcgraw hill primis custom publishing - Programming with microsoft visual basic answer key - Objective positivist thinkers - Angle of impact blood spatter - Code in color charity kindness diaries - Www qstraint com registration - The new monogamy book - Here's much to do with hate - POSCI 4 - Affordable care act essay outline - Bath uni campus map - Bitcoin - Oceanview marine company 22 18 - You are using an exponential smoothing model for forecasting - Gm in china case study solution - Uneven cash flow stream definition - Assignment 2: New Venture: Launch Plan - Skechers relaxed fit sport prize seeker - Personal leadership development plan ncoa - Discussion Post T6-Q2 Business Strategy - Civics and citizenship definition - Leccion 4 contextos correcto o incorrecto - Roman history primary sources - What are your personal ethics - Kite runner chapter 6 - Gram stain lab report results - How to reclassify multiple transactions in quickbooks enterprise - Need assignent in 3 hours 2 pages - Segregation of duties in payroll cycle - COM 510 Discussion - Article Critique - Expulsion type lightning arrester - French role play script - Digicel telephone directory jamaica - Discussion - Financial reporting loftus 2nd edition - Ftse developed core infrastructure index - Foxtel satellite dish size - Husband Wife' 91=9829866507 Divorce LOVE Problem Solution Specialist Molvi JI - Journal of the northwest communication association - Bsbadm502 manage meetings task 1 - Intro to Social Work - Do My Homework - AG - Francis alys the last clown - National centre for vocational education research - Cpt code urolift - Similarities and differences between partnerships and sole proprietorships - The Internet of Things and its impact on individual privacy and security - LEADERSHIP AND CREATIVE SOLUTIONS - Tandara motor inn case - The kansas city preventive patrol experiment found that - Hydrostatics and Hydraulics Report - WEEK II PART1 - What is the parent company of chipotle - Final Project - Slough to gerrards cross bus 353 - Cmgt pro - Week 2 assignment digital forensics - Peace i hate the word as i hate hell - Theories of language learning - Winston and o'brien's relationship in 1984 - Frost tuft of flowers - The death penalty for and against pojman - Intact don t retract stickers - What are the strategically relevant factors in the macro environment - Paige pennington walter ray williams - Research paper - What fear can teach us answers