Percentages+in+Excel

In one of the homework #3 requires that you make a absolute reference to a certain cell in order to calculate the percentages of a column of data relative to that cell.

A percentage is a way of expressing a number as a fraction of 100. Percentages are used to express proportion or how large/small one quantity is to another.
 * What is a percentage?**

Generally when you have a set of data with which you want to calculate percentages of to a set data value in one cell you need to specify an absolute reference to that cell so that when you copy and paste the formula to other cells the one specific cell is always referenced and never changed.
 * How do you set absolute references?**

This can easily be done by adding the **$** sign to indicate an absolute reference. For example if you wanted an absolute reference to cell G3. You would use in the formula $G$3 to indicate a absolute reference to cell G3.

In the homework you simply use the formula:
 * How do you calculate it with absolute references in Excel?**

data for which you want the percentage / absolute reference to cell with total

The advantage for using an absolute reference is you can copy and paste the formula with the total cell always referenced.

Here's a Youtube.com link: []