Microsoft Excel - Quiz 1 Com254

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 Tfishermba
T
Tfishermba
Community Contributor
Quizzes Created: 2 | Total Attempts: 373
| Attempts: 297
SettingsSettings
Please wait...
  • 1/20 Questions

    A worksheet is also called a ___________________________.

    • Document
    • Spreadsheet
    • Database
    • Form
Please wait...
About This Quiz

This Microsoft Excel quiz for COM254 tests knowledge on basic Excel elements like workbooks, spreadsheets, gridlines, cells, data types and more.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

     A new ______________ opens when you start the Excel program.

    • Workbook

    • Document

    • Database

    • Presentation

    Correct Answer
    A. Workbook
    Explanation
    When you start the Excel program, a new workbook opens. A workbook in Excel is a file that contains one or more worksheets where you can enter, calculate, and analyze data. It is the primary document in Excel where you can organize and manipulate your data. Therefore, the correct answer is "workbook".

    Rate this question:

  • 3. 

     Reverse an action or a series of actions by using the _________ command.

    • Undo

    • Redo

    • Overtype

    • Reverse

    Correct Answer
    A. Undo
    Explanation
    The correct answer is "undo". The undo command is used to reverse an action or a series of actions. It allows the user to revert back to a previous state before the action was performed, effectively undoing any changes made. This command is commonly found in software applications and is a useful tool for correcting mistakes or trying different options without permanently affecting the data.

    Rate this question:

  • 4. 

    Sheet tabs identify each __________ in a workbook.

    • Worksheet

    • File

    • Document

    • Location

    Correct Answer
    A. Worksheet
    Explanation
    Sheet tabs are used to identify each worksheet in a workbook. A workbook is a collection of multiple worksheets, and each worksheet represents a separate page or tab within the workbook. Therefore, the correct answer is worksheet.

    Rate this question:

  • 5. 

     The intersection of a column and a row is called a(n) ______________.

    • Cell

    • Range

    • Address

    • Value

    Correct Answer
    A. Cell
    Explanation
    A cell is the intersection of a column and a row in a spreadsheet or table. It is where data can be entered, edited, or displayed. Cells are the basic units of a spreadsheet and are used to organize and store information. They can contain text, numbers, formulas, or functions.

    Rate this question:

  • 6. 

     The cell that is ready to accept data or be affected by the next Excel command is called the _____________ cell.

    • Open

    • Active

    • Empty

    • Available

    Correct Answer
    A. Active
    Explanation
    The cell that is ready to accept data or be affected by the next Excel command is called the "active" cell. This means that it is currently selected and any input or action will be applied to this cell.

    Rate this question:

  • 7. 

    A(n) _____________ cell is a single cell created by combining two or more selected cells.

    • Combined

    • Merged

    • Active

    • Aligned

    Correct Answer
    A. Merged
    Explanation
    A merged cell is a single cell created by combining two or more selected cells. When cells are merged, their contents are combined into one cell, and the resulting cell takes up the space of all the merged cells. This is useful for creating a larger cell that spans multiple columns or rows, allowing for better organization and presentation of data.

    Rate this question:

  • 8. 

    _____________________ are text, page numbers, and graphics that display and print at the bottom of every page.

    • Footers

    • Titles

    • Headers

    • Elements

    Correct Answer
    A. Footers
    Explanation
    Footers are the elements that display and print at the bottom of every page. They typically contain text, page numbers, and graphics that provide additional information or navigation options. Unlike headers, which appear at the top of each page, footers are located at the bottom. They are commonly used in documents, presentations, and websites to provide consistency and enhance the overall design and usability.

    Rate this question:

  • 9. 

    When more than one worksheet of a workbook is selected they are:

    • Combined

    • Grouped

    • Totaled

    • Fixed

    Correct Answer
    A. Grouped
    Explanation
    When more than one worksheet of a workbook is selected, they are grouped. Grouping worksheets allows for easier management and manipulation of data across multiple sheets. It allows users to perform actions such as formatting, inserting or deleting rows/columns, and applying formulas to multiple sheets at once. Grouping also enables users to view and navigate through the selected sheets simultaneously, making it convenient for data analysis and comparison.

    Rate this question:

  • 10. 

    The __________ worksheet is where text and data will be entered.

    • Live

    • Open

    • Active

    • First

    Correct Answer
    A. Active
    Explanation
    The active worksheet is where text and data will be entered. This means that the user can input information directly into this worksheet. The other options, such as live, open, and first, do not specifically indicate that text and data can be entered into them. Therefore, the active worksheet is the correct choice.

    Rate this question:

  • 11. 

      __________ enables you to extend a series of values into adjacent cells based on the value of other cells.

    • Auto Type

    • Auto Fill

    • Copying

    • Formatting

    Correct Answer
    A. Auto Fill
    Explanation
    Auto Fill enables you to extend a series of values into adjacent cells based on the value of other cells. It automatically detects the pattern in the selected cells and fills the adjacent cells with the corresponding values. This feature is useful when you have a series of data that follows a specific pattern and you want to quickly populate the remaining cells without manually typing each value.

    Rate this question:

  • 12. 

     __________ cell references refer to their fixed position in the worksheet and do not change when the formula is copied.

    • Relative

    • Absolute

    • Workbook

    • Worksheet

    Correct Answer
    A. Absolute
    Explanation
    Absolute cell references refer to their fixed position in the worksheet and do not change when the formula is copied. Unlike relative cell references, which adjust their position based on the location of the formula, absolute cell references remain constant. This is useful when you want to refer to a specific cell or range of cells in a formula and ensure that it does not change when the formula is copied to other cells.

    Rate this question:

  • 13. 

    Use the _________ Text command to display long cell entries on more than one line within a cell.

    • Format

    • Wrap

    • Justify

    • Align

    Correct Answer
    A. Wrap
    Explanation
    The Wrap Text command is used to display long cell entries on more than one line within a cell. This command automatically adjusts the height of the cell to accommodate the text, allowing it to be displayed in a more readable format. By selecting the Wrap Text option, the text will wrap within the cell, preventing it from overflowing into adjacent cells. This is particularly useful when dealing with lengthy text entries or when formatting cells for reports or presentations.

    Rate this question:

  • 14. 

    The __________ command inserts the most recent data stored in the Clipboard to a new cell or range of cells.

    • Move

    • Copy

    • Paste

    • Insert

    Correct Answer
    A. Paste
    Explanation
    The "paste" command is used to insert the most recent data stored in the Clipboard to a new cell or range of cells. It allows you to transfer data from one location to another within a spreadsheet or document. This command is commonly used when you want to duplicate or move data without retyping it.

    Rate this question:

  • 15. 

     _____________________ consist of numbers, text, dates, or times of the day.

    • Cells

    • Formulas

    • Data

    • Functions

    Correct Answer
    A. Data
    Explanation
    Data refers to the information that is stored in a spreadsheet. It can include numbers, text, dates, or times of the day. In a spreadsheet, data is typically organized into cells, which are the basic units of a spreadsheet. Cells can contain different types of data, such as numerical values, text strings, or dates. Data is essential for performing calculations, creating formulas, and analyzing information in a spreadsheet. Therefore, the correct answer is "Data."

    Rate this question:

  • 16. 

    What is a temporary area maintained by the Windows operating system that stores data?

    • Recycle Bin

    • Clipboard

    • Storage

    • Drive

    Correct Answer
    A. Clipboard
    Explanation
    The clipboard is a temporary area maintained by the Windows operating system that stores data. It allows users to cut, copy, and paste text, images, and other types of data between different applications or within the same application. The data stored in the clipboard remains there until it is replaced by new data or until the computer is restarted. This feature provides a convenient way for users to transfer information and enhances productivity by allowing the reuse of data across different tasks and applications.

    Rate this question:

  • 17. 

    The Find and Replace feature searches the __________ in a worksheet – or in a selected range – for matches and then replaces each match with a replacement of your choice.

    • Columns

    • Rows

    • Cells

    • Selections

    Correct Answer
    A. Cells
    Explanation
    The Find and Replace feature in a worksheet allows users to search for matches and replace them with a chosen replacement. In this context, the feature searches for matches within the cells of the worksheet or a selected range. It does not search within columns, rows, or selections specifically, but rather within the individual cells of the worksheet.

    Rate this question:

  • 18. 

    The __________ range is the range of cells into which copied data is placed.

    • Destination

    • Source

    • Data

    • Adjacent

    Correct Answer
    A. Destination
    Explanation
    The destination range refers to the range of cells where the copied data is placed. It is the location or target where the data is being copied to.

    Rate this question:

  • 19. 

    A pattern of uniformly spaced horizontal and vertical lines that are present when you open an Excel file are called _________________.

    • Cells

    • Ranges

    • Gridlines

    • Rows

    Correct Answer
    A. Gridlines
    Explanation
    When you open an Excel file, you can see a pattern of uniformly spaced horizontal and vertical lines that form a grid-like structure. These lines are called gridlines. They help in visually organizing and aligning the data in the cells of the spreadsheet, making it easier to read and work with the information.

    Rate this question:

  • 20. 

    Grouped __________ enable you to format the same range of cells in all worksheets of the group simultaneously.

    • Ranges

    • Workbooks

    • Cells

    • Worksheets

    Correct Answer
    A. Worksheets
    Explanation
    Grouped worksheets enable you to format the same range of cells in all worksheets of the group simultaneously. By grouping the worksheets, any changes made to the formatting of a specific range of cells will be applied to all the worksheets within the group. This saves time and effort as you don't have to manually format each worksheet individually.

    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
  • Jun 24, 2009
    Quiz Created by
    Tfishermba
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.