Microsoft Excel Basics - Exercises for Beginners

🧪 Coding Exercises

🟢 Beginner Exercises

1. Rename and Organize Worksheets

Create a workbook with three sheets named “My Data”, “Practice”, and “Summary”. Reorder them so “Summary” comes first and apply tab colors.

Requirements

• Rename sheets.
• Reorder sheet tabs.
• Change tab colors.

Expected Output

# Workbook with three named sheets in the correct order and colors applied

📚 Excel Basics Guide

---

---

2. Enter and Edit Table Data

Create a table with the columns: Name, Age, City, Country. Enter data for 10 fictional people, then edit a few cells.

Requirements

• Add 10 rows of sample data.
• Edit data manually in a few cells.

Expected Output

# A filled table with 10 entries and updated information

📚 Excel Basics Guide

---

---

3. Format Table Headers and Cells

Format the table you created with bold headers, centered text for the Age column, and add borders and colors.

Requirements

• Bold and fill headers.
• Center-align Age column.
• Add borders to the whole table.

Expected Output

# Well-formatted table with styled headers and cells

📚 Excel Basics Guide

---

---

4. Adjust Row Height and Column Width

Adjust the width of Name and City columns, and increase the row height for the header. Use Wrap Text for long text entries.

Requirements

• Adjust column width.
• Change row height.
• Apply Wrap Text.

Expected Output

# Properly spaced and readable table

📚 Excel Basics Guide

---

---

5. Copy, Cut, and Paste Data

Copy the first five rows to another sheet, and move the last two rows to a new position using Cut and Paste.

Requirements

• Use Copy/Paste between sheets.
• Use Cut to rearrange data.

Expected Output

# Data duplicated and rearranged successfully

📚 Excel Basics Guide

---

---

6. Work with Cell Ranges

Select a range of cells in the table and apply borders and a fill color. Check the selected range address in the Name Box.

Requirements

• Select a cell range.
• Format range with borders and color.
• Use the Name Box.

Expected Output

# Visually styled cell range with accurate selection

📚 Excel Basics Guide

---

---

7. Save and Reopen Workbook

Save the workbook as `Excel_Basics_Exercises.xlsx`, close it, and reopen to verify your changes were saved.

Requirements

• Save workbook with a specific name.
• Close and reopen file.

Expected Output

# Workbook opens with all data intact

📚 Excel Basics Guide

---

---

🟡 Intermediate Exercises

🔴 Advanced Exercises