A chart title linked to a cell

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

A chart title linked to a cell

Name:
Date:
Class:
A

Quick Questions

Shade in the A or B circle for each question.

1. How do you link a chart title to a cell?
A Click the title, type = then click the cell
B Double-click the title and type the cell name as plain text
2. Which title formula joins text with the value in B1?
A ="Sales for "&B1
B ="Sales for "+B1 as plain text
3. A chart title is linked to cell B1, and B1 changes from Maths to Science. What happens to the title?
A It stays showing Maths until you retype it
B It updates to show Science
4. Why would you link a chart title to a drop-down list cell?
A So the title matches the option the user picks
B So the drop-down list can be deleted
5. Which one will NOT make a linked title?
A Typing =Sheet1!B1 in the title bar
B Typing Sales for B1 in the title box
B

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left columnRight column
1="Sales for "&B1 A="Results for "&B1
2=Sheet1!$B$1 BThe fixed text is missing quotation marks, so the formula is invalid. It should be ="Sales for "&B1
3To join fixed text and a drop-down choice in cell B1 into one title, use the & operator CLinks the chart title straight to cell B1, so the title shows exactly what that cell says
4To link a title to a cell, click the chart title, then type = and the cell address in the formula bar DJoins the words Sales for with whatever is in cell B1, so a linked chart title can change when B1 changes
5=Sales for &B1 E=Sheet1!B1
6="Sales for "+B1 FThe + sign is used instead of & to join text, so it gives an error. It should be ="Sales for "&B1
C

Definitions

="Sales for "&B1
D

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
_"Sales for "&B1
2.
="Sales for "_B1
3.
// Drop-down choice is in cell B1 ="Sales for "&__
4.
="Rainfall for "&B1_" this week"
5.
// Selected day is in cell C3 ="Weather for "&__
E

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A B1: Hobart
B D1: ="Rain in "&B1
C Click the chart title
D Type D1 and press Enter
Question 2
A B1: Maths
B Click the chart title once
C Type ="Marks for "+B1
Question 3
A B1: Hobart
B D1: =Rain in &B1
C Select the chart title
D Type =D1 then press Enter
Question 4
A B1: Hobart
B D1: ="Rain in "&B1
C Click the chart title
D Type =Sheet1.D1, press Enter
Question 5
A B1: Year 9
B D1: ="Marks for "&B1
C Click axis, type =D1, Enter

Answer Key

A chart title linked to a cell
Section A: Quick Questions
Q1
A — Click the title, type = then click the cell
Q2
A — ="Sales for "&B1
Q3
B — It updates to show Science
Q4
A — So the title matches the option the user picks
Q5
B — Typing Sales for B1 in the title box
Section B: Match the Pairs
Q1
="Sales for "&B1 → Joins the words Sales for with whatever is in cell B1, so a linked chart title can change when B1 changes
Q2
=Sheet1!$B$1 → Links the chart title straight to cell B1, so the title shows exactly what that cell says
Q3
To join fixed text and a drop-down choice in cell B1 into one title, use the & operator → ="Results for "&B1
Q4
To link a title to a cell, click the chart title, then type = and the cell address in the formula bar → =Sheet1!B1
Q5
=Sales for &B1 → The fixed text is missing quotation marks, so the formula is invalid. It should be ="Sales for "&B1
Q6
="Sales for "+B1 → The + sign is used instead of & to join text, so it gives an error. It should be ="Sales for "&B1
Section C: Definitions
Q1
="Sales for "&B1 — A chart title linked to a cell. Click the title, type = then a cell or text joined with &, and the title updates when the cell changes, such as a drop-down choice.
Section D: Fill in the Blanks
Q1
="Sales for "&B1
Q2
="Sales for "&B1
Q3
// Drop-down choice is in cell B1 ="Sales for "&B1
Q4
="Rainfall for "&B1&" this week"
Q5
// Selected day is in cell C3 ="Weather for "&C3
Section E: Spot the Error
Q1
D — Without the = sign, the chart title shows the plain text D1 and is not linked to the cell. It should be: Type =D1 and press Enter.
Q2
C — Text and a cell are joined with the & operator, not +. Using + gives a #VALUE! error. It should be: Type ="Marks for "&B1
Q3
B — Fixed text in a formula must be wrapped in double quotes. It should be: D1: ="Rain in "&B1
Q4
D — A reference to a cell on a sheet uses an exclamation mark, not a full stop. It should be: Type =Sheet1!D1, press Enter
Q5
C — The link must be made on the chart title. Clicking an axis title or label would link the wrong element. It should be: Click title, type =D1, Enter