8 Basic Excel Functions Everybody Should Know

Basic Excel Functions

In this article, we will tell you the 8 basic Excel functions. So, without further ado, let’s get started!!

Microsoft Excel is the most widely used app where students and scholars find out their data results. It let its users format, organize and calculate data in a spreadsheet. It displays a large number of boxes called cells (ordered in rows and columns). This app allows you to perform tasks without a calculator or extra work. It has multiple features like graphing tools, pivot tables, calculation or computation capabilities, and a macro programming language (named Visual Basic for Applications). 

Basic Excel Functions Everybody Should Know

Basic Excel Functions

You should be aware of the following functions of Excel, which are stated as under:

1. Add Numbers in Cells: SUM

The first and foremost function is to add numbers in cells in Excel and use the SUM function to make this task done. However, the syntax is SUM(value1, value2,…) where value1 is required and value2 is optional. So, for each argument, use a number, cell reference, or cell range. For example, to add a number in cells (from A2 to A10) then, select the A11 cell, enter the following & press Enter: 

=SUM(A2:A10)

2. Average Numbers in Cells: AVERAGE

Another function is using an AVERAGE function in a cell. Well, The syntax is the same for the AVERAGE function in Excel (as SUM function), AVERAGE(value1, value2,…) with value1 required and value2 optional. For the arguments, you can enter cell references or ranges. For example, to add a number in cells (from A2 to A10) then, select the A11 cell, enter the following & press Enter: 

=AVERAGE(A2:A10)

3. Find the High or Low Value: MIN and MAX

You can find high and low values in a cell by using MIN and MAX functions. Well, The syntax is the same like others, MIN(value1, value2,…) or MAX(value1, value2,…) with value1 required and value2 optional.  For example, to find the minimum or lowest value in a group of cells (from A2 to A10) then, select A11 cell (for low value) & A12 cell (for high value), enter the following & press Enter: 

For low value:

                        =MIN(B2:B10)

For high value:

                        =MAX(B2:B10)

4. Find the Middle Value: MEDIAN

If you want to find the middle value then, use the MEDIAN function. Well,  the syntax is the as others, MEDIAN(value1, value2,…) with 1 argument required and the 2 optional. For example, to find the median in a group of cells (from A2 to A10) then, select the A11 cell, enter the following & press Enter: 

=MEDIAN(A2:A10)

5. Count Cells Containing Numbers: COUNT

If you want to count how many cells in a range contain numbers then, use the COUNT function. Well, the syntax is the same as others, COUNT(value1, value2,…) with the first argument required and the second optional. For example, to count several cells in a group of cells (from A2 to A10) then, select the A11 cell, enter the following & press Enter: 

=COUNT(A1:B10)

6. Insert the Current Date and Time: NOW

If you want to display the current date and time whenever you open your spreadsheet then, use the NOW function. Well, the syntax is NOW() because the function has no required arguments. Also, you can add or remove from the current date and time if you like. However, to return the current date & time, enter the following & press Enter: 

=NOW()

If you want to return the date & time five days in the future from the current date & time, enter this formula and hit Enter:

=NOW()+5

7. Find the Product by Multiplying Cells: PRODUCT

If you want to multiply several cells then, use the PRODUCT function. It is considered more efficient than using the multiplication symbol (*) in a formula. Well, the syntax is PRODUCT(value1, value2,…) with value1 required and value2 optional. You can use value1 for a cell range and value2 for an additional cell range if required. For example, to multiply cells in a group of cells (from A2 to A10) then, select the A11 cell, enter the following & press Enter: 

=PRODUCT(A2:A10)

However, this is much simpler than entering A2 * A3 * A4, and so on. 

8. Eliminate White Space: TRIM

If you want to eliminate space between words or numbers, use the TRIM function. Sometimes, when you paste or import data, it contains extra spaces. Well, the syntax is TRIM(reference) with the argument required for a cell reference containing data. 

To remove extra spaces from cell A1, enter the following and hit Enter:

=TRIM(A1)

Also see: How to Solve Clues 1 and 2 in Steam Summer Sale

However, you will see data in your referenced cell without leading & trailing spaces.

Final Words

That’s it, guys! The above-mentioned details will let you solve the data via different formulae. Well, remember these functions and let your minor errors be resolved. Well, we hope that you liked our article 8 Basic Excel Functions Everybody Should Know. For any queries, do let us know and also, share your reviews in the comment section mentioned below.

Posted by
TechChalks

Admin at Tech Chalks, Love To Share My Experiences With the World of Tech Geeks.

Leave a Reply

Your email address will not be published.