# YOF EM03 A1 â€“ Guilford College Repair & Share Club 1.1

Brazil2013 bought 14 out of 15 answered question(s)
Excel III
Information are in the att
Attachments:
YOF EM03 A1 â€“ Guilford College Repair & Share Club 1.1

Project Description:
You have been asked to advise a new club on campus called the Repair and Share Club. Its purpose is to collect used desktop and laptop computers donated from area companies and refurbish them for members of their college community. The students in this club are responsible for collecting and rebuilding these computers to give back to students on campus. The goal is to collect at least 30 computers from each company. The dean requires a report of the clubâ€™s activities over the academic year in a spreadsheet format that tracks student involvement, company donations and students receiving the refurbished computers.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Excel. Open the downloaded Excel file named e03ps3_grader_a1_start.xlsx. Save the file with the name e03ps3ShareClub_LastFirst, replacing LastFirst with your name. 0.000
2 On the Club Information worksheet, in range H6:H16, create a range named Volunteer_Hrs. In range D6:D16, create a range named Class. 4.000
3 A grade table appears in the spreadsheet assigning letter grades to grade point averages. In cell J6, use a VLOOKUP function to determine a letter grade for the grade point average in cell I6. Use AutoFill to copy the function to range J7:J16. Use absolute references in your formula as necessary. Fill the formula without formatting so the borders remain formatted. 4.000
4 Insert a new column to the left of column H. In cell H5, type Courses Completed. Resize the column as needed. 3.000
5 In cell H6, use an IF function with a nested AND function to create a function that analyzes the content of F6 and G6. Return Complete if both cells contain a Y, or Incomplete if one or both cells contain an N. Use AutoFill to copy the function to range H7:H16 without copying formatting. 6.000
6 In range A5:K16, insert a table. Use the headers in the top row to create named ranges for each of the columns. Resize the columns as needed. 5.000
7 The dean has requested a report of the studentâ€™s information. She wants a breakdown of the studentâ€™s year in high school, volunteer hours, and their grades. In cell A20, type Student Report Analysis. In cell B21, type Headcount Total. In cell C21, type Total Hours. Resize the columns as needed. In cell A22, type Seniors. In cell A23, type Juniors. In cell A24, type Sophomores. In cell A26, type â€œAâ€ Students. In cell A27, type â€œD-â€ Students. 5.000
8 In cell B22, create a COUNTIF function that counts the number of Seniors in the list using the name range Class. In cell B23, create a COUNTIF function that counts the number of Juniors in the list using the name range Class. In cell B24, create a COUNTIF function that counts the number of Sophomores in the list using the name range Class. 7.000
9 In cell C22, using the name ranges Class and Volunteer_Hrs, create a SUMIF function that displays the total number of volunteer hours for Seniors. In cell C23, using the name ranges Class and Volunteer_Hrs, create a SUMIF function that displays the total number of volunteer hours for Juniors. In cell C24, using the name ranges Class and Volunteer_Hrs, create a SUMIF function that displays the total number of volunteer hours for Sophomores. 7.000
10 In cell C26, create a SUMIF function that totals the number of volunteer hours for â€œAâ€ students. In cell C27, create a SUMIF function that totals the number of volunteer hours for â€œD-â€ students. 7.000
11 The dean has also requested an analysis regarding the companies involved in donating computers to the club. The clubâ€™s goal is to have each company donate a minimum of 30 computers. In cell A39, type Totals. Use a function in B39:E39 to find the total sum for the Value, Donated, Desktops, and Laptops columns, respectively. 10.000
12 In cell F33, create an IF function that evaluates the total number of computers donated from Safety Inc. If a minimum of 30 computers have been donated, the function will return Goal Met. If fewer than 30 computers are donated, the function will return Under Goal. Use AutoFill to copy the function to cell F37. 4.000
13 Using the data in the table, insert a PivotTable in cell A10 on the Pivot Analysis worksheet. Use the following criteria to create the PivotTable and answer the questions in rows 1, 3 and 5. Add the Major and GPA fields to the FILTERS area (in that order). Add the Grade, Year, and FirstName fields to the ROWS area (in that order). Add the Volunteer Hours and LastName fields to the VALUES area (in that order). Display subtotals at the bottom of each group.

