WGU C268 SPREADSHEETS QUESTIONS
WITH CORRECT ANSWERS 2025
PMTEfunctionE-ECORRECTEANSWERE-
calculatesEtheEperiodicEpaymentEforEaEloanEwithEaEfixedEinterestErateEandEfixedEterm
=PMT(rate,nper,pv)
InterestErateE(dividedEbyE12Emonths),EtheEnumberEofEpaymentsEtoEbeEmadeEtoEpayEoffEtheEloan,Eth
eEoriginalEloanEamount.
HLOOKUPEfunctionE-ECORRECTEANSWERE-
AElookupEfunctionEthatEsearchesEhorizontallyEacrossEtheEtopErowEofEtheElookupEtableEandEretrievesE
theEvalueEinEtheEcolumnEyouEspecify.
=HLOOKUP(lookup_value,Etable_array,Ecol_index_num,Erange_lookup)
LookupEinformation,EtheElocationEofEtheEreferenceEtable,EtheEcolumnEinEtheEtableEthatEcontainsEth
eEinformationEthatEisEreturned,EtrueEifEanEapproximateEmatchEisEOKEandEFALSEEifEanEapproximateEm
atchEisEnotEokay.
ANDEfunctionE-ECORRECTEANSWERE-
CombinesEBooleanEexpressionsEtoEdetermineEifEALLEofEtheEcombinedEexpressionsEareETRUE.E
=AND(logical1,E[logical2],...)
FirstEBooleanEexpression,EsecondEBooleanEexpressionE(asEneeded),EadditionalEBooleanEexpression
(s)EasEneeded
OREfunctionE-ECORRECTEANSWERE-
CombinesEBooleanEexpressionsEtoEdetermineEifEANYEofEtheEcombinedEexpressionsEareETRUE.E
WITH CORRECT ANSWERS 2025
PMTEfunctionE-ECORRECTEANSWERE-
calculatesEtheEperiodicEpaymentEforEaEloanEwithEaEfixedEinterestErateEandEfixedEterm
=PMT(rate,nper,pv)
InterestErateE(dividedEbyE12Emonths),EtheEnumberEofEpaymentsEtoEbeEmadeEtoEpayEoffEtheEloan,Eth
eEoriginalEloanEamount.
HLOOKUPEfunctionE-ECORRECTEANSWERE-
AElookupEfunctionEthatEsearchesEhorizontallyEacrossEtheEtopErowEofEtheElookupEtableEandEretrievesE
theEvalueEinEtheEcolumnEyouEspecify.
=HLOOKUP(lookup_value,Etable_array,Ecol_index_num,Erange_lookup)
LookupEinformation,EtheElocationEofEtheEreferenceEtable,EtheEcolumnEinEtheEtableEthatEcontainsEth
eEinformationEthatEisEreturned,EtrueEifEanEapproximateEmatchEisEOKEandEFALSEEifEanEapproximateEm
atchEisEnotEokay.
ANDEfunctionE-ECORRECTEANSWERE-
CombinesEBooleanEexpressionsEtoEdetermineEifEALLEofEtheEcombinedEexpressionsEareETRUE.E
=AND(logical1,E[logical2],...)
FirstEBooleanEexpression,EsecondEBooleanEexpressionE(asEneeded),EadditionalEBooleanEexpression
(s)EasEneeded
OREfunctionE-ECORRECTEANSWERE-
CombinesEBooleanEexpressionsEtoEdetermineEifEANYEofEtheEcombinedEexpressionsEareETRUE.E