C268 WGU QUESTIONS WITH CORRECT
ty ty ty ty
ANSWERS 2025 ty ty
Match tythe tyway tyinformation tycan tybe tydisplayed tyin tya tyspreadsheet tywith tythe tytype tyof tyinformation tyto
tybe tydisplayed. ty- tyCORRECT tyANSWER ty-In tyrows: ty5,6 tyand ty7
In tycolumns: tyAA,tyBB, tyCA
ty In tyclip tyart: tyImages
What tyis tya typossible tyoutcome tyusing tyBoolean tyLogic? ty- tyCORRECT tyANSWER ty-
tyOnly tythe tynumbers ty0 tyand ty1.
What tyis typossible tyin tyfreeze typanes? ty- tyCORRECT tyANSWER ty-
tyFreezing tythe tyrow tyabove tywhere tya typerson tyis tyworking.
Match tythe tycategory tywith tyits tytype tyof tyfunction. ty- tyCORRECT tyANSWER ty-Logical: tyAND, tyNOR,
OR tyAuto tySum: tyCOUNT, tyNUMBER, tyMAX
ty
Date tyand tyTime: tyWEEKNUM, tyWEEKDAY
ty Financial: tyDURATION, tyCOUPDAYS, tyEFFECT
What tyis tytrue tyabout tycorrelation tycoefficients tywhen tyusing tythe tyCORREL tyfunction tyin tyExcel? ty-
tyCORRECT tyANSWER ty-They tycan tybe tya tynegative tynumber.
What tytwo tyoptions tyare typossible tyunder ty"review" tyon tythe tyExcel tyribbon? ty- tyCORRECT
tyANSWER ty- tyTrack tyChanges
Protect tySheet
An tyadminister tywishes tyto tydisplay tythe tynumber ty$3.10 tyin tyCell tyA4. tyHow tycan tythis tygoal tybe tymet? ty-
tyCORRECT tyANSWER ty-Select tyA4, tyselect tythe tycurrency tycategory, tythen tyenter tythe tynumber ty3.1.
, A tystudent tynoted tya tycorrelation tybetween tyhours tyof tystudying tyand tytest tygrades. tyThe tystudentEdecides
tyto tytrack tythis tycorrelation tyusing tythe tyCORREL tyfunction tyin tyExcel.
How tyshould tythis tybe tysetEup? ty- tyCORRECT tyANSWER ty-
By tysetting tyup tyhours tyin tyarray tyAEand tygrades tyin tyarray tyB, tyand tythe tyusing tythe tyCORREL tyfunction.
A tystudent tywants tyto tyhave tytext tyappear tyin tyExcel tyas tyit tywould tyin tya tybusiness tydocument, tywith tyall tyof
tythe tyt tyext tystartingEon tythe tyleft-hand tyside.
Which tygroup tyon tythe tyhomepage tyshould tybe tyused tytoEaccomplish tythis tygoal? ty- tyCORRECT tyANSWERE-
tyAlignment
A tymanager tyhas tya tyspreadsheet tytable tywith tycompany tyname, tystock typrices tyand tysales tydollars. tyWhat
tysho tyuld tythe tymanager tydo tyto tysort tythis tytable tyby tyname tyand tythen tyby tysales tydollars, tyfrom tylargest tyto
tysmallest?
- tyCORRECT tyANSWER ty-
Click tyanywhere tyin tythe tytable, tyclick tythe tysort tyicon, tyclick tythe tyname tyin tythe tysort tyby tydrop tybox, tythen
tyclick ty" tythen tyby", tyand tychoose ty"sales tydollars tylargest tyto tysmallest".
The tyfollowing tydata tyis tyin tyan tyExcel tyspreadsheet:
Company tyA ty- tyManufacturing ty- ty$22,000,000
Company tyB ty- tyIndustrial ty- ty$12,000,000
ty
Company tyC ty- tyManufacturing ty- ty$14,000,000
Which tysteps tydisplay tyonly tythe tyinformation tyfor tythe tyManufacturing tyIndustry? ty- tyCORRECT
tyANSWER ty- tyClickEanywhere tyin tythe tytable, tyclick tythe tyfilter tybutton, tyclick tythe tydown tyarrow tynext tyto
ty"industry", tyand tyth tyen tyselect ty"Manufacturing".
ty ty ty ty
ANSWERS 2025 ty ty
Match tythe tyway tyinformation tycan tybe tydisplayed tyin tya tyspreadsheet tywith tythe tytype tyof tyinformation tyto
tybe tydisplayed. ty- tyCORRECT tyANSWER ty-In tyrows: ty5,6 tyand ty7
In tycolumns: tyAA,tyBB, tyCA
ty In tyclip tyart: tyImages
What tyis tya typossible tyoutcome tyusing tyBoolean tyLogic? ty- tyCORRECT tyANSWER ty-
tyOnly tythe tynumbers ty0 tyand ty1.
What tyis typossible tyin tyfreeze typanes? ty- tyCORRECT tyANSWER ty-
tyFreezing tythe tyrow tyabove tywhere tya typerson tyis tyworking.
Match tythe tycategory tywith tyits tytype tyof tyfunction. ty- tyCORRECT tyANSWER ty-Logical: tyAND, tyNOR,
OR tyAuto tySum: tyCOUNT, tyNUMBER, tyMAX
ty
Date tyand tyTime: tyWEEKNUM, tyWEEKDAY
ty Financial: tyDURATION, tyCOUPDAYS, tyEFFECT
What tyis tytrue tyabout tycorrelation tycoefficients tywhen tyusing tythe tyCORREL tyfunction tyin tyExcel? ty-
tyCORRECT tyANSWER ty-They tycan tybe tya tynegative tynumber.
What tytwo tyoptions tyare typossible tyunder ty"review" tyon tythe tyExcel tyribbon? ty- tyCORRECT
tyANSWER ty- tyTrack tyChanges
Protect tySheet
An tyadminister tywishes tyto tydisplay tythe tynumber ty$3.10 tyin tyCell tyA4. tyHow tycan tythis tygoal tybe tymet? ty-
tyCORRECT tyANSWER ty-Select tyA4, tyselect tythe tycurrency tycategory, tythen tyenter tythe tynumber ty3.1.
, A tystudent tynoted tya tycorrelation tybetween tyhours tyof tystudying tyand tytest tygrades. tyThe tystudentEdecides
tyto tytrack tythis tycorrelation tyusing tythe tyCORREL tyfunction tyin tyExcel.
How tyshould tythis tybe tysetEup? ty- tyCORRECT tyANSWER ty-
By tysetting tyup tyhours tyin tyarray tyAEand tygrades tyin tyarray tyB, tyand tythe tyusing tythe tyCORREL tyfunction.
A tystudent tywants tyto tyhave tytext tyappear tyin tyExcel tyas tyit tywould tyin tya tybusiness tydocument, tywith tyall tyof
tythe tyt tyext tystartingEon tythe tyleft-hand tyside.
Which tygroup tyon tythe tyhomepage tyshould tybe tyused tytoEaccomplish tythis tygoal? ty- tyCORRECT tyANSWERE-
tyAlignment
A tymanager tyhas tya tyspreadsheet tytable tywith tycompany tyname, tystock typrices tyand tysales tydollars. tyWhat
tysho tyuld tythe tymanager tydo tyto tysort tythis tytable tyby tyname tyand tythen tyby tysales tydollars, tyfrom tylargest tyto
tysmallest?
- tyCORRECT tyANSWER ty-
Click tyanywhere tyin tythe tytable, tyclick tythe tysort tyicon, tyclick tythe tyname tyin tythe tysort tyby tydrop tybox, tythen
tyclick ty" tythen tyby", tyand tychoose ty"sales tydollars tylargest tyto tysmallest".
The tyfollowing tydata tyis tyin tyan tyExcel tyspreadsheet:
Company tyA ty- tyManufacturing ty- ty$22,000,000
Company tyB ty- tyIndustrial ty- ty$12,000,000
ty
Company tyC ty- tyManufacturing ty- ty$14,000,000
Which tysteps tydisplay tyonly tythe tyinformation tyfor tythe tyManufacturing tyIndustry? ty- tyCORRECT
tyANSWER ty- tyClickEanywhere tyin tythe tytable, tyclick tythe tyfilter tybutton, tyclick tythe tydown tyarrow tynext tyto
ty"industry", tyand tyth tyen tyselect ty"Manufacturing".
