Anybody know about Excel, please help, The information about determine the maximum or minimum value of 1 cell?
Friday, July 24, 2009 11:43 | Filled in Homework Help
ஐ♥ღ I love Nicholas Teo ღ♥ஐ asked:
Excel’s Solver tool is an add-in feature that you can install to perform additional analysis activities on your worksheet data. Solver lets you determine the maximum or minimum value of one cell by changing other cells. For example, you could determine the maximum sales you can achieve by changing the value of projected sales on a certain product. Use Excel’s Help system to find more information on the SOlver tool. Then write an essay explaining how a company might use Solver to determine the maximum profit it could obtain by changing various expenditures.
Excel’s Solver tool is an add-in feature that you can install to perform additional analysis activities on your worksheet data. Solver lets you determine the maximum or minimum value of one cell by changing other cells. For example, you could determine the maximum sales you can achieve by changing the value of projected sales on a certain product. Use Excel’s Help system to find more information on the SOlver tool. Then write an essay explaining how a company might use Solver to determine the maximum profit it could obtain by changing various expenditures.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
wyoeng67 says:
July 25th, 2009 at 6:45 am
you can use excel’s solver to find what inputs (variables) cause the highest output. you could use solver to find out what your lowest possible costs and highest profits… or if your profits are a function of several variables that have certain constraints you can use solver to find the maximum profit. id be able to tell you exactly how but i just updated to 2007 and it kinda sucks cuz i have no idea where solver is… stupid microsoft changing everything and forcing me to update to be compatable… time for another beer