Spreadsheet Checklist- à Make the following changes by using your toolbars (NOT by right clicking)—you might want to print the checklist before starting, so you can check off each thing as you do it. Directions on how to complete each of the following steps is listed on page 2-3 of this document.
Start the program Microsoft Excel. It will open a new spreadsheet. Save the spreadsheet to your C: drive and name it Summer OlympicsFormat the row height for cells A1-E6 to 15
Format the column width for cells A1-E6 to 20
Put all borders around cells A1-E6
Merge the cells A1-E1, and then type 1988 Summer Olympics Medals into the merged cells.
Bold and center in the title in A1-E1
In B2, type Gold. In C2, type Silver. In D2, type Bronze.
In A3-A6, list these countries in order (one per cell): Switzerland, United States, Spain, Italy
Sort cells A3-A6 in alphabetical (ascending) order
In B3, type how many gold medals each country won: Italy=5, United States=7, Spain=1, Switzerland=2
In C3, type how many silver medals each country won: Italy=2, United States=10, Spain=5, Switzerland=8
In C3, type how many bronze medals each country won: Italy=4, United States=3, Spain=6, Switzerland=1
Find the sum, or total medals won, by Italy. Make the sum show in E3
Find the sum, or total medals won, by Spain. Make the sum show in E4
Find the sum, or total medals won, by Switzerland. Make the sum show in E5
Find the sum, or total medals won, by United States. Make the sum show in E6
Make a 2D Clustered column bar graph/chart showing the number of gold medals won by each country. (cells A2-B6) Drag the bar graph/chart so that it appears under the data chart/table. Make the bars/columns yellow or gold.
Let’s pretend the United States won 2 more gold medals and 3 more silver medals than they actually did. Change the numbers on your data chart to reflect this. Now how many medals did the United States win over all?
Highlight and copy cells D2-D6 and paste the data into cells G2-G6. This data shows how many bronze medals each country won. Sort the data in descending (largest to smallest) order. This will show you the country rankings for the bronze medals.
Clear the contents in cell G2-G6. Once those are clear, remove the border from cells G2-G6 so that there is no border showing.
Save the changes you made to the spreadsheet.
Print one copy of the spreadsheet to turn into your teacher.
Directions for each step:
1. click the start button à click programsàFind the Microsoft Excel program under and click ità click the home tabàclick save asàfind your C: drive on the right side of the box that popped up and click itàtype the name in the file name box
2. Highlight the boxes from A1-E6à click the home tabà find format button and click ità click row heightàtype 15 in the box
3. Highlight the boxes from A1-E6à click the home tabà find format button and click ità click column widthàtype 20 in the box
4. Highlight the boxes from A1-E6à click the home tabàfind the borders button and click the arrow next to itàclick on all borders
5. Highlight cells A1-E1àclick the home tableàclick on the merge and center buttonàdouble click in the cell you just merged (put together as one) and type the title
6. Highlight title in A1-E6àclick the home tab at the top and find the letter B (when you put your cursor over each box, it will tell you what each box is)àclick it one timeà highlight the textà click the button that says center (when you put your cursor over each box, it will tell you what each box is)
6. Double click your mouse on the cell that you want to type in (B2) and type the word. Repeat for cells C2 and D2
7. Double click your mouse on the cell that you want to type in (A3) and type the country. Repeat for cells A4, A5 and A6.
8. Highlight cells A3-A6àclick the home tabàclick the sort and filter buttonàwhen the pop up box pops up, click the sort current selection and click on
9. Double click in cell B3àtype how many gold medals Italy wonà Double click in cell B4àtype how many gold medals Spain wonà Double click in cell B5àtype how many gold medals Switzerland wonà Double click in cell B6àtype how many gold medals United States won
10. Double click in cell C3àtype how many silver medals Italy wonà Double click in cell C4àtype how many silver medals Spain wonà Double click in cell C5àtype how many silver medals Switzerland wonà Double click in cell C6àtype how many silver medals United States won
11. Double click in cell D3àtype how many bronze medals Italy wonà Double click in cell D4àtype how many bronze medals Spain wonà Double click in cell D5àtype how many bronze medals Switzerland wonà Double click in cell D6àtype how many bronze medals United States won
12. Highlight B3-D3àclick the button that looks like an E and says auto sumà the sum of all the number will appear in cell E3
13. Highlight B4-D4àclick the button that looks like an E and says auto sumà the sum of all the number will appear in cell E4
14. Highlight B5-D5àclick the button that looks like an E and says auto sumà the sum of all the number will appear in cell E5
15. Highlight B6-D6àclick the button that looks like an E and says auto sumà the sum of all the number will appear in cell E6
16. Highlight the A2-B6àclick the insert tabàclick the column buttonà put your cursor over each of the 2D options and click the one that says clusteràafter the graph pops up, put your cursor on any of the four corners until you see four arrowsàclick, HOLD down and drag it under the chartàclick inside one of the graphsàclick the format tabàclick shape fillàselect yellow or gold; repeat for the remaining bars/columns
17. Double click in the United States bronze cell (D6)à change the number according to the checklist; repeat this process for the silver column (C6)
18. Highlight column cells D2-D6àclick the home tabàclick the copy buttonàclick one time on the cell G2àclick the paste buttonàclick the very first past button (your data should appear in cells G2-G6)àmake sure cells G2-G6 are highlighted and click the sort and filter button on your toolbaràclick largest to smallest (data will change and be put in order from largest number to smallest number)
19. Highlight your data in cells G2-G6 and press the delete button on your keyboardàyour box will still be highlighted, look for the borders arrow pointing down button on your toolbar and click no border
20. Click the file tabàclick save
21. Click the file tabàclick print