The MS Excel Basics Quiz! Trivia Test

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 Amethbc
A
Amethbc
Community Contributor
Quizzes Created: 1 | Total Attempts: 446
Questions: 10 | Attempts: 449

SettingsSettingsSettings
The MS Excel Basics Quiz! Trivia Test - 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.


Questions and Answers
  • 1. 

    Labels are aligned at the ________ edge of the cell.

    • A.

      Left

    • B.

      Right

    • C.

      Top

    • D.

      Bottom

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

    Rate this question:

  • 2. 

    You can complete a cell entry by pressing

    • A.

      Enter

    • B.

      Tab

    • C.

      Shift+tab

    • D.

      An arrow key

    • E.

      Another cell

    Correct Answer(s)
    A. Enter
    B. Tab
    C. Shift+tab
    D. An arrow key
    E. 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:

  • 3. 

    The default font keyed in a new workbook is

    • A.

      12 pt. Times New Romans

    • B.

      10 pt. Arial

    • C.

      12 pt. Bradley Hand ITC

    • D.

      10 pt. Times New Roman

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

    Rate this question:

  • 4. 

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

    • A.

      True

    • B.

      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:

  • 5. 

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

    • A.

      Enter

    • B.

      Autofit

    • C.

      Format painter

    • D.

      Esc

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

  • 6. 

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

    • A.

      Label

    • B.

      Workbook

    • C.

      Worksheet

    • D.

      Column

    • E.

      Range

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

  • 7. 

    How do you know a range is active?

    • A.

      It is highlighted on the screen.

    • B.

      It has a marquee around it.

    • C.

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

    • D.

      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:

  • 8. 

    A range has an address called a range address.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A range in this context refers to a group of cells in a spreadsheet or a specific section of data. Each range is identified by its address, which is known as a range address. This address helps to locate and reference the range when performing operations or calculations. Therefore, the statement that a range has an address called a range address is true.

    Rate this question:

  • 9. 

    An example of a range address.

    • A.

      A1:B3

    • B.

      A1;B3

    • C.

      A1-B3

    • D.

      A1=B3

    • E.

      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:

  • 10. 

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

    • A.

      Cell selector

    • B.

      Cell cross

    • C.

      Selection pointer

    • D.

      Range selector

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

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 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.