Scribd
Upload
5 views1 page

Excel Advanced Worksheet

The document outlines exercises for an advanced Microsoft Excel worksheet, focusing on functions such as MAX, MIN, AVERAGE, and VLOOKUP. It includes tasks for sorting and filtering data, as well as creating charts. Additionally, it contains short questions related to Excel concepts.

Uploaded by

Rahul Dutta
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 views1 page

Excel Advanced Worksheet

The document outlines exercises for an advanced Microsoft Excel worksheet, focusing on functions such as MAX, MIN, AVERAGE, and VLOOKUP. It includes tasks for sorting and filtering data, as well as creating charts. Additionally, it contains short questions related to Excel concepts.

Uploaded by

Rahul Dutta
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

Advanced Microsoft Excel Worksheet

Name: ____________________ Class: ________ Date: __________

Exercise 1: Find Highest and Lowest Marks


Use MAX and MIN formulas.

Exercise 2: Average Marks


Use AVERAGE formula to calculate average marks.

Exercise 3: Sort Data


Sort students by Total Marks (Highest to Lowest).

Exercise 4: Filter Data


Filter students who scored more than 70%.

Exercise 5: Create Chart


Create a bar chart using marks data.

Exercise 6: VLOOKUP Practice


Use VLOOKUP to find marks of a student from a table.

Exercise 7: Short Questions


1. What is a cell in Excel?

2. What is a formula?

3. Difference between workbook and worksheet?

4. What is SUM function?

5. What is a chart?

Teacher's Signature: ____________________

You might also like