Excel Pre-post Test

13 Questions | Attempts: 501
Share
SettingsSettings
Please wait...
  • 1/13 Questions

    True or False: Excel can calculate averages and sums.

    • True
    • False
Please wait...
About This Quiz

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.

Microsoft Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    What is a wizard?

    • A witch

    • A selected cell

    • A series of cells running horizontally in an Excel worksheet.

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

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

    What is a cell?

    • I do not know.

    • Equation used to calculate values in a spreadsheet cell.

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

    Correct Answer
    A. The little box on Excel that you type text, numbers or formulas into
  • 4. 

    What is a worksheet?

    • Equation used to calculate values in a spreadsheet cell.

    • A selected group of cells.

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

    • I do not know.

    Correct Answer
    A. Is a collection of cells on a single sheet where you actually keep and manipulate the data, also known as a spreadsheet
  • 5. 

    What is an active cell?

    • A spreadsheet.

    • A selected cell

    • A cell that moves randomly on a worksheet

    • I do not know.

    Correct Answer
    A. A selected cell
  • 6. 

    What is a formula?

    • Equation used to calculate values in a spreadsheet cell.

    • A selected group of cells.

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

    • I do not know.

    Correct Answer
    A. Equation used to calculate values in a spreadsheet cell.
  • 7. 

    Excel is a useful program because...

    • It helps keep data organized.

    • It can perform calculations.

    • It can easily create graphs and charts from data.

    • A, B and C

    • I do not know.

    Correct Answer
    A. A, B and C
  • 8. 

    What is a row?

    • A series of cells running horizontally in an Excel worksheet.

    • A series of cells running vertically in an Excel worksheet.

    • I do not know.

    Correct Answer
    A. A series of cells running horizontally in an Excel worksheet.
  • 9. 

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

    • I do not know.

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

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

    Correct Answer
    A. Click on the drop down menu "Insert" and select "Chart."
  • 10. 

    What is a column?

    • series of cells running horizontally in an Excel worksheet.

    • A series of cells running vertically in an Excel worksheet.

    • I do not know.

    Correct Answer
    A. A series of cells running vertically in an Excel worksheet.
  • 11. 

    How many different types of charts can you make in Excel?

    • One - Column Chart.

    • Two - Column Chart and Bar Graph.

    • Three - Column Chart, Bar Graph, Pie Chart.

    • Many

    • I do not know.

    Correct Answer
    A. Many
  • 12. 

    What is a workbook?

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

    • I do not know.

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

    Correct Answer
    A. MS Excel file in which you enter and store related data.
  • 13. 

    How do you change the title of a chart?

    • I do not know.

    • In the chart-making wizard.

    • Click on Title text box on the chart

    • B or C

    Correct Answer
    A. B or C

Quiz Review Timeline (Updated): Mar 21, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 16, 2009
    Quiz Created by
    Jaspang
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.