The MS Excel Basics Quiz! Trivia Test

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 Amethbc
A
Amethbc
Community Contributor
Quizzes Created: 1 | Total Attempts: 474
| Attempts: 474
SettingsSettings
Please wait...
  • 1/10 Questions

    A range has an address called a range address.

    • True
    • False
Please wait...
About This Quiz


Are you confident enough to think that you can pass this MS Excel basics quiz? A lot of people have a hard time when it comes to using Microsoft Excel, and this is because of the complexity of how data is input. In this quiz, you will get to see just how much you know about the tool and some of the shortcuts one uses to perfect their data entry. Do take up the quiz and get to see just how well you understand it.

The MS Excel Basics Quiz! Trivia Test - Quiz

Quiz Preview

  • 2. 

    An example of a range address.

    • A1:B3

    • A1;B3

    • A1-B3

    • A1=B3

    • A1*B3

    Correct Answer
    A. A1:B3
    Explanation
    The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The format A1:B3 indicates that the range starts from cell A1 and ends at cell B3, including all the cells in between. This range can be used to perform calculations or apply formatting to multiple cells at once.

    Rate this question:

  • 3. 

    If you choose a larger font size, the height of the row is automatically made taller.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When selecting a larger font size, the height of the row is automatically adjusted to accommodate the larger text. This means that if you choose a larger font size, the row will become taller in order to properly display the larger text. Therefore, the statement "If you choose a larger font size, the height of the row is automatically made taller" is true.

    Rate this question:

  • 4. 

    Labels are aligned at the ________ edge of the cell.

    • Left

    • Right

    • Top

    • Bottom

    Correct Answer
    A. Left
    Explanation
    Labels are aligned at the left edge of the cell.

    Rate this question:

  • 5. 

    How do you know a range is active?

    • It is highlighted on the screen.

    • It has a marquee around it.

    • The data changes to Bold to let me know it's active

    • I'm psychic & I just Know!!

    Correct Answer
    A. It is highlighted on the screen.
    Explanation
    The correct answer is that a range is active when it is highlighted on the screen. This means that the range is currently selected or being used for a specific operation. This visual indicator helps the user identify which range is currently active and allows them to perform actions or make changes within that range.

    Rate this question:

  • 6. 

    Which button allows you to copy cell formats from one cell to another?

    • Enter

    • Autofit

    • Format painter

    • Esc

    Correct Answer
    A. Format painter
    Explanation
    The format painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to quickly apply the same formatting, such as font style, color, and borders, to multiple cells without manually adjusting each one. By selecting the cell with the desired format and clicking on the format painter button, you can easily apply the same format to other cells by clicking on them.

    Rate this question:

  • 7. 

    The default font keyed in a new workbook is

    • 12 pt. Times New Romans

    • 10 pt. Arial

    • 12 pt. Bradley Hand ITC

    • 10 pt. Times New Roman

    Correct Answer
    A. 10 pt. Arial
    Explanation
    The default font in a new workbook is 10 pt. Arial.

    Rate this question:

  • 8. 

    A_______ is a group of cells that form a rectangle on the screen.

    • Label

    • Workbook

    • Worksheet

    • Column

    • Range

    Correct Answer
    A. Range
    Explanation
    A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, allowing for the selection and manipulation of a specific area of a spreadsheet. Ranges are commonly used in spreadsheet applications to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.

    Rate this question:

  • 9. 

    When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.

    • Cell selector

    • Cell cross

    • Selection pointer

    • Range selector

    Correct Answer
    A. Selection pointer
    Explanation
    When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps to indicate that you are in the process of selecting cells and allows you to easily drag and highlight the desired range.

    Rate this question:

  • 10. 

    You can complete a cell entry by pressing

    • Enter

    • Tab

    • Shift+tab

    • An arrow key

    • Another cell

    Correct Answer(s)
    A. Enter
    A. Tab
    A. Shift+tab
    A. An arrow key
    A. Another cell
    Explanation
    You can complete a cell entry in a spreadsheet by pressing the enter key, which moves the cursor to the cell below. Alternatively, you can press the tab key, which moves the cursor to the cell on the right. Shift+tab can be used to move the cursor to the cell on the left. An arrow key can also be used to move the cursor in any direction. Finally, you can also complete a cell entry by selecting another cell, which automatically saves the current entry.

    Rate this question:

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

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 07, 2013
    Quiz Created by
    Amethbc
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.