Why error message #NUM! occurs and how to solve it

We may encounter some errors when calculating in tables. One of these errors is "#NUM!." There are mainly three causes: 1. The calculated value is too large or too small. 2. Invalid values are referenced in the formula. 3. The iterative function fails to calculate the result. · 1. The calculated value is too large or too small.Take this table as an example. To calculate eight hundred to the power of nine hundred, input "=B3^C3," which means B3 to the power of C3. Then it returns "#NUM....

How to set up custom slide shows in WPS Presentation

When using WPS Presentation, how can we adjust the content and order of the slide show without deleting the original slides or even changing the page order of the original slides? The Custom Slide Shows feature can help us. Click the Slide Show tab at the top of the screen, and click the Custom Slide Shows button. In the popup dialog, click the New button to customize the settings for the slide show.In the popup Define Custom Show dialog, we can enter the name of the custom show in the....

Data Format-Scientific Notation

In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.You can use the following methods:When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the numb....

How to use the paste special function

Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

More features in Split and Merge

In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

How to adjust the picture position

After inserting a picture in the document, to perfect the layout, we will adjust the position of the picture in the process of typesetting. Take this document as an example. If we want to move the picture to the lower right corner of the page margin, click the picture first. Then click the Layout Options button in the upper right corner of the picture. And then click View More, now the Layout dialog box will pop up. WPS has provided us a large variety of alignment methods in the Positi....

Learn pivot table from the beginning

A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....