# Create a data table

> A data table is a spreadsheet inside the board: it stores values and formulas. A plain table is for static text, lists and comparisons without calculations. Choose the right type before you enter a…

Source: https://docs.vectorboard.app/en/data-and-calculations/create-a-data-table/ · DATA AND CALCULATIONS

A data table is a spreadsheet inside the board: it stores values and formulas. A plain table is for static text, lists and comparisons without calculations. Choose the right type before you enter a budget or a task tracker.

![Spanish interface, English formulas](https://assets.vectorboard.app/docs/fig/fig-866.webp)
*Work in your language*

1. Open **Insert**, search for **Data table** and insert it.

![iPad: tables and data](https://assets.vectorboard.app/docs/fig/fig-867.webp)
*Find tables on the touch screen*

2. Give it a unique name, for example `Budget`. That name lets other formulas refer to it.
3. Enter headers and values. Select a cell to edit it, or a range to act on several cells.
4. Type a formula that starts with `=`. If B2 contains quantity and C2 unit price, enter `=B2*C2` in D2.
5. Review the expression in the formula bar and use autocomplete. Extend it to other rows with the fill handle.

![Spreadsheet editing](https://assets.vectorboard.app/docs/fig/fig-868.webp)
*Write formulas with help*

6. Apply number, currency, percentage or date formatting where appropriate.

![Number formats and currencies](https://assets.vectorboard.app/docs/fig/fig-869.webp)
*Show figures correctly*

> **Expected result:** The cell shows a calculated result and the bar keeps the expression. When you change an input, its dependent cells, tables and charts update.

![Data tables, formulas and charts](https://assets.vectorboard.app/docs/fig/fig-870.webp)
*Create and visualize a budget*

> **Important:** Formulas use English function names, TRUE/FALSE, English errors and commas between arguments in both languages. Numbers and dates are displayed according to the regional settings. Switching the interface to Spanish does not translate the formula.