NAME

Question types


Start with


Question limit

of 76 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. The formula -MATCH(40,{10,40,50,90},0) returns the value 2
  2. What is the mode of the data set: 2,5,4,3,1,2,7
  3. =NOT(OR(FALSE,FALSE,False)
  4. When using the increase decimal button on the toolbar, the preise value in the cell is modified. True or false?
  5. What charting limits does excel have in terms of data points and series?
  1. a =mode(2,5,4,3,1,2,7)
  2. b True because all are false so its going to come back false, but it says not, so it is the opposite
  3. c Excel charts require at least one numeric data series and at least one label data series
  4. d False
  5. e True

5 Multiple choice questions

  1. =OR(E3:E8)
  2. =Large(B2:B10,3)
  3. True
  4. =average(2,5,4,3,1,2,7)
  5. Gives a number between 0 and 1

5 True/False questions

  1. How do sparklines differ from charts?Small word-sized charts or graphics are embedded within the words, numbers, and images they represent in a worksheet, making multiple comparisons of trends and patters much easier.

          

  2. Write a formula to dtermine if none of items are within budget=Not(E3:E8)

          

  3. What is the formula to determine the number of cars that cost less than 20,000?=countif(B2:B10,"<=20000")

          

  4. What are the three steps involved in using the insert tab to create a chart?=Sumif(A2:A10,"Ford",B2:B10)

          

  5. What formula would you use if you wanted to set a conditional format of cell a3 using the formula is method-such that the item name would be shade in yellow if this item has an actual cost of at least 400You 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.

          

Create Set