Scribd
Upload
7 views2 pages

Excel

The document outlines a series of tasks for creating and formatting a Microsoft Excel worksheet titled 'Student Scores'. It includes data entry for student scores in various subjects, formatting instructions, calculations for total and average scores, sorting, conditional formatting, chart creation, and page setup for printing. Each task is assigned a specific mark value, totaling 50 marks.

Uploaded by

addobrown4
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 views2 pages

Excel

The document outlines a series of tasks for creating and formatting a Microsoft Excel worksheet titled 'Student Scores'. It includes data entry for student scores in various subjects, formatting instructions, calculations for total and average scores, sorting, conditional formatting, chart creation, and page setup for printing. Each task is assigned a specific mark value, totaling 50 marks.

Uploaded by

addobrown4
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

Question 1: Creating and Saving Worksheet

Open Microsoft Excel.

Create a new workbook.

Save the file as “Student Scores”.

Question 2: Data Entry (10 marks)

Enter the following data in Sheet1, starting from Cell A1:

Student Name

Maths

English

Science

Ama

65

70

75

Kofi

80

85

78

Yaa

72

68

74

Kojo

90

88

92

Question 3: Formatting Worksheet (10 marks)


Make the heading row bold.

Change the font size of headings to 14.

Apply borders to the entire table.

Center-align all the scores.

Change the background colour of the heading row.

Question 4: Calculations Using Formula (10 marks)

Create a new column titled Total.

Use a formula to calculate the total score for each student.

Create another column titled Average.

Use a formula to calculate the average score for each student.

Question 5: Sorting and Conditional Formatting (5 marks)

Sort the students by Total score in descending order.

Apply conditional formatting to highlight scores above 80.

Question 6: Chart Creation (10 marks)

Create a column chart showing students’ total scores.

Add a chart title: “Students’ Performance”.

Move the chart to a new worksheet.

Question 7: Page Setup and Printing (5 marks)

Set the worksheet to Landscape orientation.

Preview the worksheet before printing.

Save and close Microsoft Excel.

You might also like