TY  - BOOK
AU  - Winston, Wayne L.
TI  - Microsoft Excel 2016: Data Analysis and Business Modeling
SN  - 9788120353350
U1  - 005.369 
PY  - 2017///
CY  - Delhi
PB  - PHI Learning Private Limited
KW  - Microsoft Excel
KW  - Electronic Spreadsheets
N1  - 

        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
ER  -