5 Written Questions
5 Matching Questions
 The rows and column arguments in the INDEX functions can be numeric values, Boolean values, or text
 Write a formula to generate a random integer value between 10 and 20
 #Num
 What formula would you use if you wanted to set a conditional format of cell a3 using the formula is methodsuch that the item name would be shade in yellow if this item has an actual cost of at least 400
 What formula to find the smallest value in the cells?
 a =Randbetween(10,20)
 b Min
 c Invalid numeric values in a formula or function
 d You have to ttell it to shade yellow, so it should be conditional format using the Formula is method to create one. Use =$D3>=400, indicate to shade yellow, applying to $A$3:$A$8.
 e True
5 Multiple Choice Questions
 =And(Or(E3:E5,B7), Not(Or(E6,E8)))
 False
 =Median(2,5,4,3,1,2,7)
 =Countif(A2:A10,"GM")
 False, descending
5 True/False Questions

Write a formula to dtermine if none of items are within budget → =roundup

Write a formula in cell F3 that can be copied down the column to dtermine if this food item is not within budget → =IF(D3>C3,"True","False")

If each car shown in Question 11 is marked up between 50 and 250 increments, what function could be used to randomly assign the amount to be added to the car price in this formula? → =B2+ Randbetween(50,250)

=OR(3>5, True) → Wrong Argument type or operation

Write a formula to determine the average price of only Ford vehicles using the worksheet in question 11. → =Averageif(A2:A10,"Ford",B2:B10)