Question types

Start with

Question limit

of 76 available terms

Advertisement Upgrade to remove ads
Print test

5 Written questions

5 Matching questions

  1. Write a formula to round up 63.34% to the nearest percent
  2. How do sparklines differ from charts?
  3. How do you change the chart type of an existing chart?
  4. Algorithm
  5. The formula =Average(Choose(1,B12:D17,B22:D17)) average the value 1 with the values in cells b12 to D17 and B22 D17
  1. a 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. b Go to the design ribbon and click change chart type
  3. c False
  4. d 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. e =roundup

5 Multiple choice questions

  1. True
  2. >=
  3. =If(D3<100,"Minor component cost", "Major component Cost")
  4. =Countif(A2:A10,"GM")
  5. =IF(B3="O",C3,C3*3)

5 True/False questions

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


  2. The formula =INDEX((B2:D7,B12:D17,B22:D17),2,3,2) returns the value in cell D13False


  3. What is the formula to determine the total value of all ford cars?=Sumif(A2:A10,"Ford",B2:B10)


  4. #REFInvalid cell reference


  5. What is the formula to determine the number of cars that cost less than 20,000?=Sumif(A2:A10,"Ford",B2:B10)