Excel Formulas And Functions Trivia Quiz

10 Questions | Total Attempts: 10711

SettingsSettingsSettings
Excel Formulas And Functions Trivia Quiz - Quiz

Get ready for this 'excel formulas and functions trivia quiz'. Have you ever worked on a spreadsheet application or MS Excel? Do you know all the functions and formulas? If yes, then take this quiz to test where you stand and learn new formulas and functions used in excel. Microsoft Excel is spreadsheet software that 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. 
    For calculating which of the following options, An Excel spreadsheet is primarily used?
    • A. 

      Data

    • B. 

      Finances

    • C. 

      Numbers

    • D. 

      All of the above

  • 3. 
    This is a formula.
    • A. 

      =SUM(A1:A5)

    • B. 

      Add A1 - A5

    • C. 

      Subtract the numbers from A1 to A5

    • D. 

      A1 = A5

  • 4. 
    At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is
    • 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. 

      A 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. 
    Which of the following is the correct way to write the IF function?
    • 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) 

    • D. 

      None of these

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.