Creating a Product Analysis in Excel
Lesson Plan
Grading Rubric

Microsoft Excel is a program that is used by businesses to evaluate product performance and then displays it in easily read charts and graphs. For this activity, you will actually make up fictitious information on the number of products sold during a week period.

Open Excel by following the directions listed below:

Save Excel Worksheet:

Setting up the Worksheet and Inputting Data

Open a worksheet in Microsoft Excel. In cell A1, type the title Your Business Name Product Analysis, where Your Business Name is the name of your company. Finish putting in the rest of the data in the table below into Excel. Then go back and merge your title to appear centered across your rows.

Moving Around in the Worksheet:

There are several methods that can be used to move through the worksheet:

Entering Data:

Data is entered into single cells. The cell that has been selected to enter data is called the active cell and is identified by a heavy border. Only one cell can be active at a time. To change the active cell, move the mouse pointer into a cell and just click. To enter data, simply click in the cell and then type in the information you want to appear in the cell. In this case, you would enter a letter in each cell.

Editing Data

Once you have entered data into a cell, that data can be edited by first clicking on the cell to make the cell active and then clicking on the formula bar above the worksheet. The formula bar is shown below:

This allows you to insert or delete characters in that cell. An alternate method of editing the contents of a cell is to click on the cell to make it the active cell and then press the [F2] function key at the top of the keyboard. You can delete the contents of a cell by clicking on the cell and pressing [Delete] on the keyboard.

Formatting Worksheet:

The formatting toolbar, shown below, allows you to format the contents of a highlighted cell in a number of ways. If this toolbar is not already visible on the screen, select View>Toolbars>Formatting from the menu bar.

Merging the Title:

Align Cells with Center Alignment:

Formatting Cells Bold:

Changing Font Color:

Highlight Row:

Resizing Cells:

Some of the data overflow the cell. In this case you can drag the cell out to display all the information in the cell. To do this, place your cursor on the top of the column between the two columns you want to resize (crosshairs will appear) , hold down the left mouse, and drag the cell to the right until your cell is the size you want.

The following information should be typed in the designated cells, where Product 1, Product 2, etc. is the actual name of one of your products. You will input fictitious data for number sold and the price of the items. Do not enter information in Total Sales of Week, Minimum Sold, Maximum Sold, and Average Number Sold. You will insert formulas in these cells that will calculate the data for you.

Entering Formulas

You will now enter formulas to determine the total sales of week, minimum and maximum number sold, and the average number sold. You need to be in the cell you want your calculation to be. For example, cell C12 will hold the calculation for total sales for the week. Follow the directions below to enter your first formula:

Continue entering formulas in the cells highlighted below. The function keywords are:

Creating Charts and Graphs:

Now you will create charts and graphs that will display the information in a more user friendly format. In order to compare information graphically, you must choose the data to reflect in our graphs. You want to compare: