#relativevsabsolute

THE DEEPER TRUTHS OF EXISTENCE

A big mistake we make is projecting the relative rules of physical reality onto the non physical. They don't apply in the Absolute.

Today we continued to learn and expand our knowledge of Excel and some of the cool and useful features that it offers its users.

The first thing that I learned today was the reason the first cell is clear when you select a multitude of cells at once.  The reason for this is mathematically based -- it is important to know where you are when performing calculations

Example:

5+3

In this situation, the order of operation does not matter as 5+3 and 3+5 give you the same outcome.  However, if you had:

5/3

Here, the order of operation would be very important as 5/3 and 3/5 will give you very different answers. 

The next thing that I learned today was a useful tool called “auto-fill.” This tool is the little plus sign/cross figure that appears in the bottom right hand side of  a cell that appears when you place your cursor there.  By clicking and dragging that downwards, Excel will either do one of two things depending on what is contained within the cell.  

If the value contained within is a “relative” value, excel will copy the cell relative to the row and column we are dragging it towards.  However, if the value is “absolute,” the value within the original cell will remain constant into the next cell.