Question

Discuss ideas for when you might use calculations in tables, and when you might be better off creating a document in Excel and pasting it into their Word document.

Answer 1

1.Its better to do calculations in excel rather than doing in tables

2.In excel we can paste the data and we can write the formula there for calculations.

3.In excel the same formula can be used by dragging it until required column.

4.This would reduce the time we will spend by calculating.

5.In some cases like if we want to see the data in capital letters.
In this case it is better to copy the data and use word document to make the change at a once

6.Word document will be useful to do things at a once for whole data.

7.for example consider the following names

robert 9
elbert 10
hans 23
sund 56
siri 78

if we want to concate these two columns then we simply use excel

8.i have used concatenate formula to add these two columns data on column C in excel

=concatenate(A:A,B1)