Scribd
Upload
6 views1 page

Mba It Lab Index

The document outlines a series of tasks related to Microsoft Excel, including creating worksheets for sorting data, calculating employee salaries, and representing sales data with bar charts. It also includes demonstrations of statistical and financial functions, as well as advanced data analysis using pivot tables and charts. Additionally, it covers the creation and insertion of records into student, sales, and employee tables.

Uploaded by

ranganadh
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
6 views1 page

Mba It Lab Index

The document outlines a series of tasks related to Microsoft Excel, including creating worksheets for sorting data, calculating employee salaries, and representing sales data with bar charts. It also includes demonstrations of statistical and financial functions, as well as advanced data analysis using pivot tables and charts. Additionally, it covers the creation and insertion of records into student, sales, and employee tables.

Uploaded by

ranganadh
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
You are on page 1/ 1

SNO DATE DESCRIPTION MARKS SIGNATURE

A Introduction to Microsoft Excel


1 Create A MS-Excel Worksheet To
Illustrate Sorting. To Sort The Data:

2 Create Worksheet To Calculate The


Employee Salary
3 Create An Excel Worksheet With Fields As
Roll No, Name, Marks And Percentage And
Calculate The Percentage
4 Create An Excel Worksheet For The
Monthly Sales Of A Product And Also
Represent The Data By Using Bar
Chart
5 Demonstrate Any Two Statistical
Functions Using MS-Excel.
6 Demonstrate Financial Functions Using
MS-Excel.
7 Advanced Data Analysis Using Pivot tables
And Pivot charts
8 Student Table Creation
9 Insert Records Into Student Table
10 Create Table Sales
11 Insert Records Into Sales Table
12 Employee Table Create
13 Insert Records Into Employee Table
INDEX

You might also like