297 results for how to do squared on keyboard
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to create a scatter chart in WPS Spreadsheet02:53
How to create a scatter chart in WPS Spreadsheet
A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....
Use the Today function to quickly calculate days between dates01:57
Use the Today function to quickly calculate days between dates
In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....
How to customize text shortcut keys01:33
How to customize text shortcut keys
We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office？ First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....
How can we insert symbols in WPS Writer01:50
How can we insert symbols in WPS Writer
When we edit a document, we will inevitably need to enter some symbols that are not directly entered by the keyboard input method. So, how do we insert the special symbols that we need? Take this document as an example. We want to tick the tourist attractions we have visited to facilitate statistics. Click the position where we want to insert the symbol and click the Insert tab and the Symbol drop-down button. We can see Recently Used Symbols and Custom Symbols here. These are the ....
Make a countdown calendar in WPS Spreadsheet01:37
Make a countdown calendar in WPS Spreadsheet
It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....
WPS Spreadsheet basic editing02:12
WPS Spreadsheet basic editing
This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....
How to insert calculated fields in PivotTable01:06
How to insert calculated fields in PivotTable
Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....
How to draw on a PDF
When using WPS to preview a PDF file, how can we draw on it to markdown key points when necessary? Here are the steps. 1. Open the PDF file in WPS. 2. Get into the Comment tab → click the Graffiti dropdown button.3. Then, we can access quick settings for ink marks in the dropdown list, to change the color, width, opacity of the line. 4. Start to draw on the PDF page as your favorite. * Tips: For advanced settings of ink marks, click the Graffiti button.