When we edit a document with WPS Writer, if we want to highlight the separation of paragraphs, we can set a Drop Cap effect in the paragraph. In this way, the first letter of the paragraph is a large capital letter and it occupies multiple lines, making the paragraph separation more noticeable. · 1. DroppedTake the first paragraph as an example. Select this paragraph. Click the Insert tab and the Drop Cap button, then a dialog will pop up. In the Position area, we can choose None, Drop....

The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

The Conditional Formatting function can format the cells fulfiling specific conditions. With this function, we can quickly compare data in a worksheet. The worksheet in this example records the performance of staff. What if we want to highlight the Top Three performances? When there is a large amount of data, Conditional Formatting can quickly filter the first three maximums. 1. Select cell C2. 2. Then, press Ctrl + Shift + DOWN (↓) for quick selection from cell C2 to C26 (C2:C26).3. G....

The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....

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?