How Well Do You Know MS Excel?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Themes
T
Themes
Community Contributor
Quizzes Created: 410 | Total Attempts: 734,229
Questions: 21 | Attempts: 684

SettingsSettingsSettings
How Well Do You Know MS Excel? - Quiz

Microsoft Excel plays a key role in many sectors. It is used for spreadsheets in a lot of business activities, and the organization of personal data. Ever wondered how much you know about MS Excel? Take the online quiz and find out.


Questions and Answers
  • 1. 

    _______, ________ and _______ are what you see when you open Excel

    • A.

      Columns, rows, and charts

    • B.

      Columns, rows, and formulas

    • C.

      Columns, rows, and cells

    • D.

      Non of the above

    Correct Answer
    C. Columns, rows, and cells
    Explanation
    When you open Excel, you see columns, rows, and cells. Columns are vertical and labeled with letters, rows are horizontal and labeled with numbers, and cells are the individual boxes where you can enter data or formulas.

    Rate this question:

  • 2. 

    When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

    • A.

      1

    • B.

      2

    • C.

      3

    • D.

      4

    Correct Answer
    A. 1
    Explanation
    When you start Excel, you open a file that's called a workbook. Each new workbook comes with 1 worksheet, like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

    Rate this question:

  • 3. 

    ___________ are where you get down to business and enter data in a worksheet.

    • A.

      Cells

    • B.

      Fields

    • C.

      Tables

    • D.

      None of the above

    Correct Answer
    A. Cells
    Explanation
    Cells are where you get down to business and enter data in a worksheet. In a spreadsheet program like Microsoft Excel, a worksheet is made up of a grid of cells. Each cell can contain data, such as numbers, text, or formulas. By entering data into cells, you can perform calculations, organize information, and create charts or graphs. Therefore, cells are the correct answer as they are the fundamental units for data entry and manipulation in a worksheet.

    Rate this question:

  • 4. 

    You can use Excel to create budgets, to work with taxes, or to record student grades

    • A.

      True

    • B.

      False

    • C.

      Option 3

    • D.

      Option 4

    Correct Answer
    A. True
    Explanation
    Excel is a versatile software that can be used for various purposes, including creating budgets, working with taxes, and recording student grades. Therefore, the statement that Excel can be used for these tasks is true.

    Rate this question:

  • 5. 

    A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

    • A.

      Click in cell C6, and then press CTRL+SHIFT.

    • B.

      Click in cell C6, and then press CTRL+SHIFT.

    • C.

      Click in cell C6.

    • D.

      Non of the above

    Correct Answer
    C. Click in cell C6.
    Explanation
    To see the formula in cell C6, you simply need to click on the cell C6. This will highlight the cell and display the formula in the formula bar at the top of the Excel window. Pressing CTRL+SHIFT is not necessary in this case.

    Rate this question:

  • 6. 

    I am result of adding two or more numbers. Who am i?

    Correct Answer
    Sum
    Explanation
    The given correct answer for this question is "Sum". The term "sum" refers to the result obtained by adding two or more numbers together. It is a mathematical operation that involves combining the values of different numbers to find their total. In this context, "sum" accurately describes the outcome of adding numbers, making it the correct answer.

    Rate this question:

  • 7. 

    To divide 853 by 16 in a formula in Excel, you would use what math operator?

    Correct Answer
    /
    Explanation
    To divide 853 by 16 in a formula in Excel, you would use the forward slash (/) math operator. The forward slash is the division operator in Excel and is used to perform division calculations. By using the forward slash in the formula, Excel will divide the value 853 by the value 16 and provide the result.

    Rate this question:

  • 8. 

    I plays na important role in performing any calculation, for any formula or as logical operator in excel. Who am i.. (used symbol not word)

    Correct Answer
    =
    Explanation
    The symbol "=" is used as an assignment operator in Excel. It is used to perform calculations and formulas, as well as to compare values and determine logical outcomes. It is an important symbol in Excel as it allows users to input formulas and equations to perform calculations and manipulate data.

    Rate this question:

  • 9. 

    The cell in the worksheet in which you can type data is called the stem cells.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement is false. The cell in the worksheet in which you can type data is not called the stem cells. The correct term for the cell in which you can type data is simply called a "cell" or "data cell". Stem cells, on the other hand, are a type of biological cell that can differentiate into other types of cells in the body.

    Rate this question:

  • 10. 

    A1=10 B2=20 C3=30  BASED ON THE GIVEN DATA. USING THE MS EXCEL A1+B2=30? THE EXPRESSION IS TRUE?

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The expression A1+B2=30 is false because A1 is equal to 10 and B2 is equal to 20. Therefore, when you add them together, the result is 30, not equal to 30.

    Rate this question:

  • 11. 

    RESULT ARE THE NUMBERS ENTERED IN A CELL?

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given answer is False because the statement "RESULT ARE THE NUMBERS ENTERED IN A CELL?" is grammatically incorrect and does not make sense. It seems like there might be a typographical error or missing information in the question. Without proper context or clarification, it is not possible to determine the correct answer.

    Rate this question:

  • 12. 

    Product is the sum of two numbers

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement "Product is the sum of two numbers" is incorrect. A product is the result of multiplying two or more numbers, while a sum is the result of adding two or more numbers. Therefore, the correct answer is False.

    Rate this question:

  • 13. 

    Quotient is the product of the sum of two numbers

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given statement "Quotient is the product of the sum of two numbers" is false. The quotient is actually the result of dividing one number by another. It is not related to the product or the sum of two numbers.

    Rate this question:

  • 14. 

    Numbers and Letters are called Data

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given statement is true because numbers and letters are both types of data. Data refers to any information that can be stored and processed by a computer or used to make decisions. Numbers can represent quantities or values, while letters can represent characters or symbols. Therefore, both numbers and letters are considered data in the context of computing.

    Rate this question:

  • 15. 

    =A1-B2= Difference

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given statement "A1-B2 = Difference" is true. In mathematics, the symbol "-" represents subtraction. Therefore, subtracting the value of B2 from A1 will give us the difference between the two values.

    Rate this question:

  • 16. 

    A1:20 defines as the range of the value of A1:A20

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because it states that A1:20 defines the range of values from A1 to A20. This means that the range includes all the values from A1 to A20, indicating that A1:20 is a valid range.

    Rate this question:

  • 17. 

    In MS Excel +,-,*,/ are called Mathematical operation while Addition, Subtraction, Multiplication, Division are called Symbols

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given statement is false. In MS Excel, +, -, *, / are not called Mathematical operations, but rather they are symbols used to represent mathematical operations. Addition, Subtraction, Multiplication, and Division are the actual mathematical operations that these symbols represent.

    Rate this question:

  • 18. 

    (Asterisk) is used as the 'Multiplication operator' in MS Excel

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In MS Excel, the asterisk symbol (*) is indeed used as the multiplication operator. This means that when you want to multiply two or more numbers together in a formula, you would use the asterisk symbol between them. For example, if you want to multiply the numbers in cell A1 and A2, you would write the formula "=A1*A2". Therefore, the statement "Asterisk is used as the 'Multiplication operator' in MS Excel" is true.

    Rate this question:

  • 19. 

    In MS Excel, A Data  is an equation that calculates a new value from values currently in a worksheet

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    In MS Excel, a formula is an equation that calculates a new value from values currently in a worksheet. A data, on the other hand, refers to the values or information that is entered into the cells of a worksheet. Therefore, the statement that a data is an equation is incorrect.

    Rate this question:

  • 20. 

    Which one do you like?

    • A.

      Option 1

    • B.

      Option 2

    • C.

      Option 3

    • D.

      Option 4

    Correct Answer
    A. Option 1

Quiz Review Timeline +

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

  • Current Version
  • Jan 03, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 09, 2021
    Quiz Created by
    Themes
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.