Microsoft Excel Assignment - Create a Task Planner with Formatting and Conditional Formatting

« Back

Complete this Microsoft Excel assignment to create a task planner. Learn to format cells, rename sheets, organize assignments, apply conditional formatting, and track progress. Perfect for beginners to enhance their Excel skills.

Excel Sheet Assignment: Task Planner

Download PDF

Open a New Excel Workbook:
- Start by opening a new Excel workbook on your computer. This will provide you with a blank canvas to create your assignment sheet.
Rename the Sheet:
- By default, Excel creates a sheet named “Sheet1.” It’s a good idea to rename it to something more descriptive like “Assignment Sheet.” To do this:
  - Double-click on the sheet name (located at the bottom left corner of the workbook).
  - Type in the new name and press Enter.
Format the Cells:
- Next, format the cells to organize the assignment details, due dates, and status updates. Here’s how:
  - Column A: Assignment Names
  - Column B: Due Dates
  - Column C: Status (e.g., Not Started, In Progress, Completed)
  - You can adjust the column widths as needed.
Enter Assignment Details:
- In the “Assignment Names” column (Column A), list the names of the assignments.
- In the “Due Dates” column (Column B), enter the due dates for each assignment.
- In the “Status” column (Column C), you can use drop-down menus or simply type the status (e.g., “Not Started,” “In Progress,” “Completed”).
Conditional Formatting (Optional):
- To make the assignment sheet visually appealing, consider using conditional formatting:
  - Highlight late assignments in red.
  - Change the cell color based on the status (e.g., green for completed, yellow for in progress).
  - You can access conditional formatting under the “Home” tab in Excel.
Additional Columns (Optional):
- Depending on your needs, you can add more columns:
  - Column D: Points/Grades (if you want to track scores)
  - Column E: Notes (for additional comments or instructions)