Back to lessons

USING THIS PAGE:

Below are the links to excel projects. Click on the links on the left below to take you to a project. In some projects you will see the headings OBJECTIVE, FILE NEEDED, and SOLUTION. The "objective" is a brief summary of what you will learn to do. "File needed" means that you need to open this file in order to complete the project. "Solution" tells you were to get the Excel answer file. To get the answers in HTML go the menu on the left and click on "Project Solutions".

 

Excel Chapter 2 Project 1

-NAMES-

Excel Chapter 2 Project 2

-STUDENT FILES-

Excel Chapter 2 Project 3

- RWANDA -

Excel Chapter 2 Project 4

-HAPPY TRAILS-

Excel Chapter 2 Project 5

-FRESHMAN SAT SCORES-

Excel Chapter 2 Project 6

-EXAM GRADES-

Excel Chapter 2 Project 7

-BASKETBALL STATISTICS-

Excel Chapter 2 Project 8

-PEN PAL-

Excel Chapter 2 Project 9

-SCOTT'S SCHEDULE-

Excel Chapter 2 Project 10

-ANTARCTICA PENGUINS-

Excel Chapter 2 Project 11

-SCIENCE EXPERIMENT-

Excel Chapter 2 Project 12

-UNCLE BOB'S FARM-

Excel Chapter 2 Project 13

-COMPUTER TECHNOLOGY-

Excel Chapter 2 Project 14

-MONEY PROBLEM-

Excel Chapter 2 Project 15

-TOY SALES-

Excel Chapter 2 Project 16

-MY SCHEDULE FOR JUNE-

Excel Chapter 2 Project 17

-DOCTORS RECORDS-

Excel Chapter 2 Project 18

-GLOBAL COMPANY-

Excel Chapter 2 Project 19

-PROFESSOR MONOGAL-

Excel Chapter 2 Project 20

-STRAWBERRY SALES-

 

PROJECT 1: NAMES

 

OBJECTIVE: Students will practice changing widths, columns and fonts in various ways.

FILE NEEDED: Excel Project Data 01

1) Open the file saved as "ExcProj1Data.xls".
2) Click anywhere in column A. Adjust the column by pulling down the Format
menu, click on Column, and then Width. Type in 18 for the Column Width.
3) Highlight rows B1 - B5. Pull down the Format menu, click on column, and then Autofit Selection to change the width of column B.
4) Center "Boys", "Girls", and "Honor Roll Students" using the Center button on the toolbar.
5) While holding down the Ctrl key select and highlight cells A2, A5, B3, B4, and B5.
6) Bold the highlighted names.
7) Change the font color of “Boys” to blue using the Font Color toolbar.
8) Change the font color of “Girls” to red by pulling down the Format menu, clicking on Cells, Font tab, and changing the color to red.
9) Left align column A by clicking the right button on the mouse, then click down to Format Cells, then click on the Alignment tab, pull down the drop down arrow for horizontally, and click on Left.
10) Left align column B by using the left align button on the toolbar.
11)Now Save your work as 'Names'.

[Back To Top]

PROJECT 2: STUDENT FILES

 

OBJECTIVE: The objective of this project is to use aligning, make font changes and to select nonadjacent cells.

1) Open an Excel Spreadsheet.
2) In cell A1 type the word 'Student'.
3) Center the word 'Student' in the cell.
4) In cells A2 through A8 type these names: 'Mike' 'Nick' 'Tina' 'Matt' 'Jessica' 'Leslie' and 'Bruce'.
5) Center all of these names at the same time.
6) In cell B1 type the word 'Grade'.
7) Center it in the cell.
8) From cells B2 through B8 type these grades: 'A' 'B' 'A' 'B+' 'C' 'B-' 'A-'.
9)Center all the grades.
10) Highlight cells A1 and B1.
11) Change their Font to 'Book Antique' Bold.
12) Highlight all the grades and Italicize them.
13) Now save your work as 'Student Files'.

[Back To Top]

PROJECT 3: RWANDA

 

OBJECTIVE: Create a hyperlink and change page tile.

FILE NEEDED: Excel Project Data 03

Follow these steps below to complete your task.

