Task 1 of 5
On the "Summary" sheet, in B2:B5, add up the sales of the three branches.
Lesson theory
A pharmacy chain keeps each branch's sales on its own sheet and the prices on a "Prices" sheet. On the "Summary" sheet we will gather the total sales, the prices and the revenue.
Tip: a reference to another sheet is written as Sheet!Cell, for example =Boston!B2. For a lookup table, don't forget the $: Prices!$A$2:$B$5.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page