I would like to express my deep appreciation and gratitude to my subject teacher Mr. Praveen Koirala for his coinstantaneous help, advice, information and encouragement in this project. I feel immense pleasure to present my lab report after a long work. Besides my effort, the help and guideline given by many others hasn’t been unnoticed. I express my gratitude to all those countless people for the support for me in doing this project. I express my thanks to Trinity International College for it has been a source of the creation of this project and the support, valuable information, resources and guidance give to me to do this project. I am also grateful and indebt of my beloved friends for their immeasurable help, support and encouragement from the beginning to the end of the project without whom this project would not have been a reality. 2. Objective
The main objectives of the lab work are as follows:
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. 3. Theoretical Background 4. Work Done
1. To understand worksheet, row, column and cell.
Worksheet
Row Column 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) 5.Conclusion In conclusion, this lab effectively met the key objectives for understanding and utilizing Microsoft Excel. We began by learning the basics of worksheets, rows, columns, and cells, which established a strong foundation for data entry and organization. We explored how to format data in specific cells and applied various formulas and functions to enhance our data analysis capabilities. Additionally, we practiced using conditional statements (IF, AND, OR) and data validation to ensure data accuracy and integrity.
The lab’s final exercise, calculating a salary sheet, integrated these skills, demonstrating how Excel's features can streamline complex calculations and data management tasks. Overall, the experience underscored Excel's effectiveness as a tool for data organization, analysis, and presentation, emphasizing its importance in both academic and professional settings.
