Spread Sheet Model Question
Overview
This material related to only for art college students
Questions
Model question for computer tools spread sheet
1. Prepare a Worksheet for a class of 6 students. The student detail should have the following :
Student Name, Roll Number, Marks in 5 Subjects, Total Marks, Average and Results using MS – Excel
2...Prepare an invoice in Excel with the details such as Item code, name of the item, quantity purchased, rate and amount.
3. .Prepare a electricity bill using Excel for 10 shops. The fields are customer Number, Previous units, Current Units, Total Consumed units and amount. Constraints upto 100 units the charge is Re. 1 per unit. Next 100 units the charge os Rs. 2 per unit for the rest of the units the charge is Rs. 4 per unit.
4.Prepare a spread sheet giving details of marks of ten students in four subjects. Calculate Maximum and Minimum marks in each subject, and for each student Total and Average. Assign Pass or Fail as result. (Two students to get fail marks.)
5. Prepare a Pay bill for five employees with employee number, name and basic pay. Calculate HRA, DA, CCA, Gross Pay, P.F and Net Pay using the following formulas.
HRA = 5% of Basic Pay
DA = 6% of Basic Pay
CCA = 8% of Basic Pay
Gross Pay = Basic Pay + HRA + DA +CCA
PF = 12% of basic pay
N et Pay = Gross Pay – PF
6.From the following data given below calculate the Total and Average marks for each students and find out the maximum and minimum marks in each subject. Assign pass or fail based on the average marks.
|
| Marks | ||
Reg. No | Name | Tamil | English | Accountancy |
52521 | Ramesh | 50 | 25 | 40 |
52522 | Mohan | 80 | 70 | 60 |
52523 | Kala | 70 | 55 | 45 |
52524 | Abirami | 95 | 85 | 90 |
52525 | Kanna | 80 | 75 | 65 |
52526 | Babu | 45 | 55 | 85 |
7.Draw a pie chart to show the pay details of an employee using MS Excel.
8.Construct a work sheet in Excel with the following data.
Emp. No | Basic Pay | D. A | HRA |
1111 | 7000 | 1400 | 400 |
1112 | 8000 | 1600 | 500 |
1113 | 9000 | 1800 | 500 |
1114 | 7500 | 1500 | 400 |
1115 | 9500 | 1900 | 500 |
Calculate Gross Pay and Net Pay
Gross Pay = Basic + DA + HRA
PF = 10 % of Basic Pay
Net Pay = Gross Pay – P. F
9.Draw a suitable chart from the following data
Car Sales | Branch | ||
Trichy | Coimbatore | Chennai | |
TATA | 75 | 80 | 85 |
Maruthi | 56 | 67 | 65 |
Hindustan | 85 | 60 | 75 |
10. Do the following exercise using MS – Excel.
Sales in retail store ( in Rs.) is given
Place 2003 2004 2005
Chennai 3,00,00,000 4,00,00,000 5,00,00,000
Delhi 4,00,00,000 6,00,00,000 5,50,00,000
Calcutta 2,50,00,000 4,00,00,000 4,50,00,000
Create Pie Chart, Bar Chart and line Chart to analyse the performance of the retail outlets in the various cities.
11 Prepare 10 sales details in Excel in the following format.
Sale details for the financial year 2008-2009
S. No Date Party Name Bill Amount
Payment
1 01-04-2008 ABC &Co 12,000.00 Cash
12.Type 5 names their Basic pay is 12,000, 10,000, 8,000 , 7,000 , and 11,000 respectively.
Calculate the following using MS – Excel.
1. DA 10% of Basic pay.
2. HRA 12% of Basic pay.
3. Income Tax 20% of Basic pay.
13.Type the following data in a spread sheet. and find out Total , Average, MAX, MIN.
Roll.no | Name | Accountancy | Introduction to computer | Marketing | Total | Average |
1051 | Anu | 98 | 75 | 80 |
|
|
1052 | Amar | 90 | 72 | 92 |
|
|
1053 | Anitha | 94 | 74 | 75 |
|
|
1054 | Amala | 95 | 79 | 60 |
|
|
1055 | Sumathi | 92 | 80 | 80 |
|
|
1056 | Sunder | 94 | 95 | 90 |
|
|
1057 | Suresh | 80 | 92 | 85 |
|
|
1058 | Ravi | 75 | 76 | 78 |
|
|
1059 | Kanga | 70 | 74 | 80 |
|
|
1060 | Kumar | 75 | 85 | 82 |
|
|
Maximum :
Minimum :