7. ๐งช Practice Exercises - rafageist/book-spreadsheet-basics GitHub Wiki
This section provides hands-on activities to help you apply what youโve learned. You donโt need advanced skills โ just follow each step and try things out!
๐ Exercise 1: Grocery List Total
- Open your spreadsheet tool
- Create a table like this:
Item |
Price |
Quantity |
Bread |
2.50 |
2 |
Milk |
3.00 |
1 |
Apples |
0.75 |
6 |
- Add a Total column:
=Price * Quantity
- Use
SUM()
to calculate the final amount
๐ Exercise 2: Temperature Tracker
- Create a table to track daily temperatures
Day |
Temperature |
Monday |
29 |
Tuesday |
31 |
Wednesday |
28 |
- Use
AVERAGE()
to calculate the weekly average
- Use
MAX()
and MIN()
to find the highest and lowest temperature
๐ Exercise 3: Simple Budget Table
Category |
Amount |
Rent |
300 |
Food |
150 |
Transport |
50 |
Savings |
100 |
- Calculate the total expenses
- Use cell styles to highlight each category
- Create a pie chart to visualize the budget
๐ง Tips
- Donโt worry about making mistakes โ you learn by trying
- Explore the toolbar to format your table and improve presentation
- Save your work and compare with classmates if possible
Next: Mini Projects