Lab 4: Practical Implementation of Spreadsheet
Objective:
The objective of this lab session is to get familiar with spreadsheet software and its
practical applications in data organization, calculations, and visualization using
Microsoft Excel.
Theory:
What is Spreadsheet Software?
Spreadsheet software is a tool used to organize, analyze, and visualize data in a
tabular format. The most popular spreadsheet programs include:
Microsoft Excel (Most widely used, advanced features)
Google Sheets (Cloud-based, collaborative)
Key Features of Spreadsheet Software
1. Cells, Rows, and Columns – Data is stored in cells, arranged in rows
(horizontally) and columns (vertically).
2. Formulas and Functions – Perform calculations automatically (e.g.,
=SUM(A1:A10), =AVERAGE(B1:B5)).
3. Charts and Graphs – Convert data into visual representations like bar
charts, pie charts, and line graphs.
4. Sorting and Filtering – Organize data efficiently by sorting (A-Z, largest to
smallest) or filtering specific data.
5. Conditional Formatting – Highlight specific values based on conditions
(e.g., color-coding high/low values).
Lab Exercises:
Exercise 1: Basic Spreadsheet Operations
1. Open Microsoft Excel and create a new workbook.
2. Enter the following data in the respective cells:
A B C
Subjec Mark
Name
t s
John Math 85
Scienc
Alice 90
e
Bob English 78
Emm
History 88
a
3. Save the file as Student_Marks.xlsx.
Exercise 2: Applying Formulas
A formula is a sequence of values, cell references, and operators that produces a
new value for existing values. It is a mathematical instruction that can be used in
MS Excel to perform calculations.
Rules for using Formula in MS Excel
1. The formula must begin with an equal to sign (=).
2. After inserting formula, press Enter key to confirm it.
3. The formula can include: numeric value, cell address, references, constants,
operators and functions.
Functions in MS Excel
MS Excel supports different types of functions. The Functions are
categorized according to the work they do. Some of the commonly used
functions are discussed below:
1. In cell D2, type =AVERAGE TAB (C2:C5) to calculate the average marks.
2. In cell E2, type =MAX TAB (C2:C5) to find the highest marks.
3. In cell F2, type =MIN TAB (C2:C5) to find the lowest marks.
4. Type = TODAY() to find todays date.
5. Type = NOW() to find the current date/time.
6. Type = COUNT TAB (C2:C5) to return count numbers.
7. Save the file.
Exercise 3: Data Sorting and Filtering
1. Select the entire table (A1:C5).
2. Click on the Data tab and choose Sort.
3. Sort the data in ascending order of Marks.
4. Apply a filter to display only students who scored above 80.
5. Save the updated file.
Exercise 4: Include and remove Borders
1. Select a cell to apply borders.
2. Click on the dropdown arrow of All Borders on the Home tab of cell group.
3. Choose the appropriate line from the Style Palette.
4. You can modify line color and line style.
5. Click OK button.
6. To remove border, click on border tab again by selecting the area to remove,
then click No Border.
Exercise 5: Creating a Chart
1. On the worksheet, arrange the data that you want to plot in a chart.
2. Select the cells that contain the data that you want to use for the chart.
3. On the Insert Tab, in the Charts group, work on with the pie chart, bar-chart.
--------------Place Screenshots of your exercise here--------------------
Conclusion: This lab provided practical experience with Microsoft Excel, enhancing
skills in data organization, analysis, and visualization. I have learned to use
essential functions like AVERAGE, MAX, and MIN, sort and filter data, apply borders,
and create charts. This hands-on approach effectively reinforced the practical
applications of spreadsheet software for real-world data management.