5 Written questions
5 Matching questions
 What value would the following formula return? =IF(D4<=C4, "Within budget", "Over budget")
 #Num
 Arguments
 Write a formula to dtermine if none of items are within budget
 What formula to find the average?
 a =Not(E3:E8)
 b It would give over budget because D4 is greater then C4, statement is false therefore it gives over budget.
 c Average
 d A function input (when putting a number and how many decimal places)
 e Invalid numeric values in a formula or function
5 Multiple choice questions
 =OR(E3:E8)
 =B2+ Randbetween(50,250)
 Min
 =Averageif(A2:A10,"Ford",B2:B10)
 It would just show 1149+25
5 True/False questions

In the chapter, original labor rate for inspectors was given as 35 per hour. However, the value is 37.50. What algebraic expression could you use to determine the percent increase in labor cost? → <>

What formula could you write to average the values in cells A10 through A20, excluding blank cells, rounded to the nearest 10? → Sum

Write an excel formula in H3 that can be copied down the column to calculate the cost of this component for a larger sales meeting base on the following: if this item is optional as indicated in column b, then the cost will be equal to the original budgeted amount, if this item is required as indicated in column, then the cost will be three time the original budgeted amount. → =If(D3<100,"Minor component cost", "Major component Cost")

What formula is used in cell E3, which can be copied down the column to determine True or false if this item is within budget? → =If(D3<C3, "True","False")

Is the following formula valid? =Not(E3:E8) → No, it is not valid, Not cannot do a range