Excel '07/'10
Your browser does not support viewing this document. Click here to download the document.
Your browser does not support viewing this document. Click here to download the document.
Your browser does not support viewing this document. Click here to download the document.
Your browser does not support viewing this document. Click here to download the document.
Your browser does not support viewing this document. Click here to download the document.
Your browser does not support viewing this document. Click here to download the document.
Exercises for Basic Excel
My Address List
1. Open Excel
2. Using Sheet 1, enter the following information in the cells indicated:
a. A2: Title(s)
b. B2: Surname
c. C2: First Name(s)
d. D2: Address
e. E2: City
f. F2: ST
g. G2: ZIP
h. H2: Telephone
i. I2: E-Mail Address
j. J2: CC List??
3. Select cells A1 through J1; click on the Merge and Center icon; type: My Address List
4. Select (highlight) the title; change the font size to 12; make it Bold and Italic.
5. Use Page Layout to change to landscape orientation, center titles, etc.
6. You are now ready to start entering information in your address list file. Remember that you can quickly resize the cells of a column to accommodate the data in it by double-clicking between the line between that column and the one following it.
7. Save the file as “Address List” where you wish on your computer.
Credit Card Record
1. Open Excel
2. Using Sheet 1, enter the following information in the cells indicated.
a. A3: Date
b. B3: Vendor
c. C3: Description
d. D3: Increase
e. E3: Decrease
f. F3: Balance
3. Merge and center cells A1 through F1; type: Credit Card Record in Bold, 12 pt., Italic.
4. Merge and center cells A2 through F2; type: (the card’s name).
5. Center the titles on row 3.
6. Format the date column as you wish: Format, cells, date, etc.
7. Format columns D, E, and F as currency with 2 decimal points and a dollar sign in the top cell only.
8. Enter the following formula in cell F5: =(F4+D5-E5); Copy that formula through cell F30.
9. For practice, enter a balance of $575 on 1/1/07, a purchase of $14.95 on 1/3/07 and a payment of $500 on 1/10/07.
10. This file is now ready for your use. Name the file and save as you want.
Mileage and Miles Per Gallon Exercise
1. Open a new blank spreadsheet (Book). Type in the following titles for columns A, B, C, D, E and F: DATE,GALLONS, COST, ODOMETER READING, MILES DRIVEN, MPG
2. Change the size of each column so the titles fit within the columns. If you want everything centered in each column, highlight A, B, C, D, E, F and then choose the Centering button on the Tool Bar.
3. Type in the following for a monthly record of gasoline purchases and the miles driven.
a. 1/1/06 the odometer reading was 25567.00 when the gas tank was filled.
b. 1/05/06 – 14.50 gallons cost 36.43 and the odometer reading was 25875.85
c. 1/12/06 – 21.50 gallons cost 50.10 and the odometer reading was 26372.50
d. 1/20/06 – 16.70 gallons cost 38.41 and the odometer reading was 26743.24
e. 1/29/06 – 19.60 gallons cost 44.69 and the odometer reading was 27137.20
4. Format any columns that need changing, ie the cost should be in currency and the odometer reading could have the comma to designate the thousands.
5. Now we want to calculate the miles driven by making a formula for subtracting the odometer reading from the previous reading. Once this formula is created in cell E3, it can be copied on down through the rest of the entries by clicking on cell E3 and dragging the right hand corner of it down. (Filling)
6. In column F make a formula for calculating the MPG by dividing the miles driven by the gallons purchased. Use the fill method to calculate the rest of the column.
7. Total the columns for the gallons, cost and miles driven by using the ∑ function.
8. To find the average MPG, we will use a built in formula. Click on the cell below the last entry in the MPG column. Go to the function bar and click on the symbol and get a drop down menu and choose AVG.
9. Save your file as MPG exercise.
My Address List
1. Open Excel
2. Using Sheet 1, enter the following information in the cells indicated:
a. A2: Title(s)
b. B2: Surname
c. C2: First Name(s)
d. D2: Address
e. E2: City
f. F2: ST
g. G2: ZIP
h. H2: Telephone
i. I2: E-Mail Address
j. J2: CC List??
3. Select cells A1 through J1; click on the Merge and Center icon; type: My Address List
4. Select (highlight) the title; change the font size to 12; make it Bold and Italic.
5. Use Page Layout to change to landscape orientation, center titles, etc.
6. You are now ready to start entering information in your address list file. Remember that you can quickly resize the cells of a column to accommodate the data in it by double-clicking between the line between that column and the one following it.
7. Save the file as “Address List” where you wish on your computer.
Credit Card Record
1. Open Excel
2. Using Sheet 1, enter the following information in the cells indicated.
a. A3: Date
b. B3: Vendor
c. C3: Description
d. D3: Increase
e. E3: Decrease
f. F3: Balance
3. Merge and center cells A1 through F1; type: Credit Card Record in Bold, 12 pt., Italic.
4. Merge and center cells A2 through F2; type: (the card’s name).
5. Center the titles on row 3.
6. Format the date column as you wish: Format, cells, date, etc.
7. Format columns D, E, and F as currency with 2 decimal points and a dollar sign in the top cell only.
8. Enter the following formula in cell F5: =(F4+D5-E5); Copy that formula through cell F30.
9. For practice, enter a balance of $575 on 1/1/07, a purchase of $14.95 on 1/3/07 and a payment of $500 on 1/10/07.
10. This file is now ready for your use. Name the file and save as you want.
Mileage and Miles Per Gallon Exercise
1. Open a new blank spreadsheet (Book). Type in the following titles for columns A, B, C, D, E and F: DATE,GALLONS, COST, ODOMETER READING, MILES DRIVEN, MPG
2. Change the size of each column so the titles fit within the columns. If you want everything centered in each column, highlight A, B, C, D, E, F and then choose the Centering button on the Tool Bar.
3. Type in the following for a monthly record of gasoline purchases and the miles driven.
a. 1/1/06 the odometer reading was 25567.00 when the gas tank was filled.
b. 1/05/06 – 14.50 gallons cost 36.43 and the odometer reading was 25875.85
c. 1/12/06 – 21.50 gallons cost 50.10 and the odometer reading was 26372.50
d. 1/20/06 – 16.70 gallons cost 38.41 and the odometer reading was 26743.24
e. 1/29/06 – 19.60 gallons cost 44.69 and the odometer reading was 27137.20
4. Format any columns that need changing, ie the cost should be in currency and the odometer reading could have the comma to designate the thousands.
5. Now we want to calculate the miles driven by making a formula for subtracting the odometer reading from the previous reading. Once this formula is created in cell E3, it can be copied on down through the rest of the entries by clicking on cell E3 and dragging the right hand corner of it down. (Filling)
6. In column F make a formula for calculating the MPG by dividing the miles driven by the gallons purchased. Use the fill method to calculate the rest of the column.
7. Total the columns for the gallons, cost and miles driven by using the ∑ function.
8. To find the average MPG, we will use a built in formula. Click on the cell below the last entry in the MPG column. Go to the function bar and click on the symbol and get a drop down menu and choose AVG.
9. Save your file as MPG exercise.