Excel Basic

12 Questions | Total Attempts: 521

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

This quiz is aimed at testing your basic knowledge of Microsoft Excel.


Questions and Answers
  • 1. 
    A __________ is a grid that organizes data into columns and rows.
    • A. 

      Cell

    • B. 

      Workbook

    • C. 

      Spreadsheet

    • D. 

      Excel

  • 2. 
    The __________ is the place in your worksheet where you enter information; it is highlighted with a black border.
    • A. 

      Name box

    • B. 

      Active cell

    • C. 

      Formula bar

    • D. 

      Grid

  • 3. 
    These items on a spreadsheet are labeled with letters.
    • A. 

      Column heading

    • B. 

      Row heading

  • 4. 
    The ______________ is a field that allows you to enter or edit data in a cell. It will display the formula for a selected cell instead of the results of that cell.
    • A. 

      Name box

    • B. 

      Formula bar

    • C. 

      Sheet tab

    • D. 

      Active cell

  • 5. 
    The ___________ identifies the location of a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address.
    • A. 

      Value

    • B. 

      Label

    • C. 

      Cell reference

    • D. 

      Active cell

  • 6. 
    A __________ is an entry that is usually used for headings, names, and for identifying columns of data. It can contain letters and numbers.
    • A. 

      Value

    • B. 

      Label

    • C. 

      Range

    • D. 

      Cell reference

  • 7. 
    A __________ is an entry that contain a number and can be used in calculations.
    • A. 

      Value

    • B. 

      Label

    • C. 

      Formula

    • D. 

      Function

  • 8. 
    A __________ is a group or block of cells in a worksheet that have been selected or highlighted. 
    • A. 

      Value

    • B. 

      Label

    • C. 

      Formula

    • D. 

      Range

  • 9. 
    A __________ is a mathematical equation that will calculate a result.
    • A. 

      Formula

    • B. 

      Function

    • C. 

      Range

    • D. 

      Cell

  • 10. 
    A __________ is a preset formula. Example  =SUM(D1:D6).
    • A. 

      Value

    • B. 

      Label

    • C. 

      Function

    • D. 

      Constant

  • 11. 
    What is the formula for calculating the number of girls in the spreadsheet above?