Based on the image provided, here is the solution to the task.
Analysis of the Task:
The image shows a tutorial on how to link data from one Excel sheet to another.
1.
Source Data: On the left, there is a table on a sheet named "Sheet 1". Cell
B3 contains the value
$2,000 for "Corn Flakes".
2.
Target Data: On the right, there is a table on a sheet named "Sheet 2". Row 3 corresponds to "Corn Flakes".
3.
The Goal: The arrow indicates you need to pull the sales data from Sheet 1 into Sheet 2. Specifically, you need to put the value from Sheet 1, cell B3, into Sheet 2, cell B3.
Step-by-Step Solution:
1.
Identify the target cell: Look at the table on the right (Sheet 2). You need to fill in the Sales column. The first row has a formula `=` already typed in cell
B3 (next to Corn Flakes).
2.
Switch to the source sheet: Click on the tab at the bottom labeled
Sheet 1.
3.
Select the data: Click on cell
B3, which contains the value
$2,000.
4.
Confirm the link: Press
Enter on your keyboard.
What happens:
Excel will automatically write a formula that looks like `=Sheet1!B3` in cell B3 of Sheet 2. This creates a live link. If you change the price of Corn Flakes in Sheet 1, it will automatically update in Sheet 2.
Final Answer:
To link the data, click on cell
B3 in the "Sheet 2" table (where the equals sign is), then click on the tab for
Sheet 1, click on cell
B3 (the $2,000 value), and press
Enter. This creates a formula `=Sheet1!B3` that pulls the data across.
Parent Tip: Review the logic above to help your child master the concept of hyperlink to excel worksheet.
