MS Excel Basics Quiz Questions And Answers

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 Agazaheer
A
Agazaheer
Community Contributor
Quizzes Created: 3 | Total Attempts: 14,117
Questions: 14 | Attempts: 13,515

SettingsSettingsSettings
MS Excel Basics Quiz Questions And Answers - Quiz

.


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 will see columns, rows, and cells. Columns are the vertical sections labeled with letters, rows are the horizontal sections labeled with numbers, and cells are the individual rectangular boxes formed by the intersection of columns and rows. These elements are the basic building blocks of an Excel spreadsheet and allow you to organize and input data in a structured manner.

    Rate this question:

  • 2. 

    Ribbon is MS Excel is

    • A.

      Commands organized in small related groups is called Ribbon

    • B.

      The band at the top of the Excel 2007 window is the Ribbon

    • C.

      All of the above

    • D.

      Non of the above

    Correct Answer
    B. The band at the top of the Excel 2007 window is the Ribbon
    Explanation
    The correct answer is "The band at the top of the Excel 2007 window is the Ribbon." This statement accurately describes the Ribbon in MS Excel as the band located at the top of the Excel 2007 window. It is where commands are organized in small related groups, allowing users to easily access and navigate through different features and functionalities in Excel.

    Rate this question:

  • 3. 

    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.

      One

    • B.

      Two

    • C.

      Three

    • D.

      Four

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

    Rate this question:

  • 4. 

    ___________ 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 cell is a basic unit of a worksheet that is used to store and manipulate data. It is identified by a unique combination of a column letter and a row number. Cells allow you to input text, numbers, formulas, and perform various calculations. They are the building blocks of a worksheet and are essential for organizing and analyzing data.

    Rate this question:

  • 5. 

    In a new worksheet, you must start by typing in cell A1.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    In a new worksheet, you are not required to start by typing in cell A1. You can start typing in any cell of your choice.

    Rate this question:

  • 6. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Excel is a powerful tool that can be used for various purposes, including creating budgets, working with taxes, and recording student grades. It provides features such as formulas, functions, and formatting options that make it easy to organize and analyze data. By using Excel, users can create and manage budgets, calculate taxes, and track student grades efficiently. Therefore, the statement "You can use Excel to create budgets, to work with taxes, or to record student grades" is true.

    Rate this question:

  • 7. 

    You can enter two basic kinds of data into worksheet cells:

    • A.

      Numbers and text

    • B.

      Numbers and figures

    • C.

      Text and charts

    • D.

      None of the above

    Correct Answer
    A. Numbers and text
    Explanation
    In a worksheet, you can enter two basic kinds of data: numbers and text. Numbers can be used for calculations and mathematical operations, while text can be used for labels, descriptions, or any non-numeric information. This allows for a versatile and comprehensive representation of data in the worksheet.

    Rate this question:

  • 8. 

    To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    When entering a date in a cell in Excel, you should use a slash or a hyphen to separate the parts. For example, 7/16/2009 or 16-July-2009. Excel will recognize this as a date value, not as text. Therefore, the correct answer is False.

    Rate this question:

  • 9. 

    You learned in the practice that ###### means:

    • A.

      You've entered a number wrong

    • B.

      You've misspelled something

    • C.

      The cell is not wide enough

    Correct Answer
    C. The cell is not wide enough
    Explanation
    The correct answer is "The cell is not wide enough." This means that when entering data into a cell in a spreadsheet or table, the width of the cell is not sufficient to display the entire content. This can result in the data being cut off or displayed in a way that is not fully visible. To fix this issue, the cell width needs to be adjusted to accommodate the content.

    Rate this question:

  • 10. 

    What do you type into an empty cell to start a formula?

    • A.

      An equal sign (=)

    • B.

      A plus sign (+)

    • C.

      Number

    • D.

      Fx

    Correct Answer
    A. An equal sign (=)
    Explanation
    To start a formula in an empty cell, you need to type an equal sign (=). This is because the equal sign is used to indicate that the cell will contain a formula and not just a regular value. By typing the equal sign, you are telling the spreadsheet software that you want to perform a calculation or use a function in that cell.

    Rate this question:

  • 11. 

    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
    Clicking in cell C6 allows you to select the cell and view its contents, including any formula that may be present. This will allow you to see the formula that was used to calculate the result in cell C6.

    Rate this question:

  • 12. 

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

    • A.

      +

    • B.

      =

    • C.

      %

    • D.

      /

    Correct Answer
    D. /
    Explanation
    To divide 853 by 16 in a formula in Excel, you would use the "/" math operator. The "/" operator is used for division in Excel formulas.

    Rate this question:

  • 13. 

    Cell Reference:A10,A20Refer to values in

    • A.

      The cell in column A and row 10

    • B.

      Cell A10 and cell A20

    • C.

      The range of cells in column A and rows 10 through 20

    • D.

      The range of cells in row 15 and columns B through E

    Correct Answer
    B. Cell A10 and cell A20
    Explanation
    The correct answer is "cell A10 and cell A20." This is because the cell reference "A10" refers to the specific cell in column A and row 10, and the cell reference "A20" refers to the specific cell in column A and row 20. Therefore, the answer is that the cell reference refers to both cell A10 and cell A20.

    Rate this question:

  • 14. 

    A10:A20Refer to values in

    • A.

      The cell in column A and row 10

    • B.

      Cell A10 and cell A20

    • C.

      The range of cells in column A and rows 10 through 20

    • D.

      The range of cells in row 15 and columns B through E

    Correct Answer
    C. The range of cells in column A and rows 10 through 20
    Explanation
    The correct answer is "the range of cells in column A and rows 10 through 20". This answer indicates that the reference A10:A20 refers to a range of cells in column A, specifically from row 10 to row 20.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 04, 2010
    Quiz Created by
    Agazaheer
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.