Excel Pre-post Test

13 Questions | Total Attempts: 480

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

This test is designed to determine what 4th and 5th grade students know about Excel vocabulary and basic functions before and after an Excel technology lesson.


Questions and Answers
  • 1. 
    Excel is a useful program because...
    • A. 

      It helps keep data organized.

    • B. 

      It can perform calculations.

    • C. 

      It can easily create graphs and charts from data.

    • D. 

      A, B and C

    • E. 

      I do not know.

  • 2. 
    If you want to make a chart, how would you get to the chart-making wizard?
    • A. 

      I do not know.

    • B. 

      Click on the drop down menu "Insert" and select "Chart."

    • C. 

      Click on the drop down menu "Tools" and select "Chart."

  • 3. 
    True or False: Excel can calculate averages and sums.
    • A. 

      True

    • B. 

      False

  • 4. 
    How many different types of charts can you make in Excel?
    • A. 

      One - Column Chart.

    • B. 

      Two - Column Chart and Bar Graph.

    • C. 

      Three - Column Chart, Bar Graph, Pie Chart.

    • D. 

      Many

    • E. 

      I do not know.

  • 5. 
    How do you change the title of a chart?
    • A. 

      I do not know.

    • B. 

      In the chart-making wizard.

    • C. 

      Click on Title text box on the chart

    • D. 

      B or C

  • 6. 
    What is a worksheet?
    • A. 

      Equation used to calculate values in a spreadsheet cell.

    • B. 

      A selected group of cells.

    • C. 

      Is a collection of cells on a single sheet where you actually keep and manipulate the data, also known as a spreadsheet

    • D. 

      I do not know.

  • 7. 
    What is a formula?
    • A. 

      Equation used to calculate values in a spreadsheet cell.

    • B. 

      A selected group of cells.

    • C. 

      A grid of rows and columns containing numbers, text, and formulas.

    • D. 

      I do not know.

  • 8. 
    What is an active cell?
    • A. 

      A spreadsheet.

    • B. 

      A selected cell

    • C. 

      A cell that moves randomly on a worksheet

    • D. 

      I do not know.

  • 9. 
    • A. 

      A witch

    • B. 

      A selected cell

    • C. 

      A series of cells running horizontally in an Excel worksheet.

    • D. 

      A tool to guide you through the steps of a process or task by asking a series of questions or presenting options.

  • 10. 
    What is a row?
    • A. 

      A series of cells running horizontally in an Excel worksheet.

    • B. 

      A series of cells running vertically in an Excel worksheet.

    • C. 

      I do not know.

  • 11. 
    What is a column?
    • A. 

      series of cells running horizontally in an Excel worksheet.

    • B. 

      A series of cells running vertically in an Excel worksheet.

    • C. 

      I do not know.

  • 12. 
    What is a cell?
    • A. 

      I do not know.

    • B. 

      Equation used to calculate values in a spreadsheet cell.

    • C. 

      The little box on Excel that you type text, numbers or formulas into

  • 13. 
    What is a workbook?
    • A. 

      MS Excel file in which you enter and store related data.

    • B. 

      I do not know.

    • C. 

      Is a collection of cells on a single sheet where you actually keep and manipulate the data, also known as a spreadsheet