Provides friendly Word processing, Spreadsheets & Presentation software.

|
Kingsoft Office > Support for Windows Office > Kingsoft Spreadsheets 2012 Step by Step Formula Tutorial

Kingsoft Spreadsheets 2012 Step by Step Formula Tutorial

Release Date: 07-05-12

Spreadsheets 2012 Formula Tutorial–Overview

Kingsoft Spreadsheets 2012 provides more than 100 commonly used formulas, covering Mathematics, Finance, Engineering and more. This tutorial introduces how to create a basic spreadsheet formula from the Function Library in Spreadsheets 2012.

You can use a Spreadsheets 2012 formula for both simple equations, such as addition or subtraction, and complex calculations, such as averaging a student's text result or payroll deduction.

Whenever you edit your data, Spreadsheets 2012 will automatically adjust your results without you needing to reenter any formulas.

Basic Spreadsheets Formula Tutorial: Step 1 of 3

basic spreadsheets formula tutorial step 1 of 3

The following is a simple example that you can also use to help you write more complex formulas.

How to get the result of 2+3:

Step 1: Entering the data.

1. Type a 2 in cell A1 and press the ENTER key on the keyboard.

2. Type a 3 in cell A2 and press the ENTER key on the keyboard.

Basic Spreadsheets Formula Tutorial: Step 2 of 3

basic spreadsheets formula tutorial step 2 of 3.png

When you create formulas in Spreadsheets 2012, you’ll always have to start with “=” sign. Inputting an "=" sign signals to Spreadsheets 2012 that you want to enter a formula.

Step 2: Entering the “=” sign in the cell you want to get the solution.

1. Click cell A3 with your mouse pointer.

2. Type the “=” sign in cell A3.

Basic Spreadsheets Formula Tutorial: Step 3 of 3

basic spreadsheets formula tutorial step 3 of 3.png

Following the “=” sign, we add in references to the cells containing our data. Cell references refer to the address of your cell. For example, the address of data "2" is A2.

By using cell references, the result of the formula will automatically change when you change the data in cell A1 and A2.

Step 3: Entering data using cell references.

1. Click cell A1 with the mouse pointer to enter data 2

2. Type a plus “+” sign

3. Click cell A2 with the mouse pointer to enter data 3

4. Press the Enter key on the keyboard

5. The answer 5 will appear in cell A3

6. Click on cell A3, the formula “=A1+A2” will appear on the status bar.

Note:You're also allowed to follow the descriptions of different formulas and get relevant solutions.

For example, The description of SUM function is: SUM(number1,number2), adds all the numbers that you specify as arguments. You can use the “SUM” function to get the result of 2+3. Input SUM(A1, A2) to get the result.

You're able to find all the formulas and their descriptions in the following link and select the formula that best suits your needs.

http://help.kingsoftstore.com/spreadsheets/formulas-tab/function-category