_{Made On Canva}

This is a great opportunity to get to know the spreadsheet well. Because this course is designed for that purpose. With the help of this, our shortcomings will also be filled and we will learn to operate the spreadsheet professionally. I would like to thank the contest organizer for giving us this opportunity to learn from here and apply it.

Spreadsheet

A spreadsheet is a digital tool that consists of columns and rows. and which is used to organize and store data in table format. It is a grid that performs any task from a simple to a complex calculation.

By working on a spreadsheet we can make any of our tasks easy and automated. It has some popular features and some its purposes which I am going to explain below.

Features

Cells:

The union of a column and a row is called a cell. In which we can write different types of data including number text and formulas etc

Rows And Columns:

Horizontal lines defined with numbers are called rows. And the lines labeled with letters are what we call columns. A cell is identified with the combination of these two.

Formulas And Functions:

In the spreadsheet, we use formulas to improve the automatic calculation. On the other hand, functions are predefined formulas that perform specific calculations.

Data Formatting:

User can format their data according to their account. He can align the data according to his calculations. Can give it color can set its font. And can accommodate a variety of number formats.

Charts And Graphs:

Spreadsheet displays our data by converting it into different types of graphs and charts like pie charts etc. Which makes it easier for us to understand.

Data Sorting And Filtering:

In a spreadsheet, we can sort the data in ascending and descending order. And also we can use filters to bring out something specific.

Pivot Tables:

This is a feature that we can use to summarize our various types of large data.

Data Validation:

Data validation refers to the verification of the data in our cells and represents that it meets the specified criteria for which the data is written. And so minimizes his mistakes.

Purpose

We use spreadsheets for a variety of purposes, some of which are listed below:

Financial Planning:

We use spreadsheets for our budgets and our budget forecasting and financial analysis.

Data Analysis:

Business people use spreadsheets to sort their data and summarize their data. In which they analyze correlations and other statistical information.

Project Management:

The spreadsheet we use to track our project progress. Either we use it to manage our schedule or we use it to get help in allocating our resources.

Inventory Tracking:

The spreadsheet we use to manage our inventory. In which we set our schedule. Manage your inventory's stock level and set its cost.

Personal Use:

We also use spreadsheets for ourselves. In which we manage our things, and set our times. Or if we have to create a project then we create a file for it. There are various programs that we use it for.

Here is an example image of my spreadsheet with all features and rows and columns cells all visible.

SUM of Students

I will use the main formula of SUM to apply the SUM function. In this, I will collect the marks of all the students. For the sum, I use the formula of =SUM(B2:B5) which means the sum of B2, B3, B4, and B5.

Average of Students

I will use the main formula of AVERAGE to apply the AVERAGE function. In this, I will collect the average of all the students. For average I use the formula =AVERAGE(B2:B5) which means the average of B2, B3, B4, and B5.

This was the picture of my third task in which I used the colors mentioned in the question. And in each cell, I have used my username and set the format to be easily visible.

For calculating the SUM of all students I just make a table and put the relative information given below:

SUM of Students Marks

Now for calculating the SUM, I use the formula =SUM(B2:E2) which means the sum of B2, C2, D2, and E2.

Average of Students Marks

Now optionally for calculating the AVERAGE, I use the formula =AVERAGE(B2:E2) which means the average of B2, C2, D2, and E2.

Here Is The Final Output

Thank you so much for spending time here. I try my best to complete this task. If you find any mistake then please correct it. Have a nice day.

I invite my friends @muhammad-ahmad, @rumaisha, and @neelofar to join this challenge.

Cc:
@simonnwigwe, @josepha

_{Dated: 09-09-2024 About Me}