Gnumeric's user manual

Miguel de Icaza Amozurrutia

    
  

Adrian Likins

    
  


Table of Contents
1. Entering data.
Strings and numbers
Dates and Numbers
Editing of cells.
Editing commands
Formulas
Syntax
Using Functions
Names
Array Formulas
Cell Referencing
Absolute cell referencing
Referencing multiple cells
Referencing cells on other sheets
Selecting Cells While Entering Formulas.
Entering data into a formula with the mouse
Entering data into a formula with the keyboard.
Copying and moving cells
Using the mouse to drag the selection
Right Click Options
Move and copy right click menu options
Editing cells using the selection
Simple Selections
Selecting multiple cells
Discontinuous selections
Keyboard Shortcuts
Filling a region with the same text or value.
Autofill
Filling with Dates
String And Number autofill
Formula autofill
Other Notes on autofill
2. Style.
3. Cell Formatting
Cell Formatting
The Format Dialog
Changing the Font
Changing the cell's Color
Cell content justification and alignment
Cell Formatting options on the buttonbar.
Number formatting expressions
Date and Time formatting
4. Worksheet overview.
The Worksheet
The Menu bar
The Button Bar
Data entry area.
The Cell area
The Info Area
5. Working with files.
Working with files
Saving files
File format
6. Printing
7. Analysis tools
Data Analysis Tools
Anova: Single Factor Tool
Correlation Tool
Covariance Tool
Descriptive Statistics Tool
F-Test:Two-Sample for Variances Tool
Random Number Generation Tool
Sampling Tool
z-Test:Two Samples for Means Tool
8. Tutorials
9. Drawing on a worksheet
10. Gnumeric Function Reference
Reference
LCM —
PRICEDISC —
IMARGUMENT —
RANDBETWEEN —
COSH —
REPT —
DEGREES —
NOMINAL —
ISODD —
RSQ —
COLUMN —
RATE —
DPRODUCT —
FDIST —
ISEVEN —
ZTEST —
DMIN —
TEXT —
WEEKDAY —
PRODUCT —
MULTINOMIAL —
IMSIN —
COS —
EXP —
ASIN —
TRIMMEAN —
FLOOR —
GCD —
CHOOSE —
POISSON —
SYD —
MID —
ASINH —
EXPONDIST —
UPPER —
HARMEAN —
TBILLYIELD —
CONVERT —
LOG —
HYPGEOMDIST —
IMABS —
SINH —
AVEDEV —
NORMDIST —
GEOMEAN —
TIME —
MIN —
MEDIAN —
FREQUENCY —
GAMMAINV —
IMSUB —
ISTEXT —
SQRT —
INTERCEPT —
LEN —
RIGHT —
PERMUT —
AVERAGEA —
PERCENTRANK —
DATE —
STEYX —
OCT2BIN —
PRICEMAT —
IMCONJUGATE —
SUMIF —
LINEST —
IMREAL —
IMSUM —
SERIESSUM —
LEFT —
DURATION —
COMPLEX —
DEC2HEX —
COLUMNS —
LN —
DGET —
DATEVALUE —
COUNTBLANK —
AVERAGE —
CORREL —
SUMSQ —
IMPRODUCT —
CHAR —
PMT —
DAY —
SQRTPI —
FISHER —
VARA —
DMAX —
ISLOGICAL —
ATAN2 —
MINA —
LOOKUP —
CEIL —
MDETERM —
HEX2DEC —
MINUTE —
VARPA —
NOT —
TINV —
TAN —
SUMXMY2 —
NOW —
NA —
BETAINV —
ROWS —
DSTDEVP —
CHITEST —
CRITBINOM —
SUMPRODUCT —
INT —
BINOMDIST —
DB —
IMLOG2 —
VARP —
EXACT —
EDATE —
DVAR —
YEAR —
LOWER —
TIMEVALUE —
DEC2OCT —
RAND —
KURT —
BIN2DEC —
ERF —
MAX —
NEGBINOMDIST —
DOLLARDE —
EOMONTH —
MROUND —
DEVSQ —
SELECTION —
ROUND —
FIND —
VALUE —
WEIBULL —
BIN2HEX —
DDB —
NPV —
VLOOKUP —
DAVERAGE —
MINVERSE —
LOGNORMDIST —
RANK —
INTRATE —
BESSELI —
BESSELJ —
TBILLEQ —
BESSELK —
ADDRESS —
INDIRECT —
SIGN —
REPLACE —
GAMMADIST —
SKEW —
CHIINV —
CODE —
ERROR —
LOGINV —
ISNA —
ROUNDDOWN —
SUMX2MY2 —
VAR —
HEX2OCT —
STDEVPA —
DAYS360 —
DVARP —
FINV —
ISPMT —
IMCOS —
IMDIV —
ISBLANK —
SECOND —
IMEXP —
ACOS —
STANDARDIZE —
BESSELY —
SIN —
EFFECT —
OFFSET —
OR —
TYPE —
QUARTILE —
QUOTIENT —
FORECAST —
BIN2OCT —
CHIDIST —
CONFIDENCE —
PI —
COUNT —
IMPOWER —
NORMSINV —
CELL —
DSUM —
TBILLPRICE —
LOG2 —
ABS —
PEARSON —
IMAGINARY —
ROW —
ATANH —
ERFC —
N —
WORKDAY —
ROMAN —
POWER —
NORMSDIST —
STDEVA —
TTEST —
DISC —
NPER —
NETWORKDAYS —
STDEV —
MOD —
FACTDOUBLE —
GAMMALN —
SMALL —
OCT2DEC —
T —
NORMINV —
PV —
DOLLAR —
TANH —
SUBSTITUTE —
TODAY —
FV —
PPMT —
PROPER —
DELTA —
CEILING —
KURTP —
IMLOG10 —
AND —
ODD —
MAXA —
ISNONTEXT —
SUM —
FVSCHEDULE —
MONTH —
ISERR —
BETADIST —
FIXED —
STDEVP —
ACCRINTM —
DEC2BIN —
HLOOKUP —
MMULT —
LOG10 —
HYPERLINK —
DCOUNT —
COUNTA —
SUBTOTAL —
CLEAN —
MODE —
DCOUNTA —
SUMX2PY2 —
FTEST —
SKEWP —
ISNUMBER —
RADIANS —
TREND —
IPMT —
MIRR —
ISREF —
ROUNDUP —
DSTDEV —
SUMA —
ACCRINT —
IMTAN —
FISHERINV —
ATAN —
SLN —
LARGE —
HEX2BIN —
GESTEP —
TDIST —
HOUR —
FACT —
SLOPE —
COVAR —
DOLLARFR —
OCT2HEX —
COMBIN —
EVEN —
RECEIVED —
IF —
XNPV —
IMSQRT —
COUNTIF —
ACOSH —
TRUNC —
TRIM —
TRANSPOSE —
PROB —
SEARCH —
CONCATENATE —
ISERROR —
INFO —
ERROR.TYPE —
IMLN —