---
title: "First formulas practice: 4 exercises with answers"
description: "Write your first Excel formulas: add and multiply cells and build a formula by clicking, with step-by-step help."
canonical_url: "https://excelsavvy.com/practice/first-formulas"
meta:
  "og:description": "Write your first Excel formulas: add and multiply cells and build a formula by clicking, with step-by-step help."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Rmlyc3QgZm9ybXVsYXMgcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~V3JpdGUgeW91ciBmaXJzdCBFeGNlbCBmb3JtdWxhczogYWRkIGFuZCBtdWx0aXBseSBjZWxscyBhbmQgYnVpbGQgYSBmb3JtdWxhIGJ5IGNsaWNraW5nLCB3aXRoIHN0ZXAtYnktc3RlcCBoZWxwLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlByaWNlIl19LHsibiI6MiwiY2VsbHMiOlsiQ29mZmVlIiwiMzIiXX0seyJuIjozLCJjZWxscyI6WyJDYWtlIiwiMjgiXX0seyJuIjo0LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOlszLDFdfX0%2Cp_Ii9wcmFjdGljZS9maXJzdC1mb3JtdWxhcyI%2Cs_3B1RQM4bWi3nEFIJ.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "First formulas practice: 4 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Rmlyc3QgZm9ybXVsYXMgcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~V3JpdGUgeW91ciBmaXJzdCBFeGNlbCBmb3JtdWxhczogYWRkIGFuZCBtdWx0aXBseSBjZWxscyBhbmQgYnVpbGQgYSBmb3JtdWxhIGJ5IGNsaWNraW5nLCB3aXRoIHN0ZXAtYnktc3RlcCBoZWxwLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlByaWNlIl19LHsibiI6MiwiY2VsbHMiOlsiQ29mZmVlIiwiMzIiXX0seyJuIjozLCJjZWxscyI6WyJDYWtlIiwiMjgiXX0seyJuIjo0LCJjZWxscyI6WyIiLCIiXX1dLCJ0YXJnZXQiOlszLDFdfX0%2Cp_Ii9wcmFjdGljZS9maXJzdC1mb3JtdWxhcyI%2Cs_3B1RQM4bWi3nEFIJ.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **First formulas practice exercises**

A formula is how a spreadsheet does the math for you. Write your first ones here, add, multiply and click cells into a formula, with each idea explained before you try it.

[**Start the first exercise**](https://excelsavvy.com/practice/first-formulas/add-two-cells)

## **How to write a formula in Excel**

A formula is an instruction that tells the spreadsheet to calculate something. It always starts with an equals sign, followed by numbers, cell references and operators: + to add, - to subtract, \* to multiply, / to divide and ^ for powers. A reference like B2 means the formula reads whatever is in that cell, so when the number changes, the result updates by itself.

`**=B2+B3**` adds the price of the coffee in B2 and the price of the cake in B3, and `**=B2*C2**` multiplies the units in B2 by the price in C2. You can type the references or click the cells while you write the formula. Clicking is faster and avoids typos.

Excel does multiplication and division before addition and subtraction, so `**=B2+C2*D2**` multiplies C2 by D2 first. Put the addition in parentheses, `**=(B2+C2)*D2**`, and it happens first. If a formula shows up as text instead of a number, it is missing the equals sign or the cell is formatted as Text. The exercises below cover adding two cells, multiplying quantity by price, clicking cells into a formula and using parentheses.

1. [**1****Add two cells**In B4, write a formula that adds the price of the coffee and the cake.](https://excelsavvy.com/practice/first-formulas/add-two-cells)
2. [**2****Multiply quantity by price**In D2, multiply the number of units by the price.](https://excelsavvy.com/practice/first-formulas/multiply-two-cells)
3. [**3****Click cells into a formula**In B5, add up the visitors for the three weeks by clicking the cells into your formula.](https://excelsavvy.com/practice/first-formulas/click-cells-into-a-formula)
4. [**4****Parentheses change the order**In E2, work out the total: the units plus the bonus units, all times the price. Write (B2+C2)\*D2 with the addition in parentheses, so it happens first.](https://excelsavvy.com/practice/first-formulas/order-of-operations-parentheses)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://excelsavvy.com/learn/excel-keyboard-shortcuts)
- [**Best Excel courses online in 2026: 10 places to learn Excel, ranked**](https://excelsavvy.com/learn/best-places-to-learn-excel)
- [**Udemy vs Coursera vs LinkedIn Learning for Excel: which to pick**](https://excelsavvy.com/learn/udemy-vs-coursera-vs-linkedin-learning-excel)

## **Questions**

<details>

<summary>

### Why does my Excel formula show as text instead of a result?

</summary>

Usually the cell is formatted as Text, or a space or an apostrophe sits in front of the equals sign. Change the format to General, click into the cell and press Enter. Also check that the formula starts with =. A formula that starts any other way is treated as plain text and never calculated.

</details>

<details>

<summary>

### How do I add up a column of numbers in Excel?

</summary>

Use SUM. =SUM(B2:B10) adds every number from B2 to B10. The quickest way on Windows is to select the empty cell under the numbers and press Alt+=, and Excel types the formula for you. You can also write =B2+B3+B4, but that gets slow and error-prone with a long list.

</details>

<details>

<summary>

### How do I copy a formula to the cells below?

</summary>

Select the cell and drag the fill handle, the small square in its bottom-right corner, down over the rows. Double-click the handle to fill as far as the neighboring column has data. Ctrl+D also fills a selection downward. The references move with each row, so =B2\*C2 becomes =B3\*C3 in the next row.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/first-formulas#webpage","description":"Write your first Excel formulas: add and multiply cells and build a formula by clicking, with step-by-step help.","name":"First formulas practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/first-formulas","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/first-formulas#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/first-formulas"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/first-formulas#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"First formulas practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does my Excel formula show as text instead of a result?","acceptedAnswer":{"@type":"Answer","text":"Usually the cell is formatted as Text, or a space or an apostrophe sits in front of the equals sign. Change the format to General, click into the cell and press Enter. Also check that the formula starts with =. A formula that starts any other way is treated as plain text and never calculated."}},{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I add up a column of numbers in Excel?","acceptedAnswer":{"@type":"Answer","text":"Use SUM. =SUM(B2:B10) adds every number from B2 to B10. The quickest way on Windows is to select the empty cell under the numbers and press Alt+=, and Excel types the formula for you. You can also write =B2+B3+B4, but that gets slow and error-prone with a long list."}},{"@id":"https://excelsavvy.com/practice/first-formulas#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I copy a formula to the cells below?","acceptedAnswer":{"@type":"Answer","text":"Select the cell and drag the fill handle, the small square in its bottom-right corner, down over the rows. Double-click the handle to fill as far as the neighboring column has data. Ctrl+D also fills a selection downward. The references move with each row, so =B2*C2 becomes =B3*C3 in the next row."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