1) Go to the top left corner of the Excel window and click on the "File" menu.
2) Next click on "New" under the file menu.

3) Go to the menu bar click on "Insert", then click on picture.
4) You will see a sub menu. In the picture sub menu click on "From file".
5) Find the picture
"Rwanda_image.gif". Then click on "Insert"
6) Center the picture in the middle of the excel page by dragging the picture with the mouse.
7) Copy and paste this web address, "http://www.flags.net/RWAN.htm" under the flag picture.
8) In the next 5 cells under the link. Number and type 5 ways of how you can make Rwanda a better place.
9) Go back to "File" and click on "Save as Web Page".
10) Click on the button that says "Change Title". Type in
RWANDA and click "OK".
11) Save your file as "rwanda.html"

[Back To Top]

PROJECT 4: HAPPY TRAILS

 

OBJECTIVE: To learn to make a useful chart using borders and cell shading.

Marcia is a travel agent for Happy Trails travel agency and she needs your help in keeping organized. She wants to make a color coded chart of the months and weeks in the year that are the busiest times of travel.

1) Open a Blank Excel Worbook
2) In Cell A1 write the words "Happy Trails 2003". Highlight cells A1-E1 and click on the center and merge button on the toolbar. Rehighlight those same cells, bold the words and change them to size 14 font.
3) In cell A2 write the word Months. Click on the bold button on the toolbar and then on the center and merge button.
4) In Cells A3 to A14 write in each month of the year. Next in cells B2-E2 write in the corresponding words foir each cell: Week 1, Week 2, Week 3, Week 4. Highlight cells B2-E2 and click on the bold button on the toolbar as well as the center align button
5) The following color coding system is used by happy trails:


Impossible weeks - Red
Busy weeks - Orange
Somwhat busy weeks - Yellow

The next step is to color code the weeks of the year that Happy Trails has determined to be Impossible Weeks, Busy Weeks, ans Somewhat busy Weeks.
6) Click on cell B3 and drag to highlight the row range of B3-C3. Right click on the highlighted cells and click on the option Format Cells. Under the Pattern Tab click on the color red in the cell shading section. You have just color coded the first two weeks in January to be labeled as Impossible Weeks.
7) Do the same thing as you did in Part 6. For each of the following weeks in the following months


January - weeks 1 and 2 red, weeks 3 and 4 orange
Febraury - None
March - all 4 weeks yellos
April - None
May - None
June - all 4 weeks orange
July - all 4 weeks red
August - all 4 weeks red
September - all 4 weeks yellow
October - None
November - None
December - weeks 1 and 2 orange, weeks 3 and 4 red

8) Save your work as 'Happy Trails.'

[Back To Top]

PROJECT 5: FRESHMAN SAT SCORES

 

OBJECTIVE: To practice formatting cells, copying a cell entry, and pasting into a cell range.

FILE NEEDED: Excel Project Data 05

1) Open the file named "Easy Proj1.xls"
2) Merge and center cells A1-A5.
3) Bold and center A1 and A2.
4) Move cell range A3-B13 to B3-C13.
5) In cell, A14, enter "Average," and make the font red.
6) Make a border around cell range B3-C3, so that there is a single line under "2001" and "2002."
7) Make a border around cell range B4-C13, so that there are 2 lines under the scores, "1320" and "1410."
8) Enter the formula in cell B14 to find the average of the 2001 scores.
9) Copy the formula from B14 to C14.
10) Now Save your work 'Freshman SAT Scores'.
 

[Back To Top]

PROJECT 6: EXAM GRADES

 

OBJECTIVE: Students will act if they are a teacher's assistance and practice entering data into excel, adjusting column and widths. Also, students will change the numerical format of the data entered and change the font and alignment to make the spreadsheet more presentable.

You are currently a professor's assistant at the University of Rwanda. The class that you are helping to teach just took an exam. The professor asked that you grade the exams and present the grades to him in some kind of organized way. After grading all the papers you decided to make an Excel spreadsheet with the names of the students in the class and their grades.

