Microsoft Office 2013: Excel 101 Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Mcqquestions
M
Mcqquestions
Community Contributor
Quizzes Created: 23 | Total Attempts: 626,705
| Attempts: 28,452
SettingsSettings
Please wait...
  • 1/10 Questions

    The first cell in EXCEL worksheet is labeled as:

    • AA
    • A1
    • Aa
    • A0
Please wait...
About This 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.

Microsoft Office 2013: Excel 101 Quiz! - Quiz

Quiz Preview

  • 2. 

    A __________ is a grid with labeled columns and rows.

    • Dialog box

    • Worksheet

    • Clipboard

    • Toolbar

    Correct Answer
    A. 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:

  • 3. 

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

    • Contents tab

    • Answer Wizard tab

    • Index tab

    • All of the above

    Correct Answer
    A. 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:

  • 4. 

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

    • Reference tabs

    • Position tabs

    • Location tabs

    • Sheet tabs

    Correct Answer
    A. 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:

  • 5. 

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

    • To insert a background.

    • To add borders.

    • To select a distribution of figures.

    • To add shading or color to a cell range.

    Correct Answer
    A. 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:

  • 6. 

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

    • Logical

    • Math & Trigonometry

    • Statistical

    • Financial

    Correct Answer
    A. 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:

  • 7. 

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

    • An absolute cell address is created.

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

    • The sheet tab is changed.

    • 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:

  • 8. 

    In Excel, a Data Series is defined as what?

    • A type of chart

    • A cell reference

    • A collection of related data

    • A division of results

    Correct Answer
    A. 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:

  • 9. 

    The active cell:

    • Is defined by a bold border around the cell

    • Receives the data user enters

    • It is the formula bar

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

    Correct Answer
    A. 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. 

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

    • Copy handle

    • Fill handle

    • Insert handle

    • Border

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 22, 2023 +

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
  • Oct 24, 2010
    Quiz Created by
    Mcqquestions
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.