Study

Excel Basic Functions and Other Information

  •   0%
  •  0     0     0

      Back   Restart
  • The function to capitalize the first letter of each word would be . . .
    proper
  • The function to place all letters in uppercase would be . . .
    UPPER
  • The function that will input the current date and time into your document would be . . .
    NOW
  • The function that will input only the current date in your document would be . . .
    TODAY
  • Which keystroke combination must you use to display functions/formulas in your spreadsheet?
    CTRL + ~
  • What function key puts your cell reference into an absolute reference?
    F4
  • What function will you use to find the mean of a column or row of numbers?
    Average
  • True or False: Function names are case sensitive.
    False
  • How many arguments does the TODAY function have?
    0
  • What do you call what goes inside the parentheses in a function?
    Arguments
  • What function will you use to find the lowest number in a range of cells?
    MIN
  • What puts Excel into math mode?
    =
  • What type of cell reference will NOT change when it is copied or moved?
    Absolute
  • In the formula B4 + 10, what is the operator?
    +
  • What symbol indicates an absolute reference?
    $
  • What symbol indicates the operator for multiplication?
    *
  • What symbol is used as the operator for division?
    /
  • What function will you use to add a column or row of numbers?
    SUM
  • What do you call a chart that appears on the same page as the spreadsheet?
    embedded
  • When using text as arguments in a function, what must your text be enclosed in?
    quotation marks
  • What function will indicate the number of values and text within a range of cells?
    counta
  • The arguments for an Excel function are enclosed in . . .
    parentheses
  • What type of cell reference adjusts to its new location when it is copied or moved?
    Relative
  • What function will you use to find the highest number in a range of cells?
    Max
    • Your experience on this site will be improved by allowing cookies.