2nd Excel Test - Spring 2014

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 Christy Williams
C
Christy Williams
Community Contributor
Quizzes Created: 13 | Total Attempts: 3,867
Questions: 14 | Attempts: 262

SettingsSettingsSettings
Spring Quizzes & Trivia

Read and answer each question carefully. There are different kinds of questions; matching, multiple choices, and true/false.


Questions and Answers
  • 1. 

    The coordinates of the intersection of a row and column is the ______________.

    • A.

      Positive reference

    • B.

      Cell reference

    • C.

      Name box

    • D.

      Fill handle

    Correct Answer
    B. Cell reference
    Explanation
    The coordinates of the intersection of a row and column is referred to as a cell reference. A cell reference is used to identify a specific cell in a spreadsheet by specifying its column letter and row number. It is a way to locate and access data within a spreadsheet.

    Rate this question:

  • 2. 

    The cell into which you are currently entering data; it has a heavy border around it

    • A.

      Name box

    • B.

      Cell

    • C.

      Active cell

    • D.

      Gridlines

    Correct Answer
    C. Active cell
    Explanation
    The active cell refers to the cell in which the user is currently entering data. It is indicated by a heavy border around it. This allows the user to easily identify the cell they are working on and ensures that any data entered is applied to the correct cell.

    Rate this question:

  • 3. 

    The small green square located in the lower right corner of the active cell

    • A.

      Option handle

    • B.

      Fill handle

    • C.

      Status bar

    • D.

      Range

    Correct Answer
    B. Fill handle
    Explanation
    The fill handle is a small green square located in the lower right corner of the active cell. It is used to quickly fill data into adjacent cells by dragging it across the desired range. This feature is particularly useful when you want to copy a formula or a series of values to multiple cells without manually entering them one by one.

    Rate this question:

  • 4. 

    The blinking vertical line that indicates where the next typed character will appear

    • A.

      Insertion point

    • B.

      Active cell

    • C.

      Cell reference

    • D.

      Fill line

    Correct Answer
    A. Insertion point
    Explanation
    The blinking vertical line that indicates where the next typed character will appear is called the insertion point. It is used to show the current position in a document or text field where the text will be inserted.

    Rate this question:

  • 5. 

    The ________________ allows you to add all the numbers in a range of cells.

    • A.

      MIN function

    • B.

      SUM function

    • C.

      MAX function

    • D.

      ADD function

    Correct Answer
    B. SUM function
    Explanation
    The SUM function allows you to add all the numbers in a range of cells. It is a built-in function in spreadsheet software that simplifies the process of adding multiple numbers together. By selecting the range of cells you want to add, the SUM function automatically calculates the total sum of those numbers. This function is commonly used in financial analysis, budgeting, and other tasks that involve adding numerical data.

    Rate this question:

  • 6. 

    Provides easy access to frequently used commands

    • A.

      Easy Access Toolbar

    • B.

      Office Button

    • C.

      Quick Access Toolbar

    • D.

      Name Box

    Explanation
    The Quick Access Toolbar provides easy access to frequently used commands in an application. It is a customizable toolbar located at the top left corner of the application window. Users can add commonly used commands to the toolbar, such as save, undo, and print, so that they are easily accessible with just one click. This saves time and improves efficiency by eliminating the need to navigate through menus or ribbons to find these commands.

    Rate this question:

  • 7. 

    Excel opens a new workbook with ________ worksheets.

    • A.

      One

    • B.

      Two

    • C.

      Three

    • D.

      Five

    Correct Answer
    C. Three
    Explanation
    Excel opens a new workbook with three worksheets. This means that when you create a new workbook in Excel, it automatically comes with three blank worksheets. These worksheets can be used to organize and analyze data separately, allowing users to work on multiple sheets within the same workbook. Having three worksheets by default provides flexibility and convenience for users to start working on different tasks or projects simultaneously.

    Rate this question:

  • 8. 

    The numbers on the left side of the grid are

    • A.

      Row Headings

    • B.

      Column Headings

    • C.

      Headers

    • D.

      Footers

    Correct Answer
    A. Row Headings
    Explanation
    The numbers on the left side of the grid are referred to as row headings. They indicate the different rows in the grid and are typically used to label or identify each row.

    Rate this question:

  • 9. 

    The Name Box displays the active cell reference.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The Name Box in Excel displays the active cell reference, allowing users to easily identify which cell is currently selected. This feature is particularly useful when working with large spreadsheets or when navigating between different cells. By showing the cell reference, the Name Box helps users keep track of their location and ensures accurate data entry and manipulation. Therefore, the statement "The Name Box displays the active cell reference" is true.

    Rate this question:

  • 10. 

    How are columns designated in Excel?

    • A.

      Letters

    • B.

      Numbers

    • C.

      Triangles

    • D.

      Combination of letters and numbers

    Correct Answer
    A. Letters
    Explanation
    Columns in Excel are designated using letters. Each column is assigned a letter starting from A and going up to Z, then continuing with two letters combinations like AA, AB, AC, and so on. This letter designation is used to identify and reference specific columns in formulas, functions, and data manipulation operations within Excel.

    Rate this question:

  • 11. 

    This means the cell's content is positioned at the far left in the cell

    • A.

      Justified

    • B.

      Right-aligned

    • C.

      Center-aligned

    • D.

      Left-aligned

    Correct Answer
    D. Left-aligned
    Explanation
    Left-aligned means that the content of the cell is positioned at the far left in the cell. This means that the text or data in the cell starts from the left side and extends towards the right side of the cell. It is the opposite of right-aligned, where the content would be positioned at the far right in the cell. Center-aligned means that the content is positioned in the center of the cell, and justified means that the content is aligned to both the left and right sides of the cell.

    Rate this question:

  • 12. 

    The basic unit of a worksheet into which you enter data is called a __________________.

    • A.

      Cell

    • B.

      Box

    • C.

      Range

    • D.

      Gridline

    Correct Answer
    A. Cell
    Explanation
    A cell is the basic unit of a worksheet where data can be entered. It is represented as a rectangular box and is used to store and manipulate data. Cells are organized in a grid-like structure, with rows and columns intersecting at specific points known as gridlines. Each cell can hold a single piece of data, such as a number, text, or formula.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.