### How to get calculate average

· Option 1: with Quick AccessSelect the cell range filled with the data for calculation.Click Home from the toolbar → AutoSum dropdown button → choose Average · Option 2: with the AVERAGE functionEnter the formula =AVERAGE(Select the cell range filled with the data for calculation.Press Enter to get the average result. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

### IRR Function in EXCEL

· Description:IRR means the Internal Rate of Return that is represented by numbers for a series of cash flows. It requires that the cash flows are at regular intervals. · Syntax:(Value, guess) · Arguments:Value is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.Guess is a number that you guess is close to the result of IRR; 0.1 (10 percent) of omitted. · Example:Suppose we want to calculate the IRR of this investment p....

### MATCH Function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. · Description:The INDEX function can look up a value regarding its row and column numbers, which can be used in two forms: array form and reference form. · Syntax1(Array form): INDEX (Array, Row_num, [Column_num].) · Arguments:Array: Specified array or range of cells.Row_num: The row number of the specified arrayCol_num: [Optional] The column number of....

### The RAND Function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. · Description:With Rand Function, you can return a random number between 0 and 1, and each time you recalculate them, they will return new values. · syntax:RAND( ) · ArgumentsNo arguments for the RAND function. · Example:1. Open your table in WPS Spreadsheet.2. Select a blank cell where you want to add a random number. Click the Formulas tab > Insert F....

### The SUMIF function in Excel

The SUMIF function is used to sum several cells based on a specified condition. Take this sales table as an example. We want to sum the sales of Beijing. 1. Click the cell where you want to insert the total sales, click Formulas > Insert Function to get a dialog.2. Enter SUMIF in the Search for a function text box and click OK to pop up another dialog. 3. Click the select icon in Range area, and then select the cell range which contains the condition. Here we select the cells A2:A10.....

### The TRIM Function in Excel

Want to Learn Excel? Here is a WPS Spreadsheet online training that will teach you all the basics and advanced skills. Download WPS Office, easily find more about spreadsheet formulas, data, and cells in WPS professional spreadsheet tutorials. · Description:The TRIM function removes the leading and trailing spaces and the unnecessary spaces between words. When receiving the text with irregular spacing, you can use TRIM to modify quickly and easily. · Syntax:=TRIM(text) · Arguments:Text....

### The WEEKDAY Function in EXCEL

· Description:Weekday Function can return a number from 1 to 7 identifying the day of the week of a date. In today’s tutorial, we will also learn how to combine WEEKDAY with nested IF&OR function. · Syntax:(Serial_number, Return_type) · Arguments:Serial_number: The number that represents a date.Return_type: You can enter a number here: 1: Returns a number from 1 to 7, meaning start from Sunday and end at Saturday. It’s the default if omitted.2: Returns a number from 1 to 7, meaning st....

### Subtraction in Excel

There are two methods for you. Here we take this sales table as an example. How can we work out the net margins of each kind of fruit quickly? · Option 1Input the formula “=C2-B2” and press Enter on the keyboard. Then drag the mouse to fill the following cells. · Option 21. Click Formulas, and click Insert Function to pop up a dialog. 2. Input “IMSUB” in the dialog and input “C2” in Plural 1 and “B2” in Plural 2. Then click OK and drag the mouse to fill the following cells. WPS office....