Read a Cell Address

Supplied materials

• Paper and pencil; answers may also be spoken or typed.
• All cases, labels, numbers and rules are supplied on this page. No real account, private information or purchase is needed.

Learn the idea

A spreadsheet cell address combines a column label and a row number. Values at nearby addresses can have different meanings. In this paper sheet A contains item labels and B contains counts; row 1 is the heading and rows 2–4 are data. Cell addresses refer to locations rather than quantities.

Find the specified column and row before interpreting its value. Do not treat the header row as a data count.

Use this supplied case: Value at B2. Sheet: A2=tiles,B2=6; A3=pencils,B3=4; A4=cards,B4=8. What is requested? Use the details in this example. Say which detail helped you choose. This pretend example does not tell us how every real system works.

1. Follow the worked example one step at a time. Say or draw what happens.
2. Find the specified column and row before interpreting its value.
3. Say which detail makes the example answer fit. Pick another answer and say why it does not fit.
4. Try the question and practice questions. Read the rule again if your answer does not match the explanation.

Check your reasoning

Your answer is temporary and is not saved to an account. Download your current answer before leaving or reloading. Written work on paper or in another app stays in your own file.

Take it further

New sheet: A2=books, B2=9; A3=maps, B3=3. Expected: B3=3 and A2=books; distinguish labels from numeric counts.

Nothing here is saved to an account or sent to a teacher. The answer download includes your current choice and any checked feedback. It does not include choices from the separate More practice section. Download that section separately.