Formatting

  • Select boxes A6 through E6
  • Right click on the selected boxes and choose Format Cells.
  • Chose the alignment tab
Alignment Tab

  • Under Text Alignment choose Horizontal: Center.
  • Under Text control choose wrap text.
  • Choose the font tab
  • Under Font Style chose bold
  • Choose the boarder tab
  • Select a lower boarder only
Lower Boarder
  • Press OK
  • At this point you should notice that the distance, acceleration, and force cells need to be resized.
  • Click at the top of the column window between B and C you can changed the width of the column so that Distance is on the first line and (m) is on the second.
Column Width
  • Adjust the column with for acceleration too
  • For Force cell put to extra spaces after the word Force.
  • Click on cell A1
  • Select bold and underline from the home menu
Bold and Underline
  • At this point, realizing adjusting column A would make it out of proportion with the table so we will need to move the data from column B to the right and merge certain cells. 
  • Now select B2, B3, and B4
  • Use the cut function
  • Click on C2 and paste the data
  • Select A2 and B2
  • Right click on the selected cells
  • Choose format cells
  • Click on the Alignment Tab
  • Under Text Controls click Merge cells.
  • Press OK
Merge Cells
  • Select A3 and B3
  • Right click on the selected cells
  • Choose format cells
  • Click on the Alignment Tab
  • Under Text Controls click Merge cells.
  • Press OK
  • Select A4 and B4
  • Right click on the selected cells
  • Choose format cells
  • Click on the Alignment Tab
  • Under Text Controls click Merge cells.
  • Press OK
  • Realizing at this point that we have never accounted for the initial position, we need to add the data below the mass line.
  • Right click on the "5" of row 5
  • Select insert
Insert
  • Merge cell A5 and B5
  • In A5 type "Initial Velocity (m/s) -"
  • Expand column B to make everything in the step above fit into A5 and B5
  • In C5 enter "0"
  • For acceleration and force we need to make the 2's an exponent. 
  • Click on D7
  • In the formula bar select the "2"
Formula Bar

  • Expand the font menu
Expand Font Menu

  • In this menu, under effects, choose Superscript.
Superscript

  • Repeat this process to superscript the 2 in cell E7,

  • There is also a need to standardize the decimal value of the cells associated with these calculations.
  • Chose cells B8 through E17.
  • Right click in the selected cells.
  • Choose format
  • Select the number tab.
  • Under "Category" choose "Number"
  • In the middle of this widow make sure the decimal places are marked "2"
  • Click OK
Decimal Spot

  • SAVE YOUR WORK