1) Open an excel spreadsheet
2) Save the document onto a floppy disk as "Exam Grades"
3) In Cell A1 type "Students"
4) From A3 to A11 type in the following names respectively: Jonathan Green, Susan Johnson, Jennifer Smith, Robert Clarke, Julia Robinson, Karen Lee, Albert Peterson, and Rachel Silver.
5) Adjust the width of column A by highlighting everything in that column. Highlight everything in column A by going to cell A1, click on the left mouse button and drag the mouse down to A11. Then click on the Format, then to column and then click on width. Change the width to 13.5.
6) In B1 type "Grades"
7) Type in the following grades: .100, .90, .83, .78, .96, .70, .84, and .74 in cells B3 - B11 respectively.
8) Then highlight cells B3-B11 and click on the Format menu, then cells. Click on the number tab and change the numbers in cells B3-B11 to Percentage.
9) Bold the titles in A1 and B1 using the tool bar.
10) Center "Students" and "Grades" using the tool bar.
11) Save your work as 'Exam Grades'.

[Back To Top]

PROJECT 7: BASKETBALL STATISTICS

 

OBJECTIVE: The objective of this project is to use different methods to align cells, change different font settings and to select nonadjacent cells.

1) Open an Excel Spreadsheet
2) In cell A1 type the title 'College Basketball Statistics'- be sure to the widen the column to accommodate the text
3) Highlight this cell and bold and increase font size to 12- make sure to readjust the column width.
4) In cell A2 type 'School Name' center this within the cell using the shortcut toolbar.
5) From cells A3 through A6 type the following school names: 'Univ. of Maryland' 'Clemson' 'NC State' 'Duke'
6) Make the text of the 'Univ. of Maryland' the color red by using the Format button on the toolbar, selecting font and choosing the color red
7) Make the text of 'Clemson' the color orange
8) Make the text of 'NC State' the color black
9) Make the text of 'Duke' the color blue
10) Highlight all the school names and bold them.
11) Create a new heading in cell B2 that says 'Point Average' make sure the column is wide enough
12) In cells B3 through B6 type the numbers '78' '70' '77' '80'
13) Highlight all the scores and change the Fonts to "Courier"
14) Now highlight cells A2, B2 and B6 all at the same time. Change them to bold text.
15) Now save your work as 'Basketball Statistics'.

[Back To Top]

PROJECT 8: PEN PAL

 

OBJECTIVE: Create a an e-mail hyperlnk in your docment.

You are sending an important message to your pen pal from Japan, that you have changed your e-mail address. When yo are done save your file as a web page. Follow these steps below to complete your task.

1) Go to the top left corner of the Excel window and click on the "File" menu.
2) Next click on "New" under the file menu.
3) In cell A1 Type in the word "Dear" and then your pen pals name followed by a comma.
4) Next Skip a cell and right click on the next cell with your mouse.
5) Select "Hyperlink" from the menu.
6) In the Hyperlink window select "E-mail Address".
7) Type your e-mail address in the "E-mail Address" field
8) In the "Text to display" field type "Here is my new e-mail address" and click "OK"
9) Go back to "File" and click on "Save as Web Page". Save your file as "penpal.html"

[Back To Top]

PROJECT 9: SCOTT'S SCHEDULE

 

OBJECTIVE: To learn to place borders around cells and shade them.

Scott Schueler just registered for the Spring semester classes for 2003. The online program that makes schedules for students to print out and hang on their walls is broken and Scott will now have to make his on his own. He needs your help in using excel and creating the schedule.

