I have a spread sheet issue with my homework, trying to figure out what my teacher wants.

Question

anonymous · Answer

Marked yellow.

espex · Answer

Are you asked to write the code for those cells or just have to select the proper one?

anonymous · Answer

if you consider =sum(A7) =max, etc, etc code, then yes.But I dont see what he wants me to do, it doesnt make sense. It doesnt give me the monthly sales.

espex · Answer

The monthly sales are given in the rows of each salesperson.

espex · Answer

Johns, James sales for Jan, Feb, Mar, Apr, are C7,D7,E7, F7 repectively

espex · Answer

respectively I mean. :)

anonymous · Answer

But thats the total money they made. if you look, it give the monthly average to a sales persons sales. not, the highest amount of sales, because we are not given sales, only how much they made. So going off what you stated, would it be, the month, or amount they made in there, " Top " Month?

espex · Answer

Yes.

anonymous · Answer

so, the first would be January, or 115,000 whatever it is?

anonymous · Answer

101,927 *

espex · Answer

That is the highest for James, so then what is his lowest monthly sales?

anonymous · Answer

March, but im saying, would I put the number? or the month?

espex · Answer

The number, most likely if they wanted the month they would have asked "which month had the highest sales", or something like that.

anonymous · Answer

ok, Thanks !

espex · Answer

You're welcome