Excel Functions Quiz

9 Questions | Total Attempts: 728

SettingsSettingsSettings
Please wait...
Excel Functions Quiz

This is a review about lesson 3, the topics contained are this: excel formulas, functions( sum,max,min,average,round,if)


Questions and Answers
  • 1. 
    To start a formula you must use:
    • A. 

      Parentheses ()

    • B. 

      Equals =

    • C. 

      Just type your formula

  • 2. 
    Which of the following is invalid?
    • A. 

      =MAX(B5:B15)

    • B. 

      =MAX(B1,B2,B3,B4,B5,B6,B7)=MAX(B8,B9)

    • C. 

      =MAX(B1:B10,B11:B20)

  • 3. 
    List which standart math operators Excel uses and what is their order of precedence.
  • 4. 
    Explain how works the function if ?
  • 5. 
    Write an example of an if function
  • 6. 
    Explain how average function works and provide an example of it
  • 7. 
    You can refer data in worksheet from another?
    • A. 

      True

    • B. 

      False

  • 8. 
    SUM() is a function that allow to make additions ?
    • A. 

      True

    • B. 

      False

Back to Top Back to top