How to Copy and Paste Formula in MS Word Table?

MS Word allows to use most of the formula like in MS Excel. Because Word do not offer column headings such as A, B, C, D… and row numbers 1, 2, 3,… students gets confused in composing formula. However, you can assume first column and column A, second as column B and so on. Similarly, the first row is numbered 1, second one the 2 and so on.

Therefore if you enter =C2 * D2 formula in E2 cell you’ll get the value as product of the cells in third column second row and fourth column second row.

Now, since we are well accustomed to drag down and fill the succeeding cells in Excel, many are disappointed to not find any way to copy the formula and paste it in other cell that require same calculation.

Because MS Word is focused on word processing and not calculating, it does not have similar and powerful convenience for applying formula. However, we have a workaround so that we can apply same formula to many cells in a Word table.

Lets take an example of a table in MS Word

table example

[Continue reading]

Solved Excel Practical Question from Set 8 Question 3 – Data Validation, Conditional Formatting & Nested IF

Solved Excel Practical Question Set 8 question 3 - Data Validation, Conditional Formatting, Nested IF

Here I present another video solution to Computer Operator Practical Question paper Set 8 Question No 3. The question asked to create a table in Excel and asks us to perform various tasks: Apply Data validation so that users can type exactly 7 … [Continue reading]

Video Solution to Computer Operator Practical Examination Model Set 3 Question B

Solution to excel Practical Question Set 3B

Some time back, I'd created Computer Operator Practical Model Question Papers to help candidates of Computer Operators of Public Service Commission (Lok Sewa Ayog) so that they can realize what kind of question will be asked in their practical … [Continue reading]

Computer Operator Practical Question Paper Set 16

Format Cells Dialog Box

MS Word Create a new document as 'Aug14' and save it with following content:                                                Enter following text and number the lines starting from 10 and with difference 3. On the Insert tab, the … [Continue reading]

Excel Data Validation: How to accept exactly 4 characters (Not Numbers)

Excel Data Validation button menu

This post briefly explains how Excel Data Validation can be used to ensure correct data for worksheet and goes on to show how you can make required cells accept exactly 4 characters (not numbers). What is Data Validation Data validation is the … [Continue reading]

Access: Change Form Control Size, Name, Caption and Alignment

Sizing and Naming MS Access Form Controls

These are basic skills to design Access Forms. You should be able to size the form controls such as text boxes, combo boxes, labels and so on. It will give your form look attractive and professional. But, more importantly, if you know the sizing … [Continue reading]