Excel Pre-Post Test

1. True or False: Excel can calculate averages and sums.

True

False

2. What is a wizard?

A witch

A selected cell

A series of cells running horizontally in an Excel worksheet.

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

4. What is a worksheet?

Equation used to calculate values in a spreadsheet cell.

A selected group of cells.

I do not know.

5. What is an active cell?

A spreadsheet.

A selected cell

A cell that moves randomly on a worksheet

I do not know.

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.

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.

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.

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."

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.

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.

12. What is a workbook?

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

I do not know.

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

Excel Pre-post Test