Please help me with excel Tutorial 7 Case problem 4

[Candy]

I am using the Excel 2007 book and I can not figure out how to complete Tutorial 7 Case Problem 4 Question 5. I am having trouble figuring out how to set up the formulas.

 

[aniketbhanu]

Could you please post the question here?

 

[Candy]

I am new to this site, What exactly do you mean. The question says to create a report on Overall Home Sales based on Sales Price, using figure 7-40 as a guide. But I can not figure out the formulas to use to get the Number sold total, the average sales price, Highest sales price, and Lowest sales price. If I am correct I need to put a formula in for each on.

 

[Hermanito]

we have no idea what book you're talking about, you will need to give more info if you want help.
There are hundreds of Excel books, so be more specific please...

 

[Candy]

It is New Perspectives Microsoft Office Excel 2007 Premium Video Edition, thats all my book says. Sorry for not being very specific, This is my first time to this site.

 

[moonfish]

I am new to this site, What exactly do you mean. The question says to create a report on Overall Home Sales based on Sales Price, using figure 7-40 as a guide. But I can not figure out the formulas to use to get the Number sold total, the average sales price, Highest sales price, and Lowest sales price. If I am correct I need to put a formula in for each on.

Here's an attempt to help you help yourself:
The COUNT() formula allows you to count things, like number of sales.
The SUM() formula allows you to sum the values in a range of cells, like sales values.
The AVERAGE() formula allows you to average the values for a range of cells.
The MAX() formula allows you to find the highest value in a range of cells, like the highest sales price.
The MIN() formula allows you to find the lowest value in a range of cells, like the lowest sales price.

Here's an example spreadsheet, complete with example formulas:

Excel Workbook
	A	B	C	D
1	500.00		count:	6
2	200.00		sum:	2,500.00
3	250.00		average:	416.67
4	1,000.00		max:	1,000.00
5	100.00		min:	100.00
6	450.00
Sheet1

I do not know what figure 7-40 looks like, but I'm guessing you can solve it with the information I gave you.

 

[Hermanito]

Never heard of that one before...

Okay, so now we know what book it is, you will still need to provide us with an exact and complete description of the question they ask and problem you have...

 

[Candy]

The question says insert a new worksheet and then rename the worksheet q5-8 Sales Summary. Create a report on Overall Home Sales based on Sales Price, using figure 7-40 as a guide. But I can not figure out the formulas to use to get the Number sold total, the average sales price, Highest sales price, and Lowest sales price from the home sales data worksheet to the Sales summary worksheet. If I am correct I need to put a formula in for each on.

 

[Michael M]

With respect, it sounds like you need to step back a couple of tutorials and re-cover worksheet functions
Moonfish has given you some examples to meet your current requirements, but have a look at this site for a free download of most of the most frequently used worksheet functions.....with working examples.

http://www.xlfdic.com/

Referring to an Excel Book, doesn't help the posters here, mainly because;
1. there are literally thousands of Excel books on the market
2. While most of them do similar tutorials, they most definitely do them differently
3. The posters here have nothing to do with Microsoft or Excel
(unless they have accreditations for same).
They are volunteers with a desire to help other posters with their problems,
so mentioning a book generally will not help us solve the problem.

Hope this guides you in the right direction, and keep posting if you have more questions / queries