5 Written Questions
5 Matching Questions
 What value would the following formula return? =IF(D4<=C4, "Within budget", "Over budget")
 =NOT(OR(FALSE,FALSE,False)
 Excel matches the lookup_value "tom" with the entry "TOM" in a lookup table
 Write a formula in cell G3 that can be copied down the column to return the following: if this item has an actual cost of less than 100, then return the text, minor component cost. If this item has an actual cost of 100 or more, then return the text, major component cost
 Algorithm
 a True
 b It would give over budget because D4 is greater then C4, statement is false therefore it gives over budget.
 c True because all are false so its going to come back false, but it says not, so it is the opposite
 d =If(D3<100,"Minor component cost", "Major component Cost")
 e A rule that governs how a function works. A systematic set of procedures that the computer always steps through to calculate the results of a function
5 Multiple Choice Questions
 True, because 25 is greater than 6, and not false is true
 Sum
 True
 11 standard charts and 73 sub types
 =And(Or(E3:E5,B7), Not(Or(E6,E8)))
5 True/False Questions

When writing formula's, why is it preferable to use cell reference? → Min

Syntax → No Answer

#REF → No Answer

What formula could you write you calculate the mean of the following data set: 2,5,4,3,1,2,7 → =average(2,5,4,3,1,2,7)

Write a formula to determine the average price of only Ford vehicles using the worksheet in question 11. → =Not(E3:E8)