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 may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....

When using WPS Spreadsheet, we often need to locate a cell or a cell range to view data. If the table contains a lot of data, it will be very troublesome to look up the target cell or cell range by dragging the scroll bar with the mouse. Now, we are going to introduce three options to quickly locate cells.· Option 1 Ctrl+Home key can help us quickly locate the first cell of this table.Ctrl+End key can help us quickly locate the last cell of this table. We are locating at cell O56. Pres....

Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....

If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....