Entering Formulas & Functions

10 Questions | Total Attempts: 212

SettingsSettingsSettings
Function Quizzes & Trivia

Entering Formulas & Functions for Basic


Questions and Answers
  • 1. 
    When using Excel 2007 what symbol is used to create a formula or function in a cell?
    • A. 

      ?

    • B. 

      +

    • C. 

      =

  • 2. 
    in "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
    • A. 

      Letters

    • B. 

      Cell references

    • C. 

      Symbols

    • D. 

      Operators

  • 3. 
    The Insert Function dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 4. 
    The function arguments dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 5. 
    All functions have arguments.
    • A. 

      True

    • B. 

      False

  • 6. 
    FUNCTION(argument1,argument2, ...) Is ________.
    • A. 

      The syntax of writing optional arguments.

    • B. 

      An example of a formula.

    • C. 

      The general syntax of all functions.

  • 7. 
    What is a Formula?
    • A. 

      A calculation that describes the relationship between cells

    • B. 

      Excel automatically knows that you want to add the column of numbers above or add the row of numbers to the left

    • C. 

      This is what rows are sorted by

  • 8. 
    You can display a formula by pressing the _____ keys.
    • A. 

      Alt+~

    • B. 

      Ctrl+~

    • C. 

      Ctrl+W

    • D. 

      Ctrl+¬

  • 9. 
    What function would you use to calculate today's date so that tomorrow it updates.
    • A. 

      =TODAY()

    • B. 

      =[date]

    • C. 

      =[system date]

  • 10. 
    A function inside another function is called a _____________ function.
    • A. 

      Nested

    • B. 

      Round

    • C. 

      Complex

    • D. 

      Compound

Back to Top Back to top