TRINITY INTERNATIONAL SS & COLLEGE
Dillibazar Height, Kathmandu, Nepal
LAB WORK #1: Application Package [MS Excel]
(COMPUTER SCIENCE)
SUBMITTED BY: SUBMITTED TO:
NAME: ANKIT ISHAR PRAVEEN KOIRALA
GRADE: XI (MA1) Department of Computer Science
DATE : 2025/08/26
KATHMANDU, NEPAL
2025
1
Table of Contents
S. No. Page No.
1. Acknowledgement I
2. Objectives II
3. Theoretical Background (3-4)
3.1 Chapter Name
3.1.1 Unit Name
4. Work Done (5-8)
4.1 Work Done on Unit Name
4.1 list work here
5. Conclusion (9)
2
II. Objective
1. To understand worksheet, row, column and cell.
2. Enter data into specific cells with different formats.
3. To practice applying formulas and using different functions in a spreadsheet.
4. To understand input data validation in excel.
5. To understand and apply conditional statements (IF , AND, OR )
6. To practice calculating salary sheet using formula, function and conditional statements.
III. Theoretical Background
3
4
IV. Work Done
1. Worksheet, Rows, Columns, and Cells
Open MS Excel and create a new workbook.
Observe that rows are numbered horizontally and columns are labeled
alphabetically.
Identify a cell as the intersection of a row and column (e.g., A1, B2).
A worksheet was opened in MS Excel, and the concept of rows, columns, and
cells was studied. Cells were identified using addresses such as A1 or B2.
2. Entering Data in Cells
Click on any cell and type data (text, numbers, or dates).
Press Enter or Tab to move to the next cell.
Apply formatting (Bold, Italics, Number format, Date format) using the Home tab.
Data was entered into different cells, and various formats such as text, number,
and date were applied.
5
3. Data Validation
Select the cell range where work hours will be entered.
Go to Data → Data Validation.
In “Allow”, choose Whole Number.
Set Minimum = 0 and Maximum = 24.
Test the rule by trying to enter invalid values (e.g., 27).
The Data Validation feature was used to restrict input. A rule was applied so that
working hours could not exceed 24 or be less than 0. Invalid entries were tested
and successfully restricted.
6
4. Applying Formulas and Functions
Start every formula with =.
Practice using:
o =SUM(A1:A10) → adds numbers.
o =AVERAGE(A1:A10) → finds average.
o =MAX(A1:A10) and =MIN(A1:A10) → largest/smallest value.
o =COUNT(A1:A10) → counts numeric entries.
Different formulas and functions such as SUM, AVERAGE, MAX, MIN, and
COUNT were applied to calculate and analyze data. As a result, a employee
salary sheet was created.
7
5. Using Conditional Statements
Apply IF for decision making:
Example: =IF(B2>=40, "Full-time","Part-time").
Apply AND inside IF:
Example: =IF(AND(C2>=1000,D2>=40),"Eligible","Not Eligible").
Apply OR inside IF:
Example: =IF(OR(B2<20,C2<500),"Low","Normal").
Conditional statements were practiced. The IF function was applied to
categorize employees as full-time or part-time. The AND and OR functions were
also combined with IF to check multiple conditions and return logical results.
8
IV. Conclusion
In this lab work, the basic structure of a worksheet was understood and data
was entered into cells using different formats. Data validation was applied to
control incorrect input. Formulas and functions such as SUM, AVERAGE,
MAX, MIN, COUNT, IF, AND, and OR were practiced. Finally, a salary sheet
was prepared where calculations and logical conditions were applied to
determine gross pay and employee status.
In this lab work, the basic structure of a worksheet was understood and data
was entered into cells using different formats. Data validation was applied to
control incorrect input. Formulas and functions such as SUM, AVERAGE,
MAX, MIN, COUNT, IF, AND, and OR were practiced. Finally, a salary sheet
was prepared where calculations and logical conditions were applied to
determine gross pay and employee status
