WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how many cells are included in the range a1 b3

    60 results for how many cells are included in the range a1 b3

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    60 results for how many cells are included in the range a1 b3

    Create simple and intuitive mini charts

    Create simple and intuitive mini charts

    03:10

    Create simple and intuitive mini charts

    The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

    Spreadsheet views
    Use format painter to adjust the styles in batches

    Use format painter to adjust the styles in batches

    01:28

    Use format painter to adjust the styles in batches

    Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

    Spreadsheet views
    Data format - Fraction format

    Data format - Fraction format

    01:31

    Data format - Fraction format

    Do you know how we can convert a number into the fraction format?There are two available methods to set fraction format in WPS Spreadsheet. First, select the range of the table, head to the Home tab, find the setting button in the shortcut menu, and set the Fraction format.Alternatively, we can select the desired range of cells, and right-click Format cells, whose shortcut key is Ctrl+1.Locate Fraction in the category list, and choose from different types of fractions in the Type area....

    Spreadsheet views
    Set the date format cells

    Set the date format cells

    01:40

    Set the date format cells

    In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

    Spreadsheet 0.393 views
    How to use the formula function of table in WPS Writer

    How to use the formula function of table in WPS Writer

    02:38

    How to use the formula function of table in WPS Writer

    You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

    Writer views
    Use SUM function to quickly calculate the sum

    Use SUM function to quickly calculate the sum

    01:31

    Use SUM function to quickly calculate the sum

    The SUM function is commonly used when we process data with WPS Spreadsheet.Use the SUM function values in certain cells. Take this worksheet as an example. How can we sum the values in the yellow-filled cells? 1. Click the Insert Function button in the Formula tab.2. Insert the SUM function from the selection box.3. We can also click the SUM option in the AutoSum dropdown list in this step. Then, there will be a popup dialog titled Function Arguments, where Number means the range to r....

    Spreadsheet 0.9882 views
    Set Allow Users to Edit Ranges in a protected sheet

    Set Allow Users to Edit Ranges in a protected sheet

    02:04

    Set Allow Users to Edit Ranges in a protected sheet

    As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

    Spreadsheet views
    Why error message #REF! occurs and how to solve it

    Why error message #REF! occurs and how to solve it

    03:18

    Why error message #REF! occurs and how to solve it

    The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

    Spreadsheet views
    Prev 123...78 Next
    WPS Academy
    Products
    Partners