Adjusting Columns and Rows, Formatting Numbers, Changing Alignments and Fonts, and Selecting Nonadjacent Ranges

 

Setting up your worksheet:

 

  1. Open up an Excel worksheet
  2. In cells A2 through A6, type in these names, respectively:  Josephine Smith, Deo Fischer, Sylvie Black, Claudette Louise, and Jean-Philippe Jones
  3. In cells B1 and C1, type in the phrases ‘Hours per Day’ and ‘Salary per Day’, respectively

 

 

Now, you have to change the width of the columns:

 

  1. First, highlight all cells with names in them
  2. Click on ‘Format’, ‘Column’, and then ‘Width’
  3. A box will appear – change the number in the box to 16.57
  4. Click ‘OK’
  5. Now, put your cursor over the top border between columns B and C – click and drag the border until column B can fit all of the text inside of it – it doesn’t matter how wide you go, just as long as all data fits comfortably within the cells
  6. Do the same thing for column C

 

Adding data into the worksheet:

 

  1. In the ‘Hours’ column, input the numbers 2, 4, 3, 6, and 5 – one number in each cell
  2. In the ‘Salary’ column, input the numbers 10, 20, 15, 30, and 25 – one number in each cell

 

Formatting the data:

 

  1. Highlight cells B2 through B6
  2. Now, use the pull down menu – click on ‘Format’, ‘Cells’, and then tab that says ‘Number’
  3. Underneath the ‘Category’ heading, click on the ‘Number’ option – make sure that the amount of decimal places is 2 (the amount can be changed by clicking on the up or down arrows next to the decimal box)
  4. Click ‘OK’
  5. Now, highlight cells C2 through C6
  6. This time, right click with your mouse
  7. Go down to ‘Format Cells’ – the same box will appear as if you used the pull down menu
  8. Click on the tab that says ‘Number’
  9. This time, underneath the category heading, click on the ‘Currency’ option – make sure again that there are only 2 decimal places
  10. Click on ‘OK’

 

Aligning the cells:

 

  1. Highlight cells B1 through B6
  2. Use the pull down menu – click on ‘Format’, ‘Cells’, and then the tab that says ‘Alignment’
  3. Right below the ‘Horizontal’ category, click on the down arrow
  4. Click on the ‘Center’ option
  5. Click ‘OK’
  6. Now, highlight cells C1 through C6
  7. Click on the centering button on the toolbar (centering buttons are located to the right of the B I U icons on the toolbar)

 

Changing the fonts:

 

  1. Highlight all of the cells containing names (A2 through A6)
  2. Use the pull down menu and click on ‘Format’, ‘Cells’, and then the tab that says ‘Font’
  3. Underneath the ‘Font’ category, click on the down arrow, and scroll down until you reach the font ‘Garamond’ (all fonts are listed in alphabetical order) and click on it
  4. Now, under the ‘Size’ category, click on the down arrow until you get to ‘14’ and click on it
  5. Click ‘OK’
  6. You will once again have to adjust the size of column A – the cells should still be highlighted, so click on ‘Format’, ‘Column’, and then ‘Width’
  7. Change the width of the cells to 21
  8. Now, highlight the two category headings (B1 and C1)
  9. Once again, use the pull down menu and click on ‘Format’, ‘Cells’ and then the tab that says ‘Font’
  10. Underneath the ‘Font Style’ heading, click on the ‘Bold’ option
  11. Click on ‘OK’

 

Selecting nonadjacent ranges and changing the color:

 

  1. Now, you want to change the color of both the student’s names and the category headings all at the same time – the first step in doing this is first highlighting the student’s names (cells A2 through A6)
  2. Now, press and hold the ‘Ctrl’ key on your keyboard
  3. Now, highlight the category headings as normal (cells B1 and C1)
  4. Use the pull down menu and click on ‘Format’, ‘Cells’, and then the tab that says ‘Font’
  5. Underneath the ‘Color’ category, click on the down arrow, and then choose the color red
  6. Click ‘OK’

 

Your final worksheet should look like this: