Question

The data section called Transaction Growth shows how many boxed sets were sold each month. Keith entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. He notices that all of the values in the range are 1,408, even though more boxed sets than this were sold in some months. Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.

I cant figure out how in the world to change it to make the formula do what I want. I just blasted through Word, PowerPoint, Access and the first 2 parts of Excel in 30 hours, so maybe my brain is fried. any help is wanted!

Answer 1

Please find the complete solution in the attached file.

Step-by-step explanation:

In this question for a complete solution the table file is added please find it.

For this go to cell number O6

In which we modify the formula that is
`=MAX(B6:M6)`

After that, press enter at this value is calculated.

Then copy the formula to
`O7:O10`