Formulas
In spreadsheets, formulas process data automatically. It takes data from the specified area of the spreadsheet as input then processes that data, and then displays the output into the new area of the spreadsheet according to where the formula is written. In Excel, we can use formulas simply by typing “=Formula Name(Arguments)” to use predefined Excel formulas. When you write the first few characters of any formula, Excel displays a drop-down menu of formulas that match that character sequence. Some of the commonly used formulas are:
- =SUM(Arg1: Arg2): It is used to find the sum of all the numeric data specified in the given range of numbers.
- =COUNT(Arg1: Arg2): It is used to count all the number of cells(it will count only number) specified in the given range of numbers.
- =MAX(Arg1: Arg2): It is used to find the maximum number from the given range of numbers.
- =MIN(Arg1: Arg2): It is used to find the minimum number from the given range of numbers.
- =TODAY(): It is used to find today’s date.
- =SQRT(Arg1): It is used to find the square root of the specified cell.
For example, you can use the formula to find the average of the integers in column C from row 2 to row 7:
= AVERAGE(D2:D7)
The range of values on which you want to average is defined by D2:D6. The formula is located near the name field on the formula tab.
We wrote =AVERAGE(D2:D6) in cell D9, therefore the average becomes (2 + 3 + 4 + 5 + 6 + 7)/6 = 27/6 = 4.5. So you can quickly create a workbook, work on it, browse through it, and save it in this manner.
What is a spreadsheet?
A Spreadsheet is a computer application that is designed to add, display, analyze, organize, and manipulate data arranged in rows and columns. It is the most popular application for accounting, analytics, data presentation, etc. In other words, spreadsheets are scalable grid-based files that are used to organize data and perform calculations. People all across the world use spreadsheets to create tables for personal and business usage.
You can also use the tool’s features and formulas to help you make sense of your data.
For example – You may track data in a spreadsheet and see sums, differences, multiplication, division, and fill dates automatically, among other things. Microsoft Excel, Google Sheets, Apache Open Office, LibreOffice, etc. are some spreadsheet software. Among all these software, Microsoft Excel is the most commonly used spreadsheet tool and it is available for Windows, macOS, Android, etc.