2 Modules Design/Formatting and Functions/Formulas

User Generated

Hmv727

Business Finance

Description

So I have two different excels I need to edit and make it look a certain way. The first one is pretty easy I just need to reformat/design it to make it look like this.

https://imgur.com/a/Atet0tw


The second module needs to look like this

https://imgur.com/a/AjjJPDm

I have uploaded both starting modules. Let me know if you have any questions.

Unformatted Attachment Preview

FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET (in millions) December 31, 2010 December 31, 2009 ASSETS Cash and cash equivalen ts Marketab le securities (Note 6) $ 14,805 $ 20,894 20,765 21,387 70,070 75,892 7,388 7,194 11,675 17,270 Inventori es (Note 10) 5,917 5,041 Equity in net assets of affiliated companie s (Note 11) 2,569 2,367 Net property (Note 14) 23,179 22,637 Deferred income taxes 2,003 3,479 Finance receivabl es, net (Note 7) Other receivabl es, net Net investme nt in operating leases (Note 8) Net intangibl e assets (Note 16) Assets of held-forsale operation s (Note 24) Other assets Total assets 102 165 — 7,618 6,214 8,096 $ 164,687 $ 192,040 $ 16,362 $ 14,301 LIABILIT IES Payables Accrued liabilities and deferred revenue (Note 17) 43,844 46,144 Debt (Note 19) 103,988 131,635 1,135 2,421 — 5,321 165,329 199,822 Deferred income taxes Liabilitie s of heldfor-sale operation s (Note 24) Total liabiliti es EQUIT Y Capital stock (Note 25) Comm on Stock, par value $0.01 per share (3,707 million shares issued of 6 billion authori zed) Class B Stock, par value $0.01 per share (71 million shares issued of 530 million authori zed) 37 33 1 1 20,803 16,786 (14,313 ) (10,864 ) (163 ) (177 ) (7,038 ) (13,599 ) Capital in excess of par value of stock Accumul ated other compreh ensive income/(l oss) Treasury stock Retained earnings/ (Accumu lated deficit) Total equity/( deficit) attribut able to Ford Motor Compa ny (673 ) Equity/( Deficit) attributab le to noncontr olling interests 31 Total equity/( deficit) Total liabiliti es and equity (7,820 ) 38 (642 ) $ 164,687 (7,782 ) $ 192,040 Name Student 1 Student 2 Student 3 Student 4 Student 5 Student 6 Student 7 Student 8 Student 9 Student 10 Student 11 Student 12 Student 13 Student 14 Student 15 Student 16 Student 17 Student 18 Student 19 Student 20 Student 21 Student 22 Student 23 Student 24 Student 25 Student 26 Student 27 Student 28 Student 29 Student 30 Student 31 Student 32 Student 33 Student 34 Student 35 Student 36 Student 37 Student 38 Student 39 Student 40 Student 41 Student 42 Student 43 Student 44 Student 45 Student 46 Student 47 Student 48 Student 49 Student 50 Student 51 Student 52 Student 53 Student 54 Exam 1 Exam 2 90 96 89 89 97 91 56 89 93 50 50 98 84 55 90 96 95 79 85 93 78 93 89 67 90 92 90 93 90 88 93 94 89 93 50 90 88 94 85 91 89 97 94 91 84 94 96 94 50 71 86 89 96 80 88 97 96 97 88 89 85 89 96 89 86 100 90 89 94 100 95 89 88 64 92 95 91 90 97 91 96 97 83 86 93 91 50 93 50 83 91 98 87 89 84 88 95 95 76 91 87 93 53 80 50 90 95 87 Exam 3 93 96 92 96 93 62 55 91 100 89 96 98 63 92 94 98 99 87 93 93 91 96 92 85 99 90 70 91 91 96 97 90 50 93 50 96 95 98 88 94 83 95 90 98 83 95 67 99 50 50 89 88 98 58 Exam Percent Project 57 100 72 73 95 16 28 90 100 74 98 100 0 83 88 100 98 100 75 75 28 100 84 88 100 98 100 76 76 100 47 93 1 62 0 47 34 100 100 93 84 49 100 98 84 92 61 87 0 58 85 62 97 27 Project Percent Student 55 Student 56 Student 57 Student 58 Student 59 Student 60 Student 61 Student 62 Student 63 Student 64 Student 65 Student 66 Student 67 Student 68 Student 69 Student 70 Student 71 Student 72 Student 73 Student 74 Student 75 Student 76 Student 77 Student 78 Student 79 Student 80 Student 81 Student 82 Student 83 Student 84 Student 85 Student 86 Student 87 Student 88 Student 89 Student 90 Student 91 Student 92 Student 93 Student 94 Student 95 Student 96 Student 97 Student 98 Student 99 Student 100 Student 101 Student 102 Student 103 Student 104 Student 105 Student 106 Student 107 Student 108 Student 109 95 90 89 50 87 50 89 94 99 86 50 94 87 89 85 88 88 92 98 80 89 96 98 93 84 50 89 84 79 99 91 96 88 50 95 89 91 88 50 50 50 96 94 87 91 99 92 89 92 85 93 87 92 93 90 88 60 91 54 87 55 82 97 91 95 95 93 94 82 93 88 85 94 95 88 85 95 68 94 81 92 89 50 94 97 85 98 87 85 96 50 87 90 56 57 86 100 92 93 90 96 95 84 98 94 92 86 92 65 61 99 94 96 50 60 50 90 97 96 92 99 93 92 88 93 89 88 96 98 61 76 95 93 89 88 66 93 95 91 96 87 97 86 98 86 50 92 83 50 50 82 98 98 97 88 99 89 86 95 69 97 93 94 50 50 100 51 73 25 70 0 68 100 100 56 99 53 94 97 72 98 26 97 100 37 84 100 100 89 55 61 67 98 64 100 60 100 100 39 71 54 41 46 61 0 66 93 100 84 60 100 64 85 73 39 88 70 74 24 27 Student 110 Student 111 Student 112 Student 113 Student 114 Student 115 Student 116 Student 117 Student 118 Student 119 Student 120 Student 121 Student 122 Student 123 Student 124 Student 125 Student 126 Student 127 Student 128 Student 129 Student 130 Student 131 Student 132 Student 133 Student 134 Student 135 Student 136 Student 137 Student 138 Student 139 Student 140 Student 141 Student 142 Student 143 Student 144 Student 145 Student 146 Student 147 Student 148 Student 149 Student 150 Student 151 Student 152 Student 153 Student 154 Student 155 Student 156 Student 157 Student 158 Student 159 Student 160 Student 161 Student 162 Student 163 Student 164 83 87 87 90 80 82 86 92 88 93 91 82 50 91 94 85 87 95 50 82 86 81 95 81 92 92 87 78 98 87 84 95 88 92 86 53 93 88 82 98 90 82 90 90 98 89 50 86 88 91 80 78 93 85 80 85 94 92 91 89 94 86 63 80 83 92 91 79 90 90 83 50 66 93 90 95 81 98 90 92 94 92 59 99 89 98 96 86 90 91 89 88 96 96 67 95 87 97 81 98 94 50 80 90 92 60 51 95 96 84 56 96 93 96 90 82 92 92 91 80 94 64 82 95 96 85 50 50 95 93 90 89 94 89 99 97 95 50 96 96 97 98 81 98 94 92 94 97 94 97 91 59 90 87 71 89 80 85 95 67 50 50 98 94 54 83 98 49 17 89 23 92 96 78 100 98 63 45 63 70 49 28 77 71 41 77 28 71 47 74 98 56 32 98 77 77 100 80 100 100 75 89 97 94 94 78 40 78 33 100 53 32 27 55 54 73 0 78 100 17 Student 165 Student 166 Student 167 Student 168 Student 169 Student 170 Student 171 Student 172 Student 173 Student 174 Student 175 Student 176 Student 177 Student 178 Student 179 Student 180 Student 181 Student 182 Student 183 Student 184 Student 185 Student 186 Student 187 Student 188 Student 189 Student 190 Student 191 Student 192 Student 193 Student 194 Student 195 Student 196 Student 197 Student 198 Student 199 Student 200 Student 201 Student 202 Student 203 Student 204 Student 205 Student 206 Student 207 Student 208 Student 209 Student 210 Student 211 Student 212 Student 213 Student 214 Student 215 Student 216 Student 217 Student 218 Student 219 93 86 90 92 92 88 89 84 91 84 93 87 94 89 89 89 91 93 83 91 50 89 87 87 95 92 88 92 88 85 92 89 95 88 83 91 50 91 34 84 88 73 94 82 97 85 96 90 89 90 45 80 82 86 84 98 85 89 92 87 92 50 62 87 88 91 93 97 92 92 89 96 96 85 93 92 87 85 94 93 90 89 93 95 92 87 89 91 97 89 93 52 62 89 91 93 58 89 93 96 92 91 50 91 93 67 93 61 93 86 97 57 89 94 89 93 92 84 95 98 95 92 95 85 91 88 91 96 87 90 65 85 87 91 96 88 91 91 96 96 98 86 92 96 82 68 50 93 91 82 94 50 97 93 98 92 97 94 93 89 50 89 88 89 89 96 40 89 91 100 0 42 100 70 96 90 100 88 87 47 96 100 100 63 100 45 46 61 66 94 73 58 64 92 96 52 100 49 69 63 65 19 58 98 46 89 92 28 95 100 93 100 45 85 95 0 83 94 81 90 Student 220 Student 221 Student 222 Student 223 Student 224 Student 225 Average Max Min Median Mode Standard Deviation Count of 90 or above Count of less than 70 94 24 50 89 87 93 94 94 93 93 89 94 95 96 91 88 88 97 100 100 67 16 57 73 Grade Percentage Letter Grade Plus-Minus Letters Percent Letter Total Percent Grade Point Average 0 4.33 1 2 2.33 2.66 3 3.33 3.66 4
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached

