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.
    True
    False
  •  15
  • Which function finds the highest value?
    MAX
    SUM
    MIN
    AVERAGE
  •  15
  • What does the MIN function do?
    Adds values
    Counts cells
    Finds highest value
    Finds lowest value
  •  15
  • True or false: You can use the Function Library to browse functions.
    True
    False
  •  15
  • True or false: You must always use parentheses in functions.
    False
    True
  •  15
  • What does the AVERAGE function do?
    Counts cells
    Adds values
    Finds median
    Calculates average
  •  15
  • True or false: You can manually enter functions in Excel.
    True
    False
  •  15
  • Which function adds all values in a range?
    AVERAGE
    SUM
    MIN
    COUNT
  •  15