Usually Excel is used for tabulating data and calculating using functions. MS Word also enables you to do this in tables. Here let us see how to handle these data and calculate using functions.
As usual you can use the symbols such as +, –, /, * for addition, subtraction, division and multiplication. Some functions that you can use are as follows:
AVERAGE() gives the average of selected numbers
MIN() returns the least number in the selected numbers
MAX() returns the biggest number in the selected numbers
PRODUCT() returns the sum of multiplication of all the numbers selected.
SUM() returns the sum of all the numbers in the range.
When using these functions you can specify the selected numbers using the range of cells similar to Excel. The columns are named as A, B, C…. etc. The Rows are named as 1, 2, 3….etc. Therefore the top left cell is A1, the adjacent cell horizontally is B1 and so on. The cell below A1 will be A2 and so on. So when specifying the range you can specify as A1:A5 or B1:X1 etc.
No comments:
Post a Comment