Scribd
Upload
5 views2 pages

Excel Practical E1 Update

The document outlines practical Excel tasks involving a table of football players, including calculations for total weight, average height, and maximum weight using Excel functions. It also includes instructions for sorting the table by age, applying conditional formatting, and counting players over 80 kg. Additionally, it provides steps for creating a new worksheet for vehicle sales data, including a pie chart and filtering options.

Uploaded by

andexbornledick
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
5 views2 pages

Excel Practical E1 Update

The document outlines practical Excel tasks involving a table of football players, including calculations for total weight, average height, and maximum weight using Excel functions. It also includes instructions for sorting the table by age, applying conditional formatting, and counting players over 80 kg. Additionally, it provides steps for creating a new worksheet for vehicle sales data, including a pie chart and filtering options.

Uploaded by

andexbornledick
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

BIZZILAND 

EXCEL PRACTICAL E1
1. The table below shows a list of football players perform calculations on their data,
and use Excel functions to analyze and visualize the information.

Page | 1
PLAYER NAME AGE WEIGHT (KG) HEIGHT (M)
JOHN DOE 24 78 1.8
ALEX SMITH 30 85 1.75
MARCUS WHITE 22 75 1.82
LIAM BROWN 27 90 1.9
CHRIS GREEN 25 82 1.78
DAVID BLACK 32 88 1.85
HARRY WILSON 28 80 1.83
TOM CLARK 21 76 1.79

2. Calculate Total Weight

3. Using the SUM function, calculate the total weight of all the players.

4. Calculate Average Height

5. Use the AVERAGE function to find the average height of the players.

6. Find Maximum Weight

7. Use the MAX function to find the heaviest player in the table.

8. Sort the Table by Age
Sort the table in ascending order by the players' age.
9. Conditional Formatting
Apply conditional formatting to highlight players who are over 80 kg in weight.
Page | 2

10. Use COUNTIF to Count Players Over 80kg


Use the COUNTIF function to find how many players weigh more than 80 kg.

11. Create a new worksheet and name VEHICLES SOLD


12. Create a TABLE with the following data
Vehicle make Amount
Tesla 5,000,000
Toyota 7,000,000
Porsche 2,000,000
Mercedes 6,000,000
Volkswagen 2,000,000
13. Create a pie chart to represent the vehicles sold
14. Use Excel's Filter feature to display only Toyota and Tesla
15. Save your Excel file as "EXCEL SHEET DATA and send it to
cybermoja1@[Link].

-END-

You might also like