Microsoft Office 2013: Excel 101 Quiz!

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 Mcqquestions
M
Mcqquestions
Community Contributor
Quizzes Created: 23 | Total Attempts: 615,272
Questions: 10 | Attempts: 28,182

SettingsSettingsSettings
Microsoft Office 2013: Excel 101 Quiz! - Quiz

Welcome to this short yet important Microsoft Office 2013 quiz on Excel. Here, you will be asked ten fundamental questions of this application just to test your basic understanding of the same. Let's see if you can pass all the questions without getting a single one wrong or not.


Questions and Answers
  • 1. 

    The first cell in EXCEL worksheet is labeled as:

    • A.

      AA

    • B.

      A1

    • C.

      Aa

    • D.

      A0

    Correct Answer
    B. A1
    Explanation
    The first cell in an Excel worksheet is labeled as A1 because the letters represent the column and the number represents the row. In Excel, columns are labeled with letters starting from A and going up to Z, then continuing with AA, AB, AC, and so on. Rows are labeled with numbers starting from 1 and going up as the number of rows increase. Therefore, the first cell in the worksheet is labeled as A1 to indicate it is in the first column and first row.

    Rate this question:

  • 2. 

    What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

    • A.

      An absolute cell address is created.

    • B.

      Cell address will change when it is copied to another cell.

    • C.

      The sheet tab is changed.

    • D.

      The status bar does not display the cell address.

    Correct Answer
    A. An absolute cell address is created.
    Explanation
    When dollar signs ($) are entered in a cell address, it creates an absolute cell address. This means that the cell reference will not change when it is copied to another cell. Absolute cell references are useful when you want to keep a specific cell reference constant, such as when creating formulas that need to refer to a specific cell regardless of where it is copied.

    Rate this question:

  • 3. 

    What are the tabs that appear at the bottom of each workbook called?

    • A.

      Reference tabs

    • B.

      Position tabs

    • C.

      Location tabs

    • D.

      Sheet tabs

    Correct Answer
    D. Sheet tabs
    Explanation
    The tabs that appear at the bottom of each workbook are called sheet tabs. These tabs allow users to navigate between different sheets or worksheets within the workbook. Each sheet tab typically displays the name of the sheet, making it easier for users to locate and access specific sheets within the workbook.

    Rate this question:

  • 4. 

    What is represented by the small, black square in the lower-right corner of an active cell or range?

    • A.

      Copy handle

    • B.

      Fill handle

    • C.

      Insert handle

    • D.

      Border

    Correct Answer
    B. Fill handle
    Explanation
    The small, black square in the lower-right corner of an active cell or range is known as the fill handle. It is used to quickly fill adjacent cells with a series, such as numbers or dates, based on the pattern of the selected cells. By dragging the fill handle, the pattern is extended to the desired range of cells, saving time and effort in data entry.

    Rate this question:

  • 5. 

    In Excel, a Data Series is defined as what?

    • A.

      A type of chart

    • B.

      A cell reference

    • C.

      A collection of related data

    • D.

      A division of results

    Correct Answer
    C. A collection of related data
    Explanation
    A Data Series in Excel refers to a collection of related data. It is used to organize and analyze data that is related or connected in some way. This can include a series of numbers, dates, or any other type of data that is related and needs to be grouped together for analysis or presentation purposes.

    Rate this question:

  • 6. 

    In Excel, the Fill Color button on the Formatting toolbar is used for what?

    • A.

      To insert a background.

    • B.

      To add borders.

    • C.

      To select a distribution of figures.

    • D.

      To add shading or color to a cell range.

    Correct Answer
    D. To add shading or color to a cell range.
    Explanation
    The Fill Color button on the Formatting toolbar in Excel is used to add shading or color to a cell range. This allows users to visually differentiate and highlight specific cells or ranges within their worksheet. By selecting a particular color or shade, users can enhance the readability and organization of their data, making it easier to interpret and analyze.

    Rate this question:

  • 7. 

    In help menu of Excel, which of the following tabs are found?

    • A.

      Contents tab

    • B.

      Answer Wizard tab

    • C.

      Index tab

    • D.

      All of the above

    Correct Answer
    D. All of the above
    Explanation
    The help menu of Excel includes all of the mentioned tabs: Contents tab, Answer Wizard tab, and Index tab. These tabs provide different ways for users to access and search for information and assistance in using Excel. The Contents tab allows users to browse through different topics and subtopics in a hierarchical manner. The Answer Wizard tab provides a search feature that helps users find answers to specific questions or issues. The Index tab allows users to search for specific keywords or terms to find relevant information. Therefore, the correct answer is "all of the above".

    Rate this question:

  • 8. 

    A __________ is a grid with labeled columns and rows.

    • A.

      Dialog box

    • B.

      Worksheet

    • C.

      Clipboard

    • D.

      Toolbar

    Correct Answer
    B. Worksheet
    Explanation
    A worksheet is a grid with labeled columns and rows. It is commonly used in spreadsheet software such as Microsoft Excel to organize and analyze data. The columns are labeled with letters (A, B, C, etc.) and the rows are labeled with numbers (1, 2, 3, etc.). This grid structure allows users to input and manipulate data in a structured manner, perform calculations, and create charts and graphs based on the data.

    Rate this question:

  • 9. 

    The active cell:

    • A.

      Is defined by a bold border around the cell

    • B.

      Receives the data user enters

    • C.

      It is the formula bar

    • D.

      Receives data user enters & defined by a bold border around the cell

    Correct Answer
    D. Receives data user enters & defined by a bold border around the cell
    Explanation
    The active cell is the cell in a spreadsheet that is currently selected or highlighted. It is where the user can enter data or perform actions such as formatting or applying formulas. The active cell is visually indicated by a bold border around the cell.

    Rate this question:

  • 10. 

    Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

    • A.

      Logical

    • B.

      Math & Trigonometry

    • C.

      Statistical

    • D.

      Financial

    Correct Answer
    D. Financial
    Explanation
    The correct answer is Financial. The Financial function in Excel is used to calculate various financial calculations such as depreciation, rates of return, future values, and loan payment amounts. This function is commonly used in financial analysis and planning to make informed decisions regarding investments, loans, and savings.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.