Excel Formulas And Functions! Trivia Quiz

10 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Have you ever worked on spreadsheet application or MS Excel? Do you know all the functions and formulas? If yes, then take this quiz to test where do you stand and learn new formulas and functions used in excel. Microsoft Excel is a spreadsheet software which is used for data processing and financial presentation. To become an expert one needs to learn the formulas and functions. So, let's try out the quiz. All the best!


Questions and Answers
  • 1. 
    Which formula below will add the value of B2 to the value of C3
    • A. 

      =B2+C3

    • B. 

      =C3+B3

    • C. 

      =6+4

    • D. 

      =B+C

  • 2. 
    An Excel spreadsheet is primarily used for calculating which of the following options
    • A. 

      Data

    • B. 

      Finances

    • C. 

      Numbers

    • D. 

      All of the above

  • 3. 
    Which of the following option is a formula?
    • A. 

      =SUM(A1:A5)

    • B. 

      Add A1 - A5

    • C. 

      Subtract the numbers from A1 to A5

    • D. 

      A1 = A5

  • 4. 
    • A. 

      To add all the data together using addition only

    • B. 

      To tell the person viewing that this is a function and it should be added together

    • C. 

      To calculate all the data correctly without any mistakes

    • D. 

      To inform the computer that an arithmetic function will occur

  • 5. 
    A worksheet is a(n) ___________
    • A. 

      Piece of graph paper

    • B. 

      Single page in a workbook

    • C. 

      Excel file

    • D. 

      All of the above

  • 6. 
    A selection of multiple cells is called a
    • A. 

      Group

    • B. 

      Range

    • C. 

      Reference

    • D. 

      Package

  • 7. 
    Using a cell address in a formula is known as:
    • A. 

      Formularizing

    • B. 

      Prefixing

    • C. 

      Cell referencing

    • D. 

      Cell mathematics

  • 8. 
    All formulas in Excel begin with the following symbol
    • A. 

      +

    • B. 

      =

    • C. 

      %

    • D. 

      #

  • 9. 
    In which view can you see the header and footer areas of a worksheet
    • A. 

      Normal view

    • B. 

      Page layout view

    • C. 

      Page break preview

    • D. 

      Header/Footer

  • 10. 
    • A. 

      =IF(condition, condition if false, condition if true) 

    • B. 

      =IF(condition, condition if true, condition if false)

    • C. 

      =IF(condition:condition if true:condition if false)