Posts

Showing posts from March, 2019

Basic calculations in Spreadsheet

Image
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, type C1+D1. Press RETURN . If you use the example numbers, the result is 8.

Layout and Graphics

Image
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. 1. Symmetrical: There should be equal weights or elements on both sides of the page. 2. asymmetrical: It may be asymmetrical when there is an artistic and different intensity on one side of the page. 3. text- the text type should be: Legible Appropriate font face Left justified, right justified, or centered The flow of text should be easy to read. 4. image - the image should be: Proportionate Sharp in color With high resolution With appropriate captions 5. proximity and harmony: The elements should be close together and scattered and arranged apart from each other. Elements should not be cluttered and not compete with each other. 6. consistency:  there should be uniformity of theme on each page. 7. image:  Use color to create interest by providing variety in the