• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
  • 4.6 TrustPilot
0
Sell
Where do you study
Your language
Start selling Create your account
  • WGU C268 Spreadsheets
  • WGU C268 Spreadsheets
To add items to your wishlist, you must be logged in
Document preview thumbnail
Preview 2 out of 14 pages
Exam (elaborations)

WGU C268 Spreadsheets Exam . Questions with correct answers. GUARANTEED A+ GRADE.

0.0
(0 reviews)
- sold
14 pages
2024/2025 Written for academic year
Institution WGU C268 Spreadsheets
Course WGU C268 Spreadsheets
Document preview thumbnail
Preview 2 out of 14 pages

WGU C268 Spreadsheets Exam . Questions with correct answers. GUARANTEED A+ GRADE. Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20-C67 in the "Payment" column are populated with the payment amount from cell C15. [34 Points] - CORRECT =PMT(C13/12,C12,C11) Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the monthly interest rate. This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period. - CORRECT =F19*$C$13/12 Calculate, in cell E20, the principal amount for period 1. The principal amount is the difference between the payment amount (cell C20) and the interest amount (cell D20) for period 1. Construct your formula in such a way that it can be reused to complete the "principal" column of the amortization table. - CORRECT =C20-D20 Calculate, in cell F20, the balance for period 1. The balance is the difference between the balance for period 0 (cell F19) and the principal amount for period 1 (cell E20). This formula is reusable. The balance is always calculated as the difference between the balance from the previous period and the principal amount for the current period. - CORRECT =F19-E20 Calculate, in cell G12, the total amount paid by multiplying the payment amount (cell C15) by the term of the loan (cell C12). - CORRECT =C15*C12 Calculate the total interest paid in cell G13. The total interest paid is the sum of all interest paid in the "Interest" column of the amortization table. - CORRECT =SUM(D20:D67) Check to see if the total interest calculation in the amortization table is correct. The total interest paid is also equal to the difference between the total amount paid over the course of the loan and the original loan amount. Insert a formula into cell G14 to calculate the difference between the total amount paid and the original loan amount. Notice the negative sign associated with the original loan amount. This value should equal the total interest calculated using the amortization table. - CORRECT =G12- ABS(C11) Assume you have made the first 36 payments on your loan. You want to trade the car in for a new car. You believe that you can sell your car for $4000. Will this cover the balance remaining on the car in period 36? CORRECT either "Yes" or "No" in cell G15 from the drop-down menu. - CORRECT No Use the HLOOKUP function to complete the "Hourly Wage" column of table 1. Use the "Employee" column of table 1 as the lookup_value and the "Employee Wage Information" above table 1 as your reference table. - CORRECT =HLOOKUP(D16,$E$11:$H$12,2,FALSE)

Content preview

12356789  66667






 23!"!#$%
!&2"!%

'()*+)(,-,.-/(01-2,(13+2,435,.-)3(262*-))'789:-4-5-2*-,.-
*-));*32,(6262<,.-(//53/56(,-)3(2624351(,632(;,.-(5<+1-2,;435
,.-4+2*,63203++;-9'-));'=>?'@A62,.-BC(01-2,B*3)+12(5-
/3/+)(,-DE6,.,.-/(01-2,(13+2,4531*-))'789FGHC362,;I?
'J::K'LMCNLO'7GP7=Q'7=Q'77R
'()*+)(,-Q62*-))S=>Q,.-62,-5-;,(13+2,435/-563D7T0
1+),6/)062<,.-T()(2*-62/-563D>O*-))U7VRT0,.-)3(262,-5-;,
5(,-O*-))'7GRD6W6D-DT07=9S6W6D62<,.-62,-5-;,5(,-T07=5-;+),;
62,.-132,.)062,-5-;,5(,-9L.6;4351+)(6;5-+;(T)-9L.-62,-5-;,435
(<6W-2/-563D6;()E(0;,.-132,.)062,-5-;,5(,-,61-;,.-T()(2*-
4531,.-/5-W63+;/-563D9?'J::K'LMU7VXY'Y7GP7=
'()*+)(,-Q62*-))K=>Q,.-/562*6/()(13+2,435/-563D79L.-
/562*6/()(13+2,6;,.-D644-5-2*-T-,E--2,.-/(01-2,(13+2,O*-))
'=>R(2D,.-62,-5-;,(13+2,O*-))S=>R435/-563D79'32;,5+*,03+5
4351+)(62;+*.(E(0,.(,6,*(2T-5-+;-D,3*31/)-,-,.-
B/562*6/()B*3)+1234,.-(135,6Z(,632,(T)-9?'J::K'LM'=>?S=>
'()*+)(,-Q62*-))U=>Q,.-T()(2*-435/-563D79L.-T()(2*-6;,.-
D644-5-2*-T-,E--2,.-T()(2*-435/-563D>O*-))U7VR(2D,.-
/562*6/()(13+2,435/-563D7O*-))K=>R9L.6;4351+)(6;5-+;(T)-9
L.-T()(2*-6;()E(0;*()*+)(,-D(;,.-D644-5-2*-T-,E--2,.-
T()(2*-4531,.-/5-W63+;/-563D(2D,.-/562*6/()(13+2,435,.-
*+55-2,/-563D9?'J::K'LMU7V?K=>
'()*+)(,-Q62*-))[7=Q,.-,3,()(13+2,/(6DT01+),6/)062<,.-
/(01-2,(13+2,O*-))

, 01235678979 789901300
01201

0
7978977
799
7

9!1"8977
799
7



789

 
799
7

789#$799
7#
 789
 7
%7
75900&'()*+),-3

089.7
99
78977
799
7
7

789 7
%7
759


 978977
799
7



9/
7789
999
59709978977
7
19789

9 789789

2

7$
97

79!137
79789

99959709978977
7
789
2


74 7
9789927
19

2


790
78789
2


78

1
9
8
9/
78977
799
7
79


2789
 7
%7
75900!156&0113

5


96
8199789

7",6 97
6
7
07
779789
 907
59
9197876

96

 83***9
78

19789599 

2789

9
",:009
789#79
# #4 #
9!12 789
 09
004 



'
9789;<='>
7
7 979789#;
6929#

7591'
9789# 699#
 7591
789 .
?1
9
789# 699929
$ 7
#5197591
6
999975900
;<='>)1,@8811+8;81@@A5<&3

'
978954)
7
7 979789#
96 

:#
 
759159 6999
7
95


789 B97C
#;


9 .9#990978789
#
7
79;

#
7890 .#D

76#

2979781
0054)1,E01,@;1,F13

'
9789
7
7 979789#
7 96 

:#
 
759159 6999

7 95


789


76 B5

Document information

Uploaded on
February 4, 2025
Number of pages
14
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
Report Copyright Violation
$10.98
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Creativewriters
3.8
(37)
Sold
197
Followers
40
Items
2353
Last sold
2 months ago

Browse related subjects

Subjects

  • wgu c268 spreadsheets exam

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions