# Excel Pre-post Test

13 Questions | Total Attempts: 487

Settings

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.

Related Topics
• 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.

• B.

A selected cell

• C.

A cell that moves randomly on a worksheet

• D.

I do not know.

• 9.
What is a wizard?
• 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