Home Topics word What are the eight most commonly used functions in word?

What are the eight most commonly used functions in word?

Nov 23, 2021 am 10:53 AM
word

word The eight most commonly used functions are: 1. AVERAGE function; 2. COUNT function; 3. MAX function; 4. MIN function; 5. ROUND function; 6. SUM function; 7. PRODUCT function; 8. DEFINED function.

What are the eight most commonly used functions in word?

The operating environment of this article: Windows7 system, Microsoft Office word2010, Dell G3 computer.

What are the eight most commonly used functions in word? Of course there are far more than 8.

You can use functions in Word, and Word has provided you with 18 functions. The following content is the name, function introduction and usage of these functions.

  • Function name: ABS

Function function: Return the absolute value of the input value. For example, function =ABS(-3) will return 3.

  • Function name: AND

Function function: Allows you to perform compound "AND" logic tests. For example, the function =AND(1=1,2 2=4) will return 1 because both logical tests in it are true.

  • Function name: AVERAGE

Function function: Calculate the arithmetic average of the input values. For example, the function =AVERAGE(1,2,3,4) will return 2.5.

  • Function name: COUNT

Function function: Count input values. For example, the function =COUNT(1,2,3,4,5,6) will return 6.

  • Function name: DEFINED

Function function: Determine whether the formula can be calculated. Returns 1 if the formula can be calculated, 0 if it cannot. For example, the function =DEFINED(1/0) will return 0 because no number can be divided by zero.

  • Function name: FALSE

Function function: Return the logical value 0 for false. For example, function =FALSE will return 0.

  • Function name: IF

Function function: perform a logical test. If the test is true, a result will be returned, and if the test is false, Return another result. For example, the function =IF(2 2=4,1,0) will return the value 1 because 2 2 is indeed equal to 4.

  • Function name: INT

Function function: Return the integer part of the value. For example, function =INT(3.5) will return 3.

  • Function name: MAX

Function function: Return the maximum input value. For example, function =MAX(1,2,3,4) will return 4.

  • Function name: MIN

Function function: Return the minimum input value. For example, function =MIN(1,2,3,4) will return 1.

  • Function name: MOD

Function function: Return the modulus (or remainder) remaining in the division operation. For example, the function =MOD(3,2) will return 1 because the remainder after dividing 3 by 2 is 1.

  • Function name: NOT

Function function: Allows you to perform compound "not" logic tests. For example, the function =NOT(1=1,2 2=4) will return 0. Because the results of both logical tests are true.

  • Function name: OR

Function function: Allows you to perform compound "OR" logic tests. For example, the function =OR(1>1,2 2=4) will return 1 because the result of the 2nd logical test is true.

  • Function name: PRODUCT

Function function: Multiply the parameters in the function. For example, function =PRODUCT(2,3,4) will return 24.

  • Function name: ROUND

Function function: Round the input value to the specified decimal precision. For example, the function =ROUND(123.456,2) will return 123.46.

  • Function name: SIGN

Function function: If the input value is a negative value, return -1, if the input value is a positive value, return 1, or 0 if the input value is 0. For example, the function =SIGN(-3) will return -1.

  • Function name: SUM

Function function: Sum input values. For example, function =SUM(2,2) returns 4.

  • Function name: TRUE

Function function: Returns a true logical value of 1. For example, function =TRUE will return 1.

Recommended study: "Word Tutorial"

The above is the detailed content of What are the eight most commonly used functions in word?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Detailed explanation of how to display the ruler in Word and how to operate the ruler! Detailed explanation of how to display the ruler in Word and how to operate the ruler! Mar 20, 2024 am 10:46 AM

When we use Word, in order to edit the content more beautifully, we often use rulers. You should know that the rulers in Word include horizontal rulers and vertical rulers, which are used to display and adjust the document's page margins, paragraph indents, tabs, etc. So, how do you display the ruler in Word? Next, I will teach you how to set the ruler display. Students in need should quickly collect it! The steps are as follows: 1. First, we need to bring up the word ruler. The default word document does not display the word ruler. We only need to click the [View] button in word. 2. Then, we find the option of [Ruler] and check it. In this way, we can adjust the word ruler! Yes or no

How to add handwritten signature to word document How to add handwritten signature to word document Mar 20, 2024 pm 08:56 PM

