How to Use

Use BOOKNAME through 3 how-to topics, all available directly in WPS Spreadsheets; choose a topic from the index and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Insert the function from the Insert Function dialog box

Entry path: 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 BOOKNAME in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• On-screen result: The target cell contains the BOOKNAME function.
• What you can do next: You can continue editing arguments or confirm the calculation result.

Tips While Using

• Entering the function name as uppercase BOOKNAME can help you locate it more quickly.
• Before filling in arguments, confirm that the referenced cells or ranges are correct.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

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

Success Criteria

• On-screen result: The cell shows the entered formula or the calculation result.
• What you can do next: You can copy the formula, edit arguments, or fill it down.

Tips While Using

• Use English punctuation in formulas. A full-width comma may prevent the formula from calculating correctly.
• If the result looks incorrect, check the parentheses, argument order, and referenced range first.

3. Review function syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter BOOKNAME in the search box.
3. Select the function to review the syntax BOOKNAME(...).
4. Click the help link for the function to open more detailed guidance.

Success Criteria

• On-screen result: You can see the function name, syntax, and the entry to parameter guidance.
• What you can do next: You can return to the spreadsheet and continue entering or editing the formula.

Tips While Using

• Opening the help link requires an internet connection.
• After reviewing the guidance, compare each argument with the current worksheet setup.