Print test
5 Written questions
5 Matching questions
 #######
 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
 What formula to find the total number of values listen in cells that contain text?
 In a Vlookup formula with a true lookup type, the first column of the lookup table referenced must be in ascending order to retrieve the correct value.
 Syntax
 a True
 b =If(D3<100,"Minor component cost", "Major component Cost")
 c The specific format of a function including the function name and the order of the arguments
 d Count
 e Box has insufficient width
5 Multiple choice questions
 conditional formatting, highlight cell rules, greater than
 Parenthesis
Exponentiation
Multiplication and division
Adding and subtracting  =Median(2,5,4,3,1,2,7)
 <>
 =IF(D3>C3,"True","False")
5 True/False questions

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")

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

What formula to find the largest value in cells? → Min

#NAME? → Invalid numeric values in a formula or function

What value would the following formula return? =IF(D4<=C4, "Within budget", "Over budget") → =OR(E3:E8)