Borders, Patterns Shading Exercise:

Setting up your worksheet:

1. Open up an Excel Spreadsheet
2. In cell A1, type in the name Celestine Smith
3. Double click on the upper right hand boundary of column A to fit the cell to Celestine’s name
4. In cell A3, type in the word “fruit” with a colon next to it
5. In cells B3 through B6, type in apples, oranges, pears and plumbs, respectively
6. In cells C3 through C6, give a quantity to each type of fruit – for example: 5 apples, 2 oranges, 6 pears, and 4 plumbs
7. Center all of your above entries – Highlight all cells with words in them, and press the center button on the toolbar
8. In cell A8, type in the word “vegetables” with a colon next to it
9. In cells B8 through B11, type in carrots, peas, squash and lettuce, respectively
10. In cells C8 through C11, give a quantity to each type of vegetable, just as you did for the fruit – for example: 20 carrots, 300 peas, 7 squashes, and 6 heads of lettuce
11. Center all of the vegetable entries – Highlight all cells pertaining to the vegetables, and press the center button on the toolbar

Now, it’s time to put borders around the fruit and vegetable entries:

12. First, highlight the 8 fruit cells, then press and hold the ‘Ctrl’ key while highlighting the 8 vegetable cells.
13. Now, click on ‘Format’, ‘Cells’, and then the tab marked ‘Border’
14. Underneath the ‘Presets’ section, click on the ‘Outline’ button, and then on the ‘Inside’ button
15. For the line style, choose the line sample that is in the left hand column, at the very bottom
16. Click ‘OK’

Now, it’s time to add color to your presentation:

17. Highlight the cell A3 – the one with the word ‘fruit’ in it
18. Now, click on ‘Format’, ‘Cells’, and then the tab marked ‘Patterns’
19. Underneath the color section, click on the red box
20. View the sample – make sure that your sample is just plain red
21. Click ‘OK’
22. Now, highlight cell A8 – the one with the word ‘vegetables’ in it
23. Then, go up to the toolbar, and click the down arrow on the fill color button
24. Click on the green box – it will automatically turn the cell green

Finally, it’s time to emphasize Celestine’s name

25. Click on cell A1 – the one with Celestine’s full name in it
26. Now, make Celestine’s name bigger by clicking on the down arrow next to the font sizes box on the toolbar, and change the size of her name from 10 to 16
27. Once again, you will need to widen the column with Celestine’s name in it, to make the whole thing fit – double click on the upper right hand boundary of cell A1 to accommodate Celestine’s larger name
28. With cell A1 still highlighted, click on ‘Format’, ‘Cells’, and then the tab marked ‘Patterns’
29. Underneath the color section, choose the color blue – in the sample box, all you should see right now is a plain blue box
30. Now, click on the down arrow next to the patterns box
31. Select the pattern in the upper right hand corner – polka dots
32. Now in the sample box, you should see a blue box with small black polka dots inside of it
33. Click on ‘OK’

Your final worksheet should look like this: