Practice entering cells one step at a time
First, look at the completed example and check where each value goes. Select “Clear the table to practice” to enter the example from the beginning. Your entries stay in place when you switch practice goals.
The table above shows the completed example. Change the cell values to update the total.
Completed example and formula to copy
| Cell | What to enter |
|---|---|
| A2 / B2 | Notebook / 120 |
| A3 / B3 | Pen / 80 |
| B4 | =SUM(B2:B3) |
The total is 200. The “:” in the formula means the range from B2 through B3.
Paste it into B4 in Excel and press Enter.
Select Excel cells and enter text and numbers
A2 means column A, row 2
The letters A and B at the top identify columns. The numbers 1, 2, and 3 on the left identify rows. Select A2 to choose where to enter the item name. Type the name in that cell, then move to B2 to enter the amount.
In this practice sheet, clicking an input field gives it a green border. Press Tab to move to the next field on the right, or Shift+Tab to return to the previous field. Enter also moves to the next input field.
Enter amounts as numbers only
Enter “120” in B2 and “80” in B3. Adding a currency unit, such as “120 yen,” prevents this practice sheet from displaying a total. In Excel, you can enter numbers into cells used for calculations and apply number formatting to display units.
Keeping headings in row 1 and data in row 2 onward makes the addition range easier to check. Keep headings and the total row out of the range you are adding.
Use SUM to add B2 and B3
- Select “Add numbers,” then enter 120 in B2 and 80 in B3.
- Enter
=SUM(B2:B3)in the B4 formula field and press Enter. - When the total is 200, select “Check the completed example.”
The opening “=” marks the start of a formula. You can also use =B2+B3 in this exercise to add the same two cells. The tool calculates only supported addition formulas and does not execute your input as program code.
If your formula does not show a total
Check that the formula includes “=” and parentheses, and that the cell references are B2 and B3. This exercise converts full-width letters, numbers, and symbols to their standard-width equivalents before checking them. When using the formula in Excel, copy the standard-width version provided here.
For review, change B2 to 240. If the total becomes 320 without changing the formula, you have checked how calculations refer to cell values.
Save your table and instructions as a CSV
The saved file starts with a table of item names, amounts, and the total. Below it are the formula you entered, a total to check against, and instructions for each cell. If entries are missing or cannot be calculated, the file uses the example values of Notebook 120 and Pen 80. The download message will tell you when this happens.
CSV files do not include borders or colors. Apply formatting after opening the file in Excel, then save it as an Excel workbook if you want to keep that formatting. The generated CSV includes an encoding marker to help software recognize Japanese text.
Practice history and tasks to review
Your check results are saved in this browser.
Clearing your browser’s stored data also deletes this history. It is not shared with other devices or browsers.