How to Calculate Table Numeric Data in MS Word 2010

How to Calculate Table Numeric Data in MS Word 2010

          You might have asked someone; if MS Word can be used for calculating data; and he said never. That only MS Excel can do it. But that’s far from the truth. MS Word can be used in the calculation of data as far as it is numeric in nature.

          Today, we gonna be talking about how to use a little trick to clear that doubt. This we’ll do by moving step by step; figuring out the right tools, and ways to accomplish it.

          Now let’s move to the main phase of this tutorial taking it step by step with the novice in mind.

Make sure to follow the steps closely and carefully for accuracy and accomplishment.

AIMS:

  • Readers should be able to use MS Word in the generation of table
  • Readers should be able to insert rows and columns in a table
  • Readers should know how to calculate data in a table using simple formula

REQUIREMENT:

  • Table  
  • Numeric Data
  • Basic Mouse & Keyboard skill
     

STEP ONE: CREATE THE DOCUMENT

  • Launch MS Word
  • Create a New Page
  • Setup your page (For steps on how to setup your page, visit our previous post on how to convert word to pdf for tips to achieve that.)
    table-insert-table
    Insert Table
    insert-table-dialog
    insert-table-dialog

 

STEP TWO: CREATE A TABLE

  • Click on INSERT tab
  • Click on TABLE
  • Click on INSERT TABLE to activate the TABLE DIALOG box
  • Click inside the COLUMN and ROW box to enter the numeric value you want
  • Click OK
    data-input
    data-input

STEP TWO: INPUT DATA INTO THE TABLE

  • Click on each CELL and type the data
  • Use TAB key to navigate from cell to cell  

DATA USED FOR THE PURPOSE OF THIS TUTORIAL

QTY ITEMS PRICE TOTAL
5 Biscuit 200.00  
5 Lollipop 400.00  
10 Burger 200.00  
20 Sandwich 50.00  
25 Potato 300.00  
TOTAL      

STEP THREE: CALCULATE THE DATA

Just as in MS EXCEL, Word calculates data based on cell reference or address e.g. A2*C2. Therefore, you should note that each column in MS Word represents an Alphabet namely: A, B, C, D and so on. While the rows are from left to right of the table; 1, 2, 3, 4, 5, 6, etc.

labelling
labelling
identifying-references
identifying cell references

  • Now, place your mouse pointer in the last COLUMN, second ROW and click to have a blinking cursor appear
  • Click on LAYOUT tab
  • Click on FORMULA command (button)
  • FORMULA DIALOG appears
  • Input the cell reference you want to calculate (e.g. {=a2 * c2}) into the FORMULA box. Check the Illustrated Figure
  • Choose format in the NUMBER FORMAT box
  • Click OK to display the result of the calculation.
    calculating-data
    calculating-data

Follow the steps above to complete the remaining cells of the last column. Then the last two cells of the columns C and D, use this formula { =SUM(ABOVE) } to sum up all the numeric values above the active cell.

calculated-data
Completed Calculation

Boom! Your table data has been calculated. Enjoy! Thanks very much for visiting. We’ll be glad to have you back. For latest update, please subscribe by using the subscribe form.

Please follow and like us:

  • Share
Close Menu
Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.
WhatsApp chat