资源描述：
《SIBEX13_CH04 Conceptual Review Answers》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、Chapter4:ConceptualQuestionAnswers1.Evaluatethefollowingexpressions:a.=OR(FALSE,TRUE,TRUE)àTRUEb.=AND(3>5,TRUE)àFALSEc.=NOT(OR(FALSE,FALSE,TRUE))àFALSEd.=AND(A2>6,NOT(FALSE))whereA2containsthevalue25.àTRUE2.Describehowyouwouldformatacellsuchthatifthevalueislessthan
2、20itwouldbeautomaticallybolded.àusetheconditionalformattingtoolwith“valueis”settingAnswerQuestions3-15usingthefollowingworksheet.Assumeallofyouranswerswillbeplacedincellsonthesameworksheet.3.WhatExcelformulawasusedincellE3,whichcanbecopieddownthecolumntodetermine(T
3、rueorFalse)ifthisitemwasoverbudget?=D3>C34.WriteanExcelformulatodetermineifalloftheitemsareoverbudget.=AND(E3:E8)5.WriteanExcelformulatodetermineifatleastoneitemisoverbudget.=OR(E3:E8)6.WriteanExcelformulaincellF3,whichcanbecopieddownthecolumn,todetermineifthisfood
4、itemiswithinbudget.=Not(E3)7.WhatformulawouldyouuseifyouwantedtosetaconditionalformatofcellA3usingtheFormulaIsmethod-suchthattheitemnamewouldbeshadedinyellowifthisitemhasanActualcostofatleast$200?=$D$3>=200(acceptwithorw/o$)SIBExcelChapter4Page3of38.WriteanExcelfor
5、mulatodetermineifnoneoftheitemsareoverbudget.=NOT(OR(E3:E8))alternative:AND(NOT(E3),NOT(E4),NOT(E5),NOT(E6),NOT(E7),NOT(E8))9.Writeaformulatodetermineif(TRUEorFALSE)onlytherequiredtrips(R)areoverbudget.Notethatthisformuladoesnothavetoworkiftheoptional/requiredcateg
6、oriesarelatermodified.=AND(OR(E3:E6),NOT(OR(E7,E8)))or=AND(OR(E3:E6),NOT(OR(E7:E8)))10.ArethesetwoBooleanexpressionsequivalent?Whyorwhynot?àYES–onefindsifonlyoneistrueandturnstheexpressiontofalseandtheotherchecksthatallitemsarefalse–thisislogicallyequivalent=NOT(OR
7、(E3:E8))=AND(NOT(E3),NOT(E4),NOT(E4),NOT(E6),NOT(E7),NOT(E8))11.Isthisformulavalid?=NOT(E3:E8)Whyorwhynot?NO–aNOTfunctioncanonlytakeoneargument.12.Whatvaluewouldthefollowingformulareturn?=IF(D4<=C4,“withinbudget”,“overbudget”)àwithinbudget13.Whatvaluewouldthefollow
8、ingformulareturn?=IF(SUM(D7,D8)<100,“gotoboth”,IF(SUM(D6,D8)>200,“gotoneither”,“chooseone”))àgotoboth14.WriteanExcelformulaincellG3,whichcanbecop