1) Open a blank Excel Spreadsheet
2) In A1 Type the words "Scott's Schedule". Click on A1 and drag it to highlight A1-F1. Click on the merge and center button on the toolbar. Then click on the bold button on the toolbar and change the size of the font to 20.
3) Type in the Days of the school week (Monday, Tuesday, Wednesday, Thursday, Friday) respectively into cells B3, C3, D3, E3, F3. Click on B3 and drag to highlight cells B3-F3. Click on the Bold button, then click on the Format menu above and select Column. Click on Width and change the number to 12. Rehighlight those same 5 cells and click on the center alignment button on the toolbar.
4) Click on A3 and type in the time 8:00am, Click on A6 and type in the time 9:00 AM. Continue filling in the time, for every hour leaving two cells between each hour. Stop at 2:00 PM. You will notice that while the "AM"s dissapear, the "PM"s don't. However by clicking back on anyone of the morning hour cells, you will find that although the "AM"s don't show they are infact still present in the cell data.
5) Scott has decided to use a color coding system to make his schedule easy to read. He is going to shade his class time giving each class a separate color: Math - Red, Science - Blue, Gym - Yellow, History - Orange, and English - Green.
6) Start filling in his schedule by clicking on cell A6 and dragging to highlight A6-A8. Right click on the higlighted cells and click on the option: "Format Cell". Click on the Pattern tab and under the cell shading selection click on the color red to symbolize math class. You have just blocked off Scott's Monday morning math class in red for him. Follow the same steps to color block everyone of scotts classes choosing the color that goes with the corresponding class. Scott has the following schedule: Math Monday and Wednesday from 9:00AM to 10:00AM, Science on Friday from 10:00AM to 11:00AM, Gym on Tuesday and Thursday from 10:00AM to 12:00PM, History on Monday and Wednesday from 10:00AM to 11:00AM, and English on Monday, Wednesday, and Friday from 12:00 PM to 1:00PM.
7) Scott is afraid he might forget the color system he set up so he wants to to label each of the color blocks. In cells B7 and D7 write the word "MATH" then click on those cells individually and click on the bold button on the toolbar as well as the center alignment button. In cells B10 and D10 write the word "HISTORY" and follow the same procedure as for Math. Do the same for each class labeling cells C11 and E11 with "GYM" and cells B16, D16, and F16 with the word "ENGLISH", and cell F10 "SCIENCE".
8) Since some of the colors are so similar Scott has decided to place a border around each class so that each class period is clearly outlined and he won't make a mistake about time. Highlight the first math class column range A6-A8. Right click on the highlighted cells and select the "Format Cell" option. Click on the Border tab and under the Line section select the thickest solid border. Then under the Presets section click on Outline. Click on "OK". Repeat this for each class color block.
9) Now place a thin border around the whole schedule by highlighting the box range A1-G24. Right click on the highlighted cells and choose the "Format Cell" option. Click on the Border tab and Select a thin black line under the Line section. Then under the Presets section select outline.
10) Now Save your work as 'Scotts Schedule'.

 

[Back To Top]

PROJECT 10: ANTARCTICA PENGUINS

 

OBJECTIVE: To practice formatting an excel sheet, and adding a hyperlink.

FILE NEEDED: Excel Project Data 10

1) Open file named " ExcProj10Data.xls"
2) Merge and center cell range A1 - D1.
3) Make the font of the title size and "Garamond" 12.
4) Move cell range A4 - B15 to cells B3 - C14.
5) Center and bold the words "Year" and "Number."
6) Shade the cell containing the word, "Year" yellow.
7) Shade the cell containing the word, "Number" cyan (light blue).
8) Make a border around the cell range B3 - C14, so that there is a thick black border around the cell range.
9) In cell A17, insert a hyperlink for the site, "http://www.coolantarctica.com," and have the link read, "Click here for information about Antarctica."
10) Now Save your work as 'Antartica Penguins'.

[Back To Top]

PROJECT 11: SCIENCE EXPERIMENT

 

OBJECTIVE: Students will pretend that they are putting together a spreadsheet for a science experiment. They will enter data into a spreadsheets, adjust column and widths, copy nonadjacent cells, changing numerical formats, and making adjustments to the spreadsheet to make it look more presentable.

FILE NEEDED: Excel Project Data 11

Your lab partner in science class had made an excel spreadsheet showing the calculations obtained from the various experiments that was performed. The only problem with the spreadsheet is that it is hard to read; therefore you decided to make adjustments to it, so that it will be easier for the both of you to read.

