Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Chapter 1. Range Names

• I want to total sales in Arizona, California, Montana, New York, and New Jersey. Can I use a formula to compute 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 like 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 easily select a cell range?

• How can I paste a list of all range names (and the cells they represent) into ...