WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

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....

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....

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....

We often insert pictures when using WPS Presentation, but if we want to make the layout of the slides more varied, we can try the Rotate feature of images. Take this slide as an example. Select a picture as needed, and a rotation icon will appear above the image. Press the left mouse button. Then we can adjust the rotation angle. If we need to flip a picture, we can select the image to get into the Picture Tools tab and click the Rotate button.Here, we can set the image to Rotate Left ....

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 ....

1. How to set the data format.2. How to enter the correct date and time formats.3. How to make number format and text format convert to each other.4. How to flexibly utilize the custom format.

When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....