1) the spreadsheet named "ExcProj11Data.xls"
2) First select the entire column A by clicking on the column header for column A, then pull down the Format Menu, click on column, then width. Delete 8.43 and type 14.
3) Change the width of column B by dragging the border of column B to 25.
4) Center align “Calculation 1” in cell B1, by clicking on Format, Cells, Alignment, and click under “Horizontal,” scroll down to center across selection and then hit enter.
5) Change “Calculations 1” in cell B1 to “Calculation 1 in Fractions.”
6) Change the numbers in cells B2 - B5 to percentages, by highlighting the area, clicking the right button of the mouse, Format Cells, then click on the Number tab, and under the number category click on Fraction. Change the type to up to two digits.
7) Highlight ranges A2 - A6, then press and hold the control key, right click the mouse button and click on copy.
8) While holding onto the Ctrl button, highlight A8 - A11, then press the right button on the mouse and hit paste.
9) Click on cell B7 and type “Calculation 2 in Fraction.” Calculation 2 in Fractions is a set up for the results that will be collected in the future lab experiments.
10) Bold cells A1 - A6, A8- A11, B1 and B2, by clicking on the Bold button on your tool bar.
11) Now Save your work as 'Science Experiment'.

[Back To Top]

PROJECT 12: UNCLE BOB'S FARM

 

OBJECTIVE: Become more familiar with cell alignments, using the Format button for fonts and selecting nonadjacent ranges.

FILE NEEDED: Excel Project Data 12

1) Open file named as "ExcProj12Data.xls."
2) Merge cell A1 across cells A1 through E1 by selecting it and clicking on the 'Merge and Center' button on the shortcut toolbar.
3) Adjust column A's width to fit all the words in the ranges.
4) Select cells B4, C4, D4, and E4 and Center them using the Format button on the toolbar under the Alignment tab in Cells.
5) Switch to the Font tab and bold cells B4, C4, D4, and E4.
6) Select A1 and change the Font to size 12 and also change the font type to something other then Arial Font.
7) Center the information under the Cows column by selecting cells B5 through B7 and using the shortcut toolbar.
8) Repeat Step 6, but center the information under the Pigs, Sheep and Chicken columns.
9) Highlight cell B6 while pressing the Control button, keep pressing the control button and highlight cells C5, E5, and E7.
10) With these for cells highlighted bold their font using the shortcut toolbar.
11) Now highlight all the remaining ranges including: B5, B7, C6, C7, D5-D7 and E6.
12) With these cells highlighted Italicize their font style.
13) Make the color of the text in cells A5, A6, and A7 green using the Format button on the toolbar.
14) Now save your work as 'Uncle Bob's Farm'.

[Back To Top]

PROJECT 13: COMPUTER TECHNOLOGY

 

OBJECTIVE: Create a more comprehensive web page

1) Go to www.cnet.com search the site for a picture of your favorite computer technology
2) Save the picture you have chosen.
3) Save the web address of the picture
4) Insert the picture in the middle of the document. Then put a blue border around the image.
5) Right click on the image with your mouse.
6) Click on "Hyperlink" in the menu.
7) In the Hyperlink window click on "Existing file or web page".
8) In the Address field insert the web address and click "OK"
9) Go back to "File" and click on "Save as Web Page". Save your file as "comptech.html"
 

[Back To Top]

PROJECT 14: MONEY PROBLEM

 

OBJECTIVE: To learn to use the formula applications of Excel

FILE NEEDED: Excel Project Data 14

Professor Monogal is computing her final class grades for her students for the end of the spring semester of 2003. She needs your help imputing the data and computing the averages of her students and total class average data.

1) Pull up the Excel document labeled " ExcProj14Data.xls".
2) Click on the column A column header to highlight all of column A. Then click on the FORMAT pull down menu above. Select column and then click on width. Change the number in the box to 14 and click on "OK". Repeat the steps for columns B, D, and F changing them to 12. For column C change the number to 20.
3) Click on the Row 2 Row header to highlight all of row 2. Then click on the bold button on the Toolbar above to make all of the words in column 2 bold.
4) Click on cell A2 and Drag to highlight A2-F2. Right click on the highlighted cells and select the option "Format Cells". Click on the border tab of the menu and select the "Outline" button in the menu. Then Click "OK".
5) Click on cell A5 and drag down to highlight A5-A10. Click the bold button on the Toolbar. Then click on the center aligning button on the Tool bar.
6) Input the following banking record transactions into the data chart:


