Thứ Ba, Tháng Tám 9, 2022
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z
No Result
View All Result
NATuts
No Result
View All Result
Home Tech

12 basic functions in Excel everyone must know

15 Tháng Mười Hai, 2021
in Tech
0
12 basic functions in Excel everyone must know
585
SHARES
3.2k
VIEWS
Share on FacebookShare on Twitter

Các bài viết liên quan:

Download 3DVista Virtual Tour 2019

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022
Taiwan is about to rehearse the anti-occupation of the island

Taiwan is about to rehearse the anti-occupation of the island

8 Tháng Tám, 2022
Instructions for using SMS OTP V3 spam tool

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022

Microsoft Excel contains many functions that allow you to perform more time-saving tasks. But in Excel there are many different functions, so in this article I will summarize the 12 most basic functions that everyone should know.

12 basic functions in Excel that everyone should know

12 basic functions in Excel that everyone should know

1. Sum: SUM

One of the most basic functions when learning Excel is the SUM function.

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

For example, to sum cells A2 through A10, you would type the following function and press Enter:

=SUM(A2:A10)

This is the result.

12 basic functions in Excel anyone must know 49

2. Average: AVERAGE

Averaging is another popular function.

The syntax of the AVERAGE function in Excel is similar to the SUM, AVERAGE function (value1, value2, …) with value1 required and value2 optional. You can enter cell references or ranges of cells.

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

=AVERAGE(A2:A10)

And this is the result.

12 basic functions in Excel anyone must know 50

3. Find the highest or lowest value: MIN and MAX

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

The syntax of this function is the same as the other functions, MIN (value1, value2, …) and MAX (value1, value2, …) with value1 required and value2 optional.

To find the minimum value in a group of cells, enter the following function. Then press Enter:

=MIN(B2:B10)

And to find the maximum value use:

=MAX(B2:B10)

Here are the results:

12 basic functions in Excel that everyone must know

4. Find the mean: MEDIAN

Instead of the min or max value, you might want to find the middle value.

Syntax MEDIAN(value1, value2, …) with the first parameter mandatory and the second optional.

Type the following and press Enter:

=MEDIAN(A2:A10)

Here are the results:

12 basic functions in Excel everyone must know 52

5. Count cells containing numbers: COUNT

The COUNT function helps you to count cells that contain numbers in a range of cells. The COUNT function syntax (value1, value2, …) with the first parameter is required and the second parameter is optional.

To count cells containing numbers in the range A1 to B10, type the following function and press Enter:

=COUNT(A1:B10)

This is the result.

12 basic functions in Excel anyone must know 53

6. Insert current date and time: NOW

If you want 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 parameters. However, you can add or subtract the current date and time if you want.

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

=NOW()

To return the date and time five days in the future from the present, type this function and press Enter:

=NOW()+5

This is the result.

12 basic functions in Excel everyone must know 54

7. Round to a certain number of digits: ROUND

The ROUND function in Excel will help you round certain numbers.

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

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

=ROUND(2.25,1)

And this is the result.

12 basic functions in Excel anyone must know 55

8. Eliminate fractions: TRUNC

The TRUNC function will help you remove certain fractions from numbers.

The syntax is TRUNC(value1, value2) with value1 required and value2 optional. If you do not enter value2, the default value is 0.

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

=TRUNC(7.2)

Result.

12 basic functions in Excel everyone must know 56

9. Multiply cells: PRODUCT

If you need to multiply several cells, using the PRODUCT function is more efficient than using the multiplication symbol

in the formula.

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

=PRODUCT(A2:A10)

To multiply cells from A2 to A10, you need to type the following function and press Enter:

Using this function will be much faster than typing A2 * A3 * A4,…

12 basic functions in Excel everyone must know 61

10. Use the reference number of a given cell: COLUMN and ROW

With the Excel COLUMN and ROW functions, you can return the position of a cell.

COLUMN (reference) and ROW (reference) syntax, where the parameter is not required. If you do not enter a parameter, the formula returns the reference of the cell containing the formula.

