Scribd
Upload
10 views3 pages

Excel Worksheet Tasks and Chart Assignments

The document outlines three Excel sessions with various tasks to practice functions, formulas, formatting, sorting, filtering, charts and more. Session 1 focuses on student mark sheet tasks. Session 2 covers employee salary calculation and formatting. Session 3 assigns charting tasks using different chart types.

Uploaded by

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

Excel Worksheet Tasks and Chart Assignments

The document outlines three Excel sessions with various tasks to practice functions, formulas, formatting, sorting, filtering, charts and more. Session 1 focuses on student mark sheet tasks. Session 2 covers employee salary calculation and formatting. Session 3 assigns charting tasks using different chart types.

Uploaded by

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

Attempt the following questions:

Session 1

1. Enter 5 numbers horizontally and find their sum using


three different methods.
2. Enter 5 numbers vertically and find their sum using
three different methods.
3. Open an Excel Workbook and create a new worksheet
and rename it as mark sheet.
4. Insert column Acad No.
5. Make row height 20 for all records.
6. Format the headings as shown in the worksheet.
7. All subject marks should be center aligned as given.
8. Calculate total, maximum and minimum marks in each
subject using functions.
9. Calculate the percentage.
10. Calculate the grade using multiple if conditions.
Session 2

1. Prepare the worksheet as shown.


2. Calculate da, hra, and gross, and net sal using
formulae.
Da is 20% of basic
Hra is 10% of basic
Gross = basic+da+hra
Net sal = gross – pf
3. Sort on ename in ascending order.
4. Display only those employees whose net sal is greater
than 5000.
5. Display net sal in red color if net sal is greater than
10,000.
6. Insert a column department after ename and enter the
following departments:
Production, sales, Accounts.
7. Validate the data to be entered in the department
column so that it allows only the above said
8. Find the sub-totals department-wise
Session 3
Assignment on charts:

1. Draw a column chart to display the students marks in


various subjects

2. Draw a 3-D pie chart of student name and total marks

3. Draw a line chart of the students name and individual


subject marks

4. Draw a bar chart to display the same

You might also like