Date Description Amount Deposit
Transaction 1: 3/1 ATM Withdrawl 234
Transaction 2: 3/2 Water Bill 43.65
Transaction 3: 3/3 Deposit 300
Transaction 4: 3/3 Rent 255.87
Transaction 5: 3/4 Cable Bill 45.31
Transaction 6: 3/4 Phone Bill 23.19

7) Click on cell B5 and drag down to highlight B5-B10. Right click on the highlighted cells and Click on the option "Format cells". Click on the Number tab above. Under the area labeled "Type". Select the format that displays the date like 14-Mar. Rehighlight the column range B5-B10 and click on the bold button on the Toolbar and then on the center aligning button.
8) Click on cell D4 and drag to highlight the box range D4 to E10. Right click on the highlighted cells and then on the option "Format cells". Click on the number tab. Under the section labeled category select Currency and then click the "OK" button. You should see the numbers change to dollar amounts with a dollar symbol next to them and rounded to two decimal places. Repeat these steps for cell F4.
9) Complete the last column labeled "Balance" subtracting or adding each of the transactions and format it in the Currency format like the amount and deposit columns. Click on cell F10 containing the final total balance in the account. Press Control C to copy it. Click on F12 and press Control V to paste the information into the cell.
10) In cell D12 input the following formula to sum the total of the Amount column: =D5+D6+D8+D9+D10, The sum of the column should appear once you click off the cell. Write in the equation for E12, using the same format as used for the Amount column. The equation should look like this: =E7.
11) Last highlight row range A3-F3. Right click on the highlighted cells and click on the "Format Cells" option. Click on the Pattern tab and select a light color under the cell shading section. Repeat the same steps shading the row range A12-F12 in the same color.
12) Now Save your work 'Money Problem'.

[Back To Top]

PROJECT 15: TOY SALES

 

OBJECTIVE: To practice formatting an excel sheet, and adding a hyperlink.

FILE NEEDED: Excel Project Data 15

1) Open the file named "ExcProj15Data.xls"
2) Merge and center cell range A1 - D1 by clicking on the Merge and Center button on the toolbar.
3) Rotate the text by clicking the right mouse button, and then selecting "Format Cells."
4) Click the Alignment tab, and in the right side of the dialogue box, where it says, "Orientation," rotate the text 11 degrees.
5) Widen the 1st row so that you can see all of the text.
6) Widen columns B, C, and D so that you can read all the text.
7) Center the cells containing "Year," "Barbie Sales," "Power Rangers Sales," and "Book Sales."
8) Put a border around the cell range A3 to D3.
9) Insert a row after Row 3. All the cells should shift down. In the now blank A4, enter "1994." In B4, enter "225." In C4, enter "300." In D4, enter "550."
10) Copy the cell containing "550" under the "Book Sales" column, and select cell range 6D - 10D, and paste. The entries under "Book Sales" should now all read "550."
11) Center cell range A4 - D10.
12) Select cell range B3 - B10, click on the right mouse button and select "Format Cells." Click the "Pattern" tab, and make the cell color pink.
13) Do the same for cell ranges C3 - C10, and D3 - D10, except make them black and blue respectively.
14) Select cell range C3 - D10, click the right mouse button and select "Format Cells," and then select the "Font" tab. Change the font color to white. This should make the text easier to see.
15) Now Save your work as 'Toy Sales'.

[Back To Top]

 

-GROUP PROJECTS-

 

 

 

PROJECT 16: MY SCHEDULE FOR JUNE

 

OBJECTIVE: Students will create a schedule on excel. They will enter data into a spreadsheet, change numerical formats, widths, heights of columns and rows. Also, they will format their spreadsheet in various ways to make the spreadsheet look more presentable.

June is a very busy month for your. You decide to organize your time by making a schedule for yourself.

