WGUzC268zSpreadsheetszLatestzGradedzA+
INzColumnsz ✔✔AA,zBB,zCA
InzRowsz ✔✔5,z6,z7
Inzclipzartz ✔✔Images
WhatziszazpossiblezoutcomezusingzBooleanzlogicz ✔✔Onlyztheznumbersz0zandz1
Whatziszpossiblezinzfreezezpanesz ✔✔Freezingzthezrowzabovezwherezazpersonziszworking
Autozsumz ✔✔Count,zNumber,zMax
Logicalz ✔✔And,zNot,zOR
Financialz ✔✔Duration,zCoupdays,zEffect
DatezandzTimez ✔✔Weeknum,zWeekday
WhatzisztruezaboutzcorrelationzcoefficientszwhenzusingzthezCorrelzfunctionzinzExcel?z ✔✔Theyz
mustzbezazwholeznumber
Whichztwozoptionszarezpossiblezunderz"Review"zonzthezExcelzriboon?z ✔✔ProtectzsheetzandzTr
ackzChanges
, Anzadministratorzwishesztozdisplayztheznumberz$3.10zinzcellzA4.zHowzcanzthiszgoalzbezmet?
✔✔SelectzcellzA4,zselectzthezcurrencyzcategory,zthenzenterztheznumberz3.1
Azstudentznotedzazcorrelationzbetweenzhourszofzstudyingzandztestzgrades.zThezstudentzdecide
sztoztrackzthiszcorrelationzcoefficientzinzExcel.zHowzshouldzthiszbezsetzup?z ✔✔Byzsettingzupzho
urszinzarrayzAzandzgradeszinzarrowzB,zthenzusingzthezCORRELzfunction
AzstudentzwantsztozhaveztextzappearzinzExcelzaszitzwouldzinzazbusinesszdocument,zwithzallzofzth
eztextzstartingzonzthezleft-
handzside.zWhichzgroupzonzthezhomepagezshouldzbezusedztozaccomplishzthiszgoal?z ✔✔Alignme
nt
Azmanagerzhaszazspreadsheetztablezwithzcompanyzname,zstockzprices,zandzsaleszdollars.zWhatzs
houldzthezmanagerzdoztozsortzthisztablezbyznamezandzthenzbyzsaleszdollars,zfromzlargestztozsma
llest?z ✔✔Clinkzanywherezinztheztable,zclickzthezsortzicon,zclickztheznamezinzthezsortzbyzdropbo
x,zthenzclickz"thenzby"zandzchoosez"saleszdollarszlargestztozsmallest"
ThezfollowingzdataziszinzanzExcelzSpreadsheet:zCompanyzA-Manufacturing-
$22,000,000;zCompanyzBz-zIndustrialz-z$12,000,000;zCompanyzCz-zManufacturingz-
z$14,000,000.zWhichzstepszwillzdisplayzonlyzthezinformationzforzthezmanufacturingzindustry?z ✔
✔Clickzanywherezinztheztable,zclickzthezfilterzbutton,zclickzthezdownzarrowznextztoz"Industry",za
ndzthenzselectz"Manufacturing"
Azdoctorzwantsztozknowzhowzmanyzpatientszshezhaszseenzthiszmonthzandztheirzdiagnoses.zThez
doctor'szassistantzputsztogetherzazreportzshowingzeachzpatient'sznamezinzcolumnzAzandzdiagn
osiszinzcolumnzB.zWhichzstepszshouldzthezassistantztakeztozobtainzazlistzofzpatientszwhozhavezb
eenzdiagnosedzwithzstrepzthroat?z ✔✔Clickzinzthezreport,zclickzthezfilterzicon,zclickzthezdownza
rrowzforzthezdiagnosiszcolumn,
CellzB3zcontainszazformulazthatzmultiplyzcellszB1zandzB2.zWhichzformulaziszinzcellzB3?
✔✔=B1*B2
Thezaccountantzforzazcompanyzwantsztozcreatezazspreadsheetztozcalculatezsaleszmarkup.zTh
ecostszofzthesezitemszarezlocatedzinzcellszC4zthroughzC30,zandzthezmarkupzpercentziszlocatedzi
n
INzColumnsz ✔✔AA,zBB,zCA
InzRowsz ✔✔5,z6,z7
Inzclipzartz ✔✔Images
WhatziszazpossiblezoutcomezusingzBooleanzlogicz ✔✔Onlyztheznumbersz0zandz1
Whatziszpossiblezinzfreezezpanesz ✔✔Freezingzthezrowzabovezwherezazpersonziszworking
Autozsumz ✔✔Count,zNumber,zMax
Logicalz ✔✔And,zNot,zOR
Financialz ✔✔Duration,zCoupdays,zEffect
DatezandzTimez ✔✔Weeknum,zWeekday
WhatzisztruezaboutzcorrelationzcoefficientszwhenzusingzthezCorrelzfunctionzinzExcel?z ✔✔Theyz
mustzbezazwholeznumber
Whichztwozoptionszarezpossiblezunderz"Review"zonzthezExcelzriboon?z ✔✔ProtectzsheetzandzTr
ackzChanges
, Anzadministratorzwishesztozdisplayztheznumberz$3.10zinzcellzA4.zHowzcanzthiszgoalzbezmet?
✔✔SelectzcellzA4,zselectzthezcurrencyzcategory,zthenzenterztheznumberz3.1
Azstudentznotedzazcorrelationzbetweenzhourszofzstudyingzandztestzgrades.zThezstudentzdecide
sztoztrackzthiszcorrelationzcoefficientzinzExcel.zHowzshouldzthiszbezsetzup?z ✔✔Byzsettingzupzho
urszinzarrayzAzandzgradeszinzarrowzB,zthenzusingzthezCORRELzfunction
AzstudentzwantsztozhaveztextzappearzinzExcelzaszitzwouldzinzazbusinesszdocument,zwithzallzofzth
eztextzstartingzonzthezleft-
handzside.zWhichzgroupzonzthezhomepagezshouldzbezusedztozaccomplishzthiszgoal?z ✔✔Alignme
nt
Azmanagerzhaszazspreadsheetztablezwithzcompanyzname,zstockzprices,zandzsaleszdollars.zWhatzs
houldzthezmanagerzdoztozsortzthisztablezbyznamezandzthenzbyzsaleszdollars,zfromzlargestztozsma
llest?z ✔✔Clinkzanywherezinztheztable,zclickzthezsortzicon,zclickztheznamezinzthezsortzbyzdropbo
x,zthenzclickz"thenzby"zandzchoosez"saleszdollarszlargestztozsmallest"
ThezfollowingzdataziszinzanzExcelzSpreadsheet:zCompanyzA-Manufacturing-
$22,000,000;zCompanyzBz-zIndustrialz-z$12,000,000;zCompanyzCz-zManufacturingz-
z$14,000,000.zWhichzstepszwillzdisplayzonlyzthezinformationzforzthezmanufacturingzindustry?z ✔
✔Clickzanywherezinztheztable,zclickzthezfilterzbutton,zclickzthezdownzarrowznextztoz"Industry",za
ndzthenzselectz"Manufacturing"
Azdoctorzwantsztozknowzhowzmanyzpatientszshezhaszseenzthiszmonthzandztheirzdiagnoses.zThez
doctor'szassistantzputsztogetherzazreportzshowingzeachzpatient'sznamezinzcolumnzAzandzdiagn
osiszinzcolumnzB.zWhichzstepszshouldzthezassistantztakeztozobtainzazlistzofzpatientszwhozhavezb
eenzdiagnosedzwithzstrepzthroat?z ✔✔Clickzinzthezreport,zclickzthezfilterzicon,zclickzthezdownza
rrowzforzthezdiagnosiszcolumn,
CellzB3zcontainszazformulazthatzmultiplyzcellszB1zandzB2.zWhichzformulaziszinzcellzB3?
✔✔=B1*B2
Thezaccountantzforzazcompanyzwantsztozcreatezazspreadsheetztozcalculatezsaleszmarkup.zTh
ecostszofzthesezitemszarezlocatedzinzcellszC4zthroughzC30,zandzthezmarkupzpercentziszlocatedzi
n
