I'm so confused about cell references!

[laxchica23]

Here are the questions from the textbook that I have been using. Question #1: The sales manager wants to know the expected sales for the first quarter of 1998 if the company raises prices. If the company raises prices, the first quarter sales of '98 should increase 3% from the 4th quarter totals for '97. enter formulas using cell ref. to calculate the total sales for the 1st quarter of '98 for each item if there is a price increase.

[Yogi Anand]

On 2002-04-20 15:51, laxchica23 wrote:
Here are the questions from the textbook that I have been using. Question #1: The sales manager wants to know the expected sales for the first quarter of 1998 if the company raises prices. If the company raises prices, the first quarter sales of '98 should increase 3% from the 4th quarter totals for '97. enter formulas using cell ref. to calculate the total sales for the 1st quarter of '98 for each item if there is a price increase.

Hi laxchica23:
I suggest first thing you do is layout the facets of the problem as you would do manually with pen and paper. Once you know how to do it manually, the next task would be to computerize it.
This would be the best way to learn about cell values, cell references ... relative, absolute, and mixed.
However don't let it overwhelm you ... you are the boss, and the computer is a tool at your command.
So, first figure it out on paper what formulas would be needed, and then post what specific formula you need help with.
Good Luck!