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: 

 

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

 

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

 

  1. Highlight the cell A3 – the one with the word ‘fruit’ in it
  2. Now, click on ‘Format’, ‘Cells’, and then the tab marked ‘Patterns’
  3. Underneath the color section, click on the red box
  4. View the sample – make sure that your sample is just plain red
  5. Click ‘OK’
  6. Now, highlight cell A8 – the one with the word ‘vegetables’ in it
  7. Then, go up to the toolbar, and click the down arrow on the fill color button
  8. Click on the green box – it will automatically turn the cell green

 

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

 

  1. Click on cell A1 – the one with Celestine’s full name in it
  2. 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
  3. 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 
  4. With cell A1 still highlighted, click on ‘Format’, ‘Cells’, and then the tab marked ‘Patterns’
  5. Underneath the color section, choose the color blue – in the sample box, all you should see right now is a plain blue box
  6. Now, click on the down arrow next to the patterns box
  7. Select the pattern in the upper right hand corner – polka dots
  8. Now in the sample box, you should see a blue box with small black polka dots inside of it
  9. Click on ‘OK’

 

Your final worksheet should look like this: