• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
WebSetNet

WebSetNet

Technology News

  • Technology News
    • Mobile
    • Games
  • Internet Marketing
  • System Admin
    • Windows 11
    • Linux
    • Mac & Apple
    • Website Scripts
      • Wordpress
You are here: Home / System Admin / Windows 11 / 12 Basic Excel Functions Everybody Should Know

12 Basic Excel Functions Everybody Should Know

February 14, 2022 by Martin6

Microsoft Excel logo on a green background

Microsoft Excel contains many functions that allow you to perform tasks without a calculator or extra work. But if you’re unfamiliar with formulas, it can feel intimidating. Here, we’ve listed 12 simple but useful Excel functions to get you started.

1. Add Numbers in Cells: SUM

One of the most basic things you can do with numbers is add them. Using the SUM function in Excel you can add numbers in cells.

The syntax is SUM(value1, value2,...) where value1 is required and value2 is optional. So for each argument, you can use a number, cell reference, or cell range.

For example, to add the numbers in cells A2 through A10, you would enter the following and press Enter:

=SUM(A2:A10)

You then get your result in the cell containing the formula.

SUM function in Excel

2. Average Numbers in Cells: AVERAGE

Averaging a group of numbers is another common mathematical function.

The syntax is the same for the AVERAGE function in Excel as with the SUM function, AVERAGE(value1, value2,...) with value1 required and value2 optional. You can enter cell references or ranges for the arguments.

To average the numbers in cells A2 through A10, you would enter the following formula and press Enter:

=AVERAGE(A2:A10)

You then get your average in the cell containing the formula.

AVERAGE function in Excel

RELATED: How to Calculate a Weighted Average in Excel

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

When you need to find the minimum or maximum value in a range of cells, you use the MIN and MAX functions.

The syntaxes for these functions are the same as the others, MIN(value1, value2,...) and MAX(value1, value2,...) with value1 required and value2 optional.

To find the minimum, lowest value, in a group of cells, enter the following replacing the cell references with your own. Then, hit Enter:

=MIN(B2:B10)

And to find the maximum, highest value, use:

=MAX(B2:B10)

You’ll then see the smallest or largest value in the cell with the formula.

MIN and MAX functions in Excel

4. Find the Middle Value: MEDIAN

Instead of the minimum or maximum value, you may want the middle one.

As you may have guessed, the syntax is the same, MEDIAN(value1, value2,...) with the first argument required and the second optional.

For the middle value in a range of cells enter the following and press Enter:

=MEDIAN(A2:A10)

You’ll then see the middle number of your cell range.

MEDIAN function in Excel

5. Count Cells Containing Numbers: COUNT

Maybe you’d like to count how many cells in a range contain numbers. For this, you would use the COUNT function.

The syntax is the same as the above two functions, COUNT(value1, value2,...) with the first argument required and the second optional.

To count the number of cells that contain numbers in the range A1 through B10, you would enter the following and press Enter:

=COUNT(A1:B10)

You then get your count in the cell containing the formula.

COUNT function in Excel

RELATED: How to Count Cells in Microsoft Excel

6. Insert the Current Date and Time: NOW

If you’d like to display the current date and time whenever you open your spreadsheet, use the NOW function in Excel.

The syntax is NOW() because the function has no required arguments. You can, however, add or remove from the current date and time if you like.

To return the current date and time, enter the following and press Enter:

=NOW()

To return the date and time five days in the future from the current date and time, enter this formula and hit Enter:

=NOW()+5

And here’s how the results would look for each of the above formulas.

NOW function in Excel

7. Round to a Certain Number of Digits: ROUND

If you have decimal numbers in your sheet that you want to round up or down, use the ROUND function in Excel.

The syntax is ROUND(value1, digits) where both arguments are required. For value1 , use the number you want to round. For digits , use the number of decimal places to round the number.

For example, to round the number 2.25 up one decimal place, enter the following and press Enter:

=ROUND(2.25,1)

And you have your results. If you want to round down, simply use a negative number for the digits argument.

ROUND function in Excel

8. Truncate a Number by Removing the Fraction: TRUNC

Maybe you’d prefer to truncate a number rather than round it. Using the TRUNC function, you can remove the fraction from the number.

The syntax is TRUNC(value1, digits) with value1 required and digits optional. If you don’t enter the digits, the default value is zero.

So, to truncate the number 7.2 you would enter the following and press Enter:

=TRUNC(7.2)

The result of this formula would be the number seven.

TRUNC function in Excel

9. Find the Product by Multiplying Cells: PRODUCT

If you need to multiply several cells, using the PRODUCT function is more efficient than using the multiplication symbol (*) in a formula.

The syntax is PRODUCT(value1, value2,...) with value1 required and value2 optional. You can use value1 for the cell range and value2 for an additional cell range if needed.

To find the product of cells A2 through A10, you would enter the following and hit Enter:

=PRODUCT(A2:A10)

As you can see, this is much simpler than entering A2 * A3 * A4 , and so on.

PRODUCT function in Excel

10. Use the Reference Number of a Given Cell: COLUMN and ROW

With the COLUMN and ROW functions in Excel, you can return the position number of a cell. These functions are useful for entering a series of reference numbers in your sheet, or row numbers, for instance.

The syntax for each is COLUMN(reference) and ROW(reference) where the argument is not required. If you don’t enter an argument, the formula returns the reference for the cell containing the formula.

For example, if you enter the following formula into cell B2, the result would be 2 because B2 is in the second row.

=ROW()

But if you enter the following formula with an argument, you’ll receive the reference number for the cell.

=ROW(C5)

You can see here; the result is 5 because C5 is in the fifth row.

ROW function in Excel

11. Eliminate White Space: TRIM

Oftentimes you when you paste or import data, it contains extra spaces. The TRIM function eliminates white space.

The syntax is TRIM(reference) with the argument required for the cell reference containing the data.

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

=TRIM(A1)

You’ll then see the data in your referenced cell without the leading and trailing spaces.

TRIM function in Excel

12. Count the Number of Characters in a String: LEN

Maybe you need to find the number of characters in a string of text. Here, you’d use the LEN function in Excel.

The syntax is LEN(reference) with the argument required for the cell reference containing the text.

To find the number of characters in cell A1, enter the following formula and press Enter:

=LEN(A1)

The result is 25 because “Use the data from Finance” contains that number of characters and note that spaces are counted as characters.

LEN function in Excel

There are many other useful functions in Excel such as VLOOKUP for finding a value and CONCATENATE for joining strings of text. But this list of the basics should help you with simple tasks while becoming more familiar with using functions.

Original Article

Twitter Facebook Pinterest Linkedin WhatsApp

Related posts:

  1. How to Use Excel Like a Pro: 18 Easy Excel Tips, Tricks, & Shortcuts
  2. Microsoft Excel Basics Tutorial – Learning How to Use Excel
  3. How to fix IPMI KVM JAVA BMCMD5withRSA and is treated as unsigned error
  4. How to Cross Reference Cells Between Excel Spreadsheets
  5. How to Learn Excel Online: 17 Free and Paid Resources for Excel Training
  6. Here are the Top 24 Functions in Microsoft Excel You Should be Using
  7. 13 Essential Excel Functions for Data Entry
  8. How to Count Cells With Text in Microsoft Excel
  9. Link Cells Between Sheets and Workbooks In Excel
  10. The Ultimate Guide to Google Sheets

Filed Under: Windows 11 Tagged With: Excel Exercises, Excel Online Course, Excel Sheet, Excel Tutorial

Primary Sidebar

Trending

  • FIX: Microsoft Store error code 0x80d02017
  • How To Extract & Install tar.gz Files In Ubuntu
  • 8 Best Sites to Read Manga Online for Free
  • Exclamation Mark on Network Signal, Mobile Data Not Working? 8 Ways to Fix
  • 3 Ways to Disable GetApps on Xiaomi, Redmi, and Poco Phones Running MIUI
  • How to find a lost Apple Pencil using your iPad (1st and 2nd gen)
  • How to Track a Stolen or Lost Nintendo Switch
  • How Much Data is Consumed by Zoom, Google Meet, Skype, Microsoft Teams, Slack and Hangouts?
  • Samsung TV model numbers explained 2022: What you need to know about Samsung’s OLED, Mini LED, QLED and LCD televisions
  • 7 Ways to Save an Image From Google Docs
  • Microsoft Edge’s newest feature? Shopping in Microsoft Edge
  • How to lock Shape, Image or Objects in Microsoft PowerPoint
  • How To Fix No Sound On YouTube
  • How to Make Any Wired Printer Wireless in 6 Different Ways
  • NVSlimmer: remove unwanted components from Nvidia drivers
  • How To Enable Or Disable Snipping Tool In Windows 10
  • [Working] Remove Blue Circle From Your Samsung Phone Touchscreen
  • How to change the time on your Fitbit

Footer

Tags

Amazon android Apple Asus available download: edge feature features first free from galaxy Game games gaming gets google install Intel iPhone launches linux Microsoft more OnePlus phone release released review: samsung series support this Ubuntu update using video watch what will windows with xbox your

Archives

  • December 2023
  • November 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org