Microsoft Excel - Quiz 1 Com254

20 Questions | Total Attempts: 247

SettingsSettingsSettings
Microsoft Excel Quizzes & Trivia

Quiz 1 for the Microsoft Excel Go! Series


Questions and Answers
  • 1. 
     A new ______________ opens when you start the Excel program.
    • A. 

      Workbook

    • B. 

      Document

    • C. 

      Database

    • D. 

      Presentation

  • 2. 
    A worksheet is also called a ___________________________.
    • A. 

      Document

    • B. 

      Spreadsheet

    • C. 

      Database

    • D. 

      Form

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

      Cells

    • B. 

      Ranges

    • C. 

      Gridlines

    • D. 

      Rows

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

      Cell

    • B. 

      Range

    • C. 

      Address

    • D. 

      Value

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

      Open

    • B. 

      Active

    • C. 

      Empty

    • D. 

      Available

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

      Cells

    • B. 

      Formulas

    • C. 

      Data

    • D. 

      Functions

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

      Combined

    • B. 

      Merged

    • C. 

      Active

    • D. 

      Aligned

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

      Footers

    • B. 

      Titles

    • C. 

      Headers

    • D. 

      Elements

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

      Format

    • B. 

      Wrap

    • C. 

      Justify

    • D. 

      Align

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

      Undo

    • B. 

      Redo

    • C. 

      Overtype

    • D. 

      Reverse

  • 11. 
    Sheet tabs identify each __________ in a workbook.
    • A. 

      Worksheet

    • B. 

      File

    • C. 

      Document

    • D. 

      Location

  • 12. 
    When more than one worksheet of a workbook is selected they are:
    • A. 

      Combined

    • B. 

      Grouped

    • C. 

      Totaled

    • D. 

      Fixed

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

      Live

    • B. 

      Open

    • C. 

      Active

    • D. 

      First

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

      Auto Type

    • B. 

      Auto Fill

    • C. 

      Copying

    • D. 

      Formatting

  • 15. 
    What is a temporary area maintained by the Windows operating system that stores data?
    • A. 

      Recycle Bin

    • B. 

      Clipboard

    • C. 

      Storage

    • D. 

      Drive

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

      Move

    • B. 

      Copy

    • C. 

      Paste

    • D. 

      Insert

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

      Destination

    • B. 

      Source

    • C. 

      Data

    • D. 

      Adjacent

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

      Ranges

    • B. 

      Workbooks

    • C. 

      Cells

    • D. 

      Worksheets

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

      Relative

    • B. 

      Absolute

    • C. 

      Workbook

    • D. 

      Worksheet

  • 20. 
    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.
    • A. 

      Columns

    • B. 

      Rows

    • C. 

      Cells

    • D. 

      Selections

Back to Top Back to top