Excel Formulas And Functions Trivia Quiz

Reviewed by Samy Boulos
Samy Boulos, MSc (Computer Science) |
Data Engineer
Review Board Member
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.
 , MSc (Computer Science)
By Oflodac
O
Oflodac
Community Contributor
Quizzes Created: 13 | Total Attempts: 60,455
| Attempts: 15,392
SettingsSettings
Please wait...
  • 1/10 Questions

    All formulas in Excel begin with the following symbol.

    • +
    • =
    • %
    • #
Please wait...
About This 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!

Excel Formulas And Functions Trivia Quiz - Quiz

Quiz Preview

  • 2. 

    Which formula below will add the value of B2 to the value of C3

    • =B2+C3

    • =C3+B3

    • =6+4

    • =B+C

    Correct Answer
    A. =B2+C3
    Explanation
    The correct answer is =B2+C3 because this formula will add the value of B2 to the value of C3. The plus sign (+) is used to indicate addition in Excel formulas, and the cell references B2 and C3 specify the cells from which the values will be taken. By using this formula, the values of B2 and C3 will be added together to give the desired result.

    Rate this question:

  • 3. 

    Which is the correct formula?

    • =SUM(A1:A5)

    • Add A1 - A5

    • Subtract the numbers from A1 to A5

    • A1 = A5

    Correct Answer
    A. =SUM(A1:A5)
    Explanation
    The correct answer is =SUM(A1:A5). This formula calculates the sum of the values in cells A1 to A5. It adds up all the numbers in this range and gives the total sum as the answer.

    Rate this question:

  • 4. 

    A selection of multiple cells is called a

    • Group

    • Range

    • Reference

    • Package

    Correct Answer
    A. Range
    Explanation
    A selection of multiple cells is called a range.

    Rate this question:

  • 5. 

    Using a cell address in a formula is known as:

    • Formularizing

    • Prefixing

    • Cell referencing

    • Cell mathematics

    Correct Answer
    A. Cell referencing
    Explanation
    Cell referencing is the correct answer because it refers to the practice of using a specific cell address in a formula. By referencing a cell, the formula can retrieve the value or perform calculations based on the data in that particular cell. This allows for dynamic and flexible formulas that can automatically update when the referenced cell's value changes.

    Rate this question:

  • 6. 

    For calculating which of the following options, An Excel spreadsheet is primarily used?

    • Data

    • Finances

    • Numbers

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    An Excel spreadsheet is primarily used for calculating all of the above options, including data, finances, and numbers. Excel provides a wide range of functions and tools that allow users to perform various calculations and analysis on different types of data. It is commonly used in business and finance for tasks such as budgeting, financial analysis, and data management. Additionally, Excel's mathematical functions make it suitable for performing calculations involving numbers. Therefore, all of the given options can be effectively managed and calculated using an Excel spreadsheet.

    Rate this question:

  • 7. 

    At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is

    • To add all the data together using addition only.

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

    • To calculate all the data correctly without any mistakes.

    • To inform the computer that an arithmetic function will occur.

    Correct Answer
    A. To add all the data together using addition only.
    Explanation
    The function of the word '=SUM' at the beginning of an Excel spreadsheet formula is to add all the data together using addition only. This is because the SUM function in Excel is specifically designed to calculate the sum of a range of cells or values. By using the '=SUM' at the beginning of the formula, it indicates to Excel that the following values should be added together.

    Rate this question:

  • 8. 

    Which of the following is the correct way to write the IF function?

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

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

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

    • None of these

    Correct Answer
    A. =IF(condition, condition if true, condition if false)
    Explanation
    The correct way to write the IF function is =IF(condition, condition if true, condition if false). This formula allows you to test a condition and return one value if the condition is true, and another value if the condition is false.

    Rate this question:

  • 9. 

    In which view can you see the header and footer areas of a worksheet

    • Normal view

    • Page layout view

    • Page break preview

    • Header/Footer

    Correct Answer
    A. Page layout view
    Explanation
    In Page layout view, you can see the header and footer areas of a worksheet. This view allows you to see how the worksheet will appear when printed, including any headers and footers that have been added. It provides a more accurate representation of the printed document compared to Normal view. In Normal view, the header and footer areas are not visible, and in Page break preview, the focus is on adjusting page breaks rather than viewing headers and footers. The Header/Footer option is not a view but rather a feature that allows you to customize and add content to the header and footer areas.

    Rate this question:

  • 10. 

    A worksheet is a(n) ___________

    • Piece of graph paper

    • A single page in a workbook

    • Excel file

    • All of the above

    Correct Answer
    A. A single page in a workbook
    Explanation
    A worksheet refers to a single page in a workbook. A workbook is a collection of multiple worksheets that are used to organize and store data in Excel. Each worksheet within the workbook functions as an individual page where users can input and manipulate data, perform calculations, and create charts or graphs. Therefore, the correct answer is "A single page in a workbook."

    Rate this question:

Samy Boulos |MSc (Computer Science) |
Data Engineer
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.

Quiz Review Timeline (Updated): Feb 7, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Feb 07, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Samy Boulos
  • Dec 01, 2009
    Quiz Created by
    Oflodac
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.