WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ZTEST Function in WPS on Windows

Last updated:July 14, 2026

This how-to guide covers 3 action topics for using the ZTEST function in WPS Spreadsheet on Windows; 3 are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert the function from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Insert the function from the Insert Function dialog

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 ZTEST in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • The target cell contains the ZTEST function.
  • After the parameters are filled in, the cell returns a calculation result.

Tips While Using

  • Make sure the data range and test value are entered correctly.
  • If parameters include text or extra spaces, the result may return an error.

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 =ZTEST(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter hints, check the on-screen prompt after typing the opening parenthesis.

Success Criteria

  • The cell shows the entered ZTEST formula.
  • After you press Enter, the cell returns a result or remains ready for parameter editing.

Tips While Using

  • Use English commas as parameter separators.
  • When copying the formula to other cells, check relative and absolute references.

3. Review syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter ZTEST in the search box.
  3. Select the function to review its syntax and parameter details.
  4. If a help entry is available in the dialog, open it for more details.

Success Criteria

  • You can see the function name, parameter structure, or help details for ZTEST.
  • You can confirm the parameter order before entering the formula.

Tips While Using

  • The help entry location may vary slightly across interface layouts.
  • An internet connection is needed when opening online help content.