Do You Know The MS Excel Basics? Quiz

12 Questions | Total Attempts: 530

SettingsSettingsSettings
Please wait...
Do You Know The MS Excel Basics? Quiz

Do you know the MS Excel basics? This tool is the right one if you want to present information using numbers and data in formulas. Do you know how to use filters to simplify data or transpose roes into columns? If you doubt how good you know about using this specific Microsoft tool, this quiz is exactly what you need to test yourself. Give it a shot and see how good you do.


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?