Question types

Start with

Question limit

of 76 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. When using the increase decimal button on the toolbar, the preise value in the cell is modified. True or false?
  2. Give an example of a low data ink ratio in a chart.
  3. The formula -MATCH(40,{10,40,50,90},0) returns the value 2
  4. #######
  5. If you enter 1,149+25, what value would result?
  1. a Box has insufficient width
  2. b False
  3. c It would just show 1149+25
  4. d 9 colors with only 4 cells with data.
  5. e True

5 Multiple choice questions

  1. =If(D3<C3, "True","False")
  2. False
  3. 42
  4. =average(2,5,4,3,1,2,7)
  5. Excel charts require at least one numeric data series and at least one label data series

5 True/False questions

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


  2. The rows and column arguments in the INDEX functions can be numeric values, Boolean values, or textTrue


  3. =NOT(OR(FALSE,FALSE,False)True because one of the two separated by the comma has to be true


  4. What is the difference between a bar chart and a column chart?XY scatter chart requires 2 values to compare (highlight tab)


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