Question Types

Start With

Question Limit

of 76 available terms

Advertisement Upgrade to remove ads

5 Written Questions

5 Matching Questions

  1. What value would the following formula return? =IF(D4<=C4, "Within budget", "Over budget")
  3. Excel matches the lookup_value "tom" with the entry "TOM" in a lookup table
  4. 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
  5. Algorithm
  1. a True
  2. b It would give over budget because D4 is greater then C4, statement is false therefore it gives over budget.
  3. c True because all are false so its going to come back false, but it says not, so it is the opposite
  4. d =If(D3<100,"Minor component cost", "Major component Cost")
  5. 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

  1. True, because 25 is greater than 6, and not false is true
  2. Sum
  3. True
  4. 11 standard charts and 73 sub types
  5. =And(Or(E3:E5,B7), Not(Or(E6,E8)))

5 True/False Questions

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


  2. SyntaxNo Answer


  3. #REFNo Answer


  4. 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)


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


Create Set