Microsoft Excel 2016: Data Analysis and Business Modeling

Machine generated contents note: Answers to this chapter's questions
Problems
How can I create named ranges?
Using the Name box to create a range name
Creating named ranges by using the Create From Selection option
Creating range names by using the Define Name option
The Name Manager
Answers to this chapter's questions
Remarks
Syntax of the lookup functions
VLOOKUP syntax
HLOOKUP syntax
Syntax of the INDEX function
Syntax of the MATCH function
Text function syntax
The LEFT function
The RIGHT function
The MID function
The TRIM function
The LEN function
The FIND and SEARCH functions
The REPT function
The CONCATENATE and &​ functions
The REPLACE function
The VALUE function
The UPPER, LOWER, and PROPER functions
The CHAR function
Contents note continued: The CLEAN function
The SUBSTITUTE function
Extracting data by using the Convert Text To Columns Wizard
CUMPRINC and CUMIPMT functions
Answer to this chapter's question
Contents note continued: Problems
Answers to this chapter's question
Handling other constraints
Solving binary and integer programming problems
Why is our model not a linear Solver model?
Understanding the GRG Multistart and Evolutionary Solver engines
How does Solver solve linear model problems?
Contents note continued: How does the GRG Nonlinear engine solve nonlinear optimization models?
How does the Evolutionary Solver engine tackle nonsmooth optimization problems?
Answer to this chapter's questions
Using conditional formatting to highlight each employee's ratings
Using conditional formatting to highlight outliers
Remarks about grouping
Questions answered in this chapter
Filling in the correlation matrix
Using the CORREL function
Relationship between correlation and R-squared
Correlation and regression toward the mean
Problems for Chapters 57 through 59
Problem
Time-series characteristics
Parameter definitions
Initializing Winters method
Contents note continued: Estimating the smoothing constants
The impact of risk on your decision
Confidence interval for mean profit
Contents note continued: Answers to this chapter's questions
Thse back-order case
The lost-sales case
Problems.