Right click on the selected boxes and choose Format Cells.
Chose the 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
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.
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
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
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
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"
Expand the font menu
In this menu, under effects, choose 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"
