Test Your Basic Excel Knowledge With This Quiz!

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS (Computer Science) |
Database Administrator
Review Board Member
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
, MS (Computer Science)
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 Kritika Joshi
K
Kritika Joshi
Community Contributor
Quizzes Created: 2 | Total Attempts: 86,573
Questions: 10 | Attempts: 83,978

SettingsSettingsSettings
Test Your Basic Excel Knowledge With This Quiz! - Quiz

Test your basic Excel knowledge with this beginner-friendly Excel Quiz! Whether you're new to Excel or looking to brush up on your skills, this quiz is designed to assess your understanding of the fundamentals. From basic formulas and functions to formatting and data manipulation, this quiz covers essential Excel concepts. Put your knowledge to the test as you answer a variety of multiple-choice questions that will challenge your proficiency in navigating Excel's interface and performing common tasks. Sharpen your Excel skills and see how well you fare in this interactive and educational quiz for beginners.


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. This means that the text of the labels will be positioned towards the left side of the cell, while the remaining space in the cell will be on the right side of the label.

    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

    • F.

      None of above

    Correct Answer
    A. Enter
    Explanation
    Pressing ctrl+enter or enter completes a cell entry in Microsoft Excel. This keyboard shortcut allows the user to stay in the current cell after entering data, rather than moving to the next cell. This can be useful when the user wants to quickly enter data in multiple cells without navigating to different cells each time.

    Rate this question:

  • 3. 

    The default font keyed in a new workbook is:

    • A.

      12 pt. Times New Romans

    • B.

      11 pt. Calibri 

    • C.

      12 pt. Bradley Hand ITC

    • D.

      10 pt. Times New Roman

    Correct Answer
    B. 11 pt. Calibri 
    Explanation
    The default font keyed in a new workbook is 11 pt. Calibri.

    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 a larger font size is chosen, the height of the row is automatically adjusted to accommodate the larger text. This is because larger text requires more vertical space to be properly displayed. 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 apply the same formatting, such as font style, color, and borders, to multiple cells without having to manually format each one. By selecting the cell with the desired format and then clicking on the format painter button, you can easily apply the same format to other cells in just a few clicks.

    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 a single cell or multiple cells, and is used to perform calculations, apply formatting, or manipulate data within the specified cells. A range can be selected and modified as a unit, making it a convenient way to work with data in a structured manner.

    Rate this question:

  • 7. 

    Which Excel feature is used to organize data in alphabetical or numerical order?

    • A.

      Sort

    • B.

      Filter

    • C.

      PivotTable

    • D.

      Conditional Formatting

    Correct Answer
    A. Sort
    Explanation
    The correct answer is "Sort". The Sort feature in Excel is used to organize data in alphabetical or numerical order. It allows users to arrange data in ascending or descending order based on a selected column. This feature is helpful for quickly finding and analyzing specific information in a large dataset.

    Rate this question:

  • 8. 

    Which function is used to find the average of a range of numbers in Excel?

    • A.

      AVERAGE

    • B.

      SUM

    • C.

      COUNT

    • D.

      MAX

    Correct Answer
    A. AVERAGE
    Explanation
    The AVERAGE function is used to find the average of a range of numbers in Excel. It calculates the sum of the numbers in the range and then divides that sum by the count of numbers in the range. This function is commonly used to calculate the average value of a set of data, such as grades, sales figures, or test scores.

    Rate this question:

  • 9. 

    An example of a range address:

    • A.

      A1:C2

    • B.

      A1;B3

    • C.

      A1-B3

    • D.

      A1=B3

    • E.

      A1*B3

    Correct Answer
    A. A1:C2
    Explanation
    A range address is a way to specify a group or block of cells in a spreadsheet. In this case, the range address A1:C2 represents a rectangular area that includes cells A1, A2, B1, B2, C1, and C2. This notation is commonly used in spreadsheet applications to perform operations 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 allows you to indicate the specific cells or range of cells that you want to work with in a spreadsheet or other software program. It helps to visually highlight the cells being selected and assists in accurately defining the desired range for various operations such as formatting, copying, or deleting data.

    Rate this question:

Godwin Iheuwa |MS (Computer Science) |
Database Administrator
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.

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 26, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Godwin Iheuwa
  • Apr 02, 2010
    Quiz Created by
    Kritika Joshi
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.