Study

Excel Functions

  •   0%
  •  0     0     0

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