web analytics

Monthly Archives: August 2013

Referring to Cell Range and Explaining the Most Important Functions in Мicrosoft Word 2013

Microsoft Word 2013

When you need to calculate the values in particular table, you can refer to singular cell, set of cells or range of cells. The Word referring cell system uses the A1 Convention where the letters refer to the cell’s column and the numbers refer to the cell’s row. In every particular Word table, the top left cell is referred as A1. You can use this rule for orientation when referring to other cells in the table. There are various Word functions that can use the referring system to address the cells, such as: SUM(), AVERAGE(), PRODUCT(), etc.

Every cell from the table in MS Word 2013 has its own reference by which you can call the cells in the formula.

01 - table

USING POSITIONAL ARGUMENTS IN MS WORD 2013

Microsoft Word 2013

The positional arguments in MS Word helps you to refer to the specific cell range according to the position of the current i.e. selected cell. The applied positional argument determines the direction of the cell’s ranging. The entered positional arguments always calculate the range beginning with the cells that are adjacent to the current cell. You can combine two positional arguments to calculate the cells that are in the same row and column with the current cell.

01 - formula dialogue box

When typing the formula in Formula textbox, you may enter different positional arguments depending on the cells that you want to be calculated. There are four positional arguments:

  • ABOVE
  • BELOW
  • LEFT
  • RIGHT

INSERTING AND UPDATING FORMULAS IN A MS WORD TABLE

Microsoft Word 2013

This article is about using and updating the mathematical formulas in a MS Word Table to literally calculate the values from the cells in the table. The principle of using the formulas is the same as the using the formulas in MS EXCEL. This provides you the possibility to calculate the values within the cells without using third party calculator or some other application. You can target as many cells as you want, and you can select the cell where you will insert the formula. Of course, you can have multiple formula cells.

01 - inserting table

First you need to create a table with numeric data in the cells. To create a table, click the Table icon from the Insert tab and drag the mouse cursor to select an area from the appeared menu with 4 columns and 7 rows i.e. 4×7 Table.

HOW TO CROP AN IMAGE IN MICROSOFT WORD 2010

Microsoft Word 2010

Cropping refers to removing unwanted areas, details or objects from the image.

We use cropping mostly for these several reasons:

  • To remove an unwanted objects or details from a photo;
  • To emphasize a subject, or
  • To improve the overall composition.

This tutorial will show how to crop an image in Word 2010; how to crop an image to a shape and how to add a border to the picture.

How to Crop an Image in Word 2010?

If you want to remove any unwanted parts of the pictures, you have to use the Crop option.

1. After you insert the picture, you need to select it. The Format tab will appear

01 Format

2. Click on Crop in the Crop command