In cell A10, type Grades. In cell B10, type TotalHours. In cell C10, type TotalStudents. Resize the columns as needed. 8.000
14 Insert a slicer for the Grade field. Format the slicer with 3 columns. Resize the slicer to remove the extra white space at the bottom. Move the slicer so the top-left corner is in cell E10. 0.000
15 In the slicer, select A, A-, B+, and B-. Use the data in the PivotTable to answer question 1, and then type your answer in cell A2. 8.000
16 Clear the filter in the slicer, and then select A. In cell B8, filter the data so the student with the highest GPA displays. In cell A4, type the answer for question 2. 4.000
17 Clear the filters. Remove the Grade and Year fields from the ROWS area. Sort the Total Hours field in largest to smallest order. Type your answers for question 3 in cells A6:B6. 8.000
18 Apply Pivot Style Medium 9 to the PivotTable. Apply Slicer Style Dark 1 to the slicer. Remove the largest to smallest order sort on the Total Hours field. 3.000
19 Insert a Clustered Column PivotChart on a new worksheet named PivotChartAnalysis. Remove the Total Students field from the VALUES area. Delete the legend. In the chart title, replace Total with VolunteerHoursbyStudent. Apply Style 4 to the PivotChart. 7.000
20 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Club information, PivotChart Analysis, Pivot Analysis. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000
Total Points 100.000
Guilford College Repair & Share Club

Student Information
StudentID LastName FirstName Year Major â€œProgramming
30456 Boucher Tom Senior Computer Science Y Y 152 3.21 0.00 F
58965 Garcia Franko Senior Computer Science Y Y 182 4.00 1.00 D-
56792 Glonden Thomas Junior MIS Y N 133 1.23 1.25 D
48795 Blasise Cherly Sophomore Networking Y Y 58 3.67 1.75 D+
23597 Linde Alice Senior Networking Y Y 110 3.91 2.00 C-
21486 Benoit Alexia Senior MIS N N 149 4.15 2.25 C
64687 Cyr Judy Junior Computer Science Y Y 145 2.10 2.75 C+
48946 Chu Lin Sophomore Computer Science Y Y 94 3.50 3.00 B-
54684 Villani Mark Junior Engineering N N 72 1.77 3.25 B
46846 Zacheris John Sophomore Engineering Y Y 113 1.98 3.50 B+
41123 Ching Lau Junior MIS N N 109 2.40 3.90 A-
4.00 A
4.25 A+

Company Donation Information
Company Value Donated Desktops Laptops Status
Safety Inc. \$4,600 23 10 13
First National \$450 33 22 11
Boscoâ€™s \$575 25 11 14
Software City \$1,950 17 4 13
Sacari Financial \$1,600 8 2 6
Â

# Our Service Charter

1. ### Excellent Quality / 100% Plagiarism-Free

We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
2. ### Free Revisions

We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
3. ### Confidentiality / 100% No Disclosure

We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
4. ### Money Back Guarantee

If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.

We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

or

