EXCEL EXERCISE #1: Grade Sheet
1. Enter the information in the spreadsheet below. Be sure that the information is entered in
the same cells as given, or the formulas below will not work.
DRAW this newly on your spread sheet.
A B C D E F G
1 PSC 556: Policy Analysis
2 Spring 1995
3 EXAM EXAM EXAM FINAL
4 STUDENT NAMES STUDENT ID #1 #2 #3 PART. AVERAGE
5 Thomas, Steven 999-25-5683 94 65 89 90
6 Alexander, Suzette 999-52-6938 93 91 97 80
7 Richards, Billy Joe 998-71-2838 92 83 88 90
8 Rasmussen, Betty 997-74-4447 95 94 90 90
You will notice that when you enter the information in the first column, the text runs over into
the next cell. To adjust the size of the column, once all the information is entered for the first
column, click on the column heading (that is the letter A). Then open the FORMAT menu, select
the COLUMN options, and then select the AUTOFIT SELECTION command.
2. Enter the formula below into cell G5 and copy it into cells G6 to G8. This demonstrates the
use of a "relative reference" (e.g., C5) that points to the contents of a cell
G5: =c5*.3+d5*.3+e5*.3+f5*.1
Now copy this formula to cells G6, G7, and G8. To do this click on cell G5 to make it the active
cell. Then open the EDIT menu and choose the COPY command (a flashing border should now
appear around the cell G5). Now click on cell G6 and drag the pointer so the range of cells from
G6 to G8 are now highlighted. At this point you need to open the EDIT menu again, but this
time selected the PASTE option. . Notice that when you copy this formula into other cells the
row numbers for the cells change according to the row into which the formula has been copied.
3. Enter the information below in the cell indicated.
B10: Averages
1
