How to use the IF function
The IF formula, as one of the most commonly used functions, can determine whether a condition is TRUE or FALSE, so as to get one of the two values. In this article, you will see the explanation of IF function, several examples of IF formula, as well as a case demonstration. · Explanations of IF formula: IF(logical_test, value_if_true, [value_if_false])· logical_test (necessary): the condition to be compared· value_if_true (necessary): the value to be presented as the result when the “....
How to show presenter view during slide shows
· Option 1: 1. Open the document in WPS Presentation. 2. Get into the Slide Show tab → click Show presenter view → OK 3. Click From Beginning or From Current Show to start the slide shows. If you have the second monitor, you will see the interface in the presenter’s screen (as is shown below). · Option 2: WPS Presentation also sets a quick entry to turn on/off the mode of Presenter View. 1. We just need to check/uncheck the Use Presenter View box in the Slide Show tab. 2. Start the s....
How to insert and change the name of the slicers
Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....
How to create a handwritten signature in PDF
1. Use WPS Office to open a PDF file.2. Click Insert → Sign → Create signature in sequence.3. In the pop-up PDF signature box, select Draw. And write what you want in the input box by controlling the mouse.4. Click OK. Choose the location of the signature and click the page. To be office specialists, you could learn how to use WPS Office online in WPS Academy.
How to unhide the ribbon
The ribbon may be hidden in two situations.· Toolbar:If the toolbar is hidden, we can click the Show the Toolbar button. · Tab:1. If the ribbon is hidden, we can click the Menu button. 2. Click Options in the drop-down menu.3. Select Customize Ribbon in the Options popup window.4. We can see the Customize Ribbon area at the right corner of the interface. Here, we can check the tab we want to unhide and click OK. To be office specialists, you could learn how to use WPS Office online in ....
How to quickly select all pages in a PDF file
1. Use WPS Office to open the PDF file.2. Click the Page tab, and click the Page Range → all pages.3. After clicking, we can find that all pages in the PDF file are highlighted and are selected. For all, easy your work with WPS office suite. Free download WPS office for PC, Mobile, Windows, Mac, Android, iOS online.
Numbering items in a worksheet
· Option 1: 1. Open the spreadsheet with WPS Office. 2. Enter the beginning number in the first cell where we want to start the numbering. In the example below, the numbering will start from the number “1”.3. Select the cell range to be filled. 4. Click the Fill button again → choose series → change the settings as demonstrated below a. Series in: choose “Columns” b. Type: choose “Linear” c. Step value: enter “1” (from which to start the numbering)d. Stop value: enter “14” (where the ....
Adjust transparency of picture background in a slide
In the first slide, a picture has been set as the background of the first slide. Follow the steps to adjust the transparency of the picture background. 1. Click the Design tab → the Background drop-down button → Background…2. Drag the scroll bar with the mouse to adjust the background transparency. You can also input the exact number of percentages in this step. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.Thousands of fr....