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