Game Preview

Excel Functions

  •  9     Public
    Test your knowledge on various Excel functions and their uses
  •   Study   Slideshow
  • Which symbol starts a function in Excel?
    @
    #
    &
    =
  •  15
  • True or false: Functions can only have one argument.
    False
    True
  •  15
  • Which function finds the highest value?
    MIN
    AVERAGE
    SUM
    MAX
  •  15
  • What does the MIN function do?
    Counts cells
    Adds values
    Finds lowest value
    Finds highest value
  •  15
  • True or false: You can use the Function Library to browse functions.
    False
    True
  •  15
  • True or false: You must always use parentheses in functions.
    False
    True
  •  15
  • What does the AVERAGE function do?
    Counts cells
    Adds values
    Calculates average
    Finds median
  •  15
  • True or false: You can manually enter functions in Excel.
    False
    True
  •  15
  • Which function adds all values in a range?
    MIN
    AVERAGE
    COUNT
    SUM
  •  15