=ROW()

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

=ROW(C5)

But if you enter the following formula with one argument, you will get the row position of that cell.

The result is 5 because C5 is in the fifth row.

12 basic functions in Excel that everyone must know

11. Remove whitespace: TRIM

Usually, when you paste or type data, it will contain extra spaces. The TRIM function will help you to remove whitespace.

=TRIM(A1)

The syntax is TRIM (the cell you want to remove the space from). To remove extra spaces from cell A1, you need to type the function and press Enter:

And this is the result.

12 basic functions in Excel everyone must know 63

12. Count the number of characters in a string: LEN

=LEN(A1)

The syntax is LEN (reference). To find the number of characters in cell A1, type the following formula and press Enter:

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

12 basic functions in Excel everyone must know 64 In addition, you can also check out the series of other useful excel articleshere

.

Previous Post

KMS Tool all in one activates all the latest and safest windows and office

Next Post

Download Antidote 11 – Advanced French learning software

Admin Natuts

Admin Natuts

Related Posts

Instructions for using SMS OTP V3 spam tool

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022
Instructions to install Outline VPN on Ubuntu

Instructions to install Outline VPN on Ubuntu

7 Tháng Tám, 2022
What is Conhost.exe and why is it running on my computer

What is Conhost.exe and why is it running on my computer

7 Tháng Tám, 2022
How to make the background transparent in Canva

How to make the background transparent in Canva

7 Tháng Tám, 2022
Load More
Next Post
Download Antidote 11 – Advanced French learning software

Download Antidote 11 - Advanced French learning software

Trả lời Hủy

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Bài viết mới

Download 3DVista Virtual Tour 2019
Software

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port
Travel

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022
Taiwan is about to rehearse the anti-occupation of the island
News

Taiwan is about to rehearse the anti-occupation of the island

8 Tháng Tám, 2022
Instructions for using SMS OTP V3 spam tool
Tech

Instructions for using SMS OTP V3 spam tool

8 Tháng Tám, 2022
How to Do Venmo Identity Verification [2022 Guide]
Tech

How to Do Venmo Identity Verification [2022 Guide]

8 Tháng Tám, 2022
Meta disrupts cyber espionage in South Asia Facebook abuse
Tech

Meta disrupts cyber espionage in South Asia Facebook abuse

8 Tháng Tám, 2022
W3Schools

Ads

Contact: [email protected]

DMCA.com Protection Status

Categories

  • Android
  • Cạm bẫy tâm lí
  • Chưa được phân loại
  • Đồ họa
  • Đời sống
  • Gen Z
  • Health
  • iOS
  • Kĩ năng mềm
  • News
  • Nhà mạng
  • Phần mềm
  • Phần mềm đồ họa
  • Review sách
  • Software
  • Tech
  • Thiết kế ảnh
  • Thiết kế video
  • Thủ thuật
  • Travel
  • Văn hóa Nam Bộ
  • Văn học
  • Window

Browse by Tag

ai là triệu phú android Apple browser Bullet Journal bản thân Chỉnh ảnh data domain download du lịch fshare game game show hosting HÌNH XĂM IKEA ios khuyến mãi kinh doanh kiến thức kiểm tra pin lừa đảo messenger miễn phí mua sắm Máy ảnh mạng mồi tiềm thức network nghệ thuật nhà Trần quảng cáo review tháp phân tầng xã hội tiếng anh tiện ích Trần Thủ Độ tên miền từ vựng viettel word xã hội Đơn giản đánh bạc

Recent News

Download 3DVista Virtual Tour 2019

Download 3DVista Virtual Tour 2019

8 Tháng Tám, 2022
Nha Trang Stone Bridge Port

Nha Trang Stone Bridge Port

8 Tháng Tám, 2022

Trang tin nóng hổi - vừa thổi vừa xem

No Result
View All Result
  • Home
  • Health
  • News
  • Software
  • Tech
  • Travel
  • Gen Z

Trang tin nóng hổi - vừa thổi vừa xem