Home

Spreadsheets 2013

Contents

1. Use labels in Top row Left column 158 Spreadsheets 2013 User Manual Figure 6 5 6 Add the 2013 Data cells area 8 Press OK Then the result of consolidation will be displayed in the target worksheet See below amp Spreadsheets Home Insert Page Layout Formulas Data on A Z i E Y Bl 3 PivotTable AutoFilter Advanced Ascending Desce E h S f EB Book1 xs x 4 H12 Q fx A B C D 1 2012 2013 Data Statistic 2 Name Score 1 Score2 Score 3 3 4 5 6 8 9 lt gt gt MBE 2013Data TotalSales Figure 6 5 7 The result of Consolidation 6 5 2 Consolidate by Category If the ranges of data to be consolidated don t have the same layout you can use the consolidation by category feature instead of consolidation by position For example as you can see in Figure 6 5 1 and 6 5 2 the scores are different in 2012 and 2013 To consolidate the two worksheets by category follow the steps below 1 Open the Total Sales worksheet tab and enter the title See below Spreadsheets Home Insert Page Layout Formulas Data X Cut amp Times New Roman 12 C Copy Format B I UB 2 A Painter BES amp B Booki xs x A2 i EQ fx A B D 2012 2013 Data Statistic 2 3 4 lt lt gt gt OBRA 2013 Data Total Saes Figure 6 5 8 Total Sales worksheet 2 Select cell A2 and click the Consolidate icon in the Data tab Then the Consolidate dialogue box will
2. SUM numberi number2 Returns the sum of all the numbers in a range of cells Ceres Figure 5 2 3 The Insert Function dialogue box 3 Select SUM in the Choose a function list box and press OK 4 Then the Function Arguments dialogue box will open where you can input or select the desired cells in the Number 1 input box Press OK See below E Function Arguments SUM Number1 C2 C8l Ay 89 90 100 88 92 92 97 Number2 Fr 648 Returns the sum of all the numbers in a range of cells Number1 number i number2 are 1 to 30 numbers to sum Logical values and text are ignored in cells included if types as arguments Formula result 648 Goma Figure 5 2 4 The Function Arguments dialogue box 5 The function is inserted successfully and the result is displayed as below A B C D E 1 2 1 2009780111 89 94 3 2 2009780112 90 96 4 3 2009780113 100 94 5 4 2009780114 88 92 6 5 2009780115 92 100 7 6 2009780116 92 95 8 7 2009780117 97 92 9 sal Figure 5 2 5 The calculated result Tips Click the Recently Used icon in the Formulas tab and the recently used formulas will be listed in the drop down list for you to choose Click the All icon in the Formulas tab and all the formulas which Kingsoft Spreadsheets provide will be listed in alphabetical order in the drop down list for you to choose 115 Spreadsheets 2013 User Manual 5 2 3 Function Category 5 2 3 1 Financ
3. Automatic x Effects Preview E Strikethrough E Superscript Kingsof Spreadsheets AaBbCc E Subscript This is a TrueType font The same font will be used on both your printer and your screen o conc Figure 3 5 1 Set Text box Format You can set the text font font style size underline style color and effects in the corresponding sections in Figure 3 5 1 3 6 Word Art Kingsoft Spreadsheets provides a series of WordArt style To insert WordArt in the worksheet follow the steps below 1 Click the WordArt icon in the Insert tab The WordArt Gallery dialogue box will open and show as below E WordArt Gallery a Select a WordArt style Kingsof Kingsolt Kin soft ng Kingsoft Kingsef ngsor cine 013307 Kgs ego pingsalt My we Pingeoft Kingsoft PNil2gsojl Kingsa A gee Misan i w la l i Figure 3 6 1 WordArt Gallery 2 Choose the WordArt style you prefer and click the OK button The Edit WordArt Text dialogue box will open and show as below 92 Spreadsheets 2013 User Manual E Edit WordArt Text e Font Size A Arial Black Tae B Es Text our Text Here Gomes Figure 3 6 2 Edit WordArt Text 3 Enter the contents in the Text enter box and set the font size bold and italic style for the text 4 Click the OK button to complete the operation Tips After you have inserte
4. Format Chart Data Table Legend Select Switch Switch Chart Type Data Row Column Figure 3 2 15 The Chart Tools tab The functions of these icons are as follows Change Chart Type Click this icon the Chart Type dialogue box will open where you can change the current chart type Chart Objects Select the chart elements here in the drop down list so as to format it Format Chart Click this icon to open the Chart Area Properties dialogue box where you can set the border fill color font and other properties of the chart Data Table Click this icon to add or remove the data table to the chart Legend Click this icon to show or hide the legend in the chart Select Data Click this icon to open the Source Data dialogue box where you can change the data range and series contained in the chart Switch Row Click this icon to create chart series in rows Switch Column Click this icon to create chart series in columns 3 2 5 Custom Chart Kingsoft Spreadsheets contains various chart styles and a vibrant color scheme It also provides a custom chart option When creating a chart you can save them for future use It s also very easy to access your previously designed charts To create a customized chart follow the steps below 1 Create a chart in the current worksheet follow the steps in chapter 3 2 4 2 Click the Change Chart Type icon in the Chart Tools tab The the Chart Type dialogue box will open and show
5. O Check Box Click this icon to insert check box in the worksheet Double click the check box you have inserted and set the colors and lines size properties and control in the Format AutoShape dialogue box O Option Button Click this icon to insert option button in the worksheet Double click the option button you have inserted and set the colors and lines size properties and control in the Format AutoShape dialogue box O List Box Click this icon to insert list box in the worksheet Double click the list box you have inserted and set the size properties and control in the Format AutoShape dialogue box O Combo Box Click this icon to insert combo box in the worksheet Double click the combo box you have inserted and set the size properties and control in the Format AutoShape dialogue box 4 Oo Scroll Bar Click this icon to insert scroll bar in the worksheet Double click the scroll bar you have inserted and set the size properties and control in the Format AutoShape dialogue box O Spinner Click this icon to insert spinner in the worksheet Double click the spinner you have inserted and set the size properties and control in the Format AutoShape dialogue box E Control Oo Control Properties Click this icon to open the Format AutoShape dialogue box and set the properties of the selected AutoShape O Edit Codec Click this icon to open Microsoft Visual Basic and edit the selected form
6. O No Borders Only paste the cell contents without the cell borders O Values Copy the selected cells containing formats and formulas and select the Values option in the Paste drop down list By doing this you can paste the values in the cells without changing the formats and formulas O Transpose To rearrange row data to be displayed in columns you should choose the Transpose option in the Paste drop down list Copy the selected row data and choose the Transpose option in the desired position to complete the action O Paste as Picture Select the contents which you want to paste as a picture put the cursor to the place where you want to paste and choose the Paste as Picture option in the drop down list By doing this you can paste the intended contents as picture O Paste as Unformatted Text Choose this option and the selected contents will be removed all formats and pasted as plain text O Paste Special option includes the options mentioned above However you can also choose Paste 23 Spreadsheets 2013 User Manual Special in the Paste drop down list directly which offers more options for you Just right click and choose the Paste Special option in the context menu and the Paste Special dialogue box will open and show as below E Paste Special s Paste o All All except borders Formulas Column widths Values Formulas and number formats Formats Values and number formats Operation Hone Multiply Add Divide Subtract i
7. Simplex LP v Options Solving Method Select the LP Simplex engine for linear Solver Problems Figure 6 10 4 Set the Solver Parameters dialogue box 4 Select the target cell in the Set Objective section Here we choose cell G4 5 Choose Max in the To section to get the possible maximum revenue 6 Select the changing cells in the By Changing Variable Cells section He we select cell D5 D9 and D13 7 Click Add to add constraints The Add Constraint dialogue box will open and show as below E Add Constraint al Cell Reference Constraint By lt y A a cones Figure 6 10 5 The Add Constraint dialogue box 8 The three constrains in Figure 6 10 4 means that first the total sales volume should be less than or equal to the maximum sales volume of all pens here 500 second the sales volume of pen and ball pen should be less than or equal to the maximum sales volume of pen and ball pen here 350 third the sales volume of ball pen should be less than or equal to the maximum sales volume of ball pen here 125 9 Choose the Simplex LP option as the solving method 165 Spreadsheets 2013 User Manual 10 Click Solve to complete the operation 11 Click OK to solve the results See below Solver found a solution All Constraints and optimality conditions are satisfied Reports Answer Keep Solver Solution Sensitivity Limits Restore Original Values T Return to Solver Parameters
8. gt 20 teacher James 25 teacher Flora 52 teacher Figure 2 6 15 Multiple conditions in a single row 47 Spreadsheets 2013 User Manual o Multiple conditions in multiple rows and columns if you want to filter the data by one or another condition you can enter the name of the conditions in different columns and enter the condition in different rows under the corresponding name For example to filter the data by the condition Age lt 36 or Occupation is policeman See below lt 36 James 25 teacher Jane 34 driver Sarah 45 policeman Figure 2 6 16 Alternative conditions If you want to filter the data by the same condition in one category and by alternative conditions in another category enter the same condition under the former category while enter the alternative conditions in different rows under the later category For example to filter the data by the same condition 20 lt Age lt 55 and by the alternative conditions Occupation is teacher or Occupation is policeman See below James 25 teacher Sarah 45 policeman Flora 52 teacher Figure 2 6 17 The same condition and alternative conditions Tips if you want to filter the data multiple conditions you should enter them in the same row If you want to filter data by alternative conditions you should enter them in different rows of the same column To apply the Advanced Filter function follow the steps below 1 Select the Advanced Fi
9. open 3 In the Function box select SUM or the function that you want Kingsoft Spreadsheets to use to 159 Spreadsheets 2013 User Manual consolidate the data 4 Select cell ranges as we mentioned above In the 2012 Data worksheet the selected source range is A2 D9 In the 2013 Data worksheet the selected source range is A2 D9 Select Top row and Left column check boxes in the Use Labels section See below E Consolidate x Function Sum Yv Reference 2013 Data l A 2 D 9 Pr Browse All references 2012 Data SAS2 5DS9 Add 2013 Data SAS2 5DS9 Delete Use labels in V Top row V Left column Figure 6 5 9 The Consolidate dialogue box 5 Press OK to complete the operation Then the result of consolidation will be displayed in the target worksheet See below Home Insert Page Layout Formulas Data i E Yes al PivotTable AutoFilter Advanced Reat Ascending BES e Bi Book1 xs x A2 Q fx A B C D 1 2012 2013 Data Statistic 2 Scorel Score2 Score3 3 NBO001 197 198 198 4 NB002 197 194 189 5 NB003 193 192 187 6 NBO004 190 193 197 7 NBOOS 196 192 196 8 NB006 189 189 197 9 NB007 199 198 189 4 gt gt MODAN 2013Data Totalsales f gt Figure 6 5 10 The result of consolidation 6 6 Group 1 Select the range of data where you want to create a group 2 Click the Group icon in the Data tab and the Group dialogue box will open an
10. Print Preview EA Send E mail 9 File Information N 2 Backup Management Help E options ext Figure 1 4 11 The File Information tab Choose the Encryption option and you can open the Security tab in the Options dialogue box as shown in Figure 1 4 7 Then you can set the security related setting here such as the Document password Reenter password Password to modify etc Click the OK button to complete the operation Set the properties of the document the steps are as follows 1 Choose the Properties option and open the dialogue box shown as below E Booki xls Property ika General Summary Custom a Type Microsoft Excel Document Location C Users admin Desktop Size 7 680 byte MS DOS file name Book1 xls Created 2014 04 09 10 42 06 Accessed 2014 04 09 10 42 11 Modified 2014 04 09 10 42 11 Attributes Read or Hidden Cancel Figure 1 4 12 The Property dialogue box 2 In the General tab you can see the basic information of the document such as Type Location Size MS DOS file name Created time Accessed time Modified time etc 3 In the Summary tab you can enter the information in the corresponding text box such as Title Subject Author Manager Company Category Keyword and Comments Shown as below 19 Spreadsheets 2013 User Manual S Bookl xls Property rx General Summary Custom Title Subject Author admin Manager Company Category Keywor
11. Spreadsheets 2013 User Manual E Edit OLE DB Query aa Connection Provider Microsoft Jet OLEDB 4 0 Password User ID Admin Data 5 Source C Users admin Desktop book3 xls Mode Share Deny Write Extended Properties HDR YES Jet OLEDB System database Jet OLEDB Registry Path Jet OLEDB Database Password Jet OLEDB Engine Type 35 Jet OLEDB Database Locking Mode 0 Jet OLEDB Global Partial Bulk Ops 2 Jet OLEDB Global Bulk Transactions 1 Jet OLEDB New Database Password Jet M CID ranba Cuntam Matakana Calan Tat OI CMD mesmo Mii ls Tn Command type SQL X Command text SELECT Age Criteria FROM Sheet1s 0 Gon Figure 6 1 9 Edit OLE DB Query 6 1 4 External Data Range Properties You can define the Name Data formatting and layout and If the number of rows in the data range changes upon refresh of external data source Click Properties in Figure 6 1 8 The External Data Range Properties dialogue box will open where you can carry out the aforesaid operations See below Ba External Data Range Properties Name ExternalData_1 Data formatting and layout V Adjust column width v Preserve formatting If the number of rows in the data range changes upon refresh O Insert cells for new data dear unused cells Insert entire rows for new data clear unused cells Overwrite existing cells with new data dear unused cells Cancel Figure 6 1 10 External Data Range Properties 6 1 5 Refresh D
12. chare Cancel Figure 2 9 2 Set the Row Height and the Column Width 4 Select the AutoFit Row Height or AutoFit Column Width option in the drop down list and the row height and column width will automatically fit the contents of the rows and columns 5 Select the Standard Width option and the corresponding dialogue box will open where you can set the standard width for the columns See below E Standard Width rn Standard column width JEF char a im 33 Spreadsheets 2013 User Manual Figure 2 9 3 Standard Width dialogue box 6 Click the OK button to complete the operation Tips You can also accomplish the aforesaid operations by the context menu Select the rows or columns right click the mouse and choose the Row Height or Column Width option in the context menu 2 9 4 Inserting Cells Rows and Columns Select the Insert Cells option in the Rows and Columns drop down list you can see that there are three options namely Insert Cells Insert Rows and Insert Columns To insert cells follow the steps below 1 Select the position where you want to insert cells 2 Choose the Insert Cells option in the Insert Cells drop down list The Insert dialogue box will open and show as below Ej Insert Insert Shift cells right o Shift cells down Entire row Entire column Cancel Figure 2 9 4 The Insert dialogue box 3 Then you can adjust the position of the inserted cells by setting
13. exit the full screen mode 9 1 5 Reading Layout We often have to deal with spreadsheets with a large number of rows and columns It is inevitable that lines and columns will be misread when we check for formulas or data As for this Kingsoft Spreadsheets provides Reading Layout which makes it easier to check the data To use the reading layout mode follow the steps below 1 Click the Reading Layout icon in the View tab to enter into the Reading Layout mode See below 178 Spreadsheets 2013 User Manual A B Cc D E 1 2012 Data 2 Name Score l Score 2 Score 3 3 NB001 100 99 98 4 NBO002 97 96 90 5 NB003 99 97 95 6 NB004 94 100 100 7 NBOOS 98 92 99 8 NBO06 96 97 98 9 NB007 99 100 94 10 Figure 9 1 4 View the data in the Reading Layout mode 2 Click a cell or cell range and Kingsoft Spreadsheets will highlight the line and column of the current cell 3 The default color for this mode is a light yellow as shown above and you can choose the preferred color in the Reading Layout drop down list See below Formula Bar Y View Task Window Print Default Hhooooooo Heo0eaeocon MORADO Si imi E ELETE More Colors Figure 9 1 5 Choose color for the Reading Layout mode 4 You can re click Reading Layout in the View tab to exit the Reading Layout mode Then you can get back to the normal view In addition reading layout belongs to documents level If you open a number of doc
14. 15 110119213 9 4 A gt Sheet1 Sheet2 Sheet3 Figure 2 9 5 Insert Rows Insert Columns works the same way as Insert Rows 2 9 5 Deleting Cells Rows and Columns You can delete any unwanted cells rows and columns by the following two ways Oo Select the unwanted cells rows and columns Click the Rows and Columns icon in the Home tab 57 Spreadsheets 2013 User Manual and choose the Delete Cells option There are three options in the drop down list You can delete the selected cells rows and columns by choosing the corresponding option See below LS ee Worksheet 7 a ma Settings 7 L Row Height a AutoFit Row Height Column Width P Q fa AutoFit Column Width Standard Width a Insert Cells E Delete Cells E 2x Delete Cells Fill 3 Delete Rows Hide and Unhide Delete Columns Figure 2 9 6 The Delete drop down list Oo Select the unwanted cells rows and columns right click the mouse and choose the Delete option in the context menu 2 9 6 Fill To avoid entering large amounts of repetitive data manually you can use the Fill function to fill cells in a more efficient manner 2 9 6 1 Allow Cell Drag and Drop Kingsoft Spreadsheets allow users to apply the fill function by default You can also manually turn on or turn off the Allow cell drag and drop function The steps are as follows 1 Click the Application Menu icon at the top left corner of the screen to open
15. 3 4 Field List 4 1 2009780111 89 94 Drag items to the PivotTable areas 5 2 2009780112 90 96 cia 6 3 2009780113 100 heer 7 4 2009780114 88 an Score 1 8 5 2009780115 93 100 w Score 2 9 6 2009780116 92 95 10 7 2009780117 97 92 11 pivot table 12 13 Sum of Score 1 2009780111 rts 14 2009780112 into 15 2009780113 areas 16 2009780114 17 2009780115 18 2009780116 4 PivotTable Ardas 19 2009780117 Drag fields betweerl areas below 20 Sum of Score 2 2009780111 21 2009780112 22 2009780113 23 2009780114 24 2009780115 25 2009780116 26 2009780117 92 27 Sum of Score 1Total 649 Drag to adjust the order of 28 these items 29 Data Sum of Score 1 Student No Sum of Score 2 Sort and disply the items Figure 3 1 3 Set the pivot table 3 1 1 1 PivotTable Tools Tab After you have created a pivot table in the worksheet the PivotTable Tools tab will appear on the top of the window See below amp Spreadsheets d Book1 xls Home Insert Page Layout Formulas Data Table Style Review View Developer PivotTable Tools bA ll Gs GA bg Gt 3 O A Modify Refresh Sort Hide Order Delete Show Hide Field Subt otals PivotTable Hide PivotTable Data Detail Detail Settings Options Field List Figure 3 1 4 The PivotTalbe Tools tab The functions of these tools are as follows o Modify PivotTable Click this icon and the Modify PivotTable dialogue box will open where you can modify the existing pivot table Oo Refresh Dat
16. AA EE Times New Ronan z Classic Style OK Cancel Figure 1 3 5 The Skin Manager drop down list SL AL Ye o 9a or 13 9 Sh 2h FE ESA Classic Skin Spreadsheet l File Edit View Insert Format Jools Data Window Help 0 49 8 9 0 2 40 9 99 5 158 Times New Roman 12 Sia ee E US Classic Style Color Scheme 2013 Skin 5 Spreadsheets Home mao A m wl PivotTable Chart Picture Shapes PivotTable Chart Picture Shapes 2013 Elegant Black 2013 Water Blue The layout wil take effect after restarting MS Figure 1 3 6 Switch skin style in Office 2013 Classic Skin Tips Under 2013 style interface you can press the lt Alt gt shortcut key to bring up the Classic menu which is shown under the main toolbar Press lt Alt gt again to hide it This menu style is also available by clicking the arrow beside the program icon See below Spreadsheets 2013 User Manual 5 Spreadsheets d Home Insert Page Layout Formulas Cut ts Times New Roman 12 AA E Y NA Paste Copy Format B J UH E A A Painter Figure 1 3 7 Show classic menu in 2013 style interface 1 3 6 Activating Kingsoft Office To activate Kingsoft Office 2013 you need to purchase a product key first When you purchase our product and complete the payment you will receive an email confirming your order with a license code The code is composed of five groups of alphanumeric codes which are connected
17. See below 97 Spreadsheets 2013 User Manual g Symbol Se Symbols Special Characters Custom Symbols Font Arial X Subset Latin 1 Supplement Ops Te DOOR ANO PRA AlAjAla leo ejeje ieiet je eeel Recently used symbols Character code 00D7 From Unicode HEX v Insert to Custom Symbols Cancel Figure 3 9 2 The Symbol dialogue box 5 Choose the symbols in the Symbols and Special Characters tab 6 You can also customize symbols in the Custom Symbols tab e g move and remove the custom symbols or even reset the symbol tool bar 7 Click the Insert button to insert the symbol Or click the Cancel button to cancel the operation 3 10 Equation You can insert equation in Kingsoft Spreadsheets follow the steps below 1 Select the cell or cell range where you want to insert the equation 2 Click the Equation icon in the Insert tab 3 The Equation Editor will open where you can edit the equation See below a ni Equation Editor Equation in Bookl et LoJLO a j File Edit View Format Style Size Help lt zz jab x 90 gt 94 Y3 ENC dol AWA Ane EA e 2 zegi A om BB a 4 Style Math Size Full Zoom 100 Figure 3 10 1 The Equation Editor 4 Close the Equation Editor and the equation you have edited will be inserted to the selected cell or cell range 98 Spreadsheets 2013 User Manual 3 11 Insert O
18. Spreadsheets 2013 User Manual 1 Select the cell or cell range to which you want to add comment 2 Click the New Comment icon in the Review tab Or right click and select Insert Comment in the context menu 3 Input the content of comment in the Comment dialogue box 4 After inputting the comment press OK to complete the operation 3 2 2 Edit Comment You can edit comments that you have created in the Kingsoft Spreadsheets The operation steps are as follows 1 Select the cell or cell range you want to edit comment 2 Click the Edit Comment icon in the Review tab Or right click and choose Edit Comment in the context menu 3 Then the Comment dialogue box will pop up where you can edit the comment 4 After editing the comment press OK to complete the operation 3 2 3 Delete Comment In Kingsoft Spreadsheets you can either delete the comment of a single cell or delete all the comments in the worksheet simultaneously The operation steps are as follows 1 To delete the comment you need to select it first 2 Click the Delete icon in the Review tab When the little red triangle disappears 1t means the comment has been deleted If you want to delete all the comments in the worksheet follow the steps below 1 Press lt Ctri A gt to select all the comments 2 Open the Home tab and click the Format icon 3 Choose Comments in the Clear drop down list Then you can delete all the comments 8 3 Lock Cell
19. There are three ways to protect a specified cell O Click the Lock Cell icon in the Review tab 170 Spreadsheets 2013 User Manual O Press lt Ctrl A gt to select the whole worksheet In the Home tab click the Format icon and select Lock Cell in the Format drop down list Oo Select the whole worksheet right click and select Format Cells in the context menu In the Format Cells dialogue box open the Protection tab and select or deselect the Locked check box Then you can lock the cells or unlock the cells Tips The worksheet protection only works on locked cells 8 4 Protect sheet In order to protect your data Kingsoft Spreadsheets allows you to set a password for the worksheet or workbook by which you can prevent unauthorized users to modify the worksheet or workbook You can protect a worksheet by the Protect Sheet function provided by Kingsoft Spreadsheets Moreover you can protect cell range decide cell ranges can be filled or not and lock the corresponding content to avoid covering important data when filling This function can be used to make tables which need to be filled or protect important data from being modified The operation steps are shown as follows 1 Click the Protect Sheet icon in the Review tab The Protect Sheet dialogue box will open and show as below Ej Protect Sheet Ss Password optional Allow all users of this worksheet to J Select locked cells Y Select unlocked cells Forma
20. follow the steps below 1 Click the Find and Replace icon in the Home tab and select the Go To option in the drop down list or you can press the lt Ctrl G gt combination The Go To dialogue box will then open and show as below g Go To Find Replace GoTo Select O Data V Constants J Formulas Data type V Numbers V Text v Logicals Z Errors Comments Blanks Visible cells only Last cell Current data area Objects Figure 2 11 3 The Go to dialogue box 2 You can specify the conditions by selecting or deselecting the check boxes in the above dialogue box 3 Click the Go To button to locate the cells which meet the conditions you have specified 4 Click the Close button to close the dialogue box 2 11 4 Select Objects You can easily select objects in the Kingsoft Spreadsheet by the selecting objects mode Follow the steps below 1 Click the Find and Replace icon in the Home tab and choose the Select Objects option in the drop down list See below 73 Spreadsheets 2013 User Manual Cc ae Es gt FNG ana Settings Sery rd Replace Go To S le Select Objects Figure 2 11 4 The Select Objects option 2 When the cursor changes into a arrow headed cross you can then select the target objects simply by clicking them 3 You can also click and hold the mouse and then drag the mouse to cover the objects you want to select There will be a shadow area with dotted lines
21. 190 193 197 14 NB012 196 192 196 15 NB013 189 189 197 16 NB014 199 198 189 17 NB015 97 99 100 18 NBO16 100 98 99 19 NB017 94 95 92 20 NB018 96 93 97 21 NB019 98 100 97 Figure 9 4 2 Effect after freezing the window 4 Click Unfreeze in the View tab and you can unfreeze the window 9 5 Window Functions Kingsoft Spreadsheets provides six window functions in the View tab See below fuma _ FR Close Other Windows m New Arrange Split Switch Close Window Window All Windows gt Figure 9 5 1 Window functions in the View tab The window functions are shown as follows 181 Spreadsheets 2013 User Manual New Window To open a new window containing the contents of the current worksheet O Arrange All When there are more than two opened worksheets you can view them horizontally vertically or in cascade by choosing the corresponding option in the drop down list Double click the window head to return to the normal view mode o Split To split worksheet to multiple re sizable panes containing views of the current worksheet Click this icon again to cancel the operation o Switch Windows To switch to the desired window by this icon o Close Other Windows To close other unused windows by this icon o Close Window To close the current window 10 Developer Tab 10 1 Macros To set macros in Kingsoft Spreadsheets follow the steps below 1 Click the Macros icon in the Developer tab or
22. 4 1 6 Print titles 2 In the Sheet tab there are five functions which are shown as follows Rows to repeat at top If you want to print the column label on every page you have to select the row number in which your column label is located in the Rows to repeat at top section O Columns to repeat at top If you want to print the row label on every page you have to select the column number in which your row label is located in the Columns to repeat at top section O Print Gridlines You can choose whether or not to print the grid lines and you can also choose to print only the horizontal grid lines or the vertical grid lines When you choose not to print the grid lines you can print the spreadsheet much faster O Print Row and column headings Select the Row and column headings check box to print the row number and column labels O Page order You can choose the print order of pages Down then over or Over then down 3 Press OK to complete the operation 4 1 6 Breaks If you want to print your worksheet in several pages you can insert breaks in the worksheet Follow the steps below 1 Select the row where you want to insert the break 2 Click the Breaks icon in the Layout tab and select the Insert Page Break option in the Breaks drop down list See below 105 Spreadsheets 2013 User Manual T in Breaks gt DI CaS breaks H Insert Page Break N Page Zoom Figure 4 1 7 The Insert Page Break o
23. 5 Homepage Alt Home Figure 6 2 5 The effect of Convert Text to Columns 153 Spreadsheets 2013 User Manual 6 3 Duplicates The Duplicates function provided by Kingsoft Spreadsheets will help you display data that is duplicated in a single row or a single column It will display a warning when you input duplicated data in a single row or column In addition it can delete the unwanted duplicated data directly and keep the original data The operation steps are shown as follows Click the Duplicates icon in the Data tab We can see there are three options in the drop down list namely Highlight Duplicates Reject Insert Duplicates and Remove Duplicates Oo Highlight Duplicates Select one row or one column and choose Highlight Duplicates in the Duplicates drop down list The Highlight Duplicate dialogue box will open to ask your permission to highlight the cells which contain duplicate contents in orange Then if there is duplicated data in the row or column the corresponding cells will be highlighted o Reject Duplicate Entries Select one row or one column and choose Reject Duplicate Entries in the Duplicates drop down list After selecting it whenever you insert duplicate data into the row or column Kingsoft Spreadsheets will automatically display warning information to remind you that the row or column already contains this data Then you can choose whether or not to insert the data O Remove Duplicates Select one row or one column and
24. A AA A A tee aie A S 102 AZ TIC TVA UI OM sa ah odes asc eeta sea atone a 103 BNR es ce E AT on eee ee ee o ee nO ant Oe a eee re Oe ae ree ee 103 AAA indian 104 AAA ed A a oceatmoe 104 Ay NO A O 105 Alc PACS ZOOM sarees tise cissuse A a E I A TAE 106 RN A O RN 107 421 Arran ee OD UI a deceo 107 SS O ees 108 E E A O O E ee Eee ee eo Tear eM E Te SUN CED More NT ee nee 109 BNO UAE en PE yste cet sumed alba chase E M AETA A E E AEE 110 DS FOrmulas VAD iecciccscccsccsssesecdsdovenTosdenicedecvesesceesSeosdsesveveddasinsdecUscescaestsssussesssacussersasedacsecdeabs aa eieiei 110 9 1 Eormulas Gramma osano dni t 110 ARE MC Reale POS a ias 112 A A a a aa a a Gtmacaatiee 112 APS A we ecaauebianadansauansesestaatele 113 A E N NEEE EA 113 Spreadsheets 2013 User Manual 532 TA Sere P UMC UO tes its naan teat EN a aa 113 5 22 Se Functions tthe Ta Die ni cias 114 De ICH OI CALC oera E E N A E weenie nace 116 EA AS 139 ES Ee en I RE Rennteam en a ee Eee 139 ZUMO COMMITS ses Seca ces tod emanate A ia 140 AN A NS 141 SAMDE td AIMS cal crcl Saisie A EE E E E EA ATTE E eet abet E tomas tac came duieneastans 141 A LEAN NI Sah se cae attra cae ee eaten eek eal a eae eenseeeeeate 142 54 2 De tine Formul NIM ess tanctisideeentaacit tonal E a e a cataiaSea sa Giantauccta deta vaesiocde 142 AA PAS Ue IN AIAG ida 143 9 Calculator 144 de lAutomato Callar E 144 3 1 2 Manual Rec ale ulatl Oni A E A E 145 A UC MAUI siete bent otactesl a a 145 6 Data Tab A
25. Average or the Below Average option the corresponding filter function will be applied to the selected cells To apply the Top 10 AutoFilter follow the steps below 1 Choose the Top 10 option in the Number Filter tab and the Top 10 AutoFilter dialogue box will open and show as below 44 Spreadsheets 2013 User Manual E Top 10 AutoFilter aa Show Top v Items X asa Figure 2 6 8 Top 10 AutoFilter dialogue box 2 Enter the values in the Show section and click the OK button to complete the operation 2 6 1 5 Custom Filter If you want to create a criteria to filter by a data range or filter by some comparison operators more complex than Equal to you can customize the filter function The operation steps are shown as follows 1 Select the data columns 2 Click the AutoFilter icon in the Home tab and choose the AutoFilter option in the drop down list 3 Click the roll down button and choose the Custom Filter option at the bottom of the Text Filter or Number Filter tab See below 2l Al Filter by Value Zoos Not Equal To i Greater Than Mult F Sele Greater Than Or Equal To 7 1101 Less Than Y 1101 Less Than Or Equal To Y 1101 Between 7 1101 a Top 10 V 1101 W 1101 Above Average Vl 1101 Below Average vi 1101 Custom Filter N Y 110119209 Y 110119210 Y 110119211 Wl 110119912 is Top 10 Above Average Below Average Showing all OK Cancel Figure 2 6 9 Custom Fi
26. ExtB Tr Simsun ExtB TFR rA JN _ ee ft Figure 2 2 1 The Font drop down list 2 2 1 2 Font Size Different font sizes can be used within a single document To set the font size follow the steps below 1 Select the cell or text for which you want to set the font size 2 Click the Size drop down list i in the Home tab and select the appropriate font size You can also input numbers between 1 and 409 in the drop down list box and press Enter It is also possible to quickly IncreaseA and Decrease A the font size These icons can be found in the Home tab 2 2 1 3 Font Style Font style represents the format of the characters within the text There are several commonly used control buttons These buttons are used to set the font style of the selected text The functions of these buttons are as follows B Bold Set the selected text in bold or cancels the setting if the text is already in bold I Ttalic Set the selected text in italic or cancels the setting if the text is already in italic U Underline Set an underline for the selected text or cancels the setting if the text is already underlined 26 Spreadsheets 2013 User Manual a Text color Set an appropriate color for the selected text Click the arrow in the icon A and open the drop down list to make the selection The automatic color is black dd Clear clear everything in the selected cell or selectively remove the formats contents or
27. FALSE in argument as 0 TRUE in argument as 1 Returns the average arithmetic mean of all the cells in a range that meet a given criteria Returns the average arithmetic mean of all cells that meet multiple criteria Returns the beta cumulative distribution function Returns the inverse of the cumulative distribution function for a specified beta distribution Returns the individual term binomial distribution probability Returns the one tailed probability of the chi squared distribution Returns the inverse of the one tailed probability 130 Spreadsheets 2013 User Manual Function Name Explanations degrees of freedom of the chi squared distribution CHITEST actual range expected Returns the test for independence range CONFIDENCE alpha standard dev Returns the confidence interval for a population number sample mean using a normal distribution CORREL array 1 array 2 Returns the correlation coefficient between two data sets COUNT valuel value2 Counts how many numbers are in the list of arguments COUNTA valuel value2 Counts the number of cells that are not empty COUNTBLANK range Counts empty cells in a specified range of cells COUNTIF range criteria Counts the number of cells within a range that meet the criteria that you have specified COUNTIFS rangel criteria 1 Counts the number of cells within a range that meet multiple criteria COVAR array 1 array 2 Returns
28. Help and so on See below Spreadsheets 2013 User Manual ETIENNE Home Ins New gt bo Open Save Save As do E Print Print Preview Q Send E mail 2 7 File Information E Backup Management Help Figure 1 4 1 Application Menu 1 4 1 The New Option in the Application Menu Click the Application Menu icon to open the drop down list Choose the New tab and you can see four options listed in the New Workbook section as shown below 5 Spreadsheets Home Insert Page Layout Formulas Data Table Style AS B N De New Workbook by New Blank Workbook Open El E New Excel 2007 2010 Workbook Save fag Eg New from Other Templates gt Save As c Exa ES New from Default Template Print Figure 1 4 2 The New tab Oo New Blank Workbook select this option to create a new blank workbook Oo New Excel 2007 2010 Workbook select this option to create a new 2007 2010 excel workbook O New from Other Templates select this option to open the Templates dialogue box as shown below 12 Spreadsheets 2013 User Manual E Templates mm General Business Education Office Personal Preview Blank Workbook The icon you selected cannot be previewed al Figure 1 4 3 The Templates dialogue box You can choose preferred templates from the General Business Education Office and Personal tabs Click the OK button to create a new workbook by the
29. IES 4 1354 Auto Complete FUNCOM ai ibi 5 Dee Wile LIN AS ica 6 POACH Kan OS Ont OC A A A ads 8 1 3 7 Switching Among Multiple Files by the Unique Tab Feature occccccccnnnnooooononnnnnnnnccnnnanananonnnonos 9 13 3 ide and Snowe th Toolbar vist dedic 11 E A sev A 11 1 4 1 The New Option in the Application MenNU occccccncnnnnnnnnnnnnnnnnnnnnnnninonnnaninnnnnnnnnnnn nono nn nn ono rn nn nnnnnos 12 14 2 The Open Option in the Application Menta id 13 1 4 3 The Save Option in the Application Menta dt 14 1 4 4 The Save As Option in the Application MenNU ococccccnncnnnnnnnnnnnonnnnnnninnnnnnnnnnnannnnn nono non n o nn n nn nro nnnnnnos 14 1 4 3 The Print Option m the Application Menu Ai ee es 16 1 4 6 The Print Preview Option in the Application MenU oooccccccncnnnnnnnnnnnnnnnnnnnnnononnnnnnnaninininnnnnnnnnnos 17 1 4 7 The Send E mail Option in the Application MenNU ccccccnnnnnnnnnnnnnnnnnnnnnnnnninnnnnnnnnnnnnn nono nn nn nn n nano 18 1 4 8 The File Information Option in the Application MenNU oocccnncncnnnnnnonononononononnnnnnnnnnnonnnnnnnnnncnnnnos 18 1 4 9 The Backup Management Option in the Application MeNU ooooocnnnnnnnnnnnnonononnnonononnnnnonnnanannnnnnnnos 20 1 4 10 The Help Option in the Application Men cconnnnnncoouooonnnnncnnnnnonoooonnnnnnnnnnnnnnnnnnrnnnnnnnnnononcnannnnn conos 21 1 4 11 The Options Function in the Application MeNU ooooonnnncnnnnnnononononnnonononnnnnnnnonnnnnononnnnnncnnnnnnnnnnnn
30. NEE EE 146 BUTI Ore Da aenn E ET E T 146 Obs Opendata Tile direc Iy oirionn EE ET E E TE 147 6 1 2 Wse ODBC data Source connection GUI raare e A a 149 0 13 Edi OLE DB Query dal aros 150 6 14 External Data Ranes Properles sil a 151 6 1 3 Refresh Data and Reese 151 0 2 TOO COMAS a 151 A A 154 ASA En A A E E E E E 154 6 Consolidation 156 OD Consolidate Dy LOST a 156 6 5 2 Consolidate Dy Cate Vue ti lla 159 66 GOUD oiana E at 160 OF SSE CAA E T O E E EAE T E E AEAT T 161 Spreadsheets 2013 User Manual 6 8 Show Detail and Hide Detail sissiscscisesticssticGactcetenshinciecdest es avieicativeaitaweecslosisee athe a ara R Eaa 162 09 Form iii 162 AS A aes EE 163 OOS Ti GOA SCC A tales racer acted acdncintiies E nav uiu N ede tdeeh beara 163 Gol 0 ZONE Paracel a dos 164 T Taple Style abusan iia 166 S Review TD si ii a a a E ae A E a aa aa EE N 167 BTC heck SS Ped NN eniin annee EEEE AR A A es 167 0 2 COMMON oaea E E S 169 SAF CEE COMMEN and id dd ai 169 A A cathe cae aia set Cease oes gaat E dered gs tazanees 170 2 Dete COMME dE 170 9 3 Lock Coli a 170 DA Protect serte a Eaa EEES 171 0 9 Protect MN OrKDOOK sat ir reiaade 172 9 6 Share Workbook ui ao 172 8 7 Protect and Share Workboo0K sssessssescssoceccoecccoeccsoecccooeeccsesesoesecoesssoossccsesecsesessesesosesecsesessesessessssssse 173 3 5 Allow Users 10 Edit RANGES RT A ia 174 9 9 Track Chani A 175 VAA A AID O O 176 9 1 View Modena eas 176 ST A A Oe OPO 176 A AA A eer nr
31. P M Returns the minute a number from 0 to 59 Returns the month a number from 1 January to 12 December Returns the number of the workdays except weekends and legal holidays between two dates Returns the current date and time formatted as a date and time Returns the second a number from 0 to 59 Converts hours minutes second given as numbers to a Kingsoft Spreadsheets serial number in date and time format Converts a text time to a Kingsoft Spreadsheets serial number for a time Returns the current date formatted as a date 122 Spreadsheets 2013 User Manual Name Explanations WEEKDAY serial number Returns a number from to 7 identifying the day of return type the week WEEKNUM serial number Returns the number identifying the order of the return_ type week of a year WORKDAY start date number of Returns a date that is the indicated number of days holidays workdays except weekends and holidays before or after a date start date Use this function when calculating the invoice due dates expected delivery date and the number of days you have worked YEAR serial number Returns the year of a date an integer in the range 1900 9999 YEARFRAC start date end date Returns the percentage of the year presented by the basis number of days between two dates start date and end date Use this function to identify the proportion of a whole year s benefits or obligations under some specified
32. Sales worksheet as the target worksheet And select B3 D9 as the target range of data 5 Click the Consolidate icon in the Data tab The Consolidate dialogue box will open and show as below 157 Spreadsheets 2013 User Manual Ej consolidate Function l Sum Y Reference Py Browse All references Use labels in Top row Left column Figure 6 5 4 The Consolidate dialogue box O In the Function box click SUM or the function that you want Kingsoft Spreadsheets to use to consolidate the data Enter the range path in the Reference box Or click the source worksheet and select the range of data to be consolidated Then the range path of the original data will be displayed automatically in the Reference box Click the 2012 Data tab and select B3 D9 as the source range Shown as follows El consolidate a Function Sum Reference 2012 Data 8 3 D 9 FS Browse All references Add Use labels in Top row F Left column Cese Figure 6 5 5 Add the 2012 Data cells area 6 Click Add Then the range will be added in the All References box 7 Repeat the steps mentioned above Add the range of B3 D9 in 2013 Data in the All References box Shown as follows El consolida Function Sum z Reference Fr Browse All references 2012 Data SBS3 5DS9 Add 2013 Data 5B 3 5DS9 Delete
33. Save As Option in the Application Menu Click the Application Menu icon to open the drop down list Choose the Save As tab and you can see seven options listed in the Save a Copy of the Document section as shown below E Spreadsheets Home Insert Page Layout Formulas Data Table Style ze 1 New Save a Copy of the Document ca Kingsoft Spreadsheets Files A Open m Egl Kingsoft Spreadsheets Templates Save a xE Microsoft Excel 97 2003 Files SA Save As N x5 Microsoft Excel 97 2003 Templates Print y XI Microsoft Excel 2007 2010 Files a Print Preview i k Other Formats A Send E mail l ye PE Export to PDF 0 File Information Backup Management Help Options Exit Figure 1 4 5 The Save As tab As you can see you can save the current document as Kingsoft Spreadsheets Files Kingsoft Spreadsheets Templates Microsoft Excel 97 2003 Files Microsoft Excel 97 2003 Templates Microsoft Excel 2007 2010 Files and Other Formats The steps are as follows 1 By choosing any one of them you can open the Save As dialogue box shown as below 14 Spreadsheets 2013 User Manual Save in My Documents amp f gt MID Aimersoft Downloads MathMagic My Data My RTX Files X Video C Equation Sources Desktop ALAA Libraries New folder PADGen RTXC File Lit Snagit Tencent Files LLLA CL Ulead Wondershare HAFIN KAALE SERE VideoStudio PDF to Word Network File
34. Se 7 GL 1 Tee Simple Shapes OGOveOV0CAKRCOVCOABD OOQ MAGVRBSEIAVAOOOC IC 3 Block Arrows OeTflotvrarPrRdAt amp IS my gt DBA Flowchart ae g ganpang uyga SPBXIAVIDADBOO Stars and Banners were Seseenrrzrny Ana Comment Pees 0000 0 40 40 09 10 40 410 JO AO AO Ob Action Buttons Figure 3 4 1 The Shapes drop down list 2 Click the shape that you prefer When the cursor changes into a cross you can draw the shape in the current worksheet Tips After inserting the shape the Drawing Tools tab will show up where you can modify the properties of the shape more detailed information see the corresponding chapters in User Manual of Writer 2013 3 5 Text Box Kingsoft Spreadsheets provides two types of text box Horizontal and Vertical In the Insert tab you can select the Horizontal or Vertical option in the Text Box drop down list When the cursor changes into a cross you can drag it to insert the text box in the current worksheet Right click the text box select the Format Text Box option in the context menu The Set Text box Format dialogue box will open and show as below 91 Spreadsheets 2013 User Manual E Set Text box Format x Font Font Font style Size Times New Roman Regular 12 Symbol 2 Regular 6 s T System Italic 8 E Tahoma Bold 9 ii Tempus Sans ITC Bold Italic 10 Terminal E 11 Fr Times New Roman a 12 Underline Color None v
35. Skip blanks al Transpose ans Figure 2 1 3 The Paste Special dialogue box You can then select the preferred check box in the above dialogue box to set the values for pasting contents 3 You can also paste by pressing lt Ctrl V gt This method will paste all copied content to the designated area 4 Right click on the document to open the context menu you can then select the Paste option there to paste the content 2 1 2 The Cut Function Cut refers to removing the currently selected contents within the file and moving them to the system clipboard where you can paste these contents to other places You can use the cut function by any of the three methods listed below 1 Open the Home tab and click the Cut icon de 2 Press lt Ctrl X gt 3 Right click the selected contents and select the Cut option in the context menu 24 Spreadsheets 2013 User Manual 2 1 3 The Copy Function Copy refers to duplicating the currently selected contents to the system clipboard so that you can paste these contents to other places However the selected contents are still retained in the file You can use the copy function by any of the three methods listed below 1 Click the Copy icon in the Home tab 2 Press the lt Ctrl C gt 3 Right click the selected contents and select the Copy option in the context menu 2 1 4 Format Painter Format Painter is a commonly used tool to replicate formats It can replicate the format
36. TRUE if the value is a number and FALSE otherwise ISODD number Returns TRUE if the number is odd and FALSE otherwise ISREF value Returns TRUE if the value is a reference and FALSE otherwise ISTEXT value Returns TRUE if the value is text and FALSE otherwise N value Returns a value converted to a number NA Returns the error value N A an abbreviation of value not available TYPE value Returns a number indicating the data type of a value Table 5 2 9 Information Functions 5 3 AutoSum Kingsoft Spreadsheets provides AutoSum automatic summary function This makes it more convenient and easy to calculate data in rows and columns You can select calculation options in the AutoSum drop down list 5 3 1 Sum of row s The operation steps are as follows 1 Select the rows which you want to sum See below Home Insert Page Layout Formulas Data Table Style Rev x OGD AAD a Insert AutoSum Recently All Financial Logical Text Date and Looku Function Used Time Refere E H S s v E Booki xlis x A2 x A fr 1 A B C D E F 1 2 1 2009780111 3 2 2009780112 gt 3 2009780113 5 4 2009780114 88 92 6 5 2009780115 92 100 7 6 2009780116 92 95 8 7 2009780117 97 92 Figure 5 2 6 Sum of a row 139 Spreadsheets 2013 User Manual 2 In the Formulas tab click the AutoSum icon and select Sum in the AutoSum drop down list gt dl O ey a A 2 Sum Ag Average ent C
37. The Move or Copy Sheet dialogue box will open and show as below E Move or Copy Sheet Sa Move selected sheets To workbook Book1 xls z Before sheet Sheetl Sheet2 Sheet3 Move to end Create a copy x Cancel Figure 2 10 7 The Move or Copy Sheet dialogue box 3 In the To workbook drop down box select the workbook where you want to put your worksheet If you want to move or copy the selected worksheet into a new workbook select the New workbook option 4 Select the worksheet before which you want to insert or copy the intended worksheet in the Before Sheet list box 5 If you want to copy rather than move the worksheet select the Create a copy check box 6 Click the OK button to complete the operation O Move or copy worksheets by the mouse This method is suitable for moving or copying worksheets that are in the same workbook The steps are as follows 1 Select the worksheets that you want to move 69 Spreadsheets 2013 User Manual 2 Drag the selected sheets along the row of the sheet tabs to the intended position There will be a little dark triangle on the top left of the first tab which indicates the location of the worksheet 3 Select the worksheets that you want to copy 4 Hold the lt Ctrl gt key and drag the sheets to the intended position 5 When the little dark triangle moves to the intended position first release the mouse button and then release the lt Ctrl gt
38. Users to Edit Ranges dialogue box will open and show as below E Allow Users to Edit Ranges Pa Ranges unlocked by a password when sheet is protected Title Refer to cells New Specify who may edit the range without a password Protect Sheet Cancel Figure 8 8 1 Allow Users to Edit Ranges 2 Click New 3 In the New Range dialogue box set the title in the Title enter box select the cell range you wish to allow others to edit in the Refer to cells section and enter the range password in the Range Password section 174 Spreadsheets 2013 User Manual New Range Title Rangel Refer to cells D 4 Br Range password Permissions Cancel Figure 8 8 2 New Range dialogue box 4 Click OK to return to the Allow Users to Edit Ranges dialogue box 5 Click the Protect Sheet button in the lower left corner of the dialogue box 6 Reenter the range password you have set in step 3 twice to protect the selected range 7 Now the selected range has been protected and users have to enter the password to make changes to it 8 9 Track Changes You can use the Track Changes function 1f you want to track the changes made in your worksheet Each reviewer who inserts or deletes data will be recorded when the Track Changes function is turned on Kingsoft Spreadsheets provides the Highlight Changes function in order to distinguish changes made by different users So when you open the wo
39. a deviation u0 Z test Table 5 2 7 Statistic functions 5 2 3 8 Engineering Functions Click the More Functions icon in the Formulas tab and choose the Engineering option in the drop down list There are 39 engineering functions in Kingsoft Spreadsheets See below Function Name BESSELI lambda n BESSELJ lambda n BESSELK lambda n BESSELY lambda n BIN2DEC binary number BIN2HEX binary number places BIN2OCT binary number places COMPLEX real num I num suffix CONVERT number from unit to unit DEC2BIN number places DEC2HEX number places DEC2OCT number places Explanations Returns the modified Bessel function In x Returns the Bessel function Jn x Returns the modified Bessel function Kn x Returns the Bessel function Yn x Converts a binary number to decimal Converts a binary number to hexadecimal Converts a binary number to octal Converts real and imaginary coefficients into a complex number Converts a number from one measurement system to another Converts a decimal number to binary Converts a decimal number to hexadecimal Converts a decimal number to octal 136 Spreadsheets 2013 User Manual DELTA number ERF integral lower bound integral upper bound ERFC integral upper bound GESTEP number alpha HEX2BIN hex places HEX2DEC hex HEX20CT hex places IMABS Inumber IMAGINARY Inumber IMARGUMENT Inumber IMCONJUGATE
40. address If you select more than one cell it will display the first selected cell address Formula Bar The formula bar will display the content you are editing in the cell Rows The rows are labeled with the numbers 1 to 65536 Document List You can easily switch among multiple documents by clicking the Document List icon Columns The columns are labeled with letters in the following pattern A B C Z AA AB AC AZ BA BB BC BZ CA IA IB IV which is the last possible column Active Cell The active cell has a bold border around it and the row and column headers have a deep shading over them It is this cell that receives your keystrokes and commands Spreadsheets 2013 User Manual 1 3 Basic Operations 1 3 1 Operations in Cells Cell is the basic unit for storing data in the spreadsheets You can select copy cut paste edit clear move and join cells 1 3 1 1 Editing in Spreadsheets There are two types of data in Kingsoft Spreadsheets text 1 e Characters or the combination of characters and numbers and number All numeric values can be used to carry out calculations In Kingsoft Spreadsheets the data in text format will be aligned to the left and the data in number format will be aligned to the right by default 1 3 1 2 Inputting Text In Kingsoft Spreadsheets text refers to characters or the combination of characters and numbers To input number as text enter before you enter t
41. and Y by selecting or deselecting the corresponding check boxes See below 85 Spreadsheets 2013 User Manual Category X axis 2014 Middle Term Examination Re Major gridlines sults Minor gridlines 110 Value Y axis 100 Major gridlines 30 E Minor gridlines 80 MScore 1 EScore 2 ib 2009780111 2009780112 2009780113 2009780114 F 2009780115 2009780116 2009780117 a e Figure 3 2 10 The Gridlines tab O Legend tab You can choose to show or hide the legend by the Show legend check box Select the position of the legend in the Placement section The default selection is Right See Score 1 and Score 2 below Y Show legend 2014 Middle Term Examination Re Placement sults Bottom 110 Corner 100 90 80 MScore 1 E Score 2 2009780111 2009780112 2009780113 2009780114 2009780116 2009780117 F 2009780115 Next gt Figure 3 2 11 The Legend tab O Data Labels tab You can add labels to data in this tab Select the Series name Category name and Value check box in the Label contains section to add the corresponding data labels See below Label contains Series name 2014 Mi ddle Term Exa Category name mination Results Value Percentage Bubble size Separator MScore 2 Legend key f Next gt Finish Figure 3 2 12 The Data Labels tab 86 Spreadsheets 2013 User Manual O Data Table tab You can show the data table
42. and so on Some elements such as the legend and data series can be subdivided into separate elements The elements of chart are shown as follows Oo Data Source Refers to the data range you select to create charts Oo Data Series Data series are automatically generated by the group of data which is going to be illustrated on the chart You can choose row data or column data to generate the series O Data Labels To quickly identify a data series in a chart you can add data labels in the chart By default the data labels are linked to values in the worksheet You can set the properties of data labels via the Data Labels tab in the Chart Settings dialogue box Axes Axes are lines on the edge of the charts used to measure and compare data Charts usually have two axes a vertical value y axis and a horizontal x axis Oo Chart Title Chart titles are usually a short description of the chart and it is usually found at the top center of the chart or aligns with the axes automatically Oo Legend Displays the names of the data series in corresponding patterns and colors 82 Spreadsheets 2013 User Manual Chart Title Score 1 A eee Dala Label on A Series MScore 1 Legend Chart Area Axes Figure 3 2 3 Chart structure 3 2 3 Creating Chart To create charts follow the steps below 1 Select the cells that contain the data you want to plot in a chart For example select the cell range as shown below Figure
43. as follows 113 Spreadsheets 2013 User Manual S Insert Function i Sa All Functions Search for a function Or select a category Recently Used v ADDRESS row_num column_num abs_num ai sheet_text Creates a cell reference as text according to the specified row and column numbers a Figure 5 2 1 The Insert Function dialogue box Tips In Kingsoft Spreadsheets there are only seven functions kept by default in the Insert Function dialogue box If there are more the system will automatically delete them But the most recently used one will always be listed at the top 5 2 2 Use Functions in the Table The syntax to call a function is the same The basic format is function name argument 1 argument 2 argument 3 Here are some examples 1 Click the cell where you want to input a function Cell C9 is taken as an example in the following illustration l 2 1 2009780111 89 94 3 2 2009780112 90 96 4 3 2009780113 100 94 5 4 2009780114 88 92 6 5 2009780115 92 100 7 6 2009780116 92 95 8 7 2009780117 97 92 9 a 10 Figure 5 2 2 Select the cell 2 Click the Insert Function icon in the Formulas tab The Insert Function dialogue box will open and show as below 114 Spreadsheets 2013 User Manual E Insert Function E All Functions Search for a function Or select a category Recently Used ee ADDRESS SUM AVERAGE IF COUNT MAX SIN SUMIF
44. as its borders and objects in it will altogether be selected 3 Insert Tab 3 1 Tables 3 1 1 PivotTable PivotTables are dynamic tabulations which allow you to quickly combine and compare data to produce tailored information to suit your needs In pivot tables by rotating rows and columns users can view details from different perspectives In brief pivot tables allow users to simplify complicated data and discover an internal model which otherwise would be difficult to find in a disordered list However it is recommended to use pivot tables only when you have a long list of complicated data and want to analyze the related details Otherwise it is not necessary to use this function To apply the PivotTable function follow the steps below 1 Click the PivotTable icon in the Insert tab GS Spreadsheets d Book1 xls Home Insert Page Layout Formulas Data Table Style Review View Developer s5 E A m Dor AHOA A hn iol FA A 3 Q T OOk e 2 PivotTable Chart Picture Shapes TextBox WordArt Headerand Hyperlink Symbol Equation File Object E El H Selection Footer Pane BES la Bj Book1 xls x Figure 3 1 1 The PivotTable icon 2 In the Select a range section of the Create PivotTable dialogue box choose the data range which you want to base your pivot table If you have already activated a cell in the source data range before 74 Spreadsheets 2013 User Manual performing the first step Kingsof
45. below E Export to Adobe PDF File rx Normal Permission Settings Save to Browse Export range Active sheet O Entire workbook Export options Y Summary information V Hyperlink Z Comment Close when export completes Cancel Figure 1 4 8 The Export to Adobe PDF File dialogue box 2 In the Save to section choose the location where you want to save the current file 3 In the Export range section select the preferred options 4 Click the OK button to complete the operation 1 4 5 The Print Option in the Application Menu To print the file the steps are as follows 1 Click the Application Menu icon to open the drop down list and choose the Print option The Print dialogue box will open and show as below 16 Spreadsheets 2013 User Manual EJ Print a Printer Name SnagIt 9 z Properties Status Ready Type Snaglt 9 Printer Where C ProgramData TechSmithSnaglIt 9 PrinterPortFile Comment _ Manual duplex Inverse output Print to file Page source Use printer setting v Page range Copies O All Number of copies fl Pages From To Print what Selection Entire workbook V Collate O Active sheet Order Multipage output and zoom F Pages per sheet 1 Page x Scale to paper size No scaling x Coon Figure 1 4 9 The Print dialogue box 2 In the Printer section you can choose the preferred p
46. choose Remove Duplicates in the Duplicates drop down list The Duplicated data in the row or column will be removed and only one will be kept 6 4 Validation In order to ensure the accuracy and normative of the input data Kingsoft Spreadsheets provides the validation function to check data and prevent input error This function can make your work more efficient The operation steps are shown as follows 1 Select the cell or cell range which you want to validate 2 Click the Validation icon in the Data tab Then the Data Validation dialogue box will open and show as below 154 Spreadsheets 2013 User Manual Settings Input Message sl Error Alert Validation criteria Allow Any value x Ignore blank Data between Apply these changes to all other cells with the same settings 9 Gema Figure 6 4 1 Set the Data Validation O You can set the Validation criteria in the Settings tab O You can set the display information when you select the cell in the Input Message tab See below O You can set the warning information when you input invalid data in the Error Alert tab T Settings InputMessage Error Alert Y Show input message when cell is selected When cell is selected show this input message Title Tips Input message Please enter number between 20 and 40 Figure 6 4 3 Set the input message 3 Press OK to complete the operatio
47. chosen template O New From Default Template Select this option to create a new workbook by the default template a blank workbook here 1 4 2 The Open Option in the Application Menu Click the Application Menu icon to open the drop down list and choose the Open option The Open dialogue box will open and show as below E Open Look in My Documents gt teh bh ih Recent Places Aimersoft Downloads MathMagic My Data My RTX Files dl Video C Equation Sources shh UU Oo 0025 Libraries New folder PADGen RTXCFileList Snagit Tencent Files Computer Ii A i 1 i J gt a Ulead Wondershare SUH F2Zi5452 SRE VideoStudio PDF to Word Network File name Files of type Common Files et ett ads dt dsx Figure 1 4 4 The Open dialogue box Choose the intended document in the Open dialogue box and click the Open button at the right bottom to open the document 13 Spreadsheets 2013 User Manual Tips You can also open the intended document by clicking the Open icon at the top left corner of the screen or press lt CtrI O gt 1 4 3 The Save Option in the Application Menu There are three ways to save the changes you have made to the current workbook 1 Click the Application Menu icon to open the drop down list and choose the Save option 2 Click the Save icon E at the top left corner of the screen 3 Press the shortcut combination lt Ctrli S gt 1 4 4 The
48. click the Form icon in the Data tab The Form Data dialogue box will open with the worksheet title as 1ts name See below 162 Spreadsheets 2013 User Manual A B C D 1 No IGOODS PRICE AMOUNT El Sheets 2 A001 Toy 12 3 3 A002 Toy 15 2 oe 4 A003 Toy 17 4 a OY 5 A004 Pen 9 2 iian E 6 A005 Pen 15 3 saci 7 A006 Pen 12 1 8 A007 Box 4 5 ec 9 A008 Box 3 10 10 Find Next Criteria 13 Close 14 15 Figure 6 9 1 The Form function 2 The data in each row will be displayed together and in separate categories on the left side of the dialogue box 3 You can click the New button at the right side to add new data in the worksheet 4 You can click the Delete button to remove the current displayed data from the worksheet 5 You can view previous or next row of data by clicking the Find Prev and Find Next button 6 You can click Criteria to set the criteria 7 Click Close to exit the dialogue box 6 10 What If Analysis Kingsoft Spreadsheets provides the what if analysis function which includes Goal Seek and Solver Parameters 6 10 1 Goal Seek Kingsoft Spreadsheets provides the Goal Seek function to obtain the value in the changing cell when a result value is assumed for a formula For example an employee has already known the product sales price is 80 and the product cost is 50 and he wants to know how much is the product sales when the expected total profit reaches 15000 To use this fun
49. code p election O Selection Pane Click this icon to open the Selection Pane task window on the right side where you can easily locate a specific object and set its order and visibility 101 Spreadsheets 2013 User Manual 4 Layout Tab 4 1 Page Setup You can use the Page Setup dialogue box to set the Page Margins Header and Footer and Sheet to meet your requirements 4 1 1 Margins To set the margins of the worksheet follow the steps below 1 Click the Margins icon in the Layout tab The Margins tab in the Page Setup dialogue box is shown as below g Page Setup f x Page Margins Header and Footer Sheet Top Header 2 54 1 30 Left Right in E 1 91 Bottom Footer Unit Centimeters 2 544 E 1 30 Center on page Horizontally Vertically Options Print Cancel Figure4 1 1 The Margins tab 2 In the Margins tab you can Oo Control the spacing of margins by editing the Top Bottom Left and Right options O Control the margins between the header and the top of the page or the footer and the bottom of the page by inputting numbers in the Header and Footer spinner O In the Center on page section set the way you want your table to be centered You can select Horizontally or Vertically options according to your requirements 3 Click the OK button to complete the operation Or click the Cancel button to exit 102 Spreadsheets 2013 User Manual 4 1 2 O
50. covariance the average of the products of paired deviations CRITBINOM trials probability s Returns the smallest value for which the alpha cumulative binomial distribution is greater than or equal to a criterion value DEVSQ number 1 number 2 Returns the sum of squares of deviations EXPONDIST x x return the Returns the exponential distribution cumulative distribution function FDIST value x degrees freedom 1 Returns the F probability distribution Use this degrees freedom 2 function to determine whether two data sets have different degrees of diversity FINV distribution probability Returns the inverse of the F probability degrees freedom 1 degrees freedom 2 distribution 131 Spreadsheets 2013 User Manual Function Name Explanations FISHER number Returns the Fisher transformation FISHERINV number Returns the inverse of the Fisher transformation FORECAST x known _y s Returns a value along a linear trend known_x s FREQUENCY data array bins array Returns a frequency distribution as a vertical array FTEST array 1 array 2 Returns the result of a F test GAMMADIST number alpha beta Returns the gamma distribution return the cumulative distribution function GAMMAINV distribution probability Returns the inverse of the gamma cumulative alpha beta distribution GAMMALN number Returns the natural logarithm of the gamma function I x GEOMEAN number 1 number
51. given periodic cash flows MIRR takes both the cost of investment and the interest received on reinvestment of cash into account 116 Spreadsheets 2013 User Manual Function Name Explanations Returns the number of payment periods for an NPER rate pmt pv fv type investment based on periodic constant payments and a constant interest rate Returns the net present value of an investment using a NPV rate valuel value2 discount rate and a series of future periodic payments and income Returns the payment for a loan based on constant PMT rate nper pv fv type payments and a constant interest rate Returns for a given period the payment on the principal PPMT rate per nper pv fv for an investment based on periodic constant payments and a constant interest rate PRICE transaction date Returns the price per 100 face value of a security that maturity date rate yid pays periodic interest redemption Returns the present value of an investment calculating PV rate nper pmt fv type from a series of future payments RATE nper pmt pv fv type Returns the interest rate per period of an annuity SLN cost salvage life Returns the linear depreciation of an asset per period Returns the sum of years digits depreciation of an asset SYD cost salvage life for a specified period which is based on its cost salvage period value and anticipated life Returns the depreciation of an ass
52. in the chart by selecting the Show data table check box in this tab See below ra EAA he agen Chant Settir Data Table _Tites Axes Gridines Legend Data Labels Show data table Show legend keys 105 100 95 90 85 Next gt Figure 3 2 13 The Data Table tab 6 Click the Finish button to complete the operation You can then the current worksheet See below 2014 Middle Term Exa mination Results MScore 1 MScore 2 insert the chart you have specified in p pmd O 2014 Mid term Examination Results ee Unida bo bh Figure 3 2 14 Chart 3 2 4 Chart Tools Tab 2009780111 2009780112 2009780113 2009780114 2009780115 2009780116 2009780117 Student Mo 5 Spreadsheets J Book1 xls a 50 x Home Insert Page Layout Formulas Table Style Review View Developer Chart Tools So Sy a 0 Change i Format Chart Data Table Legend Select Switch S Chart Type Data Row E H SA s y Bl Booki xs x r Q fx No 5 A B E D E F G H I J K L M N O P Q R Ez Fie 3 4 nr 5 r 6 e 7 8 9 MScore 1 MScore 2 111 After you have inserted the chart into the current worksheet the Chart Tools tab will appear at the top of the screen See below 87 Spreadsheets 2013 User Manual amp Spreadsheets Si Book1 xls Home Insert Page Layout Formulas Data Table Style Review View Developer Chart Tools 3 Chart Area ES Mm Ml co mE E a o g Change f
53. key You can also release them at the same time E29 x Q fx A B E D 1 4 1 2009780111 89 94 5 2 2009780112 90 96 6 3 2009780113 100 94 7 4 2009780114 88 92 8 5 2009780115 93 100 6 2009780116 92 95 10 72009780117 97 92 i gt sheet _ sheet2 Sheet3 Figure 2 10 8 Before moving E29 Q fx A B E D 1 gt 3 No Student No Scorel Score2 4 1 2009780111 89 94 5 2 2009780112 90 96 6 3 2009780113 100 94 7 4 2009780114 88 92 8 5 2009780115 93 100 9 6 2009780116 92 95 10 7 2009780117 97 92 Sheet2 _sheeti_ sheets da a Figure 2 10 9 After Moving G26 7 AQ fx A B E D 1 gt 4 1 2009780111 89 94 5 2 2009780112 90 96 6 3 2009780113 100 94 7 4 2009780114 88 92 8 5 2009780115 93 100 9 6 2009780116 92 95 10 7 2009780117 97 92 4 _ Sheeti Sheet2 stes o sheets pu Figure 2 10 10 Copying the worksheet 70 Spreadsheets 2013 User Manual 2 10 7 Tab Color You can set the tab color for the worksheets by the following steps 1 Select the worksheets that you want to set the tab color 2 Click the Worksheet icon in the Home tab and select the Tab Color option in the drop down list 3 Choose the preferred tab color in the drop down menu as shown below EN i FA Insert Sheet fH Delete Sheet Be Protect Sheet ler Rename ES Move or Copy Sheet bed Tab Color lt Hide and Unhide Worksheet Findand Settings o PE EIA r No Color BER EEeeD BER g AE q
54. offers 11 types of charts and you can choose the appropriate one to best convey what you want to express effectively They are the Column chart Bar chart Line chart Pie chart XY Scatter chart Area chart Doughnut chart Radar chart Bubble chart Stock chart and Custom You can choose different styles and colors for each type of charts See below 80 Spreadsheets 2013 User Manual Te CATE ma rngsocz 2 a i Oog 3 d DOONBOS 4 BHE 5 mos 5 o 4 7 4 Pie Charte D Score 4 o Score 3 OScore 2 Score 1 1 q one A a re 1 Score 7 Store 4 DMBOG01 1 NEOO 2 nwo 3 Seo 4 NBOOS 4 Soto Doughnut Chart Radar Charts i Score 4 Score Score 3 Score 7 140 Seot l Score MO E 0 Stock Charta Column Charts 4 Figure 3 2 1 Chart types Click the Chart icon in the Insert tab and the Chart Type dialogue box will open and show as below You can modify chart settings there 81 Spreadsheets 2013 User Manual Chart Type Ea Chart types Expand all types Chart Title pie Es XY Scatter v b Area x Doughnut M History Radar X 3 gt Bubble i lt Stock X Custom bf Add to Custom Type Set as Default Chart lt Back Finish Figure 3 2 2 Chart Type dialogue box 3 2 2 Chart Structure A chart is composed of the chart area and other elements in the area such as the chart title legend axes
55. results Smart Contraction Figure 1 3 2 Smart Contraction 1 3 4 AutoComplete Function The AutoComplete Function makes it easier to enter the same or similar data into different cells This can improve the speed and efficiency of data entry To apply this function the steps are as follows 1 Find the Application menu Spreadsheets and click Options at the bottom right corner 2 Select the Edit tab in the Options dialogue box and select the Enable AutoComplete for cell values check box shown as below Edit settings J Move selection after Enter Direction Calculation Fixed decimal Places 2 Y Enable AutoComplete for cell values General and Save Y Allow cell drag and drop Edit ee ee Y Replace Internet and network paths with hyperlinks as you type Pl Trace hyperlinks with Alt key pressed Color Security Error Checking Spelling Figure 1 3 3 Select Enable AutoComplete for cell values check box 3 When you enter the first character of similar content the system will automatically provide a Spreadsheets 2013 User Manual drop down list for you to choose from 1 3 5 Switching Skins As you might already know Kingsoft Office offers three skin interface styles 2013 Elegant Black 2013 Water Blue and Classic Style Both Office Free 2013 and Office Professional 2013 support to switch skins among the three styles Follow these two methods to choose your fa
56. shape which allows you to draw border grid 21 Spreadsheets 2013 User Manual lines for the selected cell area e Erase Border Click the Draw Border icon and select the Erase Border option The mouse will then change into an eraser and you can erase the border of the selected cell area o Line Color Select a preferred color for the border line in the drop down menu The automatic color is black Line Style Select a preferred style for the border line in the drop down menu The automatic style is straight line An alternative method to set cell borders is by the Format Cells dialogue box 1 Select the preferred cell area 2 Click the Other Borders icon HH in the Home tab and select the More Borders option at the bottom of the drop down list Choose the Border tab in the Format Cells dialogue box 3 You can set the print display of the outside border and inside border in the Presets section 4 Select the style of border lines in the Style drop down list 5 Select the color of border lines in the Color drop down list 6 Complete the operation by pressing the OK button at the bottom E Format Cells Number Alignment Font Border Patterns Protect gt Presets Outline Inside The selected border style can be applied by clickinz the presets preview diagram or the buttons above eS Figure 2 2 3 Set the border in the Format Cells dialogue box 28 Spreadshe
57. the category X axis and the category Y axis in the corresponding enter box See below CLP E E Chart Settings x Titles Axes Gridines Legend Data Labels Data Table Chart title SS a idle Term Examination Results eee ees a Category X axis 110 Student No E 100 Macara 1 Value Y axis 90 MScore 2 Scorel 80 Speen O coma Sooo 00 00 oo 0 Go 20 ree bt tt bh ot vta Gs De ea Oy ome etal cat pI o A Pf er oS Gar Ge ee eee CUALES ELE EM 2c Student No l Cancel lt Back Next Figure 3 2 8 The Titles tab O Axes tab Select the way you prefer to display the primary axis X and Y by the check box Axis Y usually displays the values of the data You can choose to automatically display axis X or to display axis X by category or in the mode of time scale See below CARTA Chart Settings exa A _ _ 5 Tites Axes Gridlines Legend Data Labels Data Table Primary axis E z Esad 2014 Middle Term Examination Re J Category X axis sults Automatic 110 O Categor Ti E E 100 MScore 1 7 ime scale amp 90 i E Score 2 Y Value Y axis 80 o tiene peste ged 2229292939 0 oo CO CO wo OR eee ee tb oO Och Sk ee pore es me Jo se De a LS Ca Gal Ge Ge Gol EA Cae EME EUR So oa Student No Cancel lt Back Next gt Figure 3 2 9 The Axes tab O Gridlines tab You can choose to show or hide the major and minor gridlines in axis X
58. the contents in the above cells or rows to the lower position Right insert the contents in the left cells or columns to the right Up insert the contents in the lower cells or rows to the upper position Left insert the contents in the right cells or columns to the left Tips The difference between filling with duplicated data and filling with sequence data lays in that 1f you want to fill the cells with duplicated data you have to press lt Ctrl gt and drag the fill handle at the same time if you only drag the fill handle the system will automatically fill the cells with sequence data 2 9 6 4 Across Sheets The operation steps are as follows 1 Select the data that you want to fill into other worksheets within the same workbook 61 Spreadsheets 2013 User Manual e amp Spreadsheets Home Insert Page Layout Formulas Data Table Style Cut Times New Roman 12 NA C Copy Format B I UE HE A A 4 Painter lil lil E H S amp 6 Book1 xs x A3 x Q fx No A B C D E 1 2 3 gt 1 2009780111 89 5 2 2009780112 90 6 3 2009780113 100 7 4 2009780114 88 8 5 2009780115 93 9 6 2009780116 92 95 10 7 2009780117 97 11 Figure 2 9 9 Select the intended data 2 Press lt Shift gt and select the worksheet you want to fill with the data 3 Select the Across Sheets option in the Fill drop down list There are three options in the Fill Across Worksheets dialogue box as s
59. the cumulative lognormal distribution function of x where In x is the normal distribution of parameters mean and standard dev Returns the cumulative lognormal distribution Returns the largest value in a set of values ignore text values and logical values Returns the largest value in a list of arguments including numbers text and logical values Returns the median of the given numbers Returns the smallest number in a set of values ignore text values and logical values Returns the smallest value in a list of arguments including numbers text and logical values Returns the most frequently occurring or repetitive value in an array or range of data Returns the negative binomial distribution Returns the normal cumulative distribution Returns the inverse of the normal cumulative distribution Returns the standard normal cumulative distribution Returns the inverse of the standard normal 133 Spreadsheets 2013 User Manual Function Name PEARSON array 1 array 2 PERCENTILE array percent PERCENTRANK array number num digits PERMUT number number chosen POISSON number arithmetic average return the cumulative distribution function PROB x range prob range lower bound of the x range upper bound of the x range QUARTILE array quartile RANK number ref order RSQ known y s known x s SKEW number 1 number 2 SLOPE known _y s known_x s SMALL array k ST
60. the drop down list Click the Options icon at the bottom right and open the Options dialogue box Choose the Edit tab in the dialogue box as shown below 58 Spreadsheets 2013 User Manual E Options View Edit settings a Y Move selection after Enter Direction Down y Calculation we Fixed decimal Places Edit W Enable AutoComplete for cell values General and Save Y Allow cell drag and drop pom ticte Y Replace Internet and network paths with hyperlinks as you type Trace hyperlinks with Alt key pressed Color Security Error Checking Spelling Privacy cancel Figure 2 9 8 The Edit tab 2 Select or deselect the Allow cell drag and drop check box to turn on or turn off this function 2 9 6 2 Fill Data by the Fill Handle There are two types of data series commonly used to fill cells in Kingsoft Spreadsheets The first type includes years months weeks quarters and other text type sequences For text type sequences all you need is to enter values in the first cell and then drag the fill handle O to accomplish the filling The operation steps are as follows 1 Select the cell range 2 Move the mouse to the lower right corner of the data field and the pointer will change into a cross 3 Drag the cross down to the last cell in the cell range and release the mouse The result is shown as follows 59 Spreadsheets 2013 User Manual amp Spreadsheets Home Insert Page Layout For
61. this icon to show all items of the active field Hide Detail Click this icon to hide all items of the active field o Field Settings Click this icon and the PivotTable Field dialogue box will open 71 Spreadsheets 2013 User Manual Name Stuendt No Subtotals Display Subtotals Automatic Sum Custom Count None Average Max Min Product Count Numbers StdDev StdDevp Var x a Figure 3 1 8 The PivotTable Field dialogue box In the Subtotals tab you can select the options offered to calculate a subtotal Name StuendtNo Subtotals Display Display Show items Show all 2009780111 2009780113 v 2009780112 v 2009780114 v 2009780115 v 2009780116 v 2009780117 Y A A E Y Y Y F Show items with no data E Figure 3 1 9 The Display tab In the Display tab you can select to display the items which you prefer Select the Show items with no data check box and only those items with no data will be displayed When you select a field in the pivot table you can choose the type of calculation to summarize data in that field See below 78 Spreadsheets 2013 User Manual PivotTable Field Source field Score 1 Name Sum of Score 1 Summarize Values By Summarize value field by Choose the type of calculation that you want to use to summarize data from the selected field Sum a Count Ave
62. to modify an existing format click Modify and the Format Cells dialogue box will open where you can change the patterns border font etc Press OK to return to the Style dialogue box 6 Click the OK button to complete the operation To add new styles follow the steps below 1 Select a range in your worksheet 2 Choose the Styles option in the Format drop down list to open the Style dialogue box see Figure 2 8 3 3 Enter a name for the new style in the Style name section and then press Add Style name newstyle x Style indudes Number General Alignment Horizontal General Vertical Vertical Center Aligned Orientation Horizontal Reading Order Context Reading Order Font Font Times New Roman Size 12 Add Border No Borders Patterns No Shading Protection Locked Cancel Modify Figure 2 8 4 Add a new style 4 Click Modify to set the values of the new style in the Format Cells dialogue box Click OK to return to the Style dialogue box 5 Click the OK button to complete the operation 2 8 4 Clear Select the Clear option in the Format drop down list or click the Clear icon in the Home tab and you can see that Kingsoft Spreadsheets provides four types of clear options 53 Spreadsheets 2013 User Manual O All Select the cells that you want to clear Choose the All option in the Clear drop down list You can then clear all the contents in the selected cells O Formats Select the cel
63. u cia eee eae 65 DMO 2 MAG CTA OSC CUS 5 fi5 oes ace fs tet et A ee ere edo decks 66 wae UBS Deena EE eae De ee ee eee Rn SREP Se a STD CEA Oe one ee a 67 DMAP TOL CUS CCU iy haa keane O A A een ane waeaeaeeeeas 68 DVO SAIS MAINO FS MCC Coa tire atet cok athe cetrades J B washed A oda aed ahaa iets 68 ZOO MOV Ot C Op yi SAL oia doi es 69 AS O O 71 Z2 10 8 Tide and SOO Wii O AC article anal is 71 A cas lt cgssacatvescactscswseunsavesdessvases geananesdusuyangetuvsauaecoesuseusssavouedossseansss oiseuasnsoneeseaiocussaveraeussvenss 72 A Aint E E cane tae ecient een ia A te tatualoees 72 A A rancid antecadas E A wate tanta utp ote cee eae ta 12 A A A A di ent inte ise eaeanets 73 DNA O A A 73 MSC Tabaco Io AA Ir A si 74 A RN 74 Dd dol AAA o ROS 74 S2 C A O 79 Ue ak D C E A eth OU ne Pe te WO Pe ey eee Ce ne te 80 A EDU o EU UU et ek dss Miho a a 82 ER rean E BAr aa E A errea aaa aula augaeaet len simc ese agua oe 83 IZAC ha TOOLS WA sarsct A RN 87 izo RUSO Cata SA al 88 E A re eS ee ny rn re nee Sue ree eee eee On ee i eee 90 ASMA DOS o rat 90 Bo WOKE A OO 91 Spreadsheets 2013 User Manual S6 Word Aru E setae ciedbowsencusehccubeti aueedstbazeds 92 Sef Header amp Foot iii aa iodo 93 2 0 perl 94 Sl recae AP dll lis 94 3 8 2 Group Create and Cancel My peri Ss a 96 A RO 97 A AN 98 3 11 Insert ODE A A A A ARS 99 3 12 Inser PIE ODD CCE eiior aa TE E EE EE 99 313 sert AO ADE ii AAA A aT 100 LAVO Uut Lab ida 102 A O TEE 102 MN UNM OM
64. use when t condition is true ormat Add gt gt Delete ds Cancel Figure 2 8 1 Conditional Formatting dialogue box 6 You can add other conditions to the selected cell by clicking the Add button at the bottom and repeating the operation above 2 8 3 Style In Kingsoft Spreadsheets you can use the built in styles directly To use these styles follow the steps below 1 Select the cells to which you want to apply a style 2 Click the Format icon in the Home tab and choose the Styles option in the drop down list MA m E EDI Forma Rows and y Fi Format Rows and Worksheet Fi Convert Text to Number F Convert Text to Hyperlink E Conditional Formatting OS Styles iS El Lock Cel Mo Clear Ep Cells Ctrl 1 Figure 2 8 2 The Styles option 52 Spreadsheets 2013 User Manual 3 The Style dialogue box will open and show as below S Style Ea Style includes ar ance Number General Alignment Horizontal General Vertical Vertical Center Aligned Orientation Horizontal Reading Order Context Reading Order Font Font Times New Roman Size 12 Border No Borders Patterns No Shading Protection Locked Nedra Figure 2 8 3 Style dialogue box 4 There are six styles in the Style name drop down list Comma Comma 0 Currency Currency 0 Normal and Percent Choose one from the list and you will see its styles in the Style includes part 5 Ifyou need
65. with hyphens One product key can be used to activate three PCs To install and activate Kingsoft Office 2013 follow the steps below 1 Run the installer and follow the instructions in the wizard to start installing Kingsoft Office 2013 to your computer 2 In the third step of the installation wizard enter the product serial number you have purchased Product Serial Number Please enter the serial number of Kingsoft Office 2013 Please enter the serial number of your purchased copy of Kingsoft Office 2013 to activate the product Product Serial Number O Trial Enter Serial Number 22GHC XXXXX XXXXX XXXXX XXXXX How to obtain the serial number Thank you for choosing our product Ead Cancel Figure 1 3 8 Enter product serial number 3 Press Next in the following steps After the installation your office 2013 is successfully installed and activated To add serial number to Office 2013 follow the steps below 1 If you already have Office 2013 free trial version installed then simply open one of the three Office components Writer Spreadsheets or Presentation Spreadsheets 2013 User Manual 2 Click the Help button to open the Product Management Center 3 Click the Add button to enter your product key and click OK to finish Product Management Center es Product Management Center Add Delete Serial Number Programs that can be activated Serial Number Entry Please enter t
66. you can input the query statement directly lt n Figure 6 1 3 The third step Data filtering and sorting 6 You can choose sorting by field or in order You can also set the filtering field filtering condition and filtering range in the filtering and sorting dialogue box You can enter the query statement directly as well If you want to perform a more complicated sorting and filtering operation you can click Advanced Query 7 Click Next and The fourth step Preview dialogue box will open and show as below Import operation result Connect string e Provider Microsoft Jet OLEDB 4 0 Password User ID Admin Data Source C Users admin Desktop book3 xls Mode Share Deny Write Extended Properties HDR YES Jet OLEDB System database Jet OLEDB Registry Path Jet OLEDB Database Password Jet OLEDB Engine Type 35 Jet OLEDB Database Locking Mode 0 Jet OLEDB Global Partial Bulk Ops 2 Jet OLEDB Global Bulk Transactions 1 Jet OLEDB New Database Password Jet OLEDB Create System Database False Jet OLEDB Encrypt Database False Jet OLEDB Don t Copy Locale on Compact False Jet OLEDB Compact Without Replica Repair False Jet OLEDB SFP False Query string is Import data preview Display only top 50 H Criteria Extract itl driver manager policeman teacher singer m Figure 6 1 4 The fourth step preview dialogue box You can preview the worksheet into which you ve inserted external data i
67. 0 Display the result of AutoSum 5 4 Define Names In the Kingsoft Spreadsheets you can name a cell range You can also name a formula or constant A name is a meaningful shorthand that makes it easier to understand the purpose of a cell range formula or constant which may be difficult to comprehend at first glance The following is a list of syntax rules that you need to be aware of when creating and editing names O The first character of a name must be a letter or an underscore _ Remaining characters in the name can be letters numbers periods and underscore characters Names cannot be the same as the cell reference Oo Spaces are not allowed as part of a name Use the underscore character _ and period as word separators A name can contain uppercase and lowercase letters However Kingsoft Spreadsheets does not distinguish between uppercase and lowercase letters For example if you create the name ABC and then create another name abc in the same workbook Kingsoft Spreadsheets will remind you to choose a unique name 5 4 1 Define Name Defining the name for selected cells will make it easier to refer to the contents in the cell To define a cell name follow the steps below 141 Spreadsheets 2013 User Manual 1 Select the cells which you want to define 2 In the Formulas tab click the Name Manager icon and the Define Name dialogue box will open and show as below Ej Define Name Em
68. 100 I 2012 2013 Data Statistic Score 1 Score2 Score 3 198 197 194 189 192 187 193 197 192 196 189 197 198 189 Horizontal page break line Figure 9 1 2 Workbook divided into two pages You can drag the horizontal page break line and vertical page break line to adjust the size of the entire page 177 Spreadsheets 2013 User Manual 9 1 3 2 Manual Page Break If you don t set values in the Adjust to section of the Page tab the worksheet will be separated into several pages according to your specified width when you click Page Break Preview in the View tab At this moment you can put the pointer on the horizontal or vertical page break line See below A 2013 Data 2012 Data Name Score 1 Score2 Score3 Score 4 I Score 1 Score2 Score3 NB 001 NB 002 NB 003 NB 004 NB 005 NB 006 NB 007 2012 2013 Data Statistic Scorel Score2 Score 3 197 198 198 197 194 189 193 192 187 190 193 197 196 192 196 189 189 197 199 198 189 Figure 9 1 3 Point to the vertical page break line By dragging the mouse you can move the horizontal and vertical page break line freely and you can enlarge the width of separated pages and increase the number of separated pages by doing that 9 1 4 Full Screen Click the Full Screen icon in the View tab the worksheet will be displayed in full screen with all the tool bars hided Click the Close button at the top right corner of the screen or press lt Esc gt on the keyboard to
69. 2 Returns the geometric mean of an array or range of positive numeric data GROWTH known y s known_x s Returns values along an exponential trend new_x s const HARMEAN number 1 number 2 Returns the harmonic mean of a data set HYPGEOMDIST sample s number Returns the hypergeometric distribution sample population s number population INTERCEPT known y s known x s Returns the intercept of the linear regression line KURT number 1 number 2 Returns the kurtosis of a data set LARGE array k Returns the k th largest value in a data set LINEST known _y s known_x s const Returns the parameters of a linear trend stats LOGEST known ys known x s Returns the parameters of an exponential trend 132 Spreadsheets 2013 User Manual Function Name const stats LOGINV distribution probability arithmetic average standard deviation LOGNORMDIST number arithmetic deviation standard deviation MAX number 1 number 2 MAXA number 1 number 2 MEDIAN number 1 number 2 MIN numberl number 2 MINA number 1 number 2 MODE number 1 number 2 NEGBINOMDIST number f number s probability s NORMDIST number arithmetic average standard deviation return the cumulative distribution function NORMINV distribution probability NORMSDIST number NORMSINV distribution probability Explanations Returns the inverse of
70. 2 2 If you don t want to show grid select the Show Grid one more time in the Align drop down list 4 2 3 Group You can group shapes pictures and other objects Grouping allows you to rotate flip move and re size all shapes and objects at the same time as if they were a single shape or object The operation steps are as follows 1 You can hold lt Ctrl gt when clicking to select multiple objects 2 In the Page Layout tab select Group in the Group drop down list See below 109 Spreadsheets 2013 User Manual Figure 4 2 3 The Group drop down list 3 Select Ungroup in the Group drop down list to ungroup the multiple objects 4 2 4 Rotate In order to allow you to freely edit pictures Kingsoft Spreadsheets provides Free Rotate Rotate Left 90 Rotate Right90 Flip Horizontally and Flip Vertically options The operation steps are shown as follows 1 Select the pictures which you want to edit 2 In the Layout tab click the Rotate icon to open the drop down list Choose the rotate style that you prefer according to your needs See below Free Rotate AL Rotate Left 90 2h Rotate Right 90 Ah Flip Horizontal lt Flip Vertical Figure 4 2 4 The Rotate drop down list 5S Formulas Tab Formulas are equations that are used to analyze and calculate the numeric values You can use a formula which usually begins with an equal mark to perform some simple calculations such as addition subtrac
71. 3 Then Kingsoft Spreadsheets will automatically spell check the worksheet and remind you when the spell check has been completed See below E Spreadsheets xa A Check spelling is complete Figure 8 1 2 Complete the check spelling You can also set language for the spell check follow the steps below 1 Choose the Set Language option in the Check Spelling drop down list See Figure 8 1 1 2 The Set Language dialogue box will open and show as below E Set Language Available Languages English United Kingdom English United States The speller automatically use dictionaries of the selected Ga language if available Figure 8 1 3 The Set Language dialogue box 3 Choose the preferred language in the Available Languages list box 4 You can click Set as Default to set the chosen language as the default language for spell check 5 Click Close to complete the operation To set the dictionaries for check spelling follow the steps below 1 Open the application menu S Spreadsheets the top left corner of the screen Click Options at the right bottom 2 Open the Spelling tab in the Options dialogue box See below 168 Spreadsheets 2013 User Manual 5 Options View Spelling C Always suggest corrections Y Ignore words in uppercase Edit Ignore words with numbers General and Save Customize dictionaries Custom Lists Name Default Folder Double click to open folder
72. 3 2 4 Select the data area 2 Click the Chart icon in the Insert Tab The Chart Type dialogue box will pop up 3 Select the suitable chart type in the Chart Types section Here we choose the Clustered Column in the Column chart group See below 2500000000 2000000000 1500000000 No MStuendt No MScore 1 1000000000 E Score 2 500000000 le 2 J 83 Spreadsheets 2013 User Manual Figure 3 2 5 Select chart type 4 Click the Next button to open the Source Data dialogue box There are two tabs in the dialogue box Data Range and Series The Data Range tab is used to modify the data range of the chart while the Series tab is used to change the name values and category x axis labels of the data range MScore 1 MScore 2 Data range Sheet21 C 3 0 10 Series in A Rows 9 Columns Figure 3 2 6 Select the data range You can select the data range and series in the corresponding sections in Figure 3 2 6 MScore 1 MScore 2 Category 00 axis labels Figure 3 2 7 The Series tab 84 Spreadsheets 2013 User Manual Choose to add or remove series by the Add and Remove button Select the Name Values and Category X axis labels areas in the corresponding sections in Figure 3 2 7 5 Click the Next button to open the Chart Settings dialogue box containing 6 tabs where you can specify the settings of the chart O Titles tab Enter titles for the chart
73. 37 Spreadsheets 2013 User Manual OCT2BIN octal number Converts an octal number to binary places OCT2DEC octal number Converts an octal number to decimal OCT2HEX octal number Converts an octal number to hexadecimal places Table 5 2 8 Engineering Functions 5 2 3 9 Information Functions Click the More Functions icon in the Formulas tab and choose the Information option in the drop down list There are 16 information functions in Kingsoft Spreadsheets See below Function Name Explanations CELL info_type ref Returns information about the formatting location or contents of a cell ERROR TYPE error_val Returns a number corresponding to the given error value or returns the N A if no error exists ISBLANK value Returns TRUE if a value refers to an empty cell and returns FALSE otherwise ISERR value Returns TRUE if the value is any error value except N A and returns FALSE otherwise ISERROR value Returns TRUE if the value is an error value and returns FALSE otherwise ISEVEN number Returns TRUE if the number is even and returns FALSE otherwise ISLOGICAL value Returns TRUE if the value is a logical value and returns FALSE otherwise ISNA value Returns TRUE if the value is the N A error value and returns FALSE otherwise ISNONTEXT value Returns TRUE if the value is not text and FALSE otherwise 138 Spreadsheets 2013 User Manual Function Name Explanations ISNUMBER value Returns
74. ANDARDIZE number arithmetic average standard deviation STDEV number 1 number 2 STDEVA number 1 number 2 Explanations cumulative distribution Returns the Pearson product moment correlation coefficient Returns the k th percentile of values in a range Returns the rank of a value in a data set as a percentage 0 1 exclusive of the data set Returns the number of permutations for a given number of objects Returns the Poisson distribution Returns the probability that values in a range are between two limits Returns the quartile of a data set Returns the rank of a number in a list of numbers Returns the square of the Pearson product moment correlation coefficient Returns the skewness of a distribution Returns the slope of the linear regression line Returns the k th smallest value in a data set Returns a normalized value calculates standard deviation based on a sample ignore text values and logical values Estimates standard deviation based on a sample including numbers text and logical values 134 Spreadsheets 2013 User Manual Function Name STDEVP number 1 number 2 STDEVPA number 1 number 2 STEYX known y s known_x s TDIST value x degrees of freedom one two tailed 1 2 distribution TINV distribution probability degrees of freedom TREND known ys known _x s new_x s not force the coefficient to be 1 TRIMMEAN array percent T
75. Category section of the Number tab When you choose different format types there will be different information references displayed at the right side of the dialogue box You can adjust the values according to the references so as to achieve a custom effect O General The General format is the default number format when you type a number into a cell It does not include any special format for numerical values O Number Select the Number option in the Category section and a Sample box will appear at the right side of the dialogue box which previews the changes of decimal 1000 separator and negative value made to the number format Shown as below S Format Cells ea Number Alignment Font Border Patterns Protection Category General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Number is used for general display of numbers Currency and Accounting offer specialized formatting for monetary value Sample Decimal places 2 Use 1000 separator Negative numbers 1234 10 1234 10 1234 10 1234 10 1234 10 conc Figure 2 4 1 Number format and options After selecting the Number option you can adjust the following settings in the dialogue box O Decimals and 1000 separator can be added to the number format O You can set the negative number format in the Negative numbers list box O Currency Select the Curren
76. Cells Ctrl 1 Figure 3 8 4 Convert Text to Hyperlink If you want to remove the hyperlink you have created right click the target cell range and choose the 96 Spreadsheets 2013 User Manual Remove Hyperlink option in the context menu See below James 25 teacher 3 4 5 Jane L Copy 6 Tom Y Cut 8 9 Sarah CE Paste Th i Paste as Unformatted Text Y Christy 10 Jack fz Paste Special 11 3 Insert 12 Delete Clear Contents 14 15 y Insert Comment Shift F2 16 ER Format Cells Ctrl 1 Pick from Drop down List 18 19 Edit Hyperlink 20 Open Hyperlink 21 Remove Hyperlink 22 N Figure 3 8 5 Remove Hyperlink 3 9 Symbol You can insert symbol in Kingsoft Spreadsheets The steps are as follows 1 Select the cell where you want to insert the symbol 2 Click the Symbol icon in the Insert tab The drop down list will open and show as below A f h Ob t Vt oe JT Srs AL Symbol Equation File Object ES Recently Used Symbols F FYOQO Ney x L gt Ts Y Y Custom Symbols x kg mm cmm ei ff x o x a iv kK a lA m a IV Lo D R A O More Symbols L Figure 3 9 1 The Symbol drop down list 3 Click the symbol that you prefer in the Recently Used Symbols section and the Custom Symbols section The symbol will be inserted in the worksheet 4 You can also choose the More Symbols option at the bottom to open the Symbol dialogue box
77. Color CUSTOM DIC C Users admin AppData Roaming Kingsoft officet Security New Add Error Checking Remove Y Spelling Set as Default Privacy EE Figure 8 1 4 The Spelling tab 3 In the Spelling section you can select Always suggest corrections Ignore words in uppercase and Ignore words with numbers check box according to your needs 4 In the Customize dictionaries section you can add new words or delete words in the current dictionary by the Modify button 5 Click the New button to select the new custom dictionary in the corresponding dialogue box 6 Click the Add button to add dictionary files 7 Click the Remove button and choose to remove the selected dictionary either from list or from disk 8 You can set the selected dictionary as default by the Set as Default button 9 Click OK to complete the operation 8 2 Comment Just like Kingsoft Writer Kingsoft Spreadsheets allows you to insert comments as well This function makes it very convenient for you to do business without papers In Kingsoft Spreadsheets you can insert comments when you want to illustrate the cell s After adding a comment there will be a little red triangle shown at the top right corner of the cell The content will appear automatically when you move the mouse to the cell 8 2 1 Create Comment If you want to set up a reminder for a cell or a cell range you can add comments The steps are shown as follows 169
78. Dialog Outline Reports Ga Gena Solver found a solution All Constraints and optimality conditions are satisfied When Simplex LP is used this means Solver has found a global optimal solution Figure 6 10 6 The Solver Results dialogue box The solver results will be like below A B C D E F G H I 2 Pen Sales Solver 3 4 price per gel pen 1 00 Total revenue l 912 5 5 volume of sales 150 00 6 subtotal 150 00 sales volume of gel pen 150 7 sales volume of pen and ball pen 350 8 price per pen 2 00 total sales volume 500 9 volume of sales 225 00 10 subtotal 450 00 Constraints 11 Max all pen 500 12 price per ball pen 2 50 Max pen and ball pen 350 13 volume of sales 125 00 Max ball pen 125 14 subtotal 312 50 15 Figure 6 10 7 The results of solver parameters You can see the possible maximum revenue is 912 5 At this point the shopkeeper have to sell 150 gel pen 225 pen and 125 ball pen 7 Table Style Tab Kingsoft Spreadsheets provides the Table Style tab for you to set the style for the table See below amp Spreadsheets d Book1 et 2 Home Insert Page Layout Formulas Data Table Style Review View Developer FirstRow v Banded Rows First Column SSS Ss cece AA EEERZ EH E E ey ES Last Row Banded Columns Last Column I mamm 5 Clear Table Style Figure 7 1 The Table Style tab By selecting or deselecting the six check boxes at the left si
79. EBEBUOULAE EERE mpre f f CB BEEe ee Figure 2 10 11 Tab Color 4 The tab color of the selected worksheets will change into the one you have chosen The effect is shown as below amp Spreadsheets Home Insert Page Layout Formulas Data E Cut amp Times New Roman 12 Paste Copy Fo BI UH amp m A Paint E H S Bj Book1 xls x Al Q fx A E D t a gt 3 4 5 Sheets Sheet f Figure 2 10 12 Tab Color effect 5 You can choose the No Color option in the drop down menu to clear the tab color 2 10 8 Hiding and Showing Sheet There are two methods to hide or unhide a worksheet Oo Select the worksheet that you want to hide or unhide Click the Worksheet icon and select the Hide and Unhide option Choose the Hide Sheet or Unhide Sheet option in the drop down list Oo Select the worksheet that you want to hide or unhide Right click the mouse and choose the Hide or 71 Spreadsheets 2013 User Manual Unhide option in the context menu 2 11 Find and Replace 2 11 1 Find To use the Find function follow the steps below 1 Click the Find and Replace icon in the Home tab and select the Find option in the drop down list or you can press the lt CtrI F gt combination The Find dialogue box will then open and show as below Efra EI Laci Find what Options gt gt Era Game Figure 2 11 1 The Find dialogue box 2 Input the text you want to find in the Fin
80. If you want to enter the time and date in to the same cell you should use a blank space to separate them For example 2011 4 19 8 30 1 3 1 5 Entering the same data into a discrete area To enter the same data in to a discrete area follow the steps below 1 Hold the lt Ctrl gt key and select the cells where you wish to enter the same data 2 Enter data in to the active cell 3 Press lt Ctrl Enter gt 1 3 2 Multiple summary results in the status bar In Kingsoft Spreadsheets multiple summary results will appear in the status bar if you select several numbers at a time The summary results include Sum Average and Count Spreadsheets 2013 User Manual A3 Q fr 454 123 1564 566 None Y Average Y Count Count Numbers Min Max Y Sum t2 Sheet3 4 mM Sum 6362 Average 1590 5 Count 4 E sA Fa 100 B e e e le Le Le 00 Ad o Figure 1 3 1 multiple summary results The three summary results mentioned above are defaults in Kingsoft Spreadsheets To adjust any of them you can right click the status bar or click the AutoSum icon in the Home tab The option list will then open and you can add or delete the summary results according to your needs 1 3 3 Smart Contraction Sometimes we have to enter a lot of information in a cell which makes it inconvenient to check information in other cells Kingsoft Spreadsheets provides a smart contraction function to make it much easier to deal wi
81. Inumber IMCOS Inumber IMDIV plural 1 plural 2 IMEXP Inumber IMLN Inumber IMLOG10 Inumber IMLOG2 Inumber IMPOWER Inumber power IMPRODUCT Inumber 1 Inumber 2 IMREAL Inumber IMSIN Inumber IMSQRT Inumber IMSUB plural 1 plural 2 IMSUM Inumber 1 Inumber 2 Tests whether two values are equal Returns the error function Returns the complementary error function Tests whether a number is greater than a threshold value Converts a hexadecimal number to binary Converts a hexadecimal number to decimal Converts a hexadecimal number to octal Returns the absolute value modulus of a complex number Returns the imaginary coefficient of a complex number Returns the argument e theta an angle expressed in radians Returns the complex conjugate of a complex number Returns the cosine of a complex number Returns the quotient of two complex numbers Returns the exponential of a complex number Returns the natural logarithm of a complex number Returns the base 10 logarithm of a complex number Returns the base 2 logarithm of a complex number Returns a complex number raised to an integer power Calculates the products of complex numbers in x y1 or x y text format Returns the real coefficient of a complex number Returns the sine of a complex number Returns the square root of a complex number Returns the difference between two complex numbers Returns the sum of complex numbers 1
82. ME KINGSOFT OFFICE user manual of spreadsheets 2013 Kingsoft Spreadsheets 2013 Kingsoft Spreadsheets is a flexible and efficient commercial application It is widely used by professionals in many fields such as business finance economics and so on It features calculation graphing tools and many other tools for complex data analysis Kingsoft Spreadsheets supports more than 100 commonly used formulas and has a battery of supplied functions e g conditional expressions sorting filtering and consolidating to make it much more convenient to analyze data Kingsoft Spreadsheets has a variety of spreadsheets templates that allow the users to create all kinds of spreadsheets easily and efficiently Kingsoft Spreadsheets is completely compatible with all Microsoft Excel files and is also capable of displaying other file formats such as txt csv dbf etc Spreadsheets 2013 User Manual Table of Contents 1 Kingsoft Spreadsheets Basic Operation scccccssssssssscsccccccccccccccccccssssssssssssssssssssssssscsccecsecosssssesees 1 O O 1 1 2 Kingsoft Spreadsheets Nter face iaissccsscsesuseciewasvcosseswetnsaccnsdenssuavesundesesnvdesesconsvusssessanecnesasedsendeaseacssteoneaeses 1 1 3 Basic O Pci 2 13 Operations Ce MS cach eee cass her ciate i hes tie de ates bl se aa 2 1 3 2 Multiple summary results in the status Dar ccccnnnnnninnninnnnonnnnnnnononnnonoononononnonnnnnnnnnnnnnnnnnnnnnnnnnnonoss 3 LAMA CONTACT E E a
83. Names in workbook Close N Refer to Sheet41 8 11 E 14 as Figure 5 4 1 The Define Name dialogue box 3 Input the name of the cells in the Names in workbook enter box and then click Add on the right 4 Click OK to complete the operation 5 4 2 Create Names Cell range can be just a cell or multiple cells These cells can be adjacent or non adjacent If you want to define a cell range name follow the steps below 1 In the Formula tab click the Create icon and the Create Names dialogue box will open and show as below E Create Names a Create names in Top row Left column Bottom row Right column Figure 5 4 2 The Create Names dialogue box 2 You can create names in Top row Left column Bottom row and Right column 3 Click OK to complete the operation Tips In this way you can only name a single row or column separately 5 4 3 Define Formula Name The operation steps are as follows 1 In the Formulas tab click the Name Manager icon and the Define Name dialogue box will open See Figure 5 4 1 142 Spreadsheets 2013 User Manual 2 Input the name of formulas in the Names in workbook text box click Add and input the corresponding formulas in the Refer to box 3 Press OK to complete the operation 4 If you want to delete the name of the cell cell range or formula you can select the corresponding name in the list box and click Delete 5 4 4 Paste Name You can paste the na
84. Options ES View Edit settings a Y Move selection after Enter Direction Down v Calculation l Fixed decimal Places v Enable AutoComplete for cell values General and Save V Allow cell drag and drop Comas Y Replace Internet and network paths with hyperlinks as you type Trace hyperlinks with Alt key pressed Color Security Error Checking Spelling Privacy ani Figure 3 8 3 The Edit tab 3 In the Edit Settings section select the Replace Internet and network paths with hyperlinks as you type check box and the hyperlinks will be activated by default 3 5 2 Group Create and Cancel Hyperlinks If the web page address or the e mail address are not automatically changed into hyperlinks in a document you can convert them altogether Kingsoft volume conversion tool allows you to perform this function so as to facilitate your document or e mail needs The steps are as follows 1 Only the URL and e mail addresses can be converted into hyperlinks Therefore select the cell range whose contents need to be converted into hyperlinks 2 Click the Format icon in the Home tab and choose the Convert Text to Hyperlink option in the drop down list Then the URL and e mail addresses will be converted into hyperlinks See below it 7 See Format Rows and Worksheet Fir SE rm Jj P lt See re Convert Text to Number Convert Text to Hyperlink N Conditional Formatting Styles Lock Cell As Clear Ep
85. Special Custom Accounting formats line up the currency symbols and decimal points in a column Figure 2 4 3 Accounting format and options o Date Select the Date option in the Category section You can choose the preferred date style in the Type list box and preview the change there See below Date formats display date and time serial numbers as date values loa Jl cama Figure 2 4 4 Date format and options Oo Time Select the Time option in the Category section You can choose the preferred time style in the Type list box and preview the change there See below 36 Spreadsheets 2013 User Manual Number Category Sample General Number Currency Accounting Time Percentage Fraction Scientific Time formats display date and time serial numbers as time values 0 Gea Figure 2 4 5 Time format and options O Percentage Select Percentage in the Category section You can set the decimal digits in the roll down list and preview the changes in the Sample box See below Number Category Sample General Number Decimal places 2 Currency Accounting Time Percentage Fraction Scientific Text Special Percentage formats multiply the cell value by 100 and displays the result with a percent symbol loa Jl coma Figure 2 4 6 Percentage format and options O Fraction Select Fraction in the Category section You can choose the preferred fraction type in the Type
86. TEST array 1 array 2 tails type VAR number 1 number 2 VARA number 1 number 2 VARP number 1 number 2 VARPA number 1 number 2 Explanations Calculates standard deviation based on the entire population given as arguments ignore text values and logical values Calculates standard deviation based on the entire population including numbers text and logical values Returns the standard error of the predicted y value for each x in the regression Returns the Percentage Points probability for the Student t distribution Returns the t value of the Student s t distribution as a function of the probability and the degrees of freedom Returns values along a linear trend Returns the mean of the interior of a data set Returns the probability associated with a Student s t test Estimates variance based on a sample ignore text values and logical values Estimates variance based on a sample including numbers text and logical values Calculates variance based on the entire population ignore text values and logical values Calculates variance based on the entire population including numbers text and logical 135 Spreadsheets 2013 User Manual Function Name WEIBULL number alpha Explanations values beta Returns the Weibull distribution returns the cumulative distribution function ZTEST array sample standard Returns the one tailed probability value of
87. a After you have made changes to the source data click this icon and the data in the 76 Spreadsheets 2013 User Manual pivot table will be refreshed o Sort Click this icon and the PivotTabel Field Advanced Options dialogue box will open and show as below In the AutoSort section you can choose to sort the data by default manually change the item order in ascending order and in descending order Choose the using field in the drop down list E PivotTable Field Advanced Options Si AutoSort Top 10 AutoShow AutoSort options O Default Change item order manually Ascending Descending Using field Ga 3 Figure 3 1 5 The AutoSort tab You can choose the Top 10 AutoShow tab to show the top 10 or other number of items in the pivot table Choose the using field in the drop down list E PivotTable Field Advanced Options Ss AutoSort Top 10 AutoShow Top 10 AutoShow off On Show Top g 10 amp Using field Sum of Score 1 X Figure 3 1 6 The Top 10 AutoShow tab o Hide Click this icon to hide the items in the pivot table fields Oo Order By choosing options offered in the Order drop down list you can move the row or column in the pivot table to the beginning or to the end Delete show Hide Move to Beginning Move Up Move Down Move to End Figure 3 1 7 The Order drop down list Oo Delete Click this icon to delete the currently selected pivot table Show Detail Click
88. ample select item 3 in the Student No drop down list See below A B C D 1 Student No Score Score al Al gt Number Filter Filter by Value Filter by Color Search All Multiple Single Select all m 110119201 110119202 Y 110119203 110119204 Aj 110119205 110119206 E 110119207 Top 10 Above Average Below Average Showing all OK Cancel Figure 2 6 1 Filter by Value Then the selected columns will be filtered by the value you have specified And all the rows that meet the criteria will be displayed See below A B de l E Ed 4 110119203 92 88 Figure 2 6 2 Filter effect 41 Spreadsheets 2013 User Manual 2 6 1 2 Filter by Color In Kingsoft Spreadsheets if you have applied different colors to the data or different cell colors you can filter the data by these colors Follow the steps below to filter data by the cell color or the font color 1 Select the range of cells you want to filter 2 Click the AutoFilter icon in the Home tab 3 Click the drop down arrow in each cell of the first line in the selected range Choose the Filter by Color tab in the drop down menu See below A B E D 1 Student No Score Score a Al gt Number Filter Filter by Value Filter by Color Filter by cell color Noe 0 Filter by font color A A Figure 2 6 3 The Filter by Color tab 4 You can either filter the data by cell color or font color Choose one color from the above cell colo
89. arest multiple of significance Returns the number of combinations for a given number of items Returns the cosine of a given angel Returns the hyperbolic cosine of a number Converts radians to degrees Rounds positive numbers up and negative numbers down to the nearest even integers Returns e raised to the power of a given number Returns the factorial of a number The factorial of a number is equal to 1 2 3 number Returns the double factorial of a number Rounds numbers down toward zero to the 126 Spreadsheets 2013 User Manual Function Name GCD number 1 number 2 INT number LCM number 1 number 2 LN number LOG number base LOG10 number MDETERM array MINVERSE array MMULT array1 array 2 MOD number divisor MROUND number significance MULTINOMIAL number Des ODD number PI I number Explanations nearest multiple of significance Returns the greatest common divisors of two or more integers Rounds a number down to the nearest integer Returns the least common multiples of two or more integers Returns the natural logarithm of a number Returns the logarithm of a number to the base you specify The LOG10 function returns the base 10 logarithm of a number Returns the matrix determinant of a number Returns the reverse matrix for the matrix stored in an array Returns the matrix product of two arrays The result is that the array
90. as below 88 Spreadsheets 2013 User Manual 2009780115 2009780116 2009780117 fon a o o o co co co e Re E a a a o So S 5 a a N N N Student Ho Figure 3 2 16 The Chart Type dialogue box 3 Click the Add to Custom Type button in the bottom and the Add User Defined Type dialogue box will open and show as below In this dialog you are permitted to change the active chart into a user defined chart type eS Name a Figure 3 2 17 The Add User Defined Type dialogue box 4 Add the name and description in the corresponding enter box 5 Press the OK button to complete the operation After adding the custom chart you can see 1t in the Custom section of the Chart Type dialogue box See below 2014 Midterm Examination Results 2009780111 2009780112 2009780113 2009780114 2009780115 2009780117 Student Mo Figure 3 2 18 Add to the Custom Type 89 Spreadsheets 2013 User Manual You can delete the custom chart type by selecting it in the Custom section of the Chart Type dialogue box Then click lt Delete gt on the keyboard 3 3 Picture If the worksheet only contains raw data and text it would be boring and without main points Pictures are very useful in presenting the data which visually display the contents of the data to the user If you have pictures which you feel would enhance the demonstration of the data you can insert these pictures into th
91. as you would on a normal browser 10 Spreadsheets 2013 User Manual 1 3 7 3 Saving All Tabs in One Click m Document 1 x Close Window m Save Save All Ga Save As Close Other Windows l Close All Open Folder Hs Properties Figure 1 3 14 Quick functions Right clicking on the tab allows some quick functions including Close Window Save Save All Save As Close Other Windows Close All and Open Folder which is a more practical way of saving work it avoids a situation where a user 1s not sure what documents are open and may have to re check or in rare circumstances save the document under the wrong name The interface Kingsoft Office offers 1s for the best convenience of the user and this feature alone saves time has improved functionality and usability compared to other less innovative office suites It eliminates everyday problems that a user may encounter when working with other word processors spreadsheet software and presentation programs like Microsoft Word Excel and PowerPoint 1 3 8 Hiding and Showing the Toolbar By clicking the Hide the Toolbar icon at the top right corner of the screen you can hide or show the toolbar 1 4 The Application Menu The Application menu is the green icon at the top left corner of the Kingsoft Spreadsheets main interface The Application menu includes the following functions New Open Save Save As Print Print Preview Send E mail File Information Backup Management
92. ase Decimal and Decrease Decimal o Currency Add a currency format for the selected cell s o Percent Style Display the values in the selected cell s as percentages Comma Style Add thousands separator to the data in the selected cell s e Increase Decimal Display the data in higher accuracy by increasing the decimal digits 00 o Decrease Decimal Display the data in lower accuracy by decreasing the decimal digits 2 4 2 Cell Format There are 12 categories in the cell format properties These categories are General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special and Custom There are several ways to open the Format Cells dialogue box in order to set the format properties for the cell N o Click the Settings icon sws in the Home tab and choose the Cells option in the drop down list The Format Cells dialogue box will open and the Number tab will be available O Right click the mouse and choose the Format Cells option in the context menu The Format Cells dialogue box will pop up and the Number tab will be available 33 Spreadsheets 2013 User Manual o Click the Format icon in the Home tab and choose the Cells option in at the bottom of the drop down list The Format Cells dialogue box will open and the Number tab will be available O Press lt Ctri 1 gt to open the Format Cells dialogue box and select the Number tab You can choose a format type in the
93. ata es V Unique records only 17 James 25 teacher i 18 Sarah 45 policeman Cancel 19 Flora 52 teacher Figure 2 6 19 Select the ranges 4 Click the OK button to complete the operation 2 6 4 Show All If you want to restore the filtered data you can either select the Show All option in the AutoFilter 49 Spreadsheets 2013 User Manual drop down list or press lt C gt in the keyboard Then all the data will be restored and displayed in the worksheet 2 7 Sort At times it is better to have the worksheets in your workbook arranged in a specific order which will make it easier to navigate through your document The sort function in Kingsoft Spreadsheets allows you to arrange the data in descending and ascending order The operation steps are as follows 1 Select any cell or cells in the worksheet which you want to sort 2 Click the Sort icon in the Home tab and you can see that there are three options in the drop down list namely Ascending Descending and Custom Sort See below gt l H 0 Sort Format Rows and Al Ascending Al Descending O 4 Custom Sort Figure 2 7 1 The Sort drop down list 3 You can choose the Ascending option to sort the data in the ascending order or choose the Descending option to sort the data in the descending order When you select the Custom Sort option the Sort dialogue box will open and show as below E Sort Sort by Ascending Descending Then by O Ascending D
94. ata and Refresh All Refresh Data and Refresh All are designed to refresh data imported from external data source Click the Refresh All icon in the Data tab to open the drop down list There are two options offered Refresh Data refresh data that you have selected Refresh All refresh all the data you have imported 6 2 Text to Columns Kingsoft Spreadsheets provides a Text to Columns function It plays an important role in importing text data and performing data storage format conversion For example import long digital data and fast data format conversion To use this function follow the steps below 1 Create a blank worksheet Copy text data from files such as txt and csv and paste it in the Al cell 151 Spreadsheets 2013 User Manual See below Figure 6 2 1 Paste the text data 2 Select column A and click the Text to Columns icon in the Data tab 3 In the Convert Text to Columns Wizard Step 1 of 3 dialogue box you can select a suitable file type according to the basic characteristics of the file In this example we select Delimited Shown as below The Text Wizard has determined that your data is Delimited If this is correct choose Next or choose the data type that best describes your data Original data type Choose the file type that best describes your data 9 Delimited Characters such as commas or tabs separate each field C Fixed width Fields are aligned in columns with spaces betw
95. ation above Skills Select the intended rows and columns right click the mouse and select the Hide and Unhide option in the context menu to perform the hide and unhide function 2 10 Worksheet You can carry out a series of operations on worksheets including select insert delete protect rename move copy set the tab color and hide and unhide worksheets 2 10 1 Selecting Sheet If you want to move copy cut or delete worksheets you have to select them first Simply click the worksheet label to select the intended worksheets 65 Spreadsheets 2013 User Manual DM Ln da Whe oO pa p oO Sheet2 Figure 2 10 1 Selecting a single sheet 1 2009780111 89 2 2009780112 90 3 2009780113 100 4 2009780114 88 5 2009780115 93 6 2009780116 92 7 2009780117 97 Sheet3 94 96 94 92 100 95 92 You can hold the lt Shift gt key to select multiple worksheets that are adjacent to one another You can hold the lt Ctrl gt key to select multiple worksheets that are non adjacent to each other Select the current worksheet right click the mouse and choose the Select All Sheets option in the context menu to select all sheets The effect is shown below pd O 2 10 2 Inserting Sheet ON da Wo by mo oO Wi B 1 2009780111 2 2009780112 3 2009780113 4 2009780114 5 2009780115 6 2009780116 7 2009780117 Sheet1 Sheet2 Sheet3 E Figure 2 10 2 Select All Sheet
96. ayout In the Print Layout mode you can check the appearance of printed tables You can check the start position end position of the documents and the header and footer on the page There are two ways to open the Print Preview tab in Kingsoft Spreadsheets O Click the Print Layout icon A in the quick access tool bar and the Print Preview tab will open where you can preview files before printing O You can also choose the Print Preview option in the Application menu S Spreadsheets _ in the top left corner to enter the Print Preview interface Shown as follows Print Preview Zoom FA SS hh i im a Oe 8 RO Print 7 100 Page Break Normal Portrait Landscape Headerand Page Margins Close Preview View Footer Setup Figure 9 1 1 The Print Preview tab You can perform the following operations by the Print Preview tab O Print Click to set the print properties and get the file s printed Oo Next Page and Previous Page If a worksheet contains more than one page of data you can click this two icons to preview the next or previous page o Zoom Select the preferred zoom size of the current worksheet in the Zoom drop down list Page Break Preview Switch to the page break preview mode 176 Spreadsheets 2013 User Manual Normal Switch to the normal view mode o Portrait and Landscape Click the corresponding icon to set the pages to portrait or landscape Oo Header and Footer edit the header and footer of the docume
97. bject The steps to insert an object in the worksheet are shown as follows 1 Click the Object icon in the Insert tab and the Insert Object dialogue box will open and show as below E Insert Object Create new Create from file Result Object type Adobe Acrobat Document s Bitmap Image 7 Cancel Kingsoft Equation 3 0 Kingsoft Spreadsheets Chart F Display as icon Kingsoft Spreadsheets Workbook Kingsoft Writer Document MathMagic Equation Microsoft Equation 3 0 Inserts a new Adobe Acrobat Document object into your document Figure 3 11 1 The Insert Object dialogue box There are two options to insert objects Create New Insert object directly Select the type of the object you want to insert in the Object type roll down list Kingsoft Spreadsheets supports a variety of object types such as Kingsoft Spreadsheets Workbook WordPad document and Microsoft Excel among others Create from file Insert objects which already exist in the system 2 Select the Display as icon check box Then the inserted object will be displayed as an icon 3 Press the OK button to complete the operation 3 12 Insert File Object To insert file object in the worksheet follow the steps below 1 Click the File Object icon in the Insert tab The Insert File Object dialogue box will open and show as below 99 Spreadsheets 2013 User Manual E Insert File Object Look in d New folder am
98. catenate one or Text concatenation more text strings to produce operator a single piece of text 111 Spreadsheets 2013 User Manual Produces one reference to all the cells between two colon Range operator references including the two references For example A1 A3 Combines multiple Reference references into one comma Union operator reference For example SUM A1 A3 B1 B5 Produces the reference to the Intersection intersecting cells of two space operator references For example A1 A3 A2 B5 Table 5 1 1 Operators offered in Kingsoft Spreadsheets 5 1 1 Create Formulas Formulas are equations that perform calculations on values in your worksheet You can create formulas by using constants calculations operators cell references and names that you have defined The operation steps are as follows 1 Click the cell where you want to create a formula 2 Input constants functions operators cell references and so on 3 Press lt Enter gt after inputting the formula 5 1 2 Input Formulas To input formulas in a cell follow the steps below 1 Select the cell where you want to input the formula 2 In the edit bar input and the specified contents of the formula 3 Press lt Enter gt or click in the edit bar 4 If you want to cancel the contents click 112 Spreadsheets 2013 User Manual 5 1 3 Copy a Formula The operation steps are as follows 1 Selec
99. ch Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider i MSDataShape OLE DB Provider for Microsoft Directory Services z 4 m J 149 Spreadsheets 2013 User Manual Figure 6 1 6 Data Link Properties 3 In the Select the data you want to connect to list box select the preferred data and click Next to go to the Connection tab ed Data Link Properties Specify the following to connect to ODBC data 1 Specify the source of data O Use data source name y Refresh Use connection string 2 Enter information to log on to the server User name Password Blank password Allow saving password 3 Enter the initial catalog to use Test Connection Figure 6 1 7 Data link properties 4 In the 1 Specify the source of data section select Use data source name and you can click the data source name you want Then type the location of the data in the 3 Enter the initial catalog to use section 5 Press OK to complete the operation 6 1 3 Edit OLE DB Query After you have imported external data into Kingsoft Spreadsheets you can perform simple queries by using the SQL language Click Edit Query in the Import Data dialogue box See below EJ import Data za Destination area E 6 A Cancel renee Eater Figure 6 1 8 Edit Query The Edit OLE DB Query dialogue box will open where you can preform simple queries See below 150
100. comments in the selected cell You can also apply this function by clicking the Format icon in the Home tab and select the preferred option in the Clear drop down list Fill Color click to select a background color for the selected cell in the drop down list 2 2 2 Border The color of the grid lines in the worksheet is gray by default Grid lines are not displayed when you print the file but 1f you need to print the grid lines you should set the borders for them To set the borders follow the steps below 1 Select the cells for which you want to set the borders 2 Click the Other Borders icon H in the Home tab and select different borders from the drop down list The list is shown in the following figure Rd HH D A p No Border All Borders Outside Borders Thick Box Border Bottom Border Top Border Left Border Right Border Bottom Double Border Thick Bottom Border Top and Bottom Border Top and Thick Bottom Border Top and Double Bottom Border More Borders Figure 2 2 2 Border drop down list Oo Draw Border Click the Draw Border icon A Sa y and select the Draw Border option in the drop down list The mouse will then change into a pen shape which allows you to draw an outside border for the selected cell area e Draw Border Grid Click the Draw Border icon and select the Draw Border Gird option in the drop down list The mouse will then change into a pen
101. condition Table 5 2 4 Date and Time Functions 5 2 3 5 Lookup and Reference Functions There are 18 lookup reference functions in Kingsoft Spreadsheets See below Function Name Explanations ADDRESS row_num column_num Creates a cell address as text according to the abs num al sheet text specified row and column numbers AREAS reference Returns the number of areas in a reference An area is a range of contiguous cells or a single cell CHOOSE andex_num valuel Returns a value from the list of arguments based value on the given index number 123 Spreadsheets 2013 User Manual Function Name COLUMN reference COLUMNS array EVALUATE formula text GETPIVOTDATA data field pivot table area HLOOKUP lookup value table_array row num range lookup HYPERLINK hyperlink position display text INDEX array row_num column num area num INDIRECT ref text al LOOKUP lookup value lookup vector result_vector MATCH lookup value lookup _array match type OFFSET reference rows cols height width ROW reference ROWS array Explanations Returns the column number of a reference Returns the number of columns in an array or reference Evaluates a formula or expression which is expressed in text and returns the result Extracts data stored in a PivotTable Searches for a value in the top row of a table or an array of values and then returns a value in the sam
102. ction follow the steps below 1 Create a worksheet containing the product sales information The value in B3 is unknown and no need to enter data in it Enter the formula B1 B2 B3 in B4 2 Click the What If Analysis icon in the Data tab and choose Goal Seek in the drop down list The Goal Seek dialogue box will open and show as below 163 Spreadsheets 2013 User Manual 7 8 B B4 1 Product Sales Price 2 Product Cost 3 Product Sales Price j Set cell B 4 4 Expected Product Profit ol To value 15000 5 By changing cell sesal 6 7 Figure 6 10 1 The Goal Seek dialogue box 3 Select cell B4 in the Set cell section enter 15000 in the To value enter box and select B3 in the By changing cell section 4 Click OK to complete the operation You can see the result as shown below BH Ss la amp 63 Book1 et x B4 7 A fx B1 B2 B3 A B C D E F 1 Product Sales Price 80 a Gosek Sane 2 Product Cost 50 ee 3 Product Sales Price rr 4 Expected Product Profit Target value 15000 5 Current value 15000 a Figure 6 10 2 Goal Seek Status 5 Click OK to preserve the result 6 10 2 Solver Parameters Simply speaking Solver Parameters can help you forecast the problem which contains more than one variable For example the shopkeeper wants to know which kinds of pens he should sell and the potential revenue Assuming that there are three kinds of pens namely gel pen pen and ball pen a
103. cy option in the Category section and a Sample box will appear at the right side of the 34 Spreadsheets 2013 User Manual dialogue box which previews the changes in decimal currency symbol and negative value usage Shown as below g Format Cells f x gt Number Alignment Font Border Patterns Protection W Category Sample General Number Decimal places 2 7 Currency Symbol Accounting z Date Time Negative numbers Percentage 1 234 10 Fraction 1 234 10 GAG 1 234 10 Scientific 1 234 10 Text 51 234 10 Special Custom Currency formats are used for general monetary values Use Accounting formats to align decimal points in a column a Goo Figure 2 4 2 Currency format and options After choosing the Currency option you can set the basic display style for currency in the dialogue box These display settings allow you to customize the Decimal places Symbol and the display format of the Negative numbers O Accounting Choose the Accounting option in the Category section The Sample box on the right displays the format changes You can define the basic accounting display format by customizing the Decimal places Symbol etc Figure 2 4 3 displays the Accounting format and options 35 Spreadsheets 2013 User Manual Number Category Sample Number Decimal places Currency x Symbol ae Date Time Percentage Fraction Scientific Text
104. d J Comments Save preview picture 0 Ce Figure 1 4 13 The Summary tab 4 In the Custom tab you can set the Name Type Value and Property of the file Shown as below S Book1 xls Property Ss General Summary Custom Name Office a Editor Layout Department Reference Publisher Type Text y Value Property s Value Tiie KSOProductB 1033 9 1 0 4550 Text a Figure 1 4 14 The Custom tab 5 Click the OK button to complete the operation 1 4 9 The Backup Management Option in the Application Menu By choosing the Backup Management option in the Application Menu the Backup Management task window will open at the right side of the screen Click the Backup Management icon again to open the drop down list and then you can choose the options listed there namely New Workbook PivotTable Selection Pane AutoShapes and Backup Management By choosing any one of them the 20 Spreadsheets 2013 User Manual corresponding task window will open and you can set preferred values there 1 4 10 The Help Option in the Application Menu Click the Application Menu icon to open the drop down list Choose the Help tab and you can see the options listed in the Feedback and Product Information section as shown below amp Spreadsheets Home Insert Page Layout Formulas Data Table Style ye New Feedback and Product Information Kingsoft Spreadsheets Help Open Kingsoft Office H
105. d show as below qe AE En E Group zaj Group Rows Columns 7 Gad 160 Spreadsheets 2013 User Manual Figure 6 6 1 The Group dialogue box 3 Select either Rows or Columns option button that you want to group by 4 Click OK to complete the operation If you want to ungroup the range do as follows In the Data tab open the Ungroup drop down list and select Clear Outline 6 7 Subtotal To use the subtotal function follow the steps below 1 You need to sort the fields that you want to subtotal first so that the fields with the same keyword will gather together Shown as follows A B E D 1 NO GOODS PRICE AMOUNT 2 A001 Toy 12 3 3 A002 Toy 15 2 4 A003 Toy 17 4 5 A004 Pen 9 2 6 A005 Pen 15 3 7 A006 Pen 12 1 g8 A007 Box 4 5 9 A008 Box 3 10 Figure 6 7 1 Sort by GOODS 2 Click the Subtotal icon in the Data tab and the Subtotal dialogue box will pop up 3 In the At each change in drop down list select the field you want to subtotal 4 Select the function you need in the Use function drop down list in the Subtotal dialogue box E Subtotal x At each change in Goons z Use function Sum Add subtotal to E NO GOODS Y PRICE v AMOUNT V Replace current subtotals Page break between groups V Summary below data Remove All oi Cancel Figure 6 7 2 The Subtotal dialogue box 5 In the Add subtotal to dialogue box select the field you want to subto
106. d the WordArt in the worksheet the WordArt tab and Format tab will appear where you can specify the properties of the WordArt for more detailed information see the corresponding chapters in User Manual of Writer 2013 3 7 Header amp Footer You can add header and footer to the worksheet The steps are as follows 1 Click the Header and Footer icon in the Insert tab The Page Setup dialogue box will open and show as below B Page Setup E 2 Page Margins Header and Footer l Sheet Header None y Custom Header Footer None y Custom Footer Options Print Cancel Figure 3 7 1 The Page Setup dialogue box 2 Open the Header and Footer tab where you can customize the header and footer Click the Custom Header button to open the Header dialogue box shown as below 93 Spreadsheets 2013 User Manual El Header a To format text select the text then dick the font button To insert a page number date time filename position the insertion point in the edit box then choose the appropriate button To insert picture press the Insert Picture button To format your picture place the cursor in the edit box and press the Format Picture button aia a aloja la lu Left section Center section Right section os cancel Figure 3 7 2 The Header dialogue box O Enter the contents of the header in the Left section Center sec
107. d what enter box 3 Click the Options button to unfold the dialogue box where you can set the finding condition in a more specific way 4 Click the Find Next button to locate the next cell which contains the target text 5 Click the Find All button and all the data which meet your requirement will be listed 6 Click the Close button to close the dialogue box 2 11 2 Replace To use the Replace function follow the steps below 1 Click the Find and Replace icon in the Home tab and select the Replace option in the drop down list or you can press the lt CtrI H gt combination The Replace dialogue box will then open and show as below E Replace Find Replace Go To 4 Find what Replace with 4 Options gt gt Replace All Replace Find All Close Figure 2 11 2 Replace Tab 72 Spreadsheets 2013 User Manual 2 Input the contents you want to find in the Find what enter box and input the contents you want to replace with in the Replace with enter box 3 Click the Replace button to replace once 4 Click the Replace All button to replace all the content in the worksheet 5 Click the Close button to close the dialogue box Tips You can enter nothing in the Replace with enter box to delete all the contents which you have find 2 11 3 GoTo You can quickly locate data in the worksheet by the Go To function offered by Kingsoft Spreadsheets To use the Go To function
108. de of the Table Style tab see the figure above you can emphasize or normalize the First Row Last Row Banded Rows Banded Columns First 166 Spreadsheets 2013 User Manual Column and Last Column of the table To use the theme style in the current worksheet follow the steps below 1 Selected the cells where you want to use the theme style 2 Click the arrow at the right side of the theme style list box to open the drop down list See below Best Match 3 Click the preferred theme style in the drop down list and it will be applied to the selected cells 4 Click the Clear Table Style icon at the end of the Table Style tab to clear the style for the table Review Tab 8 1Check Spelling Kingsoft Spreadsheets provides a Check Spelling function to proofread the text in the worksheet according to the values you have set and the dictionaries which you have choose as the check spelling criteria To spell check the worksheet follow the steps below 1 Open the worksheet which you want to spell check 2 Click the Check Spelling icon in the Review tab or select the Check Spelling option in the drop down list See below ABC or Y ir p CHECA New 5 Spelling gt Comment ES Check Spelling N F7 Set Language Figure 8 1 1 The Check Spelling drop down list 167 Spreadsheets 2013 User Manual
109. e worksheet To insert pictures in the worksheet follow the steps below 1 Click the Picture icon in the Insert tab The Insert Picture dialogue box will open and show as below Ej Insert Picture Look in ME Desktop v G E Ey File folder 6 A e Ls lt Recent Places I 1 ur kingsoft task New folder Desktop Unspecified 4 A ME mm m y Libraries 3 R A T d 7 y f A Libraries Kingsoft Computer Network Computer ta Network File name v Files of type All Pictures emf wmf jpg jpeg jpe png y Cancel Figure 3 3 1 The Insert Picture dialogue box 2 Find the picture in the File Name search box Then click the Open button and the picture will be inserted in the current worksheet Tips After inserting the picture the Picture Tools tab will show up where you can modify the properties of the picture more detailed information see the corresponding chapters in User Manual of Writer 2013 3 4 Shapes If inserting pictures are still not enough demonstration then you can insert shapes Kingsoft Spreadsheets provides various kinds of shapes which will enrich the data To insert Shapes follow the steps below 90 Spreadsheets 2013 User Manual 1 Click the Shapes icon in the Insert tab and the Shapes drop down list will open See below i rs mal WE A GB aT Shapes TextBox WordArt Headerand Hyperlink Symbol Equatio ae Lines RXNN EOE Connectors
110. e column from a row you specify in the table or array The table is ascending by default Creates a shortcut or jump that opens a document stored on a network server Intranet or Internet Returns the value of an element in a table or an array selected by the row and column number indexes Returns the reference specified by a text string Looks up a value whether from a one row or one column range or from an array Returns the relative position of an item in an array that matches a specified value in a specified order Returns a reference to a range that is a given number of rows and columns from a given reference Returns the internal row number of a specified reference Returns the number of rows in a reference or 124 Spreadsheets 2013 User Manual Function Name Transpose array VLOOKUP lookup value table_array col index num range lookup Explanations array Returns a horizontal range of cells as a vertical range or vice versa Transpose must be entered as an array formula in the range that has the same number of rows or columns respectively with those of an array Use transpose to shift vertical or horizontal orientation of an array in a worksheet Searches for a specified value in the leftmost column of a table and returns a value in the current row from a column you have specified Table 5 2 5 Lookup and Reference Functions 5 2 3 6 Math and Trigonometry Functions There are 60 math and trigonome
111. e contents will be duplicated o Date the contents will be inserted in the date format o AutoFill the contents will be inserted by default 6 Enter the step value and stop value in the corresponding enter box 7 Click the OK button to complete the operation 2 9 6 6 Custom Fill Series To make entering a particular sequence of data such as a department name or an employee name easier you can create a custom fill series A custom fill series can be based on a list of existing items on a worksheet or you can type the list from scratch The operation steps are as follows 1 Click the Application Menu icon EXA at the top left corner of the screen to open the drop down list 2 Click the Options icon at the bottom right and open the Options dialogue box 3 Choose the Custom Lists tab in the dialogue box as shown below 63 Spreadsheets 2013 User Manual E Options m View Custom lists List entries New list Red Orange Yellow Green Grey Blue Purplel Sun Mon Tue Wed Thu Fri Sat Sunday Monday Tuesday Wedne Calculation Edit General and Seve Jan Feb Mar Apr May Jun Jul A January February March April M Custom Lists Color Security Error Checking Spelling Privacy ca Figure 2 9 13 The Custom Lists tab 4 Choose the New list option in the Custom lists section and enter the new list in the List entries section as shown in Figure 2 9 12 5 Click
112. e result in the Total Sales worksheet The operation steps are as follows 1 Click the 2012 Data worksheet tab and input the data Shown as follows Home Insert Page Layout Formulas rs dh Cut 4 Times New Roman Paste Copy Format B 7 UEH E2 Painter E H SAs Bj Book1 xls 114 z Q fx A B S D 1 2012 Data 2 Name Score l Score 2 Score 3 3 NB001 100 99 98 4 NB0O02 97 96 90 5 NBO03 99 97 95 6 NB 004 94 100 100 7 NBOO5 98 92 99 8 NB006 96 97 98 9 NBOO 7 99 100 94 caia 156 Spreadsheets 2013 User Manual Figure 6 5 1 2012 Data worksheet 2 Click the 2013 Data worksheet tab and input the data Shown as follows Home Insert Page Layout Formulas Data x Cut 4 Times New Roman 12 C copy Format B I UE E2 2 A Painter BHease gt Book1 xls x 121 7 Q fx B C D 1 2013 Data 2 Name Score 1 Score 2 Score 3 3 NBOOI1 97 99 100 4 NB 002 100 98 99 5 NB 003 94 95 92 6 NB 004 96 93 97 7 NB005 98 100 97 8 NB006 93 92 99 9 NBOO7 100 98 95 id 4 gt IMAN ENTIS Figure 6 5 2 2013 Data worksheet 3 Click the Total Sales worksheet tab and input row and column labels Shown as follows amp Spreadsheets Home Insert Page Layout Formulas Data iF Ye 3 PivotTable AutoFilter Advanced Reapp Ascending BES 4 amp B Book1 xs Xx F17 x QA fx A da Wo by mm Oo eo NWN E 4 MUDAR 2013Data Total Sales Figure 6 5 3 Total Sales worksheet 4 Choose the Total
113. e values 6 13411782905 13411 78 2905 Figure 2 4 9 Special format and options Oo Custom Select Custom in the Category section You can set various kinds of customized data formats in the Type list box See below A gt wr a Format Cells Pm Number Category Sample Number zz Currency Tl Type Accounting General Date General pa Time 0 E Percentage 0 00 Fraction 7 20 Scientific 20 00 Te n SE 3 480 _ 8 480 _0 10 ii _ 5 880 00 _ 0 00 _ 22 Custom s Delete Type the number format code using one of the existing codes as a starting point sl Figure 2 4 10 Custom format and options Click the OK button to complete the operation 39 Spreadsheets 2013 User Manual 2 5 AutoSum Kingsoft Spreadsheets provides the AutoSum function which could be applied to perform several simple operations namely Sum Average Count Max and Min See below 2 E il AS e 7 AutoFilter Sort gt Sum Avg Average ent Count Max M ax Min Min fe More Functions Figure 2 5 1 The AutoSum icon and options Select the intended cells and you can perform the corresponding operation by choosing the preferred option The result will be displayed directly after the selected cells O Sum Sum up the numbers in the selected cells O Average Work out an average of the numbers in the selected cells O Count Count the number of the selected cell
114. ecommended You are not protected from potentially unsafe macros Use this setting only if you have virus scanning software installed or you have checked the safety of all documents you open cane Figure 10 2 1 The Security Level tab 2 In the Security Level tab choose Very High High Medium and Low according to your needs 3 Click OK to complete the operation 10 3 Other Functions Oo Visual Basic Editor Click to open the Visual Basic Editor and edit the macros there O Add Ins Manage the Add Ins available in this file COM Add Ins Manage the COM Add Ins available in this file Oo Design Mode Enter design mode to edit control s name and functions Oo Control Properties View and modify properties for the selected control Oo View Code View and modify the code for the selected control in the Visual Basic Editor To add objects in the worksheet you can click the corresponding icon in the Developer tab See below 183 Spreadsheets 2013 User Manual A A lalo Figure 10 3 1 Add objects icons You can add check box text box command button option button list box combo box toggle button spin button scroll bar label image and more controls in the worksheet by the corresponding icon When the cursor turn into a cross hold and drag it to insert the object in the worksheet After the object was drawn double click it to edit it in the Microsoft Visual Basic 184 Spreadsheets 2013 User Manua
115. een each field Preview of selected data 1 Copy Ctrl C 2 Paste Ctrl V 3 Save Ctrl S 4 Print Ctrl P 5 Homepage Alt Ho Figure 6 2 2 Convert Text to Columns Wizard 4 Click Next 5 You will see the Convert Text to Columns Wizard Step 2 of 3 dialogue box where you can choose further options Click the Space check box in the Delimiters section Other settings are all by default See below 152 Spreadsheets 2013 User Manual below Delimiters Tab Semicolon Comma Treat consecutive delimiters as one Data preview Copy Ctrl C Paste Ctrl V Save Ctrl S Print Ctrl P Homepage Alt Home Figure 6 2 3 Delimiters 6 Click Next In the Convert Text to Columns Wizard Step 3 of 3 dialogue box you can set the data format of every column See below VONYC ECKL LOW dll 2 Ue arad gt tep 5 OT A ES A A This screen lets you select each column and set the Data Format Column data format Destination 0 General A 1 Text Date C Do not import column skip Data preview General General Copy Ctrl C Paste Ctrl V Save Ctrl S Print Ctrl P Homepage Alt Home Figure 6 2 4 Set column data format 7 Click Finish to complete the operation The result is shown as below amp Spreadsheets Home Insert Page Layou i E YT PivotTable AutoFilter Advanced b HSAs Ba E12 x a A B 1 Copy CtrhHC 2 Paste Cui V 3 Save Cots 4 Print CrP
116. elect the size of the paper in the Paper Size drop down list 4 Press OK to complete the operation 4 1 4 Print Area To set the print area follow the steps below 1 Click the Print Area icon in the Layout tab and choose the Set Print Area option in the drop down list See below y p j gt _ Print Print Breaks Pac F Set Print Area N 3 Clear Print Area Figure 4 1 5 The Print Area drop down list 2 Then you can drag the mouse to select the area need to print 3 Open the Application menu ERAN at the top left corner of the screen Choose the Print Preview option in the drop down list Then you can see the effect of the printing area 4 Choose the Clear Print Area option in the drop down list to clear the print area you have set 4 1 5 Print Titles In order to print the titles on each page in spreadsheet documents Kingsoft provides the title printing function To use this function follow the steps below 1 Click the Print Title icon in the Layout tab and the Page Setup dialogue box will open Select the Sheet tab See below 104 Spreadsheets 2013 User Manual B Page Setup ese Page Margins Header and Footer Sheet Print area Ex Print titles Rows to repeat at top Pr Columns to repeat at left I Pr Print Gridlines Row and column headings Cell error as Displayed x Page order O Down then over Over then down Options Print a Cancel Figure
117. ent 2 9 2 Moving Rows and Columns If you want to adjust the display order of the rows and columns you can move them to the proper position To do so follow the steps below 1 Select the rows or columns you want to move 2 Move the mouse to the border of the selected rows or columns When the shape of the mouse changes from an arrow to a cross you can drag the mouse to the specified position 54 Spreadsheets 2013 User Manual 3 Release the mouse and the rows and columns will be moved to the specified position 2 9 3 Setting Row Height and Column Width You can adjust the height of the rows and width of the columns if you feel they are not suitable at the default size To set the row height and column width follow the steps below 1 Select the rows and columns 2 Click the Rows and Columns icon in the Home tab The Rows and Columns drop down list is shown below Do f ad Worksheet Find and m 57 Replace L Row Height 3 AutoFit Row Height 2 Column Width Es AutoFit Column Width Standard Width 24 Insert Cells EX Delete Cells Fill gt Z Hide and Unhide Figure 2 9 1 Rows and Columns drop down list 3 Select the Row Height or Column Width option in the drop down list and the corresponding dialogue box will open where you can set the row height and the column width See below E Row Height mrg Row height pt Cancel El Column Width x Column width
118. eps 1 Select the cell or cells T E 2 Click the Merge and Center icon in the Home tab You can also merge or split cells by the Format Cells dialogue box Follow the steps below 1 Select the cells that need to be merged or split 2 Right click and choose the Format Cells option in the context menu 3 Choose the Alignment tab in the Format Cells dialogue box and select or deselect the Merge cells check box in the Text control section B Format Cells Ea Number Alignment Font Border Patterns Protection Text alignment Orientation Horizontal Indent ir General z 0 Vertical T E t rm control Ps Wrap text ou Shrink to fit 0 Degrees Merge cells Vertical text Ta Cen Figure 2 3 4 Merge cells by the Format Cells dialogue box 32 Spreadsheets 2013 User Manual 5 Press the OK button to complete the operation 2 3 4 Adjusting Indent To change the indent of the cell content the margin between the border and the text you can use the Decrease Indent icon and the Increase Indent icon in the Home tab Oo Decrease Indent Reduce the distance between the cell border and the content Increase Indent Increase the distance between the cell border and the content 2 4 Number 2 4 1 Quick Set Format You can easily set the format of the selected cells by several icons in the Home tab such as Currency Percent Style Comma Style Incre
119. escending Then by O Ascending Descending My data range has O Header row No header row Options Cancel Figure 2 7 2 The Sort dialogue box 4 Choose the sort range in the drop down list and select the corresponding check box on the right according to your needs 5 Press the OK button to complete the operation The data in the worksheet will be sorted by the values you have specified The result is shown below 50 Spreadsheets 2013 User Manual A B E 1 2 110119209 80 83 3 110119207 82 87 4 110119214 82 87 5 110119201 83 85 6 110119204 84 86 7 110119210 85 84 8 110119215 86 89 9 110119203 88 85 10 110119208 89 85 11 110119202 90 92 12 110119205 90 87 3 110119211 91 88 14 110119213 92 84 15 110119212 93 83 16 110119206 94 85 Figure 2 7 3 Sort result 2 8 Format 2 8 1 Convert Text to Number and Hyperlink Kingsoft Spreadsheets provides the function to convert text to number and hyperlink You can apply the Convert Text to Number function or the Convert Text to Hyperlink function O When you want to convert a large amount of data in text format to numeric format do the following Click the Format icon in the Home tab and select the Convert Text to Number option in the Format drop down list O When a large number of hyperlinks are not active you can activate them altogether Select the contents you want to change to hyperlinks Click the Format icon in the Home tab and select the Convert Te
120. et for an given period VDB cost salvage life or partial period using the double declining balance start period end period method or some other method you specify Table 5 2 1 Financial Functions 5 2 3 2 Logical Functions There are 7 logical functions in Kingsoft Spreadsheets See below 117 Spreadsheets 2013 User Manual Function Name AND logicall logical2 FALSE IF logical test value _ if true value if false IFERROR value value_if error NOT logical OR logicall logical2 TRUE 5 2 3 3 Text Functions Explanations Returns FALSE if any of the arguments is FALSE returns TRUE only if all arguments are TRUE Returns the logical value FALSE Checks whether a condition is met and returns one value if TRUE and another value if FALSE Returns the values you specify if the calculated result of the formula is an error and the calculated result otherwise Reverses the logical value of the argument Returns TRUE if any of the arguments is TRUE returns FALSE only if all the arguments are FALSE Returns the logical value TRUE Table 5 2 2 Logical Functions There are 33 text functions in Kingsoft Spreadsheets See below Function Name ASC text CHAR number CLEAN text CODE text Explanations Converts full width doubt byte characters to half width single byte characters Use with doubt byte character sets DBCS Returns the character specified by the c
121. ets 2013 User Manual 2 2 3 Patterns You can complete the cell shading setting by the following steps 1 Select the cell or cell range that you want to apply shading to In the Home tab click the Other Borders icon and select the More Borders option in the drop down list The Format Cells dialogue box will open and show as below E Format Cells Number Alignment Font Border Patterns Protect Cell shading Background color Pattern style Pattern color Sample Figure 2 2 4 The Patterns tab 2 Choose the Patterns tab in the Format Cells dialogue box and several options will be available Background Color section offers shading colors for the cell Pattern Style section offers shading patterns for the cell and Pattern Color section offers shading pattern colors for the cell Choose the appropriate option in the corresponding sections 3 Press the OK button to complete the operation You can select the cell or the cell range and right click 1t to open the Context menu Select the Format Cells option and the dialogue box will pop up 2 3 Alignment 2 3 1 Aligning Text Select a cell or a cell range and go to the Home tab Kingsoft Spreadsheets provides six alignment icons 29 Spreadsheets 2013 User Manual Top Align Middle Align Bottom Align Align Text Left Center and Align Text Right Select the proper style you want by clicking the corresponding icon You can also set the ali
122. file name on the title bar will be added with shared 6 After sharing the workbook you can protect or unprotect it by clicking the Protect Shared Workbook and Unprotect Shared Workbook icon in the Review tab Tips If you created a new file before you can confirm to share it the system will warn you to save it first After you have saved the file it will be shared automatically 8 7 Protect and Share Workbook If the workbook has already been shared and you wish to protect the sharing of track changes by entering a password the steps are shown as follows 1 Select the workbook you want to protect 2 Click Protect and Share Workbook in the Review tab Then the Protect and Share Workbook dialogue box will open and show as below 173 Spreadsheets 2013 User Manual E Protect and Share Workbook a Protect workbook for Sharing with track changes This shares your workbook and then prevents change tracking from being removed If desired a password must be chosen now prior to sharing the workbook Password optional ES Figure 8 7 1 Protect and Share Workbook dialogue box 3 Enter the Password and press OK to complete the operation 8 8 Allow Users to Edit Ranges Sometimes you may want others to make changes only to part of the data in the worksheet but keep the rest of it locked To achieve this follow the steps below 1 Click the Allow Users to Edit Ranges icon in the Review tab The Allow
123. gB J A TR ge kingsoft task Place in this Document el E mail Address Address h Cancel Figure 3 8 1 The Hyperlink dialogue box 3 Select the target file in the Link to section 4 Press the OK button to insert the hyperlink between the selected cell and the target file 5 Click the cell where you ve added the hyperlink and you can quickly switch to the target file You can also open the hyperlink by right clicking the cell and choosing the Open Hyperlink option in the context menu 25 teacher Jane 34 driver Tom 38 manager a WA ln fa Whe Sarah 45 policeman Flora 52 teacher Christy 41 singer Jack 36 actor hs oo Figure 3 8 2 Cell with hyperlink 6 To edit the hyperlink you have created right click the cell and choose the Edit Hyperlink option in the context menu The Edit Hyperlink dialogue box will open where you can modify the target file To meet the different requirements of the customers Kingsoft Spreadsheets provides a hyperlink control tab which means you can input information about the Internet or the network path You can decide whether to automatically change internet links into hyperlinks in the worksheet The steps are shown as follows 1 Open the Application menu EEES a the top left corner Click the Options button at the 95 Spreadsheets 2013 User Manual lower right corner 2 Select the Edit tab in the Options dialogue box See below EJ
124. ge _ Margins le Header and Footer ils Sheet Orientation D D O Portrait Landscape Scaling O Adjustto 100 normal size Fit to 1 page s wide by 1 Paper size A4 x Print quality 1600 dpi Md First page number Automatic Options Print Cancel Figure 4 1 9 Zoom the page 2 You can adjust the print scaling in the Scaling section Enter the proportion you want to zoom the worksheet in the Adjust to enter box Kingsoft Spreadsheets supports worksheet zoom from 10 to 400 3 Enter the number of page that you want the worksheet to fit to in the Fit to enter box 4 Enter the width of the worksheet in the wide by enter box Tips When you select Adjust to the system will automatically ignore the manually created breaks Change the values in the Adjust to enter box the spreadsheet will then be printed according to your needs 4 2 Arrange 4 2 1 Arrange Object Orders To rearrange the object orders in Kingsoft Spreadsheets follow the steps below 1 Select the objects which you want to rearrange orders 2 Use the Bring Forward and Send Backward drop down list in the Page Layout tab See below Mo kd l AA Bring Send Alic Align Group Forward Backward A BringForward lt 4 SendBackward Eb Bring to Front y Send to Back Figure 4 2 1 Bring Forward and Send Backward The function of these options are as follows O Bring Forward Bring an ob
125. gnification section 3 You can choose the Fit Selection option to let Kingsoft Spreadsheets automatically choose for you 4 You can also enter the proportion in the Custom enter box 5 Click OK to complete the operation 9 4 Freeze Usually we edit a large number of rows and columns in Spreadsheets But when scrolling it is inconvenient to keep the row or column label shown all the time Sometimes we need to check the labels for the data in some rows or columns We don t want the row or column to move for which it is very 180 Spreadsheets 2013 User Manual helpful to freeze the window The steps to freeze the window are shown as follows 1 In the worksheet select the leftmost cell of the cell range you want to freeze A B D 2012 Data Name Score l Score 2 Score 3 NB 001 l 100 99 98 NB 002 97 96 90 NB 003 99 97 95 NB 004 94 100 100 NB 005 98 92 99 NB 006 96 97 98 NB007 99 100 94 NB 008 197 198 198 NB009 197 194 189 NB010 193 192 187 NB011 190 193 197 de Ly hdr LA ON Oo ju UD NY a O Figure 9 4 1 Select the cell 2 Click the Freeze icon in the View tab 3 There will be a line above the selected cell range Drag the scroll bar and the rows and columns in the frozen range won t scroll The frozen range is always in the top and left most position See below A B C D 1 2012 Data 2 Name Score 1 Score 2 Score 3 11 NB 009 197 194 189 12 NB010 193 192 187 13 NB011
126. gnment of cells by the Format Cells dialogue box The steps are shown as follows 1 Select the cells you want to align 2 Click the Other Borders icon in the Home tab 3 Choose the More Borders option in the drop down list to open the Format Cells dialogue box Select the Alignment tab and choose an appropriate Horizontal and Vertical alignment option in the Text alignment section E Format Cells Number Alignment Font Border Patterns Protect gt Text alignment Orientation Horizontal Indent E General Vertical Center Top Center Bottom Justify Distributed 0 Degrees Vertical text Figure 2 3 1 Set the alignment in the Format Cells dialogue box 4 Press the OK button to complete the operation 2 3 2 Wrapping Text If you need to input multiple lines of data into a cell take the following steps 30 Spreadsheets 2013 User Manual 1 Select the cell with the data you want to wrap 2 Click the Wrap Text icon in the Home tab to wrap the data Aside from the way mentioned above you can also wrap the data through the Format Cells dialogue box The steps are shown as follows 1 Select the cell with the data you want to wrap 2 Click the Other Borders icon in the Home tab and choose the More Borders option in the drop down list 3 The Format Cells dialogue box will open In the Alignment tab select the Wrap text check box in the Text contro
127. gsoft Spreadsheets automatically recalculates formulas only when the cells which contain the formulas change or the structure of the spreadsheet changes 5 5 1 Automatic Calculation If you turn on the automatic calculation mode when the cells which contain the formulas change Kingsoft Spreadsheets will recalculate formulas automatically The automatic calculation mode is turned on by default in Kingsoft Spreadsheet but you can also manually turn on this mode Follow the steps below 1 Open the Application menu EXA at the top left corner of the window and click Options at the bottom 2 Choose the Recalculation tab in the Options dialogue box See below B Options View Calculation gt Automatic Manual Calculation Edit Iteration Maximum iterations 3 General and Save Maximum change 0 001 Custom Lists Workbook options Color A 4 Precision as displayed Security Error Checking Spelling Privacy Figure 5 5 1 Automatic Calculation 3 Select the Automatic option button in the Calculation section 4 Click OK to complete the operation 144 Spreadsheets 2013 User Manual 5 5 2 Manual Recalculation When there are complex circular references in a formula you can turn on the manual calculation mode and recalculate manually The operation steps are shown as follows 1 Open the Application menu EXA at the top left corner of the window and click Options at the bottom 2 Choose the Recalculation tab
128. has the same number of rows with array 1 and the same number of columns with array 2 Returns the remainder after the number is divided by a divisor Returns a given number rounded to a special multiple Returns the ratio of the factorial of a sum of values to the product of factorials Rounds positive numbers up and negative numbers down to the nearest odd integers The PI function returns the value of Pi 3 14159265358979 accurate to 15 digits 127 Spreadsheets 2013 User Manual Function Name POWER number power PRODUCT numberl QUOTIENT dividend divisor RADIANS angle RAND RANDBETWEEN bottom top ROMAN number type ROUND number num digits ROUNDDOWN number num_ digits ROUNDUP number num digits SERIESSUM x n m coefficients SIGN number SIN number SINH number SQRT number SQRTPI number Explanations The POWER function returns the result of a number raised to a power The PRODUCT function multiplies all the numbers given as arguments and returns the result Returns the integer portion and discard the remainder of a division The RADIANS function converts degrees to radians The RAND function returns an evenly distributed random real number greater than or equal to 0 and less than 1 changes on recalculation Returns a random integer number between the two numbers you have specified Converts Arabic number to Roman as text Rounds a number to a
129. he serial number 22GHC XXXXX XXXXX XXXXX XXXXX Subtotal Kingsoft Writer Not limited Kingsoft Presentation Not limited Kingsoft Spreadsheets Not limited OK Cancel Figure 1 3 9 Add product serial number The product key will be recorded as Not limited 1 3 7 Switching Among Multiple Files by the Unique Tab Feature Much like a modern web browser which allows a user to open multiple web pages as tabs under the same window Kingsoft Office Free Office Professional Office tab feature offers users the same luxury for word documents spreadsheets and presentations 1 3 7 1 Advantages of Kingsoft Office Tab Feature Common Office suites such as Microsoft Office and OpenOffice force users to open a new window every time they want to start a new document which has a tendency to create a cluttered desktop and in some cases even impacts user s decision whether or not to create a new document Kingsoft Office s tab feature eliminates the problem of having too many documents workbooks presentations open at one time allowing user to conveniently switch between documents in one window by pressing the shortcut key lt Ctri Tab gt WN Writer Home Insert Page Layout References Review View Section Developer E Times New Roman 12 NA i EEW AS AaBb Paste 7 Format B IT U AB X xX Z A B Ii A Ej Nom Painter b H Sa Spreadsheets 2013 User Manual Figure 1 3 10 Open mu
130. he text data 1 3 1 3 Inputting Numbers Numbers are composed of the digits 0 9 and some special characters such as etc There are several tips to consider when inputting numbers O When you enter a positive number you do not have to add a before the number Even if you add it it will automatically be omitted O When you enclose a number in or parentheses it means you have input a negative number For example 123 refers to 123 O If you want to enter a fraction you should add a 0 before it otherwise the system will display it as date For example if you want to input 1 2 you should input 0 1 2 There should be a blank space between 0 and 1 2 Otherwise it will display as 01 Feb O When the input number is longer than the cell width or more than 11 digits it will be automatically displayed in scientific notation Spreadsheets 2013 User Manual 1 3 1 4 Inputting Date and Time When inputting date you can use or to separate the year month and day For example 11 4 19 or 11 4 19 When inputting time you can use to separate hours minutes and seconds For example 9 30 and 10 30 AM There are several tips you should pay attention to O In Kingsoft Spreadsheets the date and time are treated as numbers which means that you can perform calculations with them O If you want to enter a 12 hour time you should add AM or PM after the time Otherwise it will be treated as a 24 hour time O
131. hown below i ROSA A N Gri Across Worksheets Fill Al Contents Formats Loc _concet_ Figure 2 9 10 Fill Across Worksheets dialogue box All The same contents and formats will be filled without change eo Contents Only fill with the same contents while the existing formats remain Oo Formats Only fill with the same formats while the existing data remains 4 Select the All option and press the OK button to complete the operation The result is shown as below A B D 1 2 3 4 2009780111 5 2009780112 6 2009780113 7 2009780114 8 2009780115 9 2009780116 10 2009780117 11 12 4 gt Sheet1 Sheet2 Sheet3 Figure 2 9 11 The Fill effect 62 Spreadsheets 2013 User Manual 2 9 6 5 Series To set the fill series follow the steps below 1 Select the rows and columns to which you have applied the fill series function 2 Select the Fill option in the Rows and Columns drop down list 3 Choose the Series option and the Series dialogue box will open and show as below S Series Ss Series in Type Date unit Rows Linear O Columns Growth eekda Date AutoFill Trend seth Step value 3 Stop value 0 Gm Figure 2 9 12 The Series dialogue box 4 The Rows or Columns option will automatically be selected specifying the target object in the Series in section 5 Select a series type in the Type section Oo Linear the contents will be inserted in the linear type Oo Growth th
132. ial Functions There are 19 financial functions in Kingsoft Spreadsheets See below Function Name ACCRINT date of issue value date transaction date rate face value ACCRINTM date of issue maturity date rate face value basis DB cost salvage life period month DDB cost period factor salvage life FV rate nper pmt pv type IPMT rate per nper pv fv IRR values guess ISPMT rate per nper pv MIRR values reinvest rate finance rate Explanations Returns the interests of the securities whose interests should be paid off once the time is due Returns the interests of the securities whose interests should be paid off once the time is due Returns the depreciation of an asset for a specified period using the fixed declining balance method Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify Returns the future value of an investment based on periodic constant payments and a constant interest rate Returns the amount of interest payment for an investment within a given period based on periodic constant payments and a constant interest rate Returns the internal rate of return that is represented by numbers for a series of cash flows Calculates the interest that should be paid within a specific investment period Returns the modified internal rate of return for the
133. in the Options dialogue box See below Ej Options xs View Calculation a Automatic O Manual Calculation Edit Iteration Maximum iterations 100 General and Save Maximum change 0 001 Custom Lists Workbook options Color Precision as displayed Security Error Checking Spelling Privacy cancel Figure 5 5 2 Manual Calculation 3 In the Calculation section select Manual 4 Press OK and finish the Manual Recalculation setting If you turn on the manual calculation mode when the cells which contain the formulas change Kingsoft Spreadsheets won t recalculate formulas automatically If you need to calculate the current sheet click the Calculate icon in the Formulas tab O If you need to calculate the entire workbook click the Recalculate Workbook icon in the Formulas tab 5 5 3 Iteration Kingsoft Spreadsheets provides an iteration calculation function Iteration refers to repeated recalculation of a worksheet until a specific numeric condition is met When the number of times of recalculating 145 Spreadsheets 2013 User Manual exceeds the required number or the results of two calculations meet some specified limit the calculation will end To apply the iteration calculation function follow the steps below 1 Open the Application menu EXA at the top left corner of the window and click Options at the bottom 2 Choose the Recalculation tab in the Options dialogue box See below E Option
134. in the View tab The Macros dialogue box will open and show as below Macros Macro name Spinner45 Modi Step Into Edit Delete Options Macro in All active templates and documents Y Cancel Description Figure 10 1 1 The Macros dialogue box 2 Enter the macro name in the Macro name enter box 3 Select the range you want to apply the macro in the Macro in drop down list 4 Add description for this macro in the Description enter box The functions of the buttons at the right side are shown as follows O Run Click to run the current macro 182 Spreadsheets 2013 User Manual e Edit Click to edit the macro in Microsoft Visual Basic Oo Delete Click to delete the macro eo Options Click to add shortcut key for the macro 5 Click Cancel to exit 10 2 Security In Kingsoft Spreadsheets you can set security level for the macros follow the steps below 1 Click the Security icon in the Developer tab The Security dialogue box will open and show as below Security B Em Security Level Trusted Publishers Very high Only macros installed in trusted locations will be allowed to run All other signed and unsigned macros are disabled High Only signed macros from trusted sources will be allowed to run Unsigned macros are automatically disabled Medium You can choose whether or not to run potentially unsafe macros Low not r
135. is view mode will display where the pages will break when printed Oo Normal View exit the print preview mode and view the current file in the normal mode o Portrait set the worksheet pages to portrait O Landscape set the worksheet pages to landscape O Header and Footer edit the header and footer of the document Page Setup open the Page Setup dialogue box and set the corresponding values there Margins specify the distance between the contents of the worksheet and the edges of the printed page o Close close the Print Preview tab 1 4 7 The Send E mail Option in the Application Menu To send the current file to others by E mail the steps are as follows 1 Click the Application Menu icon to open the drop down list and choose the Send E mail option The Send E mail task window will open 2 You can set the information such as the addressee the sender the main topic and the attachments in the task window 3 Click the Send button to send the E mail 1 4 8 The File Information Option in the Application Menu Click the Application Menu icon to open the drop down list Choose the File Information tab and you can see two options listed in the Document Protection and Properties section as shown below 18 Spreadsheets 2013 User Manual SENG CMR Home Insert Page Layout Formulas Data Table Style A King Document Protection and Properties E fe Encryption Open 3 Properties Save Save As Print w t Ea
136. ject one step closer to the front Oo Bring to Front Bring an object to the front of the stack Send Backward Send an object one step toward the back 107 Spreadsheets 2013 User Manual O Send to Back Send an object to the back of the stack Tips Select the object you want to move If the object is hidden select any object and then press lt Tab gt or lt Shift Tab gt until the object you want is selected 4 2 2 Align 4 2 2 1 Align Objects Kingsoft Spreadsheets provides 6 align options Align Left Align Center Align Right Align Top Align Middle and Align Bottom The operation steps are shown as follows 1 Select the objects you want to align 2 In the Page Layout tab select the options in the Align drop down list See below A p co L 2h b f Group Rotate Selecti Align Left HE Align Center S Align Right it Align Top it Align Middle la Align Bottom Ha Distribute Horizontally Distribute Vertically t Equal Height i Equal Width 1 6 Equal Size HEH Snap to Grid E Show Grid Figure 4 2 2 The Align drop down list 4 2 2 2 Distribution Kingsoft Spreadsheets provides two distribution methods Distribute Horizontally and Distribute Vertically If objects are arranged in equal distance you can use the horizontal and vertical distribution methods The operation steps are shown as follows 1 To distribute objects you have to select multiple objects Hold lt Ctrl gt
137. l KINGSOFT Office Visit us at www ksosoft com
138. l section Shown as below E Format Cells Number Alignment _ Font Border Patterns Protect Text alignment Orientation Horizontal Indent General Vertical Center Text control Shrink to fit O 54D Merge cells egrees Vertical text Figure 2 3 2 The Wrap text check box 4 Click the OK button to complete the operation The keyboard shortcut combination lt Alt Enter gt also performs this function 2 3 3 Merging Cells There are four options in the Merge and Center drop down list Merge and Center Merge Across Merge Cells and Across Center In the Home tab select options in the Merge and Center drop down list as shown below These options can make the merging of cells much quicker and easier 31 Spreadsheets 2013 User Manual Ka P5 E 0 00 LI Merge and Center 7 Merge Across m Merge Cells c Across Center Figure 2 3 3 Merge and Center drop down list Merge and Center The selected cells will be merged and the content they contain will be aligned to the center Oo Merge Across Selected columns and rows will be merged but the number of columns and rows will not change in this case Merge Cells Merge the selected cells Oo Across Center The content in every cell will be aligned to the center but the cells will not be merged The alignment standard is based on the longest cell selected You can merge or split cells by the following st
139. list box and preview the change in the Sample box See below 37 Spreadsheets 2013 User Manual Number Category Up to one digit 1 2 Up to two digits 22 45 Up to three digits 289 591 As halves 1 2 As quarters 2 4 As eighths 4 8 As sixteenths 8 16 lx Figure 2 4 7 Fraction format and options Oo Scientific Select Scientific in the Category section The Sample box on the right displays the format changes You can set the decimal digits in the roll down list See below Number Category Sample Decimal places oe J cms Figure 2 4 8 Scientific format and options Oo Text Select Text in the Category section Contents in the text format cells are treated as text even 1f they are numbers The cell is displayed exactly as entered 38 Spreadsheets 2013 User Manual Oo Special Select Special in the Category section There are three types of special formats namely the Zip code Zip Code 4 and Social Security Number See below E Format Cells Ea Number Alignment Font Border Patterns Protection Category Sample General Number Type Currency Zip code Accounting Zip code 4 Date Social security number Time Percentage 1 Fraction Scientific 2 13411782901 13411 78 2901 en 3 13411782902 13411 78 2902 Custom 4 13411782903 13411 78 2903 5 13411782904 13411 78 2904 Special formats are useful for tracking list and databas
140. ls whose formatting you want to clear Choose the Formats option in the Clear drop down list which will clear the format but keep the content intact O Contents Select the cells whose contents you want to clear Choose the Contents option in the Clear drop down list which will clear the contents but keep the format intact O Comments Select the cells whose comments you want to clear Choose the Comments option in the Clear drop down list When the little red triangle disappears this means cell comments have already been cleared Thus you can select the clear options according to your requirements 2 9 Rows and Columns You can change the structure of the worksheet by performing operations on it The main operations include select move set row height and column width insert delete fill and hide and display rows and columns 2 9 1 Selecting Rows and Columns If you want to carry out operations on rows or columns you have to select them first Click the row number or the column label to select a single row or a single column You can select a single row or column first press the lt Shift gt key and click another row number or column label at the same time In this way you can select two or more than two rows or columns which are adjacent An alternative is to press the lt Ctrl gt key and click different row numbers or column labels at the same time In this way you can select more than one row or column which are non adjac
141. lter in the AutoFilter drop down list The Advanced Filter dialogue box will open and show as below 48 Spreadsheets 2013 User Manual g Advanced Filter x Action Filter the list in place Copy to another location List range Sheet1 F 19 Pel Criteria range By CvtonrlinAn ronne mr Hao rin cxtendng range may cover Me orginal i Unique records only Gl ma Figure 2 6 18 The Advanced Filter dialogue box Filter the list in place hide data rows that don t fit the filter condition and display the filter result in the original worksheet Oo Copy to another location copy the data rows that fit the filter condition to another location But the data rows which don t fit the filter condition will remain in the original worksheet and won t be hidden It is very convenient to compare the data in this way 2 Select the Copy to another location and the Unique records only check box The filter result will be copied to the specified place you have chosen 3 Select the List range Criteria range which you have created as shown above and Copy to range in the worksheet See below A B C 1 gt 3 4 5 6 8 El Advanced Filter Ea 9 Action 10 gt Filter the list in place 11 Copy to another location 12 List range Sheet1 A 3 C 10 Ay 7 ae gt Criteria range Sheet1 A 12 C 14 By gt lt eman aa Copy to Sheet 1 A 16 Fel 15 16 Extending range may cover the original d
142. lter option 4 In the Custom AutoFilter dialogue box set the operation conditions and upper and lower limit values See below 45 Spreadsheets 2013 User Manual E custom AutoFilter mrm Show rows where Student No O And Or lis less than X 90 Use to represent any single character Use to represent any series of characters Figure 2 6 10 Custom AutoFilter dialogue box 5 Click the OK button to complete the operation The filter result is shown as below A B C l id zj 2 110119201 87 90 3 110119202 89 94 amp 110119207 89 88 9 110119208 87 90 15 110119214 87 94 Figure 2 6 11 The Custom Filter result 2 6 2 Reapply After making changes to the data you can use the Reapply function in the Autofilter drop down list to re filter the data by the same condition you have specified For example you have filtered the Score 1 column by the condition Above Average Then you change the score in B7 See below A B C A B C l El a 2 bd ES 3 110119202 90 92 3 110119202 90 92 4 110119203 88 85 4 110119203 88 85 6 110119205 90 87 6 110119205 90 87 7 110119206 94f z 841 85 9 110119208 89 85 9 110119208 89 85 12 110119211 91 88 12 110119211 91 88 13 110119212 93 83 13 110119212 93 83 14 110119213 92 84 14 110119213 92 84 Figure 2 6 12 Modify the data At this point select the Reapply option in the AutoFilter drop down list The score in B7 after the change is no longer qualified for the conditi
143. ltiple files in Writer amp Spreadsheets Home Insert Page Layout Formulas Data Table Style re X Cut Times New Roman 12 A ka Paste Copy Format B J A Mergeand y Painter Center DHEAS Figure 1 3 11 Open multiple files in Spreadsheets SNE Home Insert Design Animation Slide Show Revie R Cyl y ES 15 Arial 18 A A From Current New Slide Figure 1 3 12 Open multiple files in Presentation The ability to create document tabs not only allows the user to easily see what documents they have opened but also most importantly saves the user s time and ultimately allows the user more time to think about what to write rather than where to find a certain document Home Insert Page Layout References Review View section JS ons y _ E oat Times New Roman 12 NAVY ir En Paste or Seco BI U sp x x 37 A B Be A ainter Document 2 BHEAS gt E Figure 1 3 13 Organize tab orders Users can organize the order of tabs by clicking and dragging a document tab to its desired location which gives the user control on how to prioritize tabs based on each one s importance 1 3 7 2 Closing File Tabs by Double Clicking Kingsoft Office s tab feature is built to save user s time quickly close the window by double clicking on the desired tab or create a new blank document by right clicking pressing the shortcut key lt Ctri N gt or even pressing the tab for a new page
144. m rs X Cut Paste Copy Format B J U WH y Times New Roman Painter E A S s v Bj Book1 xls Q fx M B DN ln de LY y Figure 2 9 7 Auto Fill The second type includes 1 2 3 2 4 6 and other numeric sequences For numeric sequences you need to enter the first two numbers which display the change pattern and then drag the fill handle to fill in the specified pattern For non sequence text such as Office and numeric sequences that don t specify the change pattern such as 200 drag the fill handle to duplicate the content 2 9 6 3 Fill Data by the Fill Drop down List You can also apply the fill function by the Fill drop down list Follow the steps below 1 Select the position adjacent to the cells rows and columns whose content you want to duplicate 2 Choose the Fill option in the Rows and Columns drop down list There are several options offered in the Fill drop down list See below 60 Spreadsheets 2013 User Manual and Worksheet Findand Settings ns Replace 7 L Row Height a AutoFit Row Height Column Width p Q aJ AutoFit Column Width Standard Width a Insert Cells EX Delete Cells Fill 2 4 Down Ctrl C Hide and Unhide gt Right Ctrl R t Up Left Series Figure 2 9 8 The Fill drop down list 3 You can choose the option according to your needs The function of the options are as follows Down insert
145. m the last character of a text string Use with double byte character set DBCS Converts a number to text using currency format RMB and the specified digits Returns the first found location of the specified character or string with in a text string reading from left to right not case sensitive Returns the first found location of the specified character or string with in a text string reading from left to right not case sensitive Use with double byte character set DBCS Replaces part of the old text with new text in a string 120 Spreadsheets 2013 User Manual Function Name T number TEXT value format_text TRIM text UPPER text VALUE text WIDECHAR text Explanations Returns the text that the value refers to Returns value as a string with the specified format Returns text with only single spaces between words Returns the upper case version of a text string Returns the numeric value of a text string Converts half width single byte characters to full width double byte characters Use with double byte character set DBCS Table 5 2 3 Text Functions 5 2 3 4 Date and Time Kingsoft Spreadsheet provides 21 functions in Date and Time category See below Name DATE year month day DATEIF start date comparison unit DATEVALUE date_ text DAY serial_ number DAYS360 start date method end date end date Explanations Return
146. me used in the current workbook as formula to the selected cells Follow the steps below 1 Define the name for the selected cell follow the steps in 5 4 1 2 Select the cell where you want to paste the name you have defined 3 Click the Paste icon in the Formulas tab and the Paste Name dialogue box will open and show as below S Paste Name m Paste Name Score Paste List OK Cancel Figure 5 4 3 The Paste Name dialogue box 4 Select the name you have defined in the Paste Name list box 5 Click OK to complete the operation The result is shown as below Home Insert Page Layout Formulas Data Table BE Y aaa g Insert AutoSum Recently All Financial Logical Text E Function Used E A SAs E Booki xls xi A B C D D 1 2 1 2009780111 3 2 2009780112 90 96 3 2009780113 100 94 5 4 2009780114 88 92 6 5 2009780115 92 100 7 6 2009780116 92 95 8 7 2009780117 97 92 Figure 5 4 4 The Paste Name result 143 Spreadsheets 2013 User Manual 5 5 Calculation Calculation is the process of computing formulas in the worksheet and then displaying the results as values in the cells which contain the formulas By default the spreadsheet will automatically compute formulas in the workbook when you open it In Kingsoft Spreadsheets there are plenty of ways to compute data such as Automatic Calculation Manual Recalculation and Iteration To avoid unnecessary calculations Kin
147. n The effect is shown below amp Spreadsheets Home Insert Page oo E l PivotTable AutoFilter Advz BHesease Y de U N l D Lun Figure 6 4 3 The effect after setting 155 Spreadsheets 2013 User Manual 6 5 Consolidate By the consolidation function data in the cells stored in several worksheets will be combined into one place helping the user to analyze and manage it more conveniently For example a company makes a census about the total sales in 2012 and 2013 and creates a statistics forecast of sales for each year separately but you want to combine them together in one worksheet Here you can use the consolidation function Here are some terms in the consolidation function Oo Goal Sheet The sheet which stores the consolidated result O Goal Range The range which receives the consolidated data O Original Sheets The sheets which have been consolidated O Original Ranges The ranges which have been consolidated Kingsoft Spreadsheets provides two methods to consolidate by position and by category 6 5 1 Consolidate by Position When you want to consolidate data by position make sure that each range of data has the same layout That means each range of data to be consolidated must be in the corresponding position on each separate worksheet For example in the example workbook the first two worksheets are 2012 Data and 2013 Data We want to consolidate data in the first two worksheets and put th
148. n this dialogue box If you are 148 Spreadsheets 2013 User Manual not satisfied with it you can click Back to reset until you are satisfied 8 Click OK to complete the operation 6 1 2 Use ODBC data source connection guide The second way is to use the ODBC data source connection guide The operation steps are shown as follows 1 Click the Import Data icon in the Data tab and the Select Data Source dialogue box will open and show as below Select data source C Open data file directly Use ODBC data source connection guide W Select Data Source Input connection string manually Explanation You can choose from three different ways to connect to your chosen data source Next gt Finish Figure 6 1 5 Import Data 2 Select the Use ODBC data source connection guide option button and the Data Link Properties dialogue box will open and show as below Provider Connection Advanced an Select the data you want to connect to gt OLE DB Provider s Microsoft Jet 4 0 OLE DB Provider Microsoft Office 12 0 Access Database Engine OLE DB Pro Microsoft OLE DB Provider for Analysis Services 9 0 Microsoft OLE DB Provider For Data Mining Services Microsoft OLE DB Provider for Indexing Service Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAP Services 8 0 Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for Sear
149. name jook 3 et Save as type Kingsoft Spreadsheets Files et hd in Figure 1 4 6 The Save As dialogue box 2 Enter the name you prefer for the current document in the File name text box and choose the file type in the Save as type drop down list 3 Click the Save button to complete the operation 4 If you want to cancel the operation click the Cancel button or click the red cross at the top right corner of the dialogue box 5 By clicking the Encryption button at the bottom right you can open the Security tab in the Options dialogue box Shown as below Security File encryption options for this workbook The password will protect your workbook Document password Reenter password to open l j File sharing options for this workbook Password to modify Reenter password to modify Caution Please keep your password properly Losing or forgetting the password will cause the file never to be recovered Remember that passwords are case sensitive Figure 1 4 7 The Security tab 15 Spreadsheets 2013 User Manual 6 You can set the security related setting here such as the Document password Reenter password Password to modify etc 7 Click the OK button to complete the operation You can also export the current file to PDF format The steps are as follows 1 Choose the Export to PDF option in the Save As tab The Export to Adobe PDF File dialogue box will open and show as
150. nd their prices are 1 2 and 2 5 To use this function follow the steps below 1 Create a worksheet containing the product sales information See below A B C D E F G H Pen Sales Solver D6 D10 D14 sales volume of gel pef D5 ume wid ball pen D9 D13 price per gel pen 1 00 Total revenue volume of sales 6 subtotal D4 D5 UN de N n 8 price per pen 2 00 D13 D9 D5 9 volume of sales 10 subtotal D8 D9 11 12 price per ball pen 2 50 13 volume of sales 14 subtotal D12 D13 Figure 6 10 3 Worksheet containing the information 164 Spreadsheets 2013 User Manual 2 The target cell here G4 is achieved by adding the three variable cells namely D6 D10 D14 Whereas the value in the three variable cells are achieved by multiply the price with the volume of sales of each kinds of pen separately The constrains area contains limiting conditions You can list them down to help you organize your thoughts 3 In the Data tab select the Solver Parameters in the What If Analysis drop down list The Solver Parameters dialogue box will open and show as below E Solver Parameters a E Set Objective 6 4 To Max Min Value Of i By Changing Variable Cells D 5 D 9 D 13 Subject to the Constraint GS8 lt G 11 Add GS7 lt G 512 DS13 lt 6513 Change A Delete Reset All V Make Unconstrained Variables Non Negative Select a Solving Method
151. nee nee 176 Othe Us oot tc a a aeration ball dis eaie su a A 177 Dle UMMC Mester aah oa bce cok te er ep attested A ts aecal oa eel 178 Ol Reddine Tay Outs sigs dd dias 178 9 2 View Check Boxers ld dond 179 SO A RS 180 JAEN its 180 9 3 Window COONS aora las i cols oasis 181 Spreadsheets 2013 User Manual 10 Developer Tainena aaaea e E EE 182 IOT MATOS ii iii 182 10 2 Secur yonin n E E AEN T 183 10 3 Other Functions AAA nae aaea o O ASe A AS SEANA EE CEO NAE a E OSNES ESES 183 vii Spreadsheets 2013 User Manual 1 Kingsoft Spreadsheets Basic Operation 1 1 Brief Introduction As one of three Kingsoft Office 2013 components Kingsoft Spreadsheets is an independent and powerful spreadsheet application Kingsoft Spreadsheets can not only fulfill your daily needs of analyzing data but also help you to perform more professional data processing tasks 1 2 Kingsoft Spreadsheets Interface If you have worked by any Windows programs or Microsoft Excel before you are already familiar with the Kingsoft Spreadsheets user interface It has all of the standard window components such as the title bar menu bar status bar and so on Title Bar The title bar displays the name of the workbook When you create new workbooks the system will automatically name your workbooks as Book1 Book2 and so on Menu Bar The menu bar contains different commands that you can use to edit the worksheet Name Box The name box displays the selected cell
152. ns the sum of sum squares of corresponding values in two arrays Returns the sum of squares of differences of corresponding values in two arrays Returns the tangent of the given angle Returns the hyperbolic tangent of a number Returns an integer by removing decimal part of the number Table 5 2 6 Math and Trigonometry Functions 129 Spreadsheets 2013 User Manual 5 2 3 7 Statistical Functions Click the More Functions icon in the Formulas tab and choose the Statistical option in the drop down list There are 83 statistical functions in Kingsoft Spreadsheets See below Function Name AVEDEV numberl number AVERAGE numberl number AVERAGEA numberl number AVERAGEIF range criteria average range AVERAGEIFS average range range 1 BETADIST value x alpha beta lower bound of the x range upper bound of the x range BETAINV distribution probability alpha beta lower bound of the x range upper bound of the x range BINOMDIST number s trials probability _ s returns the cumulative distribution function CHIDIST number degrees of freedom CHIINV distribution of probability Explanations Returns the average of the absolute deviations of data points from their mean It is a measure of the variability in a data set Returns the average of the arguments Returns the average arithmetic mean of all the arguments including numbers text and logical values Evaluate text
153. nt Page Setup open the Page Setup dialogue box and set the corresponding values there Oo Margins specify the distance between the contents of the worksheet and the edges of the printed page Close close the Print Preview tab 9 1 3 Page Break Preview If you are working in a long document and want to break it into many pages you can insert a page break in the worksheet After the insertion you can preview the worksheet in the page break preview mode There are two ways to insert a page break automatic and manual 9 1 3 1 Automatic Page Break In the Page Setup dialogue box see 4 1 6 and 4 1 7 select the Page tab to set suitable paper size for printing If you set values in the Adjust to section the system will ignore all the page breaks you have manually set After setting the values in Adjust to section click the Page Break Preview icon in the View tab and the worksheet will automatically be separated into pages you have set For example set Adjust to two page width and one page tall click Page Break Preview in the View tab and the worksheet will be separated into two pages automatically Shown as below A B C D E F G H I 2013 Data 2012 Data Name Score 1 Score2 Score3 Score 4 Name Score 1 Score 2 Score 3 3 NB 001 97 99 NB 001 99 9 NB 002 100 98 NB 002 96 Vertical page break line 5 NB 003 94 95 NB 003 97 NB 004 96 93 NB 004 100 7 NB 005 98 100 NB 005 92 NB 006 93 92 NB 006 97 NB 007 100 98 NB 007
154. ny one of them the corresponding tab will open at the right side where you can select or deselect the check box to set the preferred values Click the red Exit icon at the bottom right or click anywhere in the document to close the Application Menu 2 Home tab 2 1 Clipboard Functions After selecting the text or object you can move copy delete and carry out various other commands on the selected content You can complete all of these operations through the control command the shortcut keys or the mouse The clipboard functions offered by Kingsoft Spreadsheets are shown as below oy Paste Copy Format Painter Figure 2 1 1 The clipboard functions 22 Spreadsheets 2013 User Manual 2 1 1 The Paste Function Paste refers to moving the contents from the system clipboard to the file at the designated insertion point The paste operation can only be performed unless the clipboard is not empty To paste contents follow the steps below 1 Select the contents you want to paste and click the arrow on the Paste icon E in the Home tab The Paste drop down list will then open and show as below 4 Paste 7 sai fx Formulas Kil No Border K values 3 Transpose ff Paste as Picture Es Paste Special Figure 2 1 2 The Paste drop down list 2 Kingsoft Spreadsheets provides seven different methods of pasting contents O Formulas Paste the formulas contained in a data set rather than the data itself
155. ode number from the character set for your computer Removes all nonprintable characters from text Returns a numerical code for the first character in a text string in the character set used by your 118 Spreadsheets 2013 User Manual Function Name Explanations computer CONCATENATE text 1 text 2 Joins several text strings into one text string Converts a number to text using the currency DOLLAR number decimals format US dollar and specified digits Returns TRUE if one string is exactly equal to EXACT text 1 text 2 the other string EXACTLY means case sensitive returns FALSE otherwise Returns the starting position of one text string FIND find text within text within another case sensitive and wildcard start_num characters are not allowed Searches another text string s starting location in FINDB find text within text one text string FINDB is case sensitive and start num doesn t allow to use wildcard Use double byte characters DBCS Rounds number to the specified number of FIXED number decimals decimals in decimal format and returns the result no commas as text with or without commas Returns the first character with a specified LEFT text num_chars number from the first character of a text string Returns the specified number of characters from LEFTB text bytes number the leftmost appointed position of a text string Use with double byte character set DBCS LEN tex
156. of selected objects text and cells and apply it to the corresponding content you prefer 1 Put the cursor on the cells or objects whose format will be replicated 2 Click the Format Painter icon inthe Home tab 3 The mouse pointer will then change into 4 Select the object or cells which would be formatted to complete the operation Tips If you want to use format painter continuously you can double click the Format Painter icon to Format highlight it as tente 2 2 Font The content of different cells can be set in different font formats borders fill colors etc according to your needs All of these things make it easier to highlight and emphasize the content you prefer 2 2 1 Font Format The font format setting refers to set the font size style color of the contents 2 2 1 1 Font Kingsoft Spreadsheets provides a variety of fonts for your choice There are appropriate fonts for different tastes situations and requirements To set the font follow the steps below 25 Spreadsheets 2013 User Manual 1 Select the cell or text for which you want to set the font 2 Click the Font drop down list Yer Roman in the Home tab and select an appropriate font The list is shown in the following figure Times New Roman 12 NA Recent Fonts Tr Gabriola Tr Times New Roman T Calibri T Arial Tr CordiaUPC All Fonts Tr MingLiU_HKSCS Tr MingLiU_HKSCS ExtB Tt PMingLiv Tr PMingL1U
157. ok a Password optional ra Figure 8 5 1 The Protect Workbook dialogue box 3 Input the password and then press OK 4 If you want to remove the protection on a workbook click the Unprotect Workbook icon in the Review tab and then input the password to cancel the protection 8 6 Share Workbook If you want multiple users to edit a workbook at the same time you can share your workbook which means to put the workbook under a shared directory a web server for example Then others can access the shared workbook through the Internet This feature makes it more effective and easier for multiple users to edit a workbook simultaneously The operation steps are as follows 1 Select the workbook you want to share 2 Click the Share Workbook icon in the Review tab The Share Workbook dialogue box pops up 172 Spreadsheets 2013 User Manual 5 Share Workbook Edit Allow changes by more than one user at the same time This also allows workbook merging Who has this workbook open now admin Exclusive 2014 04 30 17 05 Lema Figure 8 6 1 Set for sharing workbook 3 Click the check box in front of Allow changes by more than one user at the same time This also allows workbook merging 4 Click OK and the Save As dialogue box will open Choose Kingsoft Spreadsheets Files et as the Save as Type Input the File Name and press Save to complete the operation 5 After sharing the workbook the
158. omepage Save Kingsoft Office Facebook Save As Check for Updates Print Purchase Serial Number w 4 E E Print Preview ovv cn About Kingsoft Spreadsheets EA Send E mail eo File Information Backup Management Help N gt amp Options Exit Figure 1 4 15 The Help tab You can choose any of the options namely Kingsoft Spreadsheets Help Kingsoft Office Homepage Kingsoft Office Facebook Check for Updates Purchase Serial Number and About Kingsoft Spreadsheets to open the corresponding web pages and know more about Kingsoft Spreadsheets Tips You can also click the Help icon at the top right corner of the screen or press the lt F1 gt shortcut key to open the relevant web pages 1 4 11 The Options Function in the Application Menu Click the Application Menu icon to open the drop down list Click the Options icon at the bottom right of the drop down list The Options dialogue box will open and show as below 21 Spreadsheets 2013 User Manual 5 Options View Calculation Edit General and Save Custom Lists Color Security Error Checking Spelling Privacy Show F Startup task window V Formula bar 7 Status bar Window options V Page breaks V Row and column headings V Sheet tabs Y Gridlines Y Outline symbols Y Zero values Gridlines color Automatic v as Figure 1 4 16 The Options dialogue box You can see a number of tabs at the left side of the dialogue box By choosing a
159. on you have specified i e Above Average Thus it is filtered out See below 46 Spreadsheets 2013 User Manual A B C 1 gj iA 3 110119202 90 92 4 110119203 88 85 6 110119205 90 87 9 110119208 89 85 12 110119211 91 88 13 110119212 93 83 14 110119213 92 84 Figure 2 6 13 Filter result 2 6 3 Advanced Filter The Advanced Filter option allows you to use complex conditions to filter a range The filter result can be displayed either in the original worksheet or in a new location Those rows which don t meet the criteria will be hidden To specify the conditions of the Advanced Filter function you have to create the specific Criteria range first Mind that the criteria range should be created out of the data range which you want to filter Oo Multiple conditions in a single column if you want to filter the data by conditions of the same category you can simply enter the conditions under the header of the category For example to filter the data by the condition Name is Jane or Flora The criteria range and filter result are shown as below Jane 34 driver Flora 52 teacher Figure 2 6 14 Multiple conditions in a single column o Multiple conditions in a single row if you want to filter the data by more than two conditions you can enter them from the right to the left under the corresponding categories For example to filter the data by the conditions Age gt 20 and Occupation is teacher See below
160. os 21 2 THOMIC A O AR A 22 2 1 Clipboard FUNCION ia dicen ORIO isa IU 22 A Wes WO e A nr ee a re ream rey rrr Cre reenter iat te teetre Meee tH near 23 PAE POS Ge MIMD ee boe e AAA A O A A N 24 Spreadsheets 2013 User Manual ARS eal See alaska teal eds oe A rae toets 25 2TA Tonnar PAM AA A A AE 25 ZZ E TE EE A 25 ZAUEN E O 25 22 y A N 21 DoD A IS AA E vcd eed ol Se se AAA AAA AA 29 PAEA YT OO 29 AS MOTRIN CU ae hast lee ak east E 29 A WV Weep pM is 30 A A eee ee ee 31 Ko GUS AS WG CMG eee te oles S 33 ZAN IMD dl s 33 ZA MOMES SE CEO Ma orina 33 ZA COV OA E iaa 33 AE O 40 ZO TM sida 40 ZO AO US A SA 40 EI TRG ANON A alte assed cet ET ETE OEE EE E AEE E T I Atase 46 ZO ANACO UE A T E E E 47 DO ASO VA Merrnin O a a a II o 49 DT SOU AS esas E E E E EAE T E O T E E a ois 50 PRA E E E O 51 28 Convent ext to Number and Ply penn scsc50 tect cots Nr lio ileso 51 E Boo o a a A 51 DS A a 52 AA E an a a a Neer TTT ene irene Meme TET TRE Ter 53 29I ROWS and Colum tas E 54 29 SECS Rows and COMAS i 54 2292 Movin RONS and COLUMNS cert d s 54 2 9 3 setting Row Height and Column Width ed 55 Spreadsheets 2013 User Manual 2 9 4 Insertine Cells Rows and COMLIMOS 00 AS E a 56 29 35 Deleting ells ROWS and COMO r E E EENT EAEE 57 DED OT RON 58 2 9 7 Hiding and Showing Columns and ROWS occccccccnnnnnonoooonnnnnnnncnnnnnnnnnnononnnnnnoncnnnnnnnnnnonnnnnnnannnnns 64 De MO WOrkS heet AE E de 65 De SONOS AAA II Se ete
161. ount Max Max Min Min fx More Functions Figure 5 2 7 The AutoSum drop down list 3 The result will be displayed in the cell to the right of the selected row See below Home Insert Page Layout Formulas Data Table Pp F a lal Insert AutoSum Recently All Financial Logical Text D Function Used T BES a amp amp 68 Booki xs x oF C2 Q fx 89 A B Cc D E 1 gt ag 2 1 2009780111 89 94 183 3 2 2009780112 90 96 3 2009780113 100 94 5 4 2009780114 88 92 6 5 2009780115 92 100 7 6 2009780116 92 95 8 7 2009780117 97 92 Figure 5 2 8 Display the result of AutoSum 5 3 2 Sum of Column s The operation steps are as follows 1 Select the columns which you want to sum See below amp Spreadsheets Home Insert Page Layout Formulas xk XY OB E Insert AutoSum Recently Al Financial Logic U Function sed BHease Book1 xls C2 7 Q fx 89 A B C D gt ONAWA ew hy Figure 5 2 9 Sum of a column 2 In the Formulas tab click the AutoSum icon and select Sum in the AutoSum drop down list See Figure 5 2 7 3 The result will be displayed in the cell at the bottom of the selected row See below 140 Spreadsheets 2013 User Manual Home Insert Page Layout Formulas o Y a E Insert AutoSum Recently Al Financial Logic Function Used 7 E H S s Bj Booki xls C2 A fr 89 A B Cc D 1 2 3 4 5 6 7 8 9 in Figure 5 2 1
162. our chosen data source Figure 6 1 1 Select Data Source 2 Select the Open data file directly check box click the Select Data Source button and the Open dialogue box will appear where you can select the source data Click the Open button to return to the Select Data Source dialogue box 3 Click Next and The second step Select table and fields dialogue box will open and show as below ee ee A ee E eh Ej the second step Select table and fields ES rata Available fields Selected fields Age 4 J Criteria lt gt F10 Fil A F13 F14 F15 F4 v F5 F6 m F7 a FS x Explanation Please select the target table to be imported from the combo box all fieldss will be listed in the left list box select the fields needed to be imported there the selected fields will be listed in the right list box Figure 6 1 2 Select table and fields 4 The usable fields will be listed in the Available fields list box You can use the control button in the 147 Spreadsheets 2013 User Manual middle to add fields into the Selected fields list box on the right 5 Click Next and The third step data filtering and sorting dialogue box will open and show as below Filter faite Field type Input query statement directly SELECT Age Criteria FROM Sheets Explanation You can click Advanced Query to sort and filter more complicated data if it still cannot satisfy your requirement
163. p Ey lt ch y Recent Places Pa J Si math magic a Huy Libraries A Computer Ca Network Files oftype Al Fies Y Cancel Figure 3 12 1 Insert File Object dialogue box 2 Find the target file and click the Open button to insert the file in the worksheet 3 13 Insert AutoShape You can also insert AutoShape in Kingsoft Spreadsheets such as Label Group Box Button etc e Label Click this icon to insert label in the worksheet Double click the label you have inserted and set the size properties and control in the Format AutoShape dialogue box See below Ej Format AutoShape Size Properties Size and rotate Height 0 53 m Width 1 85 m Rotation 0 Scale Height 100 Width 100 Lock aspect ratio Original size Height Width cancel Figure 3 13 1 Format label e Group Box Click this icon to insert group box in the worksheet Double click the group box you have inserted and set the size properties and control in the Format AutoShape dialogue box e Button Click this icon to insert button in the worksheet Double click the button you have inserted and enter the macro name and description in the corresponding enter box of the Assign Macro dialogue box See below 100 Spreadsheets 2013 User Manual Ej Assign Macro Macro name Cancel Clear Description Figure 3 13 2 The Assign Macro dialogue box
164. pecify the filter condition as Equals Not Equal To Begin With End With Contains and 43 Spreadsheets 2013 User Manual Dose Not Contain By choosing any one of them the Custom AutoFilter dialogue box will open where you can set the values to meet your requirements 2 6 1 4 Number Filter When the contents in the column is in number form click the drop down button and choose the Number Filter tab at the top right corner of the drop down menu A series of options are offered as shown below A B C D 1 Student No Score Score 2l Al gt Number Fil Equal Filter by Value S anig Not Equal To Greater Than Mult 7 Sele Greater Than Or Equal To 7 1101 Less Than 4 1101 Less Than Or Equal To Y 1101 Between Y 1101 R Top 10 V 1101 ll 1101 Above Average Y 1101 Below Average iv 1101 Custom Filter V 110119209 V 110119210 V 110119211 V7 11011991 Y Top 10 Above Average Below Average Showing all OK Cancel Figure 2 6 7 The Number Filter tab You can specify the filter condition as Equals Not Equal To Greater Than Greater Than Or Equal To Less Than Less Than Or Equal To and Between By choosing any one of them the Custom AutoFilter dialogue box will open where you can set the values to meet your requirements The most frequently used options are Top 10 Above Average and Below Average You can select them either in the Number Filter tab or at the bottom of the drop down menu Select the Above
165. ption 3 Then you can see there is a dotted line above the row you have selected See below Spreadsheets J Book1 xis Home Insert Page Layout Formulas Data Table Style Review View Developer FA E E ee Fo i E L A pr x i 3 L la e G E 4 YN as LY Margins Orientation Size Print Print Breaks Page Zoom Align Group Rotate Selection Settings Area Titles Pane E HSAs v Bj Book1 xls x F A17 Q fx A B C D E F G H I J K L M Figure 4 1 8 The dotted line 4 Open the Application menu EEE at the top left corner and choose Print Preview in the drop down list Then you can see the effect of the breaks 5 If you want to cancel the break you have inserted select the same row and choose Delete Page Break in the Breaks drop down list See Figure 4 1 7 6 If you want to reset all the breaks you have inserted in the worksheet select Reset All Page Breaks in the Breaks drop down list See Figure 4 1 7 Then all the page breaks in the worksheet will be deleted 4 1 7 Page Zoom You can set the zoom scaling when you print the work sheet If the sheet is too small you can increase its percentage If the sheet is too large you can decrease its percentage to fit it in one page To zoom the page do as follows 1 Click the Page Zoom icon in the Layout tab and the Page Setup dialogue box will open Select the Page tab See below 106 Spreadsheets 2013 User Manual El Page Setup a Pa
166. r and font color list For example select the font color of Red You will see the filter result like below A B C z E ck 85 Figure 2 6 4 Filter result If you want to remove the color filter you have applied to the worksheet data follow the steps below 1 Click the drop down button in the column header 2 Click the Clear icon at the upper side of the menu See below 42 Spreadsheets 2013 User Manual A B Cc D 1 SiudentiNo Score 1 Score al Al E an Number Filter Filter by Value Filter b Cjear c Filter by cell color None Ea Filter by font color A A Figure 2 6 5 Clear the Filter by Color Thus the filter by color will be removed 2 6 1 3 Text Filter When the contents in the column is in text form click the drop down button and choose the Text Filter tab at the top right corner of the drop down menu A series of options are offered as shown below 5 Spreadsheets x Home Insert Page Layout Formulas D Equals AE A SimSun E Y Not Equal To Paste Copy Format B J UEH EZ Painter Begin With BHAa la Book 1 xls End With G8 y Q fx Contains Does Not Contain Custom Filter Filter by Value Filter by Color Search All 4 Multiple Single Select all Atom Ben Chirsty Flora Green Hugh Jack James Iss ISS Y Y E E Jim Lily Lucy Sam Sarah e q a 8 Showing all OK Cancel Figure 2 6 6 The Text Filter tab You can s
167. rage Max Min Product Count Numbers StdDev StdDevp _ y Cancel 1 Figure 3 1 10 The Summarize Values By tab o Subtotals Click this icon to show or hide subtotals o PivotTable Optoins Click this icon and the PivotTable Options dialogue box will open where you can specify the settings of the pivot table by selecting or deselecting the check boxes See below B PivotTable Options a Name PivotTable4 J Grand totals for columns Page layout Down then over v V Grand totals for rows Fields per column 0 Subtotal hidden page items For error values show Refresh on open V For empty cells show canes Oo Hide Field List and Show Field List Click this icon to hide and show the PivotTable task window at the right side of the screen 3 2 Chart In order to enhance the explanatory effect of the data and make the data vivid for the reader you can use chart to display data Chart is the most intuitive way to analyze data Kingsoft Spreadsheets can automatically generate various kinds of charts according to the data in the cells such as the Column chart Bar chart Line chart Pie chart Area chart and so on All these types of charts can easily convert between one another In the following section we ll introduce the chart type chart structure how to create chart chart tools tab and custom chart 79 Spreadsheets 2013 User Manual 3 2 1 Chart Type Kingsoft Spreadsheets
168. rientation There are two ways to set the orientation of the page Oo Click the Orientation icon in the Layout tab and choose the Portrait or Landscape option in the drop down list See below Or e r t a tior Se Size Portrait ame Landscape Figure 4 1 2 The Orientation drop down list eo Click the Size icon in the Layout tab The Page Setup dialogue box will open Select the Page tab shown as below E Page Setup Page _ Margins Header and Footer Sheet Orientation D Portrait Landscape Scaling O Adjustto 100 normal size Fit to 1 page s wide by 1 tall Paper size A4 x Print quality 600 dpi z First page number Automatic Options Print Cancel Figure 4 1 3 Page Orientation Setting In the Orientation section select the Portrait or Landscape option button 4 1 3 Size To set the size of the page follow the steps below L 1 Click the Size icon se in the Layout tab and the Page Setup dialogue box will open Select the Page tab See below 103 Spreadsheets 2013 User Manual E Page Setup m Page Margins Header and Footer Sheet Orientation D Portrait Landscape Scaling 9 Adjustto 100 normal size Fit to 1 page s wide by 1 tall Paper size Ad Print quality 600 dpi First page number Automatic Options Print Cancel Figure 4 1 4 The Page tab 3 S
169. rinter in the Name drop down list 3 In the Page range section you can choose the range of the file which you want to print You can also enter the specific pages you prefer in the Pages text box 4 In the Copies section choose the number of copies in the roll down list Choose the Collate check box and the document will be print one copy after another 5 Click the OK button to print the document 1 4 6 The Print Preview Option in the Application Menu Click the Application Menu icon to open the drop down list and choose the Print Preview option or click the Print Preview icon at the left corner of the screen The Print Preview tab will open and show as below Spreadsheets Print Preview EL Hees OF iD B Print 7 Next 100 Page Break Normal Portrait Landscape Headerand Page Margins Close Page Preview View Footer Setup Figure 1 4 10 The Print Preview tab Oo Print click the arrow on the Print icon to open the drop down list Select the Print option or press lt Ctrl P gt to open the Print dialogue box shown in Figure 1 4 9 Then you can set the values there You can also choose the Print Directly option in the drop down list to directly print the current file Oo Previous Page click to switch to the previous page 17 Spreadsheets 2013 User Manual o Next Page click to switch to the next page Zoom zoom the current file to your preferred percentage in the drop down list Page Break Preview th
170. rksheet you can see all of the changes at once The operation steps are shown as follows 1 Click the Track Changes icon in the Review tab to open the drop down list and select the Highlight Changes option The Highlight Changes dialogue box will open and show as below E Highlight Changes rx Y Show track changes description Highlight which changes Y When Since I last saved w Who Everyone z Where a5 cama Figure 8 9 1 The Highlight Changes dialogue box 2 Select the Show track changes description check box and set criteria for changes namely When Who and Where in the Highlight which changes section 3 Press OK to complete the operation 4 Then you can make changes in the worksheet and press Enter to finish You will notice that the data that has been changed will be marked up Tips The Track Changes function can only be used in the shared workbook 175 Spreadsheets 2013 User Manual 9View Tab 9 1 View Mode Kingsoft Spreadsheets provides five different workbook view modes Normal Print Layout Page Break Preview Full Screen and Reading Layout You can select different view mode to suit your needs 9 1 1 Normal Normal view is the default view of Kingsoft Spreadsheets You can edit the content format and layout directly in the normal view If currently you are not in the normal view you can return to it by clicking the Normal View icon in the View tab 9 1 2 Print L
171. s Selecting all the sheets If you want to insert one or more worksheets take the following steps 1 Select the current worksheet 2 Click the Worksheet icon in the Home tab to open the drop down list Select the Insert Sheet option as shown below 66 Spreadsheets 2013 User Manual A EN No FE j y 4 SNeEc Find and Settings A pep H Insert Sheet HH Delete Sheet i Be Protect Sheet js Rename fue Move or Copy Sheet b Tab Color 45 Hide and Unhide Figure 2 10 3 The Insert Sheet option 3 The Insert Sheet dialogue box will then open and show as below Ej Insert Sheet Sai Insert count fl Insert Cancel O After current sheet Before current sheet Figure 2 10 4 Insert Sheet dialogue box 4 Enter the number of worksheets you want to create in the Insert count enter box 5 Choose either the After current sheet or the Before current sheet option to specify the location where you want to create the new worksheets 6 Press the OK button to complete the operation Skills You can also insert worksheets by the context menu Select the current worksheet right click the mouse and choose the Insert Sheet option in the context menu The Insert Sheet dialogue box will then open Repeat the operation above to insert new worksheets 2 10 3 Deleting Sheet If you want to delete one or more worksheets follow the steps below 1 Select the worksheets you
172. s Max Choose the maximum among the numbers in the selected cells O Min Choose the minimum among the numbers in the selected cells Choose the More Functions option in the bottom of the AutoSum drop down list and the Insert Function dialogue box will then open where you can apply preferred function to the selected cells 2 6 Filter Filtering data is a quick and easy way to find and work with a subset of data in a range of cells or in a table Filtered data displays only the rows that meet the criteria you have specified and hides rows that you don t want to display 2 6 1 AutoFilter AutoFilter makes it easier to find and process subsets of data in the spreadsheets You can create criteria to filter data Only those rows which meet the criteria you have specified will be displayed Filtering doesn t rearrange rows It just hides the rows you don t want to display 40 Spreadsheets 2013 User Manual Automatic filter includes Filter by value filter by color text filter number filter and custom filter Here we ll introduce these features 2 6 1 1 Filter by Value To filter by value follow the steps below 1 Select the column s you want to filter Click the AutoFilter icon in the Home tab and choose the AutoFilter option in the drop down list 2 A drop down button will appear at the first row of the columns you have selected 3 Click the drop down button and you can set the filter in the drop down menu For ex
173. s Ea View Calculation i Automatic Manual Calculation Edit Y Iteration Maximum iterations 100 General and Save Maximum change 0 001 Custom Lists Workbook options Color a Precision as displayed Security Error Checking Spelling Privacy Ce Figure 5 5 3 Iteration 3 Select the Iteration check box O Enter the number of times of iteration in the Maximum iterations spinner O Enter the error value in the Maximum change spinner 4 Press OK to complete the operation 6 Data Tab 6 1 Import Data External data refers to data stored outside of Kingsoft Spreadsheets such as Access dBASE SQLServer and databases created on the Web service You can click the Import Data icon in the Data tab to import data from a majority of data sources into Kingsoft Spreadsheets The two ways to get external data will be demonstrated in the following part 146 Spreadsheets 2013 User Manual 6 1 1 Open data file directly The first way is to get external data by opening data files directly which is very easy The operation steps are shown as follows 1 Click the Import Data icon in the Data tab and the Select Data Source dialogue box will open and show as below El Step 1 Select data source Select data source 9 Open data file directly C Use ODBC data source connection guide W 4 Select Data Source C Input connection string manually You can choose from three different ways to connect to y
174. s the number that represents the date in Kingsoft Spreadsheet date time code Counts the number of days months and years between the two dates Converts the date in text form to a number that represents the date in Kingsoft Spreadsheets date time code Returns the day of the month a number from to 31 Returns the number of days between two dates based on a 360 day year 30 days a month and 12 months a year which is used in some accounting calculations Use this function to help compute 12 Spreadsheets 2013 User Manual Name EDATE start date number of months EOMONTH start date number of months HOUR serial number MINUTE serial number MONTH serial number NETWORKDAYS start_ date end date holidays NOW SECOND serial_ number TIME hour minute second TIMEVALUE time text TODAY Explanations payments if your accounting system is based on a 360 day year Returns the serial number that represent the date which is the indicated number of months before or after a date the start date Use this function to calculate the maturity dates that fall on the same day of the month as the date of issue Returns the serial number for the last day of the month which is the indicated number of the month before or after the start date Use this function to calculate the maturity dates that fall on the last day of the month Returns the number as a number from 0 12 00 A M to 23 11 00
175. specified number of digits Rounds a number down toward 0 Rounds a number up away from 0 Returns the sum of a power series Returns the sign of a number Returns 1 if the number is positive zero 0 if the number is 0 and 1 if the number is negative Returns the sine of the given angle Returns the hyperbolic sine of a number Returns the square root of a number Returns the square root of a number which 128 Spreadsheets 2013 User Manual Function Name SUBTOTAL function number E na SUM numberl number SUMIF range criteria sum_range SUMIFS sum range range 1 SUMPRODUCT array 1 array3 SUMSQ number 1 number 2 SUMX2MY2 array 1 array 2 SUMX2PY2 array 1 array 2 SUMSMY 2 array 1 array 2 TAN number TANH number TRUNC number num digits refl array2 Explanations has been multiplied by Pl Returns a subtotal in a list or database Returns the sum of all the numbers in a range of cells Sum the values in a range that meet criteria that you specify Adds the cells specified by a given set of conditions or criteria Multiplies the corresponding data in the given arrays and returns the sum of those products Returns the sum of the squares of all the arguments The arguments may vary as numbers arrays names or references to cells which contain numbers Returns the sum of differences of squares of corresponding values in two arrays Retur
176. t Returns the length of a text string Returns the number of characters in a text Use LENB text with double byte character set DBCS LOWER text Returns the lowercase version of a text string Returns the characters with a specific length MID text start num num chars from a given starting position in a text string 119 Spreadsheets 2013 User Manual Function Name MIDB text start_num bytes number PROPER text REPLACE old_ text num chars new_ text REPLACEB old text start num bytes number new_ text REPT text number_times RIGHT text num_ chars Start_ num RIGHTB text byte number RMB number decimals SEARCH find text start_num SEARCHB find text start_num SUBSTITUTE text new text instance num within text within text old text Explanations Returns the specified number of characters from the appointed location of a text string Use with double byte character set DBCS Capitalizes the initials of all the words Replaces characters within a text string with another different text string Replaces characters within a text string with another different text string Use with double byte character set DBCS Returns repetitions of string for specified times You can use REPT to fill a cell with a text string repeatedly Returns the specified number of characters from the end of a text string Returns the specified number of characters fro
177. t Spreadsheets will automatically select that range for you and the data range will be enclosed by dotted boarders You can also modify a pivot table that already exists in the spreadsheet There are two options offered namely the New Worksheet and the Existing Worksheet for you to choose where you want to place the pivot table A B c D E F G H N E Create PivotTable Choose the data that you want to analyze O Select a range Sheet2 SA 3 SD 10 2009780111 2009780112 2009780113 2009780114 2009780115 2009780116 2009780117 Choose where you want the pivotTable to be placed New worksheet O Existing worksheet Sheet2 A 12 Pr OK Cancel Figure 3 1 2 Create a pivot table 3 After clicking the OK button in the Create PivotTable dialogue box an empty pivot table will appear in the position you have chosen You can use the PivotTable task window which automatically pops up on the right to put contents into the pivot table you have created Items presented in the Field List section can be dragged to the Page Area Column Area Row Area and Data Area in the Pivot Table Areas section By moving these items to different areas you can view them in different perspectives To delete any of them you can simply move them out of the areas By this way you can analyze the detailed information contained in the data range 1D Spreadsheets 2013 User Manual A B C D PivotTable x
178. t cells Format columns E Format rows _ Insert columns Insert rows Insert hyperlinks Delete columns S Figure 8 4 1 The Protect Sheet dialogue box 2 By default only Select locked cells and Select unlocked cells are checked If you want some other protection such as Format cells you can select the check box to activate it 3 Enter the password in the Password input box 4 Click OK to complete the operation 171 Spreadsheets 2013 User Manual Tips This protection for worksheet only works on locked cells After setting the protection all you have to do is to save the file and the setting will go into effect If you want to cancel the worksheet protection click Unprotect Sheet in the Review tab Or you can try the other way Select Unprotect Sheet in the Format drop down list in the Home tab Enter the password you have set and the entire worksheet will be as it was before you locked tt 8 5 Protect Workbook Workbook protection can prevent altering the structure of the workbook which includes deleting moving hiding unhiding and renaming the worksheet You cannot insert a new worksheet or move and adjust the window either when the workbook has been protected The operation steps are shown as follows 1 Select the workbook you want to protect 2 Click Protect Workbook in the Review tab Then the Protect Workbook dialogue box will open and shown as below E Protect Workbo
179. t the cell that you want to copy 2 Right click the cell and select Copy in the context menu 3 Right click the cell to which you want to copy the formula and select Paste Special in the context menu Then the Paste Special dialogue box will open and show as below E Paste Special mE x Paste All All except borders Formulas Column widths Values Formulas and number formats O Formats Values and number formats Operation Skip blanks Transpose OK N Cancel Figure 5 1 1 Paste Special dialogue box 4 In the Paste section select Formulas 5 Press OK to complete the operation 5 2 Function Library Kingsoft spreadsheets provides a number of functions for you You can create formulas by using these functions so that you can conveniently and quickly calculate data in the spreadsheet In Kingsoft Spreadsheets there mainly are nine kinds of functions namely Financial Logical Text Date and Time Lookup and Reference Math and Trig Statistical Engineering and Information 5 2 1 Insert Function If you insert a function in Kingsoft Spreadsheets 1t will automatically be saved in the Insert Function dialogue box Next time when you open the Insert Function dialogue box the function you used will be listed at the top of Recently Used functions For example if you insert ADDRESS in the spreadsheet then when you open the dialogue box next time it will be listed in the recently used functions category shown
180. tal 6 Select corresponding check box according to your needs to specify the subtotal conditions Oo Replace current subtotals subtotal according to current sorting 161 Spreadsheets 2013 User Manual Oo Page break between groups each group should be displayed on separate page O Summary below data put the subtotal result at the end of each group 7 Press OK Then you can get the subtotal result See below 5 Spreadsheets Home Insert Page Layout Formulas Data Table Style T A zZz lA i E Y AL B PivotTable AutoFilter Advanced Ascending Descending Sort E H S s v B Book1 xls x Al x Q f NO 23 A B 6 D E ey orn E O da W bh I 11 11 1 Figure 6 7 3 The result of Subtotal 6 8 Show Detail and Hide Detail If you can t see the outline symbols in Kingsoft Spreadsheets you can click Group in the Data tab After creating a group you can perform the following operations O Ifyou want to show detail in a group click the Show Detail icon in the Data tab O Ifyou want to hide detail in a group click the Hide Detail icon in the Data tab Tips you can also click the Show Detail icon and Hide Detail icon on the right side of the worksheet 6 9 Form Kingsoft Spreadsheets provides a data form function for you to add delete and find a series of data more easily in the worksheet To use the form data function follow the steps below 1 Select the title of the column in the worksheet and
181. th such situation EHSA GF Booki x r Al y Q fx In Kingsoft Spreadsheet multiple summary results appear in the status bar if you A select several numbers at a time Some of these summary results include Sum In Kingsoft Spreadsheet multiple Average and Count The three summary results mentioned above are defaults in summary results appear in the sta Kingsoft Spreadsheet To adjust any of them you can right click the status bar The bar if you select several numbers option list appears and you can add or delete the summary results according to your time Some of these summary res needs mchide Sum Average and Count The three summary results mentioned above are defaults m Kmgsoft Spreadsheet To adjust any of them you can right click the status bar The option list appears and you can add or delete the summary results HI Click the Smart Contraction Arrow de U bo Spreadsheets 2013 User Manual EHAA Y 33 Bookl x Al y Q fx In Kingsoft Spreadsheet multiple symmary results appear in the status bar if you A B C D hI F z H In Kmgsoft Spreadsheet multiple summary results appear m the status bar if you select several numbers at a time Some of these summary results mciude Sum Average and Count 1 The three summary results mentioned above are defaults m Kmgsoft Spreadsheet To adjust any of them you can right click the status bar The option list appears and you can add or delete the summary
182. the Add button at the bottom right to add the new list 6 Click the OK button to complete the operation 7 Enter Red in the Spreadsheets and drag the fill handle The new list you have just added will be applied The effect is shown below Figure 2 9 14 Fill data by custom fill series 8 You can also delete custom list by clicking the Delete button in the Custom Lists tab Mind that you can t edit or delete the built in fill series such as the fill series for days and months 2 9 7 Hiding and Showing Columns and Rows If you don t want other people to see some particular content in your worksheet you can hide the rows or columns that contain the content The steps to hide rows and columns are as follows 1 Select the rows and columns which you want to hide 2 Select the Hide and Unhide option in the Rows and Columns drop down list There are four options 64 Spreadsheets 2013 User Manual offered as shown below Worksheet Findand Settings Replace L Row Height a AutoFit Row Height Column Width p Q l a AutoFit Column Width gt Standard Width 5 Insert Cells i EX Delete Cells Fill LA Hide and Unhide Hide Rows Hide Columns Unhide Rows Unhide Columns Figure 2 9 15 The Hide and Unhide drop down list 3 Choose the Hide Rows and Hide Columns option to hide the selected rows and columns 4 Choose the Unhide Rows and Unhide Columns option to cancel the oper
183. the values in the dialogue box 4 Click the OK button to complete the operation To insert rows follow the steps below 1 Select the position where you want to insert rows 2 Choose the Insert Rows option in the Insert Cells drop down list You can then insert a row in the worksheet The process is shown below S6 Spreadsheets 2013 User Manual AT A fe 110119206 A B C D Student No Score 1 Score 2 2 110119201 83 85 3 110119202 so 9 4 110119203 88 85 5 110119204 84 86 1 Select the position 6 110119205 90 87 7 Sane z 73 Where you want to 110119207 82 87 insert rows 9 110119208 89 85 10 110119209 80 83 11 110119210 85 84 12 110119211 91 88 13 110119212 93 83 14 110119213 92 84 15 110119214 82 87 A Sheet1 Sheet2 Sheet3 H a q ows and Worksheet Findand Settings umns gt Replace L Row Height AutoFit Row Height Column Width P Q Ea AutoFit Column Width E Standard Width oE Insert Cells ME insert Cells 2 Select the Insert EY Delete Cells E Insert Rows Rows option in the Fill Insert Cells drop down list 141 Hide and Unhide A B c D E 1 2 110119201 83 8 amp 5 3 1101192022 90 92 4 110119203 88 85 5 110119204 84 86 6 110119205 90 87 5 8 110119206 84 85 9 110119207 82 87 10 110119208 89 85 11 110119209 80 83 The effect after 12 110119210 85 84 13 110119211 91 88 l l 14 110119212 93 83 inserting the row
184. tion and Right section enter box If you need to set the format of the text put the cursor in the edit box and then click the Font button A l O If you need to insert Page Number Number of Pages LA Date fe Time ey File and Sheet Name put the cursor in the edit box and press the corresponding icon O If you need to insert pictures click the Insert Picture icon EJ If you need to set the format of pictures put the cursor in the edit box and click the Reset Picture icon 3 After you have finished all the settings press OK to return to the Header and Footer tab where you can preview the effect Custom Footer works the same way as Custom Header 4 Click the Options button at the bottom to set the page layout 5 If you want to print the worksheet you can click the Print button at the bottom to set the print properties in the Print dialogue box 6 Click the OK button to complete the operation 3 8 Hyperlink 3 8 1 Create Hyperlink In Kingsoft Spreadsheets you can establish hyperlinks between cells and between cells and files web pages or even e mail accounts 94 Spreadsheets 2013 User Manual To create hyperlink in the worksheet follow the steps below 1 Select the cell where you want to add a hyperlink 2 Click the Hyperlink icon in the Insert tab The Hyperlink dialogue box will open and show as below E Hyperlink Ea Link to Text to display Screentip HZ Desktop v J
185. tion multiplication and division Meanwhile formulas can include any of the following elements functions references operators and constants If you want to input formula in a cell of a worksheet you can input a combination of these elements 5 1 Formulas Grammar In Kingsoft Spreadsheets whether a cell contains a formula or not is based on whether it starts with Specifically a formula is usually composed of the following elements 110 Spreadsheets 2013 User Manual O equality sign O Numbers 0 9 or cell addresses numbers contained in the cells O Other arguments that can be referred to by formulas or functions Oo to set the priorities O Operators to connect data There are three different types of operators in Kingsoft Spreadsheets arithmetic comparison and text and reference See below plus sign Addition The calculate orders are the asterisk Multiplication calculation priorities forward slash multiplication and division Arithmetic percent sign first and then addition and subtraction for the same Exponentiation level of operations calculate You can compare two values 3 with the operators on the left When two values are earet from left to right Greater than or Comparison compared by using the equal to operators the result is a Less than or logical value i e TRUE or equal to FALSE z Use the ampersand amp to Text join or con
186. to select multiple objects 2 In the Page Layout tab select Distribute Horizontally or Distribute Vertically in the Align drop down list See Figure 4 2 2 108 Spreadsheets 2013 User Manual 4 2 2 3 Object Size Adjustment If you want to adjust the size of the inserted objects you can do as follows O Equal Height Select the desired objects In the Page Layout tab select Equal Height in the Align drop down list The selected objects will be adjusted to the same height O Equal Width Select the desired objects In the Page Layout tab select Equal Width in the Align drop down list The selected objects will be adjusted to the same width O Equal Size Select the desired objects In the Layout tab select Equal Size in the Align drop down list The selected objects will be adjusted to the same size 4 2 2 4 Snap to Gird If you want the object you have inserted to snap to the grid you can do as follows 1 Select the desired objects 2 In the Page Layout tab open the Align drop down list and select the Snap to Grid option See Figure 4 2 2 3 Then you can use the mouse to drag the objects to align them to the grid 4 If you want to cancel the operation select the Snap to Grid option again in the Align drop down list 4 2 2 5 Show Grid In Kingsoft Spreadsheets you can set whether or not to show grid If you want to show grid select the Show Grid option in the Align drop down list of the Layout tab See Figure 4
187. try functions in Kingsoft Spreadsheets See below Function Name ABS number ACOS number ACOSH num digits ASIN number ASINH number Explanations Returns the absolute value of a number a number without its sign Returns the arccosine of a number in radians in the range from 0 to Pi The arccosine is the angel whose cosine is the Number Returns the inverse hyperbolic cosine of a number Returns the arcsine of a number within radians from P1 2 to P1 2 Returns the inverse hyperbolic sine of a number The inverse hyperbolic sine is the value whose hyperbolic sine is number so 125 Spreadsheets 2013 User Manual Function Name ATAN number ATAN2 x num y num ATANH CEILING number significance COMBIN number number chosen COS number COSH number DEGREES angle EVEN number EXP number FACT number FACTDOUBLE number FLOOR number significance Explanations ASINH SINE lt number gt equals number Returns the arctangent of a number in radians from P1 2 to Pi 2 Returns the arctangent of the specified x_ and y coordinates in radians between Pi and Pi excluding P1 Returns the inverse hyperbolic tangent of a number The number must between 1 to 1 excluding 1 and 1 The inverse hyperbolic tangent 1s the value whose hyperbolic tangent is number so ATANH TANH lt number gt equals number Rounds a number up to the nearest integer or to the ne
188. uments at the same time all the documents need to enter in the reading layout mode to set or cancel the setting 9 2 View Check Boxes There are six check boxes listed in the View tab by which you can hide or display certain items in the worksheet See below Formula Bar View Gridlines v View Headings Task Window Print Gridlines Print Headings Figure 9 2 1 Check boxes in the View tab 179 Spreadsheets 2013 User Manual The function of these check boxes are shown as follows O Formula Bar Select or deselect this check box to show or hide the formula bar in the worksheet o View Gridlines Select or deselect this check box to show or hide the gridlines in the worksheet Oo View Headings Select or deselect this check box to show or hide the row and column headings in the worksheet Oo Task Window Select or deselect this check box to show or hide the task window at the right side of the worksheet O Print Gridlines Select this check box to print gridlines in the worksheet Oo Print Headings Select this check box to print the row and column headings in the worksheet 9 3 Zoom To specify the zoom size of the worksheet follow the steps below 1 Click the Zoom icon in the View tab The Zoom dialogue box will open and show as below B Zoom xs Magnification 200 o 100 75 50 25 Fit selection Custom 100 ok cancel Figure 9 3 1 The Zoom dialogue box 2 Choose the preferred proportion in the Ma
189. vorite interface Oo Choose skin for Office 2013 during the installation During the installation process of Office 2013 you can choose a skin from the left list and press Next in the following steps to finish installation In this way the three components Writer Spreadsheets and Presentation will apply the same interface you ve chosen here See below J Kingsoft Office 2013 oO fete Choose Interface Style Please choose the interface style you want to apply 2013 ESR Black a W Writer Classic Style Home Insert Page Layout References Revie BORE Sm E Page Blank Table Picture Shapes Chart TextBox Break Page ld bed e La gs Document 1 x Figure 1 3 4 Choose interface style for Office 2013 Oo Switch skin in Office 2013 programs after installation If you want to apply another interface after the installation of Office 2013 you can easily switch to another within the Office programs Take Spreadsheets 2013 for example you can switch skins by the following Steps 1 In Spreadsheets 2013 click the Switch UI icon at the top right corner of the screen 2 Select a different skin from the current one and press OK You will need to restart the program to see the change Spreadsheets 2013 User Manual Nes Mr A fF X Wf Skin Manager i gt Mm las i gt ES PivotTable Chart Picture PivotTable Chart Picture 2013 Elegant Black 2013 Water Blue 5 File Edit View Insert
190. want to delete 2 Choose the Delete Sheet option in the Worksheet drop down list 3 If there is data in the current worksheet the following dialogue box will open E Spreadsheets Y 5 Lm A The sheet s you are deleting is not empty If you want to delete the data permanently please click OK or press Enter on the keyboard Cancel Figure 2 10 5 Delete data in sheet 4 If you ve made up your mind to delete the worksheet you can press the OK button to complete the 67 Spreadsheets 2013 User Manual operation Skills You can also delete worksheet by the context menu Select the worksheets that you want to delete right click the mouse and choose the Delete Sheet option in the context menu 2 10 4 Protect Sheet If you want to protect the worksheet follow the steps below 1 Select the worksheets which you want to protect from others 2 Choose the Protect Sheet option in the Worksheet drop down list 3 The Protect Sheet dialogue box will then open and show as below E Protect Sheet a Password optional Allow all users of this worksheet to V Select locked cells a V Select unlocked cells Format cells W Format columns Format rows Insert columns Insert rows Insert hyperlinks Delete columns ll aa aa Figure 2 10 6 The Protect Sheet dialogue box 4 The password is optional and you can enter 1t according to your need 5 Select or deselect the check bo
191. xes offered to specify the operations which other users are allowed to carry out on the worksheets 6 Click the OK button to complete the operation 2 10 5 Renaming Sheet By default Kingsoft Spreadsheets names worksheets by the model of Sheet serial number In most cases you would want to rename the worksheets The following are methods to rename worksheets O Double click the worksheet label and when the label is selected enter the new name When finished press the lt Enter gt key or click any place except the worksheet label to finish the operation Oo Right click the worksheet label which you want to rename Select the Rename option in the context menu and enter the new name Press the lt Enter gt key or click any place except the worksheet label to finish the operation 68 Spreadsheets 2013 User Manual Oo Select the worksheet label go to the Home tab and select the Rename option in the Worksheet drop down list After entering the new name press the lt Enter gt key or click any place except the worksheet label to finish the operation 2 10 6 Moving or Copying Sheet There are two ways to move and copy worksheets by the Move or Copy Sheet option in the Worksheet drop down list and by the mouse O Move or copy worksheets by the dialogue box 1 Select the worksheets that you want to move or copy 2 Click the Worksheet icon in the Home tab and select the Move or Copy Sheet option in the drop down list
192. xt to Hyperlink option in the Format drop down list 2 8 2 Conditional Formatting You can set conditions for the cells When the cells meet these conditions the program will automatically apply some type of formatting to them You can set three conditions at a time and use formulas or cell values as the condition For example change the color of the cell to yellow when the date in the cell matches the current date This function can be used to remember the birthday of friends or employees To set this kind of condition follow the steps below 51 Spreadsheets 2013 User Manual 1 Select the intended cell or cells 2 Click the Format icon in the Home tab and choose the Conditional Formatting option in the drop down list The Conditional Formatting dialogue box will open and show as in Figure 2 5 1 3 Select the Cell value is option and the equal to option in the Condition 1 drop down list Input today in the edit box 4 Click the Format button and the Format Cells dialogue box will open where you can set the fill color of the selected cell into yellow You can also set other formats for the cell such as Number Font Border and Patterns Click the OK button at the bottom right to return to the Conditional Formatting dialogue box 5 Click the OK button to complete the operation The effect is shown below Ej Conditional Formatting Condition 1 Cell value is v equal to x TODAYO Pr Preview of format to

Download Pdf Manuals

Related Search

Related Contents

Antec Black Super Mid Tower  Chamberlain 1345M User's Manual  Dvm890 ES - Velleman  MINICOMPONENTE  SHモンスターアーツ UX－02－93 メカゴジラ 取扱説明書  Modo de empleo Trimpro Unplugged PDF  Notice - Castorama  ANTI CALCAIRE  Liebert XDC™  

Copyright © All rights reserved. Failed to retrieve file