Study

Excel Functions

  •   0%
  •  0     0     0

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