Business Finance
I need someone to do all the tasks in the excel for both of the sheets within only one hour.

Question Description

I need someone to do all the tasks in the excel for both of the sheets within only one hour please, thank you.

Unformatted Attachment Preview

inches 42 72 48 15 65 6 69 29 3 89 68 93 28 79 11 69 67 25 78 84 4 8 48 41 5 Average Sum Count Minimum Maximum Range feet yards cm Task 1: Fill in the chart by converting to the different units (ft, yd, cm) Task 2: make feet, yards and cm column look like the inches column (format-wise with the table lines and centerin Task 3: Record average, sum, count, minimum, maximum and range of each column Task 4: Label G2 "50" Task 5: Multiply each cm value by cell G2 (50) by using absolute referencing and put those values in G3-27 Task 6: Find average, sum, count, min, max and range for column G Task 7: Name Sheet "Units" Task 8: Merge and center boxes A1, B1, A2 and B2 Task 9: Your Name and the title of the sheet in the merged box. Task 10: Move onto Sheet 2 Task 1: Fill in the chart by converting to the different units (ft, yd, cm) Task 2: make feet, yards and cm column look like the inches column (format-wise with the table lines and centering) Task 3: Record average, sum, count, minimum, maximum and range of each column Task 4: Label G2 "50" Task 5: Multiply each cm value by cell G2 (50) by using absolute referencing and put those values in G3-27 Task 6: Find average, sum, count, min, max and range for column G Task 7: Name Sheet "Units" Task 8: Merge and center boxes A1, B1, A2 and B2 Task 9: Your Name and the title of the sheet in the merged box. Task 10: Move onto Sheet 2 and centering) A #1 Anna Bob Carl David Elsa Frank Gabriel Hans Isabella Jordan Kate Leonidas Morgan Nathan Opal Patrick Quark Rebecca Sally Tom Ursula Vivian Waldo Xena Yolanda Zelda Assignments Quiz Mid-term Final A #2 83 90 96 62 57 78 51 47 91 91 86 58 95 68 79 57 52 85 52 62 54 51 47 66 76 40 A #3 90 82 97 53 78 90 73 95 45 57 69 65 89 92 70 60 78 74 86 48 84 84 58 80 90 74 Q #1 75 90 92 42 86 78 82 47 80 62 90 61 66 96 68 44 97 87 72 54 75 92 81 72 46 71 Q#2 99 90 74 89 42 71 99 84 61 97 53 84 71 90 58 83 69 42 56 82 93 98 64 50 86 63 91 90 90 90 84 77 81 67 56 52 75 91 81 72 74 97 77 63 65 51 90 90 72 90 99 94 10% 10% 30% 50% Task 1: Calculate averages for assignments for each person and put it in column J with a title Task 2: Calculate averages for quizzes for each person and put it in column K with a title Task 3: Calculate the student's grade based on the weighted percentages in column L with a title Task 4: In cell L30, find the Lowest weighted grade using the "min" function and color that box red Task 5: In cell L31, find the Highest weighted grade using the "max" function and color that box green Task 6: Create a title for column M that says "Pass or Fail" Task 7: Create an "if" statement that makes all weighted averages above a 60%, an "Pass" and everything else bel Task 8: Create a title for column N that says "Letter grade" Task 9: Create a nested "if" statement for 90-100 (A), 80-89 (B), 70-79 (C), 60-69 (D), and everything 59 and below Task 10: Create a count of how many A, B, C, D and Fs there are (Use =COUNTIF) Task 11: Create a bar graph showing how many of each letter grade there are Task 12: Add Title and Axis Titles Task 13: Name Sheet "Grades" (down at the bottom… the tab) Mid-term Final Exam 60 63 43 93 98 98 98 59 84 62 94 40 80 69 61 91 43 74 53 99 76 81 44 79 78 41 100 84 73 99 92 41 66 90 43 73 97 90 90 60 65 62 79 69 69 85 90 74 100 82 83 63 hat box green s" and everything else below that is a "Fail" d everything 59 and below as an (F). ...
Purchase answer to see full attachment

Final Answer

The solution is attached.Let me know if you need any clarification.
Attached.

Turki Almalki
Units

Average
Sum
Count
Minimum
Maximum
Range

inches
42
72
48
15
65
6
69
29
3
89
68
93
28
79
11
69
67
25
78
84
4
8
48
41
5

feet
3.50
6.00
4.00
1.25
5.42
0.50
5.75
2.42
0.25
7.42
5.67
7.75
2.33
6.58
0.92
5.75
5.58
2.08
6.50
7.00
0.33
0.67
4.00
3.42
0.42

yards
1.17
2.00
1.33
0.42
1.81
0.17
1.92
0.81
0.08
2.47
1.89
2.58
0.78
2.19
0.31
1.92
1.86
0.69
2.17
2.33
0.11
0.22
1.33
1.14
0.14

cm
106.68
182.88
121.92
38.10
165.10
15.24
175.26
73.66
7.62
226.06
172.72
236.22
71.12
200.66
27.94
175.26
170.18
63.50
198.12
213.36
10.16
20.32
121.92
104.14
12.70

50
5334
9144
6096
1905
8255
762
8763
3683
381
11303
8636
11811
3556
10033
1397
8763
8509
3175
9906
10668
508
1016
6096
5207
635

45.84
1146
25
3
93
90

3.82
95.50
25
0.25
7.75
7.50

1.27
31.83
25
0.08
2.58
2.50

116.43
2910.84
25
7.62
236.22
228.60

5821.68
145542.00
25
381.00
11811.00
11430.00

Task 1: Fill in the chart by converting to the different units (...

uoscar (3957)
New York University

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors