Worksheets - Free Excel Practice Online

This free, interactive exercise teaches you Worksheets in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Other Excel Skills track and works right in your browser - no Excel install, no download, and no signup.

Practising Worksheets this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Worksheets lesson

1. In Excel, the entire Excel file is called a workbook, and each of the tabs along the bottom represents a worksheet. In the example below, the active worksheet (the one you're currently viewing) is Sheet4.When you're writing a formula on Sheet4, you can reference cells from other worksheets in your formula.Press Enter to continue.
2. To reference a cell in another sheet, type the sheet name followed by an exclamation point, then the cell letter and number.In the space below, type =Sheet1!A5 to reference cell A5 in worksheet Sheet1.
3. Write a reference to cell B2 in the second sheet.
4. Write a reference to the entire A column in the second worksheet.
5. Use the SUM function to add cell A1 from sheet 1, and cell A1 from sheet 2.
6. Use the MIN function to find the minimum value in column G in sheet 2.
7. Use the UPPER function to convert the contents of cell C5 in sheet 3 to uppercase.
8. Write a reference for the entire row 4 of the Data sheet.
9. Use the SUM function to find the sum of all values in column B of the data tab.
10. Use the MAX function to find the maximum value in column C in sheet 3.

Worksheets practice - FAQ