by Angelrob09 » Wed Jul 18, 2012 10:19 pm
Attached is a copy of what I have completed for chapter 6 however I did have problems with the following question please assist regarding on how to resolve or example for questions please!
3. Beginning in cell E3, complete the series of substitution values ranging from 300 to 500 in increments of 20 students vertically down column E.
- Steps attempted: click cell, fill editing group, series, column, step I tried 20, 20%, .20, .2 & stop value 500 when I press enter nothing happens.
Please help to info what im doing wrong !!!
4. In cell F2, enter a reference to the total income formula from column C. In cell G2, enter a reference to the total expenses formula from column C. And in cell H2, enter a reference to the balance formula from column C.
- for this question I didn't know where to began !
8. Apply a Red, Accent 2, Lighter 80% fill color to the three cells closest to break-even without creating a deficit.
I know where fills colors are just didn't know how to locate break even pts
13. In cell C34 of the Budget worksheet, use Solver to find the highest balance possible by changing the number of attendees and the ticket price per person. Using the Limitations section of the spreadsheet model, add the following constraints:
Number of attendees
Ticket price per person (this will require two constraints based on the minimum and maximum ticket prices)
I down load solver for changing variable cell you want to enter $A$4$A$4,$A$9 Then im confused about what to do next i think click "add"
Thank you for your time please reply asap