Word documents are widely used due to their powerful functions. Not only can various formats be inserted into Word, such as pictures and tables, etc., but now for the integrity and authenticity of the files, many files require a manual signature at the end of the document. It sounds like this How to solve complex problems? Today I will teach you how to add a handwritten signature to a word document. Use a scanner, camera or mobile phone to scan or photograph the handwritten signature, and then use PS or other image editing software to perform necessary cropping on the image. 2. Select "Insert - Picture - From File" in the Word document where you want to insert the handwritten signature, and select the cropped handwritten signature. 3. Double-click the handwritten signature picture (or right-click the picture and select "Set Picture Format"), and the "Set Picture Format" pops up.

How to draw a table in Word How to draw a table in Word Mar 19, 2024 pm 11:50 PM

Word is a very powerful office software. Compared with WPS, Word has more advantages in detail processing. Especially when the document description is too complex, it is generally more worry-free to use Word. Therefore, when you enter the society, you must learn some tips on using word. Some time ago, my cousin asked me a question like this. I often see other people drawing tables when using Word, and I feel very high-level. I laughed at that time. It seemed like high-level content, but actually it only took 3 steps to operate. Do you know how to draw a table in Word? 1. Open word, select the place where you want to insert the table, and find the "Insert" option in the upper menu bar. 2. Click the "Table" option, and densely packed small cubes will appear.

Where is the shading setting in word? Where is the shading setting in word? Mar 20, 2024 am 08:16 AM

We often use word for office work, but do you know where the shading settings are in word? Today I will share with you the specific operation steps. Come and take a look, friends! 1. First, open the word document, select a paragraph of text paragraph information that needs to be added with shading, then click the [Start] button on the toolbar, find the paragraph area, and click the drop-down button on the right (as shown in the red circle in the figure below) ). 2. After clicking the drop-down box button, in the pop-up menu options, click the [Border and Shading] option (as shown in the red circle in the figure below). 3. In the pop-up [Border and Shading] dialog box, click the [Shading] option (as shown in the red circle in the figure below). 4. In the filled column, select a color

How to underline in Word How to underline in Word Mar 20, 2024 pm 03:16 PM

As a very commonly used word processing software, Word is used in our life, study and work all the time. Of course, if you want to make good use of Word to edit text, you must lay a good foundation. So today I will take you to learn how to underline in Word. You can do it together with the editor. It is very simple. 1. First, we open the file we need to edit. Here we take the following figure as an example. 2. Use the mouse to select the text we need to edit. In the pop-up tab, we select the [U] icon. The operation is as shown in the figure: 3. Let’s take a look at the effect: 4. In fact, we can use a more convenient and faster The method is to use the key combination [ctrl] + [U] on the keyboard to add and follow your text.

What should I do if the word interface becomes smaller? What should I do if the word interface becomes smaller? Mar 20, 2024 pm 09:30 PM

When we use computers to edit word documents, we often don't know where we touched, and the interface suddenly becomes very small. Sometimes the text in the word document cannot be seen clearly. Some people may panic when encountering such a problem, thinking that the computer is malfunctioning. In fact, it is just because you have encountered a certain setting and adjusted the display. So, if you accidentally change the size of the interface display, how should you restore and adjust it? What should I do if the word interface becomes smaller? Below, we will share several ways to solve it. I hope you can easily deal with it when you encounter such a problem. First, we create and open a Word document and perform simple editing operations to show the steps. In the picture below

How to insert automatic numbering or serial numbers into Word tables How to insert automatic numbering or serial numbers into Word tables Mar 20, 2024 am 09:30 AM

When we make tables, the first thing we think of is to use Excel software to make tables. But did you know that Word software is actually very convenient to make tables. Sometimes when we make tables in Word software, we need to enter serial numbers or numbers. , if you enter them one by one manually, it will be very troublesome. In fact, there is an operation in the word software that can automatically insert numbers or serial numbers. So let’s learn with the editor how to insert automatic numbering or serial numbers into Word tables. . 1. First create a Word document and insert a table. 2. Select the column or cell where you want to insert automatic serial numbers or numbers. 3. Click "Start" - "Number". 4. Select one of the style numbers. 5.

How to switch tables horizontally and vertically in word How to switch tables horizontally and vertically in word Mar 20, 2024 am 09:31 AM

Word software is indispensable to us and needs to be used frequently. I have learned how to edit tables using Word software before. However, if I accidentally edit the table in the horizontal and vertical directions, and I don’t want to waste time re-creating it, is it possible to change the horizontal and vertical directions of the table? Woolen cloth? The answer is of course yes. Next, the editor will introduce to you in detail how to swap tables horizontally and vertically in Word. Let us learn together. First, we need to swap the rows and columns of the Word table below. To do this, we need to first select the table entirely, then right-click and select the copy function. Step 2: After selecting copy, we minimize word, then open an Excel table, right-click, select paste, and paste it into Exc

See all articles