Name
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Student 19
Student 20
Student 21
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Student 31
Student 32
Student 33
Student 34
Student 35
Student 36
Student 37
Student 38
Student 39
Student 40
Student 41
Student 42
Student 43
Student 44
Student 45
Student 46
Student 47
Student 48
Student 49
Student 50
Student 51
Student 52
Student 53
Student 54

Exam 1

Exam 2
90
96
89
89
97
91
56
89
93
50
50
98
84
55
90
96
95
79
85
93
78
93
89
67
90
92
90
93
90
88
93
94
89
93
50
90
88
94
85
91
89
97
94
91
84
94
96
94
50
71
86
89
96
80

88
97
96
97
88
89
85
89
96
89
86
100
90
89
94
100
95
89
88
64
92
95
91
90
97
91
96
97
83
86
93
91
50
93
50
83
91
98
87
89
84
88
95
95
76
91
87
93
53
80
50
90
95
87

Exam 3
93
96
92
96
93
62
55
91
100
89
96
98
63
92
94
98
99
87
93
93
91
96
92
85
99
90
70
91
91
96
97
90
50
93
50
96
95
98
88
94
83
95
90
98
83
95
67
99
50
50
89
88
98
58

Exam Percent Project
Project Percent
72.27%
57
11.40%
77.07%
100
20.00%
73.87%
72
14.40%
75.20%
73
14.60%
74.13%
95
19.00%
64.53%
16
3.20%
52.27%
28
5.60%
71.73%
90
18.00%
77.07%
100
20.00%
60.80%
74
14.80%
61.87%
98
19.60%
78.93%
100
20.00%
63.20%
0
0.00%
62.93%
83
16.60%
74.13%
88
17.60%
78.40%
100
20.00%
77.07%
98
19.60%
68.00%
100
20.00%
70.93%
75
15.00%
66.67%
75
15.00%
69.60%
28
5.60%
75.73%
100
20.00%
72.53%
84
16.80%
64.53%
88
17.60%
76.27%
100
20.00%
72.80%
98
19.60%
68.27%
100
20.00%
74.93%
76
15.20%
70.40%
76
15.20%
72.00%
100
20.00%
75.47%
47
9.40%
73.33%
93
18.60%
50.40%
1
0.20%
74.40%
62
12.40%
40.00%
0
0.00%
71.73%
47
9.40%
73.07%
34
6.80%
77.33%
100
20.00%
69.33%
100
20.00%
73.07%
93
18.60%
68.27%
84
16.80%
74.67%
49
9.80%
74.40%
100
20.00%
75.73%
98
19.60%
64.80%
84
16.80%
74.67%
92
18.40%
66.67%
61
12.20%
76.27%
87
17.40%
40.80%
0
0.00%
53.60%
58
11.60%
60.00%
85
17.00%
71.20%
62
12.40%
77.07%
97
19.40%
60.00%
27
5.40%

Student 55
Student 56
Student 57
Student 58
Student 59
Student 60
Student 61
Student 62
Student 63
Student 64
Student 65
Student 66
Student 67
Student 68
Student 69
Student 70
Student 71
Student 72
Student 73
Student 74
Student 75
Student 76
Student 77
Student 78
Student 79
Student 80
Student 81
Student 82
Student 83
Student 84
Student 85
Student 86
Student 87
Student 88
Student 89
Student 90
Student 91
Student 92
Student 93
Student 94
Student 95
Student 96
Student 97
Student 98
Student 99
Student 100
Student 101
Student 102
Student 103
Student 104
Student 105
Student 106
Student 107
Student 108
Student 109

95
90
89
50
87
50
89
...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags