Back to topics

Why does copying a formula sometimes change the wrong cell?

A spreadsheet formula can move with its new location or keep pointing to a fixed cell. In A1 notation, dollar signs fix a column, a row, or both. Understanding those choices explains why copying the same calculation across a table can be useful in one case and quietly wrong in another.

8–10 min

Questions you could explore

  • When would fixing only a row or only a column be useful?

Start reading

Ready to try your ideas aloud?

Your topic carries over. Record up to 2½ minutes, depending on your plan.

Computers and AI

Why can a damaged QR code still work?

A scratch or stain does not always stop a QR code from being read. Its stored information includes redundancy, but that does not mean any part of the image can be covered without consequence.

3–5 min

Why can a damaged QR code still work?

Computers and AI3–5 minA scratch or stain does not always stop a QR code from being read. Its stored information includes redundancy, but that does not mean any part of the image can be covered without consequence.

Computers and AI

How does a website name become an internet address?

You remember a website by its name, while the network needs an address for the connection. DNS supplies that translation, sometimes from a saved answer and sometimes by asking other servers.

4–5 min

How does a website name become an internet address?

Computers and AI4–5 minYou remember a website by its name, while the network needs an address for the connection. DNS supplies that translation, sometimes from a saved answer and sometimes by asking other servers.

Computers and AI

Same emoji, different picture

The same emoji can arrive with a different expression or style from the one you saw when sending it. Unicode identifies characters and sequences, while software platforms choose artwork and decide what their versions support.

2–3 min

Same emoji, different picture

Computers and AI2–3 minThe same emoji can arrive with a different expression or style from the one you saw when sending it. Unicode identifies characters and sequences, while software platforms choose artwork and decide what their versions support.

Why does copying a formula sometimes change the wrong cell? | Speech Topic | speaking.app