WGUiC268iSpreadsheetsiLatestiGradediA+
INiColumnsi ✔✔AA,iBB,iCA
IniRowsi ✔✔5,i6,i7
Iniclipiarti ✔✔Images
WhatiisiaipossibleioutcomeiusingiBooleanilogici ✔✔Onlyitheinumbersi0iandi1
Whatiisipossibleiinifreezeipanesi ✔✔Freezingitheirowiaboveiwhereiaipersoniisiworking
Autoisumi ✔✔Count,iNumber,iMax
Logicali ✔✔And,iNot,iOR
Financiali ✔✔Duration,iCoupdays,iEffect
DateiandiTimei ✔✔Weeknum,iWeekday
WhatiisitrueiabouticorrelationicoefficientsiwheniusingitheiCorrelifunctioniiniExcel?i ✔✔Theyimusti
beiaiwholeinumber
Whichitwoioptionsiareipossibleiunderi"Review"ionitheiExceliriboon?i ✔✔ProtectisheetiandiTracki
Changes
, Aniadministratoriwishesitoidisplayitheinumberi$3.10iinicelliA4.iHowicanithisigoalibeimet?
✔✔SelecticelliA4,iselectitheicurrencyicategory,ithenienteritheinumberi3.1
Aistudentinotediaicorrelationibetweenihoursiofistudyingianditestigrades.iTheistudentidecidesitoi
trackithisicorrelationicoefficientiiniExcel.iHowishouldithisibeisetiup?i ✔✔Byisettingiupihoursiiniarr
ayiAiandigradesiiniarrowiB,itheniusingitheiCORRELifunction
AistudentiwantsitoihaveitextiappeariiniExceliasiitiwouldiiniaibusinessidocument,iwithialliofitheitext
istartingionitheileft-
handiside.iWhichigroupionitheihomepageishouldibeiuseditoiaccomplishithisigoal?i ✔✔Alignment
Aimanagerihasiaispreadsheetitableiwithicompanyiname,istockiprices,iandisalesidollars.iWhatishoul
ditheimanageridoitoisortithisitableibyinameiandithenibyisalesidollars,ifromilargestitoismallest?i ✔
✔Clinkianywhereiinitheitable,iclickitheisortiicon,iclickitheinameiinitheisortibyidropbox,itheniclicki"t
heniby"iandichoosei"salesidollarsilargestitoismallest"
TheifollowingidataiisiinianiExceliSpreadsheet:iCompanyiA-Manufacturing-
$22,000,000;iCompanyiBi-iIndustriali-i$12,000,000;iCompanyiCi-iManufacturingi-
i$14,000,000.iWhichistepsiwillidisplayionlyitheiinformationiforitheimanufacturingiindustry?i ✔✔Cl
ickianywhereiinitheitable,iclickitheifilteributton,iclickitheidowniarrowinextitoi"Industry",ianditheni
selecti"Manufacturing"
Aidoctoriwantsitoiknowihowimanyipatientsisheihasiseenithisimonthianditheiridiagnoses.iTheidoct
or'siassistantiputsitogetheriaireportishowingieachipatient'sinameiinicolumniAiandidiagnosisiinico
lumniB.iWhichistepsishoulditheiassistantitakeitoiobtainiailistiofipatientsiwhoihaveibeenidiagnose
diwithistrepithroat?i ✔✔Clickiinitheireport,iclickitheifilteriicon,iclickitheidowniarrowiforitheidiagn
osisicolumn,
CelliB3icontainsiaiformulaithatimultiplyicellsiB1iandiB2.iWhichiformulaiisiinicelliB3?
✔✔=B1*B2
Theiaccountantiforiaicompanyiwantsitoicreateiaispreadsheetitoicalculateisalesimarkup.iThe
costsiofitheseiitemsiareilocatediinicellsiC4ithroughiC30,ianditheimarkupipercentiisilocatediin
INiColumnsi ✔✔AA,iBB,iCA
IniRowsi ✔✔5,i6,i7
Iniclipiarti ✔✔Images
WhatiisiaipossibleioutcomeiusingiBooleanilogici ✔✔Onlyitheinumbersi0iandi1
Whatiisipossibleiinifreezeipanesi ✔✔Freezingitheirowiaboveiwhereiaipersoniisiworking
Autoisumi ✔✔Count,iNumber,iMax
Logicali ✔✔And,iNot,iOR
Financiali ✔✔Duration,iCoupdays,iEffect
DateiandiTimei ✔✔Weeknum,iWeekday
WhatiisitrueiabouticorrelationicoefficientsiwheniusingitheiCorrelifunctioniiniExcel?i ✔✔Theyimusti
beiaiwholeinumber
Whichitwoioptionsiareipossibleiunderi"Review"ionitheiExceliriboon?i ✔✔ProtectisheetiandiTracki
Changes
, Aniadministratoriwishesitoidisplayitheinumberi$3.10iinicelliA4.iHowicanithisigoalibeimet?
✔✔SelecticelliA4,iselectitheicurrencyicategory,ithenienteritheinumberi3.1
Aistudentinotediaicorrelationibetweenihoursiofistudyingianditestigrades.iTheistudentidecidesitoi
trackithisicorrelationicoefficientiiniExcel.iHowishouldithisibeisetiup?i ✔✔Byisettingiupihoursiiniarr
ayiAiandigradesiiniarrowiB,itheniusingitheiCORRELifunction
AistudentiwantsitoihaveitextiappeariiniExceliasiitiwouldiiniaibusinessidocument,iwithialliofitheitext
istartingionitheileft-
handiside.iWhichigroupionitheihomepageishouldibeiuseditoiaccomplishithisigoal?i ✔✔Alignment
Aimanagerihasiaispreadsheetitableiwithicompanyiname,istockiprices,iandisalesidollars.iWhatishoul
ditheimanageridoitoisortithisitableibyinameiandithenibyisalesidollars,ifromilargestitoismallest?i ✔
✔Clinkianywhereiinitheitable,iclickitheisortiicon,iclickitheinameiinitheisortibyidropbox,itheniclicki"t
heniby"iandichoosei"salesidollarsilargestitoismallest"
TheifollowingidataiisiinianiExceliSpreadsheet:iCompanyiA-Manufacturing-
$22,000,000;iCompanyiBi-iIndustriali-i$12,000,000;iCompanyiCi-iManufacturingi-
i$14,000,000.iWhichistepsiwillidisplayionlyitheiinformationiforitheimanufacturingiindustry?i ✔✔Cl
ickianywhereiinitheitable,iclickitheifilteributton,iclickitheidowniarrowinextitoi"Industry",ianditheni
selecti"Manufacturing"
Aidoctoriwantsitoiknowihowimanyipatientsisheihasiseenithisimonthianditheiridiagnoses.iTheidoct
or'siassistantiputsitogetheriaireportishowingieachipatient'sinameiinicolumniAiandidiagnosisiinico
lumniB.iWhichistepsishoulditheiassistantitakeitoiobtainiailistiofipatientsiwhoihaveibeenidiagnose
diwithistrepithroat?i ✔✔Clickiinitheireport,iclickitheifilteriicon,iclickitheidowniarrowiforitheidiagn
osisicolumn,
CelliB3icontainsiaiformulaithatimultiplyicellsiB1iandiB2.iWhichiformulaiisiinicelliB3?
✔✔=B1*B2
Theiaccountantiforiaicompanyiwantsitoicreateiaispreadsheetitoicalculateisalesimarkup.iThe
costsiofitheseiitemsiareilocatediinicellsiC4ithroughiC30,ianditheimarkupipercentiisilocatediin
