Skip to main content

Featured

Golden Rules Of Investment

12 GOLDEN RULES OF INVESTMENT Live by these 12 rules and let your money grow!  1) The past is irrelevant –   Do not rely on past performances and build castles in the air. Invest for tomorrow and live for today.  2) Opinions can hurt. Don’t ask too many people –   just don’t!! To each, his own. What works for someone else, may not work for you and vice-versa. Your investment plan should be as unique as the back of your hand. More importantly, it must suit you best.  3) Everyone’s journey is different. Understand yours. –   Do not invest if you’re not clear on the purpose. Do not draw parallels with other investors. Your need for investing, risk appetite, and nature of investments is of utmost importance. You need to understand what you are doing.  4) Don’t allow your ego to engage with professional advice –   Trust your financial advisor! Google can give you lots of information but your advisor will tell you what’s best for you. Listen and then act!  5) Overthinking will never allow

More About Formulas, Cells & Ranges In Excel

 More about formulas, cels, and ranges

Excel is made up of individual cells that are grouped into rows and columns. Rows are numbered, and columns are lettered. There are over 1 million rows and 16,000 columns, and you can put formulas in any of them. 

Formulas can contain cell references, ranges of cell references, operators, and constants. The following are all examples of formulas:

=A1+B1

=10*20

=SUM(A1:A10)

You'll notice that in our third example above, we used the SUM function. A function is a pre-built command that takes a value or values, calculates them in a certain way, and returns a result. For instance, the SUM function takes the cell references or ranges you specify, and totals them. In this example, it takes cells A1 through A10 and totals them. Excel has over 400 functions which you can explore on the Formulas tab.

Formulas with functions start with an equals sign, then the function name follows with its arguments (the values a function uses to calculate) wrapped in parentheses.

You confirm a formula by pressing Enter. Once you do that the formula will calculate, and the result will be displayed in the cell. To see the formula itself, you can look at the formula bar beneath the Ribbon, or press F2 to enter Edit mode, where you'll see the formula in the cell. Press Enter again to finalize the formula and calculate the result.



Comments

Popular Posts