Excel icon |
Getting started
To run Excel, double click on the Excel icon on the desktop. If the excel icon is not
on the desk top, click on _{} in the lower left corner of the screen. Drag your cursor up to Run and release the left mouse button.
In the Run
window that appears type "excel" as shown above. Click on OK or press
Enter to start Excel. This is a sure-fire way to start Excel if you can't
find the Excel icon.
The Excel Worksheet
The Excel worksheet is shown in Figure 1. It contains control menus and buttons at the top of the screen, but most of the window is an array of rectangular boxes called cells.
Column Width
Sometimes the cells are not wide enough to contain the information we wish to display. You can change the width of a column.
Entering data
We want to setup an Excel spreadsheet to calculate grades in a course. Enter the student names and grades given in the table below into the Excel worksheet. Put each grade in a separate cell. To enter data into a cell, first select the cell by clicking on it, then just type the data. You can move to another cell by clicking, using the arrow keys or by pressing the Tab key. Duplicate the table below on the worksheet.
Exam 1 | Exam2 | Problems | Lab | Average | Grade | |
Smith, Mary | ||||||
Jones, Sara | ||||||
Johnson, Martha | ||||||
Wise, Joan | ||||||
Swift, Bernadette |
Calculations
We wish to have Excel determine the grades. Exam 1 and 2 are each 30% of the grade. Problems and Lab are each worth 20%. A student's average in the course is calculated using the formula,
Average = 0.3*Exam1 + 0.3*Exam1 + 0.2*10*Problems + 0.2*10*LabThe problems and Lab grades are out of 10. Therefore they have to be multiplied by 10 to make them "out of 100". That is, if we multiply the Lab grade by 10 the maximum lab grade changed from 10 to 100. We then take 20% of this number, since the lab counts as 20% of the average.
To make Excel do this calculation,
You don't have to type the formula to repeat the calculation for the other students.