Scribd
Upload
7 views1 page

Using The Table Provided

The document outlines a series of tasks to be performed in Excel, including calculating SUM, MAX, MIN, and AVERAGE scores for students, determining ranks based on average scores, and assigning grades. It also includes instructions for counting students within specific score ranges, extracting exam dates, generating admission numbers, applying conditional formatting, and using data validation. Finally, it suggests creating a graph to compare average scores and explains the best chart type for this comparison.

Uploaded by

machariae513
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views1 page

Using The Table Provided

The document outlines a series of tasks to be performed in Excel, including calculating SUM, MAX, MIN, and AVERAGE scores for students, determining ranks based on average scores, and assigning grades. It also includes instructions for counting students within specific score ranges, extracting exam dates, generating admission numbers, applying conditional formatting, and using data validation. Finally, it suggests creating a graph to compare average scores and explains the best chart type for this comparison.

Uploaded by

machariae513
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

 Using the table provided, find the SUM, MAX, MIN, and AVERAGE of scores for each student

across all subjects using


appropriate Excel formulas.

 From the Average column, find the highest and lowest average scores and state which students achieved them.

 Using Excel formulas, determine the POSITION (rank) of each student based on their Average score, from highest to
lowest.

 Create a grading formula that assigns grades (A, B, C, D, E) based on the Average score, and apply it to all students.

 Using an Excel function, COUNT the number of students who scored:

 below 40

 between 40 and 69

 70 and above

 From the Date column, extract the DAY of the exam date using an Excel formula and display it in a new column.

 Write an Excel formula to automatically generate the Admission Number (e.g., ADM001, ADM002…) when a student
name is entered.

 Apply Conditional Formatting to highlight:

 scores below 20 in red

 scores between 40 and 59 in yellow

 scores 70 and above in green

 Use Data Validation to restrict subject scores so that only values between 0 and 100 can be entered.

 Create a graph (chart) to compare students’ Average scores, and briefly explain which chart type best shows the
comparison and why

You might also like