WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

Use AVERAGE in 3 how-to topics, all available directly in WPS Spreadsheet; 3 are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter AVERAGE from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Enter AVERAGE from the Insert Function dialog box

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for AVERAGE in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter the required arguments in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell now contains the AVERAGE function.
  • The formula returns an average result after the arguments are entered.
  • You can continue editing the formula or copy it to other cells.

Tips While Using

  • Search with the standard function name AVERAGE.
  • Arguments can be numbers, cell references, or range references.

2. Type the formula directly in a cell

Entry point: Worksheet cell or formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =AVERAGE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter details, type =AVERAGE( and then press F1 to view syntax guidance.

Success Criteria

  • The cell displays the calculated average result.
  • The full formula is visible in the formula bar.
  • The formula can be edited, copied, or filled down to other cells.

Tips While Using

  • Use commas to separate arguments.
  • Check that the referenced range starts and ends in the intended cells.

3. Review syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter AVERAGE in the search box.
  3. Select the function to review the syntax AVERAGE(...).
  4. Click the help link for the function to view more details.

Success Criteria

  • You can find the AVERAGE function information area or help page.
  • The function name, syntax, and parameter details are visible.
  • You can return to the worksheet and continue entering the formula.

Tips While Using

  • Opening help content may require an internet connection.
  • If you only need quick entry, return to the worksheet after confirming the syntax.