WGU C268 SPREADSHEETS QUESTIONS WITH CORRECT ANSWERS

WGU C268 SPREADSHEETS QUESTIONS
WITH CORRECT ANSWERS 2025/2026
PMT Cfunction C- CCORRECT CANSWER C-
calculates Cthe Cperiodic Cpayment Cfor Ca Cloan Cwith Ca Cfixed Cinterest Crate Cand Cfixed Cterm



=PMT(rate,nper,pv)

Interest Crate C(divided Cby C12 Cmonths), Cthe Cnumber Cof Cpayments Cto Cbe Cmade Cto Cpay Coff
Cthe Cloan, Cth Ce Coriginal Cloan Camount.




HLOOKUP Cfunction C- CCORRECT CANSWER C-
A Clookup Cfunction Cthat Csearches Chorizontally Cacross Cthe Ctop Crow Cof Cthe Clookup Ctable Cand
Cretrieves Cthe Cvalue Cin Cthe Ccolumn Cyou Cspecify.




=HLOOKUP(lookup_value, Ctable_array, Ccol_index_num, Crange_lookup)



Lookup Cinformation, Cthe Clocation Cof Cthe Creference Ctable, Cthe Ccolumn Cin Cthe Ctable Cthat
CcontainsEth Ce Cinformation Cthat Cis Creturned, Ctrue Cif Can Capproximate Cmatch Cis COKEand
CFALSE Cif Can Capproximate Cm Catch Cis Cnot Cokay.




AND Cfunction C- CCORRECT CANSWER C-
Combines CBoolean Cexpressions Cto Cdetermine Cif CALLEof Cthe Ccombined Cexpressions Care
CTRUE.




=AND(logical1, C[logical2],...)

First CBoolean Cexpression, Csecond CBoolean Cexpression C(as Cneeded), Cadditional CBoolean

, Cexpression
(s) Cas Cneeded



OR Cfunction C- CCORRECT CANSWER C-
Combines CBoolean Cexpressions Cto Cdetermine Cif CANY Cof Cthe Ccombined Cexpressions Care
CTRUE.