Chapter 1. Range names
Questions answered in this chapter:
I want the total sales in Arizona, California, Montana, New York, and New Jersey. Can I use a formula to compute the total sales in a form such as AZ+CA+MT+NY+NJ instead of SUM(A21:A25) and still get the right answer?
What does a formula such as Average(A:A) do?
What is the difference between a name with workbook scope and one with worksheet scope?
I really am getting to like range names. I have started defining range names for many of the workbooks I have developed at the office. However, the range names do not show up in my formulas. How can I make recently created range names show up in previously created formulas?
How can I paste a list of all range names (and the cells they represent) ...
Get Microsoft Excel 2013: 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.
