Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

First Name Last Name Grade Amount Raised Sandra Parker 8 $100.00 Kim Li 9 $75.00 Maxwell Huang 8 $5.00 Joseph Smith 10 $25.00 Alec Jessup

First Name Last Name Grade Amount Raised
Sandra Parker 8 $100.00
Kim Li 9 $75.00
Maxwell Huang 8 $5.00
Joseph Smith 10 $25.00
Alec Jessup 11 $30.00
Leslie Pollock 9 $150.00
Sriya Chopra 12 $75.00
Isabel Mendez 12 $36.00
Jermaine Rossi 9 $54.00
Phillip Jackson 10 $89.00
Ana Portofino 10 $23.00
Katherine Sansa 11 $27.00
Lee Chang 8 $90.00
Tiquana Johnson 12 $67.00
Braxton Gerrard 11 $84.00
Will Kipley 9 $110.00
Muhammed Assaf 10 $250.00
Watson Merrigold 11 $7.00
Gabriela Potter 11 $90.00
Gustaf Handle 8 $22.00
Jenna Bates 8 $83.00
Thor Gundersen 12 $45.00
Lilly Bell 9 $91.00
Martin Campbell 9 $103.00
Shiva Niall 11 $107.00
Jessa Hart 10 $8.00
Matthew Brainerd 8 $11.00
Mariela Villalobos 10 $37.00
Juan Flores 12 $17.00

Instructions:

1.Using the challenge data set;

a.Determine the amounts raised by each grade, and total amount raised, using the most effective method available.

b.Rank the results, most to least amount raise, and represent totals amounts in an appropriate chart.

c.Format the results for enhance readability.

2.Insert your tabulated results into your assessment submission question.

3.Create a professional styled memo addressed to the principal with the above chart, and the names and amounts of the top 10 doners in rank order.

  • I need step to step instruction to know how to make this on Excel!!!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions