Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

1. Introduction to Formulas: Excel’s rea... > When you copy and paste a formula, t...

When you copy and paste a formula, the references shift

This feature of formulas is really useful because you can write just one formula to do a whole lot of different stuff.

image with no caption

It actually would not have taken you long to write three more similar formulas to calculate your share of the meals you bought. But what if, instead of four meals, you’d bought a hundred or a thousand meals? In that case, being able to copy formulas with automatic reference shifting would be a big help.

image with no caption
Long Exercise

Here are summaries of what each of you spent.

Below these three tables on your spreadsheet, write the formulas to answer these questions. Be sure to put text labels in the cells next to each formula to remind you what they mean.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint