Chapter 2

Range names

Questions answered in this chapter:

  • I want to sum the 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 range name with workbook scope and one with worksheet scope?

  • 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) into my worksheet?

  • I am computing projected annual revenues as a multiple of last year’s revenue. Is there a way to have the formula look like (1+Growth)*Last Year?

  • For each day of the ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.

Start your free trial