Posts

Image
BASIC CALCULATIONS IN SPREADSHEET Add and subtract numbers Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can use the formula bar to create them. Add two or more numbers in one cell Click any blank cell, and then type an equal sign (=) to start a formula. After the equal sign, type a few numbers separated by a plus sign (+). For example, 50+10+5+3. Press RETURN . If you use the example numbers, the result is 68. Add numbers using cell references A cell reference combines the column letter and row number, such as A1 or F345. When you use cell references in a formula instead of the cell value, you can change the value without having to change the formula. Type a number, such as 5, in cell C1. Then type another number, such as 3, in D1. In cell E1, type an equal sign (=) to start the formula. After the equal sign, t...
Post a Comment
Read more

Layout and graphics

Image
LAYOUT Layout    - It is a process of planning and arranging graphics or text in a page or book. A good layout should have a balanced make up and alignment of elements. Symmetrical    -There should be equal weights or elements on both sides of the page.   Asymmetrical        -It may be asymmetrical when there is an artistic and different intensity on one side of the page . Text    - the text should be :   -          Legible -           Appropriate font face   -           Left Justified -           Right Justified -           Centered -           Easy to read Image     -Images sh...
Post a Comment
Read more

Mailmerge, Hyperlink and Animation

Image
Mailmerge using an Excel spreadsheet      First, you must prepare and set up data in Excel for mail merge. It is the most important step in mail merge process. Create column names in your spreadsheet match the field names you want to insert in your mail merge. For example, to address readers by their first name in your document, so you’ll need to separate columns for first name, middle initial, last names. It is just like this: After inserting and filling up all the data in columns, you must save it for you to create a mail merge. To start the mail merge, go to Microsoft word and click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.                                            ...
Post a Comment
Read more