---
title: "The grid practice: 4 exercises with answers | ExcelSavvy"
description: "New to Excel? Practice how cells, rows and columns are named, how to select a range and how to type text and numbers, in small steps."
canonical_url: "https://excelsavvy.com/practice/the-grid"
meta:
  "og:description": "New to Excel? Practice how cells, rows and columns are named, how to select a range and how to type text and numbers, in small steps."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VGhlIGdyaWQgcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~TmV3IHRvIEV4Y2VsPyBQcmFjdGljZSBob3cgY2VsbHMsIHJvd3MgYW5kIGNvbHVtbnMgYXJlIG5hbWVkLCBob3cgdG8gc2VsZWN0IGEgcmFuZ2UgYW5kIGhvdyB0byB0eXBlIHRleHQgYW5kIG51bWJlcnMsIGluIHNtYWxsIHN0ZXBzLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlByaWNlIl19LHsibiI6MiwiY2VsbHMiOlsiQ29mZmVlIiwiNDUiXX0seyJuIjozLCJjZWxscyI6WyJNaWxrIiwiMTIiXX0seyJuIjo0LCJjZWxscyI6WyJCcmVhZCIsIjI4Il19XX19%2Cp_Ii9wcmFjdGljZS90aGUtZ3JpZCI%2Cs_8b2BgDPFtIOxgdBa.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "The grid practice: 4 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VGhlIGdyaWQgcHJhY3RpY2U6IDQgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~TmV3IHRvIEV4Y2VsPyBQcmFjdGljZSBob3cgY2VsbHMsIHJvd3MgYW5kIGNvbHVtbnMgYXJlIG5hbWVkLCBob3cgdG8gc2VsZWN0IGEgcmFuZ2UgYW5kIGhvdyB0byB0eXBlIHRleHQgYW5kIG51bWJlcnMsIGluIHNtYWxsIHN0ZXBzLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSXRlbSIsIlByaWNlIl19LHsibiI6MiwiY2VsbHMiOlsiQ29mZmVlIiwiNDUiXX0seyJuIjozLCJjZWxscyI6WyJNaWxrIiwiMTIiXX0seyJuIjo0LCJjZWxscyI6WyJCcmVhZCIsIjI4Il19XX19%2Cp_Ii9wcmFjdGljZS90aGUtZ3JpZCI%2Cs_8b2BgDPFtIOxgdBa.png"
---

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

# **The grid practice exercises**

New to spreadsheets? Start here. Learn how cells, rows and columns are named, how to select a range and how to type text and numbers, one small step at a time.

[**Start the first exercise**](https://excelsavvy.com/practice/the-grid/welcome)

## **How cells, rows and columns work**

A spreadsheet is a grid. Columns run left to right and are named with letters, rows run top to bottom and are numbered, and every cell has an address made of the two: column first, then row. The cell where column B and row 3 meet is B3. A range is a block of cells, written with a colon between the first and last cell, so A1:C5 is every cell from A1 to C5. This works the same in Excel and Google Sheets.

Type 25 in B2 and 40 in B3, then type `**=B2+B3**` in B4, and the sheet shows 65. The total changes when you change a number. `**=SUM(B2:B3)**` gives the same result using a range.

Text is left-aligned and numbers are right-aligned by default, which is a quick way to spot a number stored as text. Press Enter to confirm what you typed and Esc to cancel it. Be careful with slashes, because Excel may turn 3/5 into a date, Mar 5. The exercises below cover finding your way around the grid, selecting ranges, and typing text and numbers.

1. [**1****Welcome**Get started: see how a lesson works and make your first click in the spreadsheet.](https://excelsavvy.com/practice/the-grid/welcome)
2. [**2****Cells, rows and columns**Find your way around the grid. Click cells by their address and type in one.](https://excelsavvy.com/practice/the-grid/cells-rows-and-columns)
3. [**3****Select a range**Select ranges of cells with the mouse, and learn how a range is written.](https://excelsavvy.com/practice/the-grid/select-a-range)
4. [**4****Type text and numbers**Type a heading, a number and a correction into the sheet.](https://excelsavvy.com/practice/the-grid/type-text-and-numbers)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)

## **Questions**

<details>

<summary>

### What is the difference between a workbook and a worksheet in Excel?

</summary>

A worksheet is one grid of cells, shown as a tab at the bottom of the window. A workbook is the whole Excel file and can hold many worksheets. In Google Sheets the file is called a spreadsheet and the tabs are called sheets. When people say they have an Excel sheet, they usually mean the whole workbook.

</details>

<details>

<summary>

### Why is my number on the left side of the cell?

</summary>

Excel treats it as text, not as a number. Common causes are an apostrophe in front, a space or a symbol typed in with the number, or numbers imported from another system. A small green triangle often shows in the corner of the cell. Retype the number cleanly, and check that the alignment hasn't just been set to left.

</details>

<details>

<summary>

### How many rows and columns does Excel have?

</summary>

A worksheet in current versions of Excel has 1,048,576 rows and 16,384 columns. The columns run from A to XFD, so the last cell is XFD1048576. You will rarely get near that. Press Ctrl+End to jump to the last cell that is actually in use, which tells you how large your data is.

</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/the-grid#webpage","description":"New to Excel? Practice how cells, rows and columns are named, how to select a range and how to type text and numbers, in small steps.","name":"The grid practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/the-grid","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/the-grid#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/the-grid"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/the-grid#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":"The grid practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between a workbook and a worksheet in Excel?","acceptedAnswer":{"@type":"Answer","text":"A worksheet is one grid of cells, shown as a tab at the bottom of the window. A workbook is the whole Excel file and can hold many worksheets. In Google Sheets the file is called a spreadsheet and the tabs are called sheets. When people say they have an Excel sheet, they usually mean the whole workbook."}},{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why is my number on the left side of the cell?","acceptedAnswer":{"@type":"Answer","text":"Excel treats it as text, not as a number. Common causes are an apostrophe in front, a space or a symbol typed in with the number, or numbers imported from another system. A small green triangle often shows in the corner of the cell. Retype the number cleanly, and check that the alignment hasn't just been set to left."}},{"@id":"https://excelsavvy.com/practice/the-grid#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How many rows and columns does Excel have?","acceptedAnswer":{"@type":"Answer","text":"A worksheet in current versions of Excel has 1,048,576 rows and 16,384 columns. The columns run from A to XFD, so the last cell is XFD1048576. You will rarely get near that. Press Ctrl+End to jump to the last cell that is actually in use, which tells you how large your data is."}},{"@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.
