Excel Pre-post Test
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.
Correct Answer
D. A, B and C -
- 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."
Correct Answer
B. Click on the drop down menu "Insert" and select "Chart." -
- 3.
True or False: Excel can calculate averages and sums.
- A.
True
- B.
False
Correct Answer
A. True -
- 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.
Correct Answer
D. Many -
- 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
Correct Answer
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.
Correct Answer
C. Is a collection of cells on a single sheet where you actually keep and manipulate the data, also known as a spreadsheet -
- 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.
Correct Answer
A. Equation used to calculate values in a spreadsheet cell. -
- 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.
Correct Answer
B. A selected cell -
- 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.
Correct Answer
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.
Correct Answer
A. A series of cells running horizontally in an Excel worksheet. -
- 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.
Correct Answer
B. A series of cells running vertically in an Excel worksheet. -
- 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
Correct Answer
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
Correct Answer
A. MS Excel file in which you enter and store related data. -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz Edited by
ProProfs Editorial Team -
Feb 16, 2009Quiz Created by
Jaspang
Back to top