Microsoft Excel

Lab Activity 1: Basic Spreadsheet Creation

Task:Create a worksheet showing marks obtained by 5 students in 6 subjects and calculate their Total, Average, and GPA.



Formulas Used:

 Total: =B2+C2+D2+E2+F2+G2

 Average: =H2/6

 GPA (based on average marks):

=IF(I2>90,4,IF(I2>80,3.6,IF(I2>70,3.2,IF(I2>=60,2.8,IF(I2>=50,2.4,IF(I2>=40,2,0)))))) 

Steps:

1. Open Microsoft Excel.

2. Enter the data as shown in the table.

3. Apply formulas for Total, Average, and GPA.

4. Copy formulas down for all students.

5. Format the table using borders, bold headings, and center alignment.


 Lab Activity 2: Using Excel Functions

Task:Find the Highest, Lowest, and Average Total marks.









Formulas Used:

Highest Marks=MAX(B2:B6)

Lowest Marks=MIN(B2:B6)

Average Marks=AVERAGE(B2:B6)


Lab Activity 3: Creating a Chart

Task:Create a Column Chart showing Total marks of each student.




  








Book's Exercise Page number 266---- number 2

a.Create a salary sheet of an organization with field names as: S.no, Name, B salary, Service year, Monthly allowance, Daily allowance, Provident fund, Month salary, Yearly Salary, Monthly tax, Yearly tax, Net yearly income.

A

B

C

D

E

F

G

H

I

J

K

L

S.N

Name

Basic Salary

Service Year

Monthly Allowance

Daily Allowance

Provident Fund

Monthly Salary

Yearly Salary

Monthly Tax

Yearly Tax

Net Yearly Income

  b.Insert 10 data under the fields S.no, Name, Basic Salary, Service year.

 c. Calculate Monthly allowance according to the following condition.

 If service year is greater than 10 years, 10% of Basic Salary, if service year is greater than 5 years,5% of Basic Salary, other wise 0.

=IF(D2>10,0.1*C2,IF(D2>5,0.05*C2,0))

d. Calculate Daily allowance according to the following condition.

If service year is greater than 8 years, 10% of Basic Salary, if service year is greater than 3 years,5 % of Basic Salary, other wise 1% of Basic Salary.

=IF(D2>8,0.1*C2,IF(D2>3,0.05*C2,0.01*C2))

e.Calculate Provident fund according to the following condition.

 If Basic Salary is greater than 50,000, 10,000, if Basic Salary is greater than 30,000, 5000, other wise 2000.

=IF(C2>50000,10000,IF(C2>30000,5000,2000))

 f. Calculate Monthly salary by adding Basic salary, Monthly allowance, Daily allow-ance and Provident fund.

=C2+E2+F2+G2

g Calculate yearly salary.

=H2*12

 h. Calculate monthly tax. (tax=13% of Monthly salary)

=0.13*H2

 i. Calculate yearly tax.

=J2*12

j. Calculate Net yearly income. (yearly salary-yearly tax.)

 =I2-K2

  k. Display the record of Name of staff and their yearly income in the form of Bar graph, and Pie chart.

 

 


Popular posts from this blog

Computer

Grid for SEE class 10 Computer Science  Chapter Very Short Questions( (1 marks each) Short Questions( (2 marks each) Long Questions(4 marks each) Total Computer Fundamentals 6X1=6 (2 QnA, 2TT, 2FF) 5X2=10 (5 QnA) 1X4=4 (Number System) 20 Marks DBMS 2X1=2 (2 QnA) 4X2=8 (4 QnA) - 10 Marks QBASIC 1X1=1 (1 QnA) 3X2=6 (Output, Debug, QnA) 2X4=8 (Sub, Function, File Handling) 15 Marks C- programming 1X1=1 (1 QnA) - 1X4=4   5 Marks Total 10 questions 12 questions 4 questions 50 marks
Read more

Sequential Programs

  Sequential Programs 1.       WAP to display sum of two integer numbers. x = 2 y = 3 result = x+ y print("The sum is:",result)   Output: The sum is: 5   WAP to display sum of two integer numbers given by the user. 1.1 x = int(input("Enter the first number:")) y = int(input("Enter the second number:")) result = x+ y print("The sum is:",result) Output: Enter the first number:2 Enter the second number:3 The sum is: 5  1.2 x = int(input("Enter the first number:")) y = int(input("Enter the second number:")) result = x+ y print(f"The sum of {x} and {y} is: {result}")   Output: Enter the first number:2 Enter the second number:3 The sum of 2 and 3 is: 5 1.3   x = float(input("Enter first number:")) y = float(input("Enter second number: ")) sum = x + y print("The sum of {0} and {1} is {2}".format(x, y, sum))   Output: Enter ...
Read more