C268 WGU QUESTIONS WITH CORRECT
ANSWERS 2025
MatchEtheEwayEinformationEcanEbeEdisplayedEinEaEspreadsheetEwithEtheEtypeEofEinformationEtoEbeE
displayed.E-ECORRECTEANSWERE-InErows:E5,6EandE7
InEcolumns:EAA,EBB,ECA
InEclipEart:EImages
WhatEisEaEpossibleEoutcomeEusingEBooleanELogic?E-ECORRECTEANSWERE-
OnlyEtheEnumbersE0EandE1.
WhatEisEpossibleEinEfreezeEpanes?E-ECORRECTEANSWERE-
FreezingEtheErowEaboveEwhereEaEpersonEisEworking.
MatchEtheEcategoryEwithEitsEtypeEofEfunction.E-ECORRECTEANSWERE-Logical:EAND,ENOR,EOR
AutoESum:ECOUNT,ENUMBER,EMAX
DateEandETime:EWEEKNUM,EWEEKDAY
Financial:EDURATION,ECOUPDAYS,EEFFECT
WhatEisEtrueEaboutEcorrelationEcoefficientsEwhenEusingEtheECORRELEfunctionEinEExcel?E-
ECORRECTEANSWERE-TheyEcanEbeEaEnegativeEnumber.
WhatEtwoEoptionsEareEpossibleEunderE"review"EonEtheEExcelEribbon?E-ECORRECTEANSWERE-
TrackEChanges
ProtectESheet
AnEadministerEwishesEtoEdisplayEtheEnumberE$3.10EinECellEA4.EHowEcanEthisEgoalEbeEmet?E-
ECORRECTEANSWERE-SelectEA4,EselectEtheEcurrencyEcategory,EthenEenterEtheEnumberE3.1.
, AEstudentEnotedEaEcorrelationEbetweenEhoursEofEstudyingEandEtestEgrades.ETheEstudentEdecidesEtoE
trackEthisEcorrelationEusingEtheECORRELEfunctionEinEExcel.E
HowEshouldEthisEbeEsetEup?E-ECORRECTEANSWERE-
ByEsettingEupEhoursEinEarrayEAEandEgradesEinEarrayEB,EandEtheEusingEtheECORRELEfunction.
AEstudentEwantsEtoEhaveEtextEappearEinEExcelEasEitEwouldEinEaEbusinessEdocument,EwithEallEofEtheEt
extEstartingEonEtheEleft-handEside.
WhichEgroupEonEtheEhomepageEshouldEbeEusedEtoEaccomplishEthisEgoal?E-ECORRECTEANSWERE-
Alignment
AEmanagerEhasEaEspreadsheetEtableEwithEcompanyEname,EstockEpricesEandEsalesEdollars.EWhatEsho
uldEtheEmanagerEdoEtoEsortEthisEtableEbyEnameEandEthenEbyEsalesEdollars,EfromElargestEtoEsmallest?
E-ECORRECTEANSWERE-
ClickEanywhereEinEtheEtable,EclickEtheEsortEicon,EclickEtheEnameEinEtheEsortEbyEdropEbox,EthenEclickE"
thenEby",EandEchooseE"salesEdollarsElargestEtoEsmallest".
TheEfollowingEdataEisEinEanEExcelEspreadsheet:
CompanyEAE-EManufacturingE-E$22,000,000
CompanyEBE-EIndustrialE-E$12,000,000
CompanyECE-EManufacturingE-E$14,000,000
WhichEstepsEdisplayEonlyEtheEinformationEforEtheEManufacturingEIndustry?E-ECORRECTEANSWERE-
ClickEanywhereEinEtheEtable,EclickEtheEfilterEbutton,EclickEtheEdownEarrowEnextEtoE"industry",EandEth
enEselectE"Manufacturing".
ANSWERS 2025
MatchEtheEwayEinformationEcanEbeEdisplayedEinEaEspreadsheetEwithEtheEtypeEofEinformationEtoEbeE
displayed.E-ECORRECTEANSWERE-InErows:E5,6EandE7
InEcolumns:EAA,EBB,ECA
InEclipEart:EImages
WhatEisEaEpossibleEoutcomeEusingEBooleanELogic?E-ECORRECTEANSWERE-
OnlyEtheEnumbersE0EandE1.
WhatEisEpossibleEinEfreezeEpanes?E-ECORRECTEANSWERE-
FreezingEtheErowEaboveEwhereEaEpersonEisEworking.
MatchEtheEcategoryEwithEitsEtypeEofEfunction.E-ECORRECTEANSWERE-Logical:EAND,ENOR,EOR
AutoESum:ECOUNT,ENUMBER,EMAX
DateEandETime:EWEEKNUM,EWEEKDAY
Financial:EDURATION,ECOUPDAYS,EEFFECT
WhatEisEtrueEaboutEcorrelationEcoefficientsEwhenEusingEtheECORRELEfunctionEinEExcel?E-
ECORRECTEANSWERE-TheyEcanEbeEaEnegativeEnumber.
WhatEtwoEoptionsEareEpossibleEunderE"review"EonEtheEExcelEribbon?E-ECORRECTEANSWERE-
TrackEChanges
ProtectESheet
AnEadministerEwishesEtoEdisplayEtheEnumberE$3.10EinECellEA4.EHowEcanEthisEgoalEbeEmet?E-
ECORRECTEANSWERE-SelectEA4,EselectEtheEcurrencyEcategory,EthenEenterEtheEnumberE3.1.
, AEstudentEnotedEaEcorrelationEbetweenEhoursEofEstudyingEandEtestEgrades.ETheEstudentEdecidesEtoE
trackEthisEcorrelationEusingEtheECORRELEfunctionEinEExcel.E
HowEshouldEthisEbeEsetEup?E-ECORRECTEANSWERE-
ByEsettingEupEhoursEinEarrayEAEandEgradesEinEarrayEB,EandEtheEusingEtheECORRELEfunction.
AEstudentEwantsEtoEhaveEtextEappearEinEExcelEasEitEwouldEinEaEbusinessEdocument,EwithEallEofEtheEt
extEstartingEonEtheEleft-handEside.
WhichEgroupEonEtheEhomepageEshouldEbeEusedEtoEaccomplishEthisEgoal?E-ECORRECTEANSWERE-
Alignment
AEmanagerEhasEaEspreadsheetEtableEwithEcompanyEname,EstockEpricesEandEsalesEdollars.EWhatEsho
uldEtheEmanagerEdoEtoEsortEthisEtableEbyEnameEandEthenEbyEsalesEdollars,EfromElargestEtoEsmallest?
E-ECORRECTEANSWERE-
ClickEanywhereEinEtheEtable,EclickEtheEsortEicon,EclickEtheEnameEinEtheEsortEbyEdropEbox,EthenEclickE"
thenEby",EandEchooseE"salesEdollarsElargestEtoEsmallest".
TheEfollowingEdataEisEinEanEExcelEspreadsheet:
CompanyEAE-EManufacturingE-E$22,000,000
CompanyEBE-EIndustrialE-E$12,000,000
CompanyECE-EManufacturingE-E$14,000,000
WhichEstepsEdisplayEonlyEtheEinformationEforEtheEManufacturingEIndustry?E-ECORRECTEANSWERE-
ClickEanywhereEinEtheEtable,EclickEtheEfilterEbutton,EclickEtheEdownEarrowEnextEtoE"industry",EandEth
enEselectE"Manufacturing".
