Download WPS Office for your device

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.

In this lesson we have studied the following key points:1. How to make number format and text format convert to each other?In WPS Spreadsheets, when the number entered exceeds 11 digits, it will be automatically converted into text.Text format has the following 3 features: it is aligned to the left by default; it is unable to participate in calculation; a green corner prompt will appear in the upper left corner of the cell will. The way to convert text format into number format is as ....

1.We only need to set the logical value in advance, we can use the IF function to quickly determine whether the data meet the conditions.2. When we want to meet more than one condition at the same time, we can use the AND function; when we want to meet only one of the conditions in the case of multiple conditions, we can use the OR function.3. share how to use the function combination of IF+AND+OR in practical work.

The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....

The spell-check function of WPS Presentation helps us to quickly check the spelling mistakes and provides suggestions for corrections. It saves us a lot of time to proofread documents. Click the Review tab and the Spell Check button to open the Spell Check dialog. Its shortcut key is F7. In the text box on the left, we can see that some words are marked red, and these are the words that WPS Office has detected for us that may have spelling errors.Take the first wrong word "Notabel" as ....

The Spell Check function of WPS Spreadsheet can help us quickly trap misspelled words and provide suggestions for correction, greatly saving the calibration time of the table.In the Review tab, click the Spell Check button and open the Spell Check dialog box, whose shortcut key is F7.In the text box on the left, we can see some words marked in red. These are the words in which WPS Office has detected possible spelling mistakes. Take this table as an example. The cells are checked from ....

1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

1. Reviewed the steps to insert functions in the table, there are 3 entrances to insert functions. You do not need to remember each function, just enter the first few letters, and the system will generate an automatic association.2. shared the 3 types of formula references, namely relative, absolute and mixed references.3. shared the function of how to reference data across worksheets or workbooks.