1) Open an excel spreadsheet.
2) In cell A2 type in “Dates”.
3) In cells A3 - A7 type in the following dates respectively: June 5, June 10, June 16, and June 27.
4) In B2 type “Events”.
5) Type the following events: Mary’s Birthday, Graduation, Family Picnic, and Job interview in cells B3 - B7 respectively.
6) In C2 type “Time”.
7) In cells C3 - C7 type the following times: 17:00, 15:00, 13:00, 13:30.
8) Highlight cells A3 - A7, pull down the Format menu, click cell, and the number tab. Click on dates and change the date type so that the dates will appear with the month/day.
9) Change the width of column B, by clicking the column header for column B, pull down the Format menu, click on column, and then on auto width.
10) Change the times in cells C3 - C6, by pulling down the Format menu, numbers, time, as the type choose the one with a standard time (12:00 pm).
11) Bold “Date, Events, and Time.”
12) Left align A4 -A7 by pulling down the Format menu, click in Alignment, pull down the horizontal drop down arrow and click on Left.
13) Change the height of row 1 by pulling down the Format menu, click on rows, and the click on height. Change the height to 20.
14) Save your work as "My Schedule for June."

[Back To Top]

PROJECT 17: DOCTORS RECORDS

 

OBJECTIVE: The objective of this project is to apply most of the tasks you have learned in Excel Chapter 2.

FILE NEEDED: Excel Project Data 17

Dr. Milton has records of three different patients. Right now he has their records organized in a dull manner on one spreadsheet in an Excel book. It will be your job to better organize his records. In the end, each patient will be on a different spreadsheet and the records will be presented in a professional looking way. The three sheets are listed below with the different tasks under each of their names

1) Open the file named "ExcProj17Data.xls."
2) To begin adjust all column widths so all the words fit.
3) Highlight cells A12 through E18. This should include Neal and all his information. Click on the Cut command with this highlighted. Switch to Sheet 2 and click in cell A1. Click on the Paste command to transport Neal's information.
4) Repeat step #2 with Omar's information from cell A20 through E26. Paste it on Sheet 3 in cell A1.


SHEET 1
1) Bold the text in cell A1 and change the font to size 12.
2) Bold the text in cell A3 and change the font color to red.
3) Bold and center the cells B4, C4, D4, and E4.
4) Shade cells A5 through A9.
5) Numerically format cells B5 through B9 to be dates in the month of January.
6) Create an outline and inside border around cells B5 through E9.


SHEET 2

7) 7. Bold the text in cell A1 and change the font color to red.
8) Bold and center the cells B2, C2, D2, and E2.
9) Shade cells A3 through A7.
10) Numerically format cells B3 through B7 to be dates in the month of January.
11) Create an outline and inside border around cells B3 through E7.


SHEET 3

12) Bold the text in cell A1 and change the font color to red.
13) Bold and center the cells B2, C2, D2, and E2.
14) Shade cells A3 through A7.
15) Numerically format cells B3 through B7 to be dates in the month of January.
16) Create an outline and inside border around cells B3 through E7.
17) Now save your work as 'Doctors Records'.

[Back To Top]

PROJECT 18: GLOBAL COMPANY

 

OBJECTIVE: Create a hyperlink and save your excel document as a webpage.

FILE NEEDED: global.txt

You work at a global company with offices all over the world. Your boss has some data that he/she wants you to make into a web page and publish it to the web(put on the internet) for other offices around the world to see. In the file "global.txt" you will find the name of a city and country of where an office is located. Next to that name you will find a link to that offices webpage. Put the same information in the file into an excel document, First the location and then the link underneath the location (each at a time! ) remember to skip a space for each office location and link. Save the document as a web page and call it "global_company" put it in a folder called "Publish".

[Back To Top]

PROJECT 19: PROFESSOR MONOGAL

 

OBJECTIVE: To learn to input data and use formulas

FILE NEEDED: Excel Project Data 19

 Professor Monogal is computing her final class grades for her students for the end of the spring semester of 2003. She needs your help imputing the data and computing the averages of her students and total class average data.

1) 1) Open the file labeled "ExcProj19Data.xls"
2) Here are the grades for the Professor's students:

Test 1, Test 2, Final
Graham Drako 85, 78, 87
Elizabeth Heines 92, 94, 93
Lisa Graves 77, 83, 78
Mark Jacobs 91, 90, 92
Chris Staten 82, 83, 92
Sally Martin 94, 95, 90
Mike Satar 77, 79, 76
Kristin Cars 84, 85, 82


