Scribd
Upload
11 views3 pages

? Excel Data Entry Worked Example

The document provides two Excel exercises focused on data entry and calculations. The first exercise involves entering student information and formatting it, while the second requires entering test scores and calculating totals and averages. Both exercises include specific instructions and follow-up questions to reinforce learning.

Uploaded by

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

? Excel Data Entry Worked Example

The document provides two Excel exercises focused on data entry and calculations. The first exercise involves entering student information and formatting it, while the second requires entering test scores and calculating totals and averages. Both exercises include specific instructions and follow-up questions to reinforce learning.

Uploaded by

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

📊 Excel Data Entry Worked Example

Objective:
Practice typing or pasting data into Excel and formatting it neatly.

Instructions:
1.​ Open Microsoft Excel and create a new blank workbook.

2.​ In Row 1, type these column headings:

Name Age Class Favorite Subject

3.​ Copy the data below and paste it into Excel starting from cell A2:

Ada 11 6A Mathematics

Kunle 12 6B English

Tomi 11 6A Science

Chika 12 6C Social Studies

Musa 11 6B Art

4.​ Format the table:


o​ Make the headings (Row 1) bold.

o​ Center-align all the text.

o​ Adjust the column width so all words are visible.

5.​ Save the file as Class [Link].

Follow-up Questions:
1.​ How many pupils are listed in the table?

2.​ Which pupil is in Class 6C?

3.​ What is Tomi’s favorite subject?

4.​ If you wanted to add another pupil, where would you type the new information?
📊 Excel Classwork Exercise
Objective:
Enter student test scores into Excel and calculate their total and average.

Instructions:
1.​ Open a new Excel workbook.

2.​ In Row 1, type these column headings:

Name Mathematics English Science Total Average

3.​ Copy the data below and paste it into Excel starting from cell A2:

Ada 75 80 70

Kunle 60 65 55

Tomi 90 85 95

Chika 50 60 55

Musa 88 92 84

4.​ In the Total column (Column E), calculate each student’s total score by adding
Mathematics, English, and Science.

o​ Example: In cell E2, type:

o​ =B2+C2+D2

5.​ In the Average column (Column F), calculate each student’s average score.

o​ Example: In cell F2, type:

o​ =E2/3

6.​ Format the headings in bold, and adjust the column widths so that all text is
visible.

7.​ Save the file as Class [Link].


Follow-up Questions:
1.​ Who scored the highest total marks?

2.​ Who has the lowest average score?

3.​ What is the class average in Mathematics (hint: use Excel’s AVERAGE function
or highlight the values)?

4.​ If a new student named Bisi scored 78 in Mathematics, 82 in English, and 80 in


Science, what would her total and average be?

You might also like