Learn Computer Skills On Desktop Applications

Learn Computer Skills On Desktop Applications

Share

We entertain questions as well as choosing applications randomly to give tips on effective usage.

24/07/2025

Hello fans, sure you have missed this page, we are back and better, just stay tuned and you are in an awesome experience!

11/11/2024

Here Is How To Rename Your Excel Worksheet!

Photos from Learn Computer Skills On Desktop Applications's post 25/10/2024

Do you know you can sum up your values in Microsoft Word table?

Sum a column or row of numbers in a table

To add up a column or row of numbers in a table, use the Formula command.

Click the table cell where you want your result to appear.

On the Layout tab (under Table Tools), click Formula.

The Formula option is highlighted on the Table Tools Layout tab.

In the Formula box, check the text between the parentheses to make sure Word includes the cells you want to sum, and click OK.

The Sum(Above) formula is shown.

=SUM(ABOVE) adds the numbers in the column above the cell you’re in.

=SUM(LEFT) adds the numbers in the row to the left of the cell you’re in.

=SUM(BELOW) adds the numbers in the column below the cell you’re in.

=SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.

Tip: If you change any of the numbers you’re adding, select the sum and press F9 to update the total.

You can use more than one formula in a table. For example, you can add up each row of numbers in the right-hand column, and then you can add up those results at the bottom of the column.

Other formulas for tables
Word includes other functions for tables—for example, AVERAGE and PRODUCT.

Click the table cell where you want your result.

On the Layout tab (under Table Tools), click Formula.

The Formula option is highlighted on the Table Tools Layout tab.

In the Formula box, delete the SUM formula, but keep the equal sign (=). Then click the Paste function box and click the function you want.

The paste functions of a formula are shown from the Table Tools Layout tab.

Between the parentheses, type which table cells you want to include in the formula, and then click OK:

Type ABOVE to include the numbers in the column above the cell you’re in.

Type LEFT to include the numbers in the row to the left of the cell you’re in.

Type BELOW to include the numbers in the column below the cell you’re in.

Type RIGHT to include the numbers in the row to the right of the cell you’re in.

For example, to average numbers in the row to the left of the cell, click AVERAGE and type LEFT:

=AVERAGE(LEFT)

To multiply two numbers, click PRODUCT and type the location of the table cells:

=PRODUCT(ABOVE)

Tip: To include a more specific range of cells in a formula, you can refer to specific cells. Imagine each column in your table has a letter and each row has a number, like in a Microsoft Excel spreadsheet. For example, to multiply the numbers from the second and third columns in the second row, type =PRODUCT(B2:C2).

18/10/2024

How to Create Columns in a New Document

Step 1. Create a new document in your Microsoft Word.

Step 2. Click the Layout tab on the Word’s ribbon at the top.

Step 3. On the Layout tab, in the Page Setup section, click Columns. Then you can see a drop-down menu of columns. They are:

One: This keeps only one column in your document.
Two: Select this option to add two equal-sized columns to your document.
Three: This option adds three columns to your document.
Left: This adds one column to the left of your document.
Right: This adds one column to the right of your document.
select which columns to use

Step 4. When you have selected the column style in your document, start typing and your text will be formatted in the column style.

NB: To add columns to an existing document, just highlight them and follow the steps above.

Want your business to be the top-listed Computer & Electronics Service in Lagos?
Click here to claim your Sponsored Listing.

Telephone

Website

Address

Lagos

Opening Hours

Monday 08:00 - 20:00
Tuesday 08:00 - 20:00
Wednesday 08:00 - 20:00
Thursday 08:00 - 20:00
Friday 08:00 - 20:00
Sunday 10:00 - 17:00