3) Click on the column header for column A and click on the format menu above. Select column in the menu and then the option "width". Change the width to 20. Click on the column E column header and pull down the format menu and select column, then width. Change column E width to 12.
4) Enter each of the students names in the format of last name, first name. Starting in cell A5 input one student per cell in the column. Place the names in alphabetical order by last name.
5) Input each of the corresponding test grades for each of the students given the data above.
6) Click on cell A3 and drag to highlight row range A3-E3. Click on the bold button on the toolbar and then click on the center alignment also.
7) Click on cell A14 and type in the words Class Average. Click on the bold button above on the toolbar and then on the center alignment button.
8) Click on cell B14. Input the following formula to calculate the class average: =Average(B5:B12). In cell C14 input the following average formula to compute the class average for the second exam: =Average(C5:C12). Click on cell D14 and input the following average formula to compute the average for the final exam: =Average(D5:D12).
9) Each of the class exams have a weight to them counting a certain percentage towards the students final grade. In cell A16 type the words "Weight Percentage". In cell B16 and C16 type in 25% and in cell D16 type in 50%.
10) Click on E5 and input the following general formula that can be copied and pasted over again to use to compute the rest of the students averages: =$B$16*B5+$C$16*C5+$D$16*D5. An average number should appear in the box now. Click back on cell E5 and press control C to copy it. Click on cells E6-E12 each individually and press control V to paste the formula into each of the cells. The formula is designed to change the information used to calculate the average to the specific student of the average being calculated. Although average numbers appear, clicking on any of these cells would reveal the formula used to derive that average.
11) Click on cell A3 and drag to highlight row range A3-E3. Right click on the highlighted cells and select "Format Cell". Click on the Pattern tab, and under the cell shading section select a light yellow color. Do the same thing for row range A14-D14, and A16-D16. Go back and highlight each of those ranges again and go once again into the Format Cell menu. This time click on the Borders tab and on the option "Outline".
12) Highlight the box range E1-F18. Right click on the highlighted cells and select the option "Format Cell". Click on the Border tab and select under the Line section the thickest solid black line, then click on the outline button under the Presets section. Click on "OK".
13)Now save your work 'Professor Monogal'.

 

[Back To Top]

PROJECT 20: STRAWBERRY SALES

 

OBJECTIVE:To practice working in multiple sheets within the same excel file, copying, cutting and pasting cell ranges, and formatting cells to make the final product look professional.

FILE NEEDED: Excel Project Data 20

The following project is for three people. The first person should following these first set of instructions:

1) Open file named, “Exc2Project1Data.xls.”
2) Change the title simply to “Strawberry Sales (in pounds).”
3) Change the font size of the title to 14.
4) Center and merge cells A1 to E1 by pressing the center and merge button.
5) Change the cell color to red, and the font color to white, by right clicking, and selecting “Format cells.”
6) Insert a row after the 2nd row.
7) In cells B3, C3, and D3, enter the numbers “1980,” “1990,” and “2000,” respectively.

The second person should follow these second set of instructions:

1) Click “Sheet2,” where you will find the strawberry sales for the year 1990.
2) Copy the cell range B3 to B13.
3) Go back to “Sheet1,” and paste into the cell range C4 to C14.
4) Center and bold cell range B3 to D3 by clicking the “Center” button, and the “Bold” button.
5) Change the color of the State names font to dark gray.
6) Change the cell range B4 to D14 font color to pink.
7) In E3, enter the number “2001.” The font should automatically come out bolded and centered. If not, then bold and center it.

The last person should follow these third set of instructions:

1) Click “Sheet3,” where you will find the strawberry sales for the year 1990.
2) Copy the cell range B3 to B13.
3) Go back to “Sheet1,” and paste into the cell range D4 to D14.
4) Select cell range A3 to D14, and change the font size to 12.
5) Change the font name to “Times New Roman.” Adjust column widths so that all text shows, if needed.
6) In cell range E4, enter the formula, “=D4+516.”
7) Copy this formula, and paste it into the cell range, E5 to E14.
8) Change the font in the last column so that it looks like the rest of the entries.

9)Now save your work as 'Strawberry Sales'.

[Back To Top]