36
CHAPTER 3:
HancomMobileSheet
•
Data Move and Copy
When creating data with HancomMobileSheet, you will likely want to copy and
change the data without directly entering it. For this, the copy and move
functions are very useful. Let's try to copy and move with the following data.
i) Copy and move with the Menu : When you use [Edit-Copy] the formula is
copied and when [Edit-Cut] is selected the formula is deleted. When an area is
selected the formula can be copied and the data is pasted at the same time.
ii) Copy and move with Tools : Formulas can be copied or deleted by using the
cut, copy, and paste functions.
iii) Copy and move with the Shortcut Menu : If you press down with the stylus for
a few moments a submenu(shortcut menu) will appear with the cut, copy and
paste functions(similar to doing a right click with the mouse on your PC.).
Creating Formulas
•
Basics of Formulas
SpreadSheet programs are convenient in that they provide functions for
complex calculations by using just a few formulas. In formulas there are
numbers and operators, but also cell addresses, functions, data area names,
file names, etc. The following are an example of formula usage.
Formula Explanation
=A1+B1 Adds the values of cells A1 and B1
=Sheet1!B4+B8 Adds the values of cell B4 of Sheet1 and cell B8 of the current sheet.
=sum(A1:B2)-2 Using the SUM function, adds the values of A1, A2, B1, B2 and subtract 2
•
Operator
The operator is a sign that indicates what the data in the cells will do.
① Arithmetic Operator : +(add), -(subtract), *(multiply), /(divide), %(percentage),
^(exponent)
② Comparison Operator : =(equal), >(larger), <(smaller), >=(larger or equal),
<=(smaller or equal), !=(unequal)
To Next Page
Loading...
Need help?
General
