Contents
Chapter 1 Basic spreadsheet modeling
Answers to this chapter’s questions
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
Answers to this chapter’s questions
Syntax of the lookup functions
Answers to this chapter’s questions
Answers to this chapter’s questions
Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.