This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or
meeting goals.
Give this one a try later!
Solver
Which tool is most effective when comparing the impact of various combinations of
production expenses and new customer acquisition on net sales profit?
Give this one a try later!
Two-variable data table
, What is the keyboard shortcut to open the Paste Name dialog box?
Give this one a try later!
F3
What function would you use to calculate the total number of periods in a loan or
investment?
Give this one a try later!
NPER
A column contains names in uppercase, which is hard to read. Which function displays
the names where the first letter of each word is capitalized?
Give this one a try later!
PROPER
After creating a blank PivotTable, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
Give this one a try later!
meeting goals.
Give this one a try later!
Solver
Which tool is most effective when comparing the impact of various combinations of
production expenses and new customer acquisition on net sales profit?
Give this one a try later!
Two-variable data table
, What is the keyboard shortcut to open the Paste Name dialog box?
Give this one a try later!
F3
What function would you use to calculate the total number of periods in a loan or
investment?
Give this one a try later!
NPER
A column contains names in uppercase, which is hard to read. Which function displays
the names where the first letter of each word is capitalized?
Give this one a try later!
PROPER
After creating a blank PivotTable, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
Give this one a try later!
