solved Question 12 PointsCase-Based Critical Thinking Questions Case 4-2 Nathan is

Question 12 PointsCase-Based Critical Thinking Questions Case 4-2 Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below. If Nathan entered the dates shown in column B directly into a formula, Excel would interpret the entry as a(n) ____.datenumerical expressionerrortext entryQuestion 22 PointsYou can use the ____ logical functions AND, OR, and NOT.BooleanBradstreetRelationalSimpleQuestion 32 PointsNOT(FALSE) returns the value ____.TRUEFALSEEQUALERRORQuestion 42 Points=OR(FALSE,TRUE,TRUE) results in the final value of ____.TRUEFALSEEQUALERRORQuestion 52 PointsCase-Based Critical Thinking Questions Case 4-1 Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company’s customers. Please refer to the figure above as you answer the questions below. Chloe also intends to send out a letter congratulating those customers who have the value TRUE in all three columns of B, C, and D. She now wants to write a formula to generate a TRUE if a customer matches this criteria. The logical construct would be ____.AND(C5:D5)AND(C5:C9)OR(C5:D5)NOT(OR(C5:D5)Question 62 PointsYou can use dates in ____.relational expressionsarithmetic expressionsboth a and bneither a nor bQuestion 72 PointsThe syntax of the NOT function is as follows: ____.NOT(logical1)NOT(logical1, logical2,….)NOT(reference1)NOT(value1, value2,….)Question 82 PointsThe first argument of the IF function is the logical_test, and can consist of ____.the value TRUE or FALSEa reference to a cell containing a TRUE or FALSE valuea relational expression resulting in a single TRUE or FALSE valueall of the aboveQuestion 92 PointsIf you entered the date 1/1/2014 directly into a formula, Excel interprets the entry as a ____.numerical expressiondateboth a and bneither a nor bQuestion 102 PointsThe result of the formula =C1<=D1 where cell C1 contains the label “AA” and cell D1 contains the label “BB” is ____.TRUEFALSEERROREQUAL