Excel Assignment: Beginner Level
Objective:
To learn and practice basic Excel skills, including data entry, formatting, using formulas, and creating charts.
Task 1: Data Entry
- Open a new Excel workbook and create a sheet named
Student Data. - Enter the following table:
| Student Name | Subject | Marks Obtained | Total Marks | Percentage | Grade |
|---|---|---|---|---|---|
| Arun | Mathematics | 88 | 100 | ||
| varun | Science | 75 | 100 | ||
| Monika | English | 92 | 100 | ||
| Shivani | History | 68 | 100 | ||
| Gauri | Geography | 80 | 100 |
Task 2: Formulas
- Calculate the Percentage for each student using the formula:
Percentage = (Marks Obtained / Total Marks) * 100. - Enter the formula in the first row under “Percentage” and apply it to the rest of the rows.
Task 3: Conditional Formatting
- Highlight the Percentage column.
- Use Conditional Formatting to:
- Apply green fill to cells where the percentage is 80% or above.
- Apply yellow fill to cells where the percentage is between 50% and 79%.
- Apply red fill to cells where the percentage is below 50%.
Task 4: Grades
- Use the following criteria to assign Grades:
- A: Percentage >= 90
- B: 80 <= Percentage < 90
- C: 50 <= Percentage < 80
- F: Percentage < 50
- Write an appropriate formula under the “Grade” column and apply it to all rows.
Task 5: Chart Creation
- Create a Bar Chart that compares “Marks Obtained” for all students.
- Add appropriate titles and labels to the chart.
Task 6: Save and Submit
- Save the file as
Excel_Assignment_YourName.xlsx. - Ensure the workbook has the following sheets:
Student Data: Contains the table and calculations.Charts: Contains the chart.
This assignment will help you practice data entry, formulas, formatting, and visualization. Let me know if you’d like me to explain any part in detail! 😊
