Excel Proficiency Quiz AFS

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 AmericanFleet
A
AmericanFleet
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,123
| Attempts: 1,123
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/10 Questions

    True or False.  A range has an address called an range address.

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

The Excel Proficiency Quiz AFS assesses key skills in navigating and utilizing Microsoft Excel. It covers basic functionalities such as cell alignment, entry completion, default settings, and formatting tools. Designed for learners aiming to enhance their practical Excel skills.

Excel Proficiency Quiz AFS - Quiz

Quiz Preview

  • 2. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    If you choose a larger font size, the height of the row is automatically made taller. This is because the font size determines the amount of vertical space that each character occupies. When the font size is increased, the characters become larger and require more vertical space, thus causing the row height to increase.

    Rate this question:

  • 3. 

    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:

  • 4. 

    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 tool is useful when you want to apply the same formatting, such as font style, font size, and cell 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 then apply the formatting to other cells by clicking on them.

    Rate this question:

  • 5. 

    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 "A1" refers to the top-left cell of the range, and the "B3" refers to the bottom-right cell of the range. This notation is commonly used in spreadsheet programs to specify a group of cells that are adjacent to each other and need to be selected or manipulated together.

    Rate this question:

  • 6. 

    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

    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 worked on. This visual indicator helps the user identify which range they are currently working with and ensures that any actions or changes made will apply to that specific range. The other options, having a marquee around it or the data changing to bold, are not mentioned as indicators of an active range, making them incorrect choices.

    Rate this question:

  • 7. 

    The default font keyed in a new work book 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 retangle 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 be a selection of cells, a specific row or column, or even multiple rows and columns. Ranges are commonly used in spreadsheet programs to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.

    Rate this question:

  • 9. 

    You can complete a cell entry by pressing

    • Enter

    • Tab

    • Shift+tab

    • An arrow key

    • Another cell

    • All of the Above

    Correct Answer
    A. All of the Above
    Explanation
    Pressing "enter", "tab", "shift+tab", an arrow key, or moving to another cell are all ways to complete a cell entry in a spreadsheet. Therefore, the correct answer is "All of the Above" as all of these options can be used to finalize a cell entry.

    Rate this question:

  • 10. 

    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 you visually identify and indicate the cells that you are selecting. It allows you to easily choose multiple cells or a range of cells in a spreadsheet or document.

    Rate this question:

Quiz Review Timeline (Updated): Sep 4, 2023 +

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

  • Current Version
  • Sep 04, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 01, 2012
    Quiz Created by
    AmericanFleet
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.