Excel Pre-post Test
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.
- 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.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
Back to top