## Instant Quote

 Subject: Please Select... Art   Architecture   Dance   Design Analysis   Drama   Movies   Music   Paintings   Theatre Biology Business Chemistry Communications and Media   Advertising   Communication Strategies   Journalism   Public Relations Creative writing Economics   Accounting   Case Study   Company Analysis   E-Commerce   Finance   Investment   Logistics   Trade Education   Application Essay   Education Theories   Pedagogy   Teacher's Career Engineering English Ethics History   African-American Studies   American History   Asian Studies   Canadian Studies   East European Studies   Holocaust   Latin-American Studies   Native-American Studies   West European Studies Law   Criminology   Legal Issues Linguistics Literature   American Literature   Antique Literature   Asian Literature   English Literature   Shakespeare Studies Management Marketing Mathematics Medicine and Health   Alternative Medicine   Healthcare   Nursing   Nutrition   Pharmacology   Sport Nature   Agricultural Studies   Anthropology   Astronomy   Environmental Issues   Geography   Geology Philosophy Physics Political Science Psychology Religion and Theology Sociology Technology   Aeronautics   Aviation   Computer Science   Internet   IT Management   Web Design Tourism Type: Please Select... Essay Term Paper Research Paper Coursework Book Report Book Review Movie Review Dissertation Thesis Thesis Proposal Research Proposal Dissertation Chapter - Abstract Dissertation Chapter - Introduction Chapter Dissertation Chapter - Literature Review Dissertation Chapter - Methodology Dissertation Chapter - Results Dissertation Chapter - Discussion Dissertation Services - Editing Dissertation Services - Proofreading Formatting Admission Services - Admission Essay Admission Services - Scholarship Essay Admission Services - Personal Statement Admission Services - Editing Editing Proofreading Case Study Lab Report Speech Presentation Math Problem Article Article Critique Annotated Bibliography Reaction Paper PowerPoint Presentation Statistics Project Multiple Choice Questions (None-Time-Framed) Other (Not listed) Pages/Words: 1 page/approx 275 words 2 pages/approx 550 words 3 pages/approx 825 words 4 pages/approx 1100 words 5 pages/approx 1375 words 6 pages/approx 1650 words 7 pages/approx 1925 words 8 pages/approx 2200 words 9 pages/approx 2475 words 10 pages/approx 2750 words 11 pages/approx 3025 words 12 pages/approx 3300 words 13 pages/approx 3575 words 14 pages/approx 3850 words 15 pages/approx 4125 words 16 pages/approx 4400 words 17 pages/approx 4675 words 18 pages/approx 4950 words 19 pages/approx 5225 words 20 pages/approx 5500 words 21 pages/approx 5775 words 22 pages/approx 6050 words 23 pages/approx 6325 words 24 pages/approx 6600 words 25 pages/approx 6875 words 26 pages/approx 7150 words 27 pages/approx 7425 words 28 pages/approx 7700 words 29 pages/approx 7975 words 30 pages/approx 8250 words 31 pages/approx 8525 words 32 pages/approx 8800 words 33 pages/approx 9075 words 34 pages/approx 9350 words 35 pages/approx 9625 words 36 pages/approx 9900 words 37 pages/approx 10175 words 38 pages/approx 10450 words 39 pages/approx 10725 words 40 pages/approx 11000 words 41 pages/approx 11275 words 42 pages/approx 11550 words 43 pages/approx 11825 words 44 pages/approx 12100 words 45 pages/approx 12375 words 46 pages/approx 12650 words 47 pages/approx 12925 words 48 pages/approx 13200 words 49 pages/approx 13475 words 50 pages/approx 13750 words 51 pages/approx 14025 words 52 pages/approx 14300 words 53 pages/approx 14575 words 54 pages/approx 14850 words 55 pages/approx 15125 words 56 pages/approx 15400 words 57 pages/approx 15675 words 58 pages/approx 15950 words 59 pages/approx 16225 words 60 pages/approx 16500 words 61 pages/approx 16775 words 62 pages/approx 17050 words 63 pages/approx 17325 words 64 pages/approx 17600 words 65 pages/approx 17875 words 66 pages/approx 18150 words 67 pages/approx 18425 words 68 pages/approx 18700 words 69 pages/approx 18975 words 70 pages/approx 19250 words 71 pages/approx 19525 words 72 pages/approx 19800 words 73 pages/approx 20075 words 74 pages/approx 20350 words 75 pages/approx 20625 words 76 pages/approx 20900 words 77 pages/approx 21175 words 78 pages/approx 21450 words 79 pages/approx 21725 words 80 pages/approx 22000 words 81 pages/approx 22275 words 82 pages/approx 22550 words 83 pages/approx 22825 words 84 pages/approx 23100 words 85 pages/approx 23375 words 86 pages/approx 23650 words 87 pages/approx 23925 words 88 pages/approx 24200 words 89 pages/approx 24475 words 90 pages/approx 24750 words 91 pages/approx 25025 words 92 pages/approx 25300 words 93 pages/approx 25575 words 94 pages/approx 25850 words 95 pages/approx 26125 words 96 pages/approx 26400 words 97 pages/approx 26675 words 98 pages/approx 26950 words 99 pages/approx 27225 words 100 pages/approx 27500 words 101 pages/approx 27775 words 102 pages/approx 28050 words 103 pages/approx 28325 words 104 pages/approx 28600 words 105 pages/approx 28875 words 106 pages/approx 29150 words 107 pages/approx 29425 words 108 pages/approx 29700 words 109 pages/approx 29975 words 110 pages/approx 30250 words 111 pages/approx 30525 words 112 pages/approx 30800 words 113 pages/approx 31075 words 114 pages/approx 31350 words 115 pages/approx 31625 words 116 pages/approx 31900 words 117 pages/approx 32175 words 118 pages/approx 32450 words 119 pages/approx 32725 words 120 pages/approx 33000 words 121 pages/approx 33275 words 122 pages/approx 33550 words 123 pages/approx 33825 words 124 pages/approx 34100 words 125 pages/approx 34375 words 126 pages/approx 34650 words 127 pages/approx 34925 words 128 pages/approx 35200 words 129 pages/approx 35475 words 130 pages/approx 35750 words 131 pages/approx 36025 words 132 pages/approx 36300 words 133 pages/approx 36575 words 134 pages/approx 36850 words 135 pages/approx 37125 words 136 pages/approx 37400 words 137 pages/approx 37675 words 138 pages/approx 37950 words 139 pages/approx 38225 words 140 pages/approx 38500 words 141 pages/approx 38775 words 142 pages/approx 39050 words 143 pages/approx 39325 words 144 pages/approx 39600 words 145 pages/approx 39875 words 146 pages/approx 40150 words 147 pages/approx 40425 words 148 pages/approx 40700 words 149 pages/approx 40975 words 150 pages/approx 41250 words 151 pages/approx 41525 words 152 pages/approx 41800 words 153 pages/approx 42075 words 154 pages/approx 42350 words 155 pages/approx 42625 words 156 pages/approx 42900 words 157 pages/approx 43175 words 158 pages/approx 43450 words 159 pages/approx 43725 words 160 pages/approx 44000 words 161 pages/approx 44275 words 162 pages/approx 44550 words 163 pages/approx 44825 words 164 pages/approx 45100 words 165 pages/approx 45375 words 166 pages/approx 45650 words 167 pages/approx 45925 words 168 pages/approx 46200 words 169 pages/approx 46475 words 170 pages/approx 46750 words 171 pages/approx 47025 words 172 pages/approx 47300 words 173 pages/approx 47575 words 174 pages/approx 47850 words 175 pages/approx 48125 words 176 pages/approx 48400 words 177 pages/approx 48675 words 178 pages/approx 48950 words 179 pages/approx 49225 words 180 pages/approx 49500 words 181 pages/approx 49775 words 182 pages/approx 50050 words 183 pages/approx 50325 words 184 pages/approx 50600 words 185 pages/approx 50875 words 186 pages/approx 51150 words 187 pages/approx 51425 words 188 pages/approx 51700 words 189 pages/approx 51975 words 190 pages/approx 52250 words 191 pages/approx 52525 words 192 pages/approx 52800 words 193 pages/approx 53075 words 194 pages/approx 53350 words 195 pages/approx 53625 words 196 pages/approx 53900 words 197 pages/approx 54175 words 198 pages/approx 54450 words 199 pages/approx 54725 words 200 pages/approx 55000 words Single spaced approx 275 words per page Urgency (Less urgent, less costly): Please Select... 6 hours 12 hours 24 hours 48 hours 3 days 4 days 5 days 7 days 10 days 20 days 30 days Level: Choose High School Undergraduate Master Ph. D. Currency: USD GBP CAD AUD EUR Total Cost: NaN

Get 10% Off on your 1st order!