Excel Fundamentals: practice exercises
These exercises cover the first things every Excel user needs: finding your way around the window, typing data into cells, selecting ranges, filling a series with AutoFill and saving a workbook in the right format. Each task asks for one concrete change in a small sample sheet, so you practice the actual clicks and keystrokes instead of reading about them. Start here if you have never opened a spreadsheet, or use the set as a quick warm-up before moving on to formulas.
23 exercises · level: Beginner
Start with the first task Study the course: Excel Fundamentals →
Showing 23 of 23
Getting to Know Excel
In A4, add the city "Phoenix".
In B4, enter the population of Phoenix: 1600000.
Edit A3 without erasing it: add "New " at the beginning so it reads "New Orleans".
Use the Name Box to jump to cell E10 and type "Done" there.
In B2, enter the number 3.75.
In B3, enter the text "Seattle".
In B4, enter the date September 1, 2026.
In B5, enter the logical value TRUE.
In B6, store the part number 00123 so the zeros are kept.
Working Faster
Copy the quantity 2 from C2 into every row C3:C6.
Drag the total formula from D2 down to D3:D6.
Copy the text "none" from E2 into E3:E6.
In C2:C9, replace "2025" with "2026" in the codes: do what Ctrl+H would, but with a formula.
In D2:D9, replace the first three letters of the code (ART or INV) with "SKU".
In E2:E9, show "yes" if the item name contains "coffee" (in any letter case), otherwise "no".
In H1, count how many names contain "coffee" anywhere, using wildcards.
In H2, count the new items: names that end with a real asterisk.
Project P01
Format the headers A1:H1: bold font and a gray fill.
In C11, total all the month's expenses, then format C2:C11 as currency ($).
In F2:F5, total each category.
In F7, add up the category totals. It should match C11.
In G2:G5, calculate each category's share of the expenses and apply the "%" format.
In I2:I5, write "Over limit" if the total is greater than the limit, otherwise "Within limit".
No exercises match these filters.