Question Types

Start With

Question Limit

of 76 available terms

Advertisement Upgrade to remove ads

5 Written Questions

4 Matching Questions

  1. Write a formula to dtermine if at least one item is within budget
  2. Reference and lookup functions may not contain nested functions as arguments
  3. What is the Countif formula to count the number of GM cars on this list?
  4. Arguments
  1. a =OR(E3:E8)
  2. b A function input (when putting a number and how many decimal places)
  3. c False
  4. d =Countif(A2:A10,"GM")

5 Multiple Choice Questions

  1. 42
  2. True
  3. False, descending
  4. =Sumif(A2:A10,"Ford",B2:B10)
  5. INDEX

5 True/False Questions

  1. The formula =RAND() gives what result?Gives a number between 0 and 1


  2. What charting limits does excel have in terms of data points and series?Max


  3. What are the three steps involved in using the insert tab to create a chart?Select data you wish to display
    Click insert tab
    Click a button in charts group or dialogue box launcher


  4. AND(A2>6, NOT(FALSE)) where A2 contians the value 25True, because 25 is greater than 6, and not false is true


  5. What formula would you write to add a range of numbers in cells A2:X2?Max


Create Set