notes 2.54 KB
Newer Older
1 2 3 4

Control-Enter after finishing entering some data into a cell
sets the whole range of selected cells to that value.

Chyla Zbigniew's avatar
Chyla Zbigniew committed
5
On a selection: Enter, Shift-Enter, Tab, Shift-Tab navigate trought
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
the selected cells.

Double clicking on a column division automatically adjusts the column
size.

Sheet drawing:

	1. Selected background + white margin
	2. Grids
	3. CEll content

If more than one sheet is selected changes take place on all sheets.

Dates are stored as numbers with the format for the date.

Today's date is inserted with Control-;
Current tiem is inserted as Control-Shift+;

The expression: 	="5/12/94"-"3/5/98" yields 68



Date 1 is Jannuary 1, 1900

Texts can be used in a formula:
	="Total for "& 1985 displays "Totals for 1985"

Hard carriage returns are entered with alt-enter

Automatic completion of names is done per column (looked backwards)

Alt-down arrow pops up a list of available choices for the autofill

* FORMULAS:
	
	Operators, cell references, values, worsheet functions,
	and names.

	Arrays:  SUM({1,2,3}*4) gets converted to:
		SUM({1,2,3}*{4,4,4})

** Operators
	
*** Arithmetic

	+, -, /, *, 
	% (percent, as in 20%)
	^ Exponentiation

*** Comparision
	=, <, >, <=, >= <>

*** Text operator

	& Concatenates values and returns a string value

*** Reference operator
	
	Range (colon) Produces one reference to all the cells between
	and includig the two references.

	Union (comma) Produces one reference that includes the two
	references

	Intersection (space) Produces on reference to cells common
	to the two references

** Wierd things
74
	="1"+"2" yields 3, Excel does the converion to integers
75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124
	="A"&TRUE, Excel convers TRUE to a string: ATRUE

** Display

	Control-` Switches between computed formula display and
	actual formua display

** References
	$ is the absolute cell reference
	R[-2]C	Two rows above, same column
	R[2]C[2] two column down, two right
	R2C2 Absolute reference to B2
	R[-1] Entire row above the active cell
	R current row
	
	=Sheet4!D12+4
	='Miguel is a moron'!A1+2
	
** Functions
	They can take any number of arguments
		X(number)
	They are documented
	The arguments are documented
	A wizard can be popped up to help with it
	
*** Types
	Database and list management functions
	Date and time functions
	DDE and external functions
	Engineering functions
	Financial functions
	Information functons
	Logical functions
	Lookup and reference functions
	Math and trigonometric functions
	Statistical functions
	Text functions

** Errors

	#####
		Result too big to fit in scell
	#DIV/0
		Division by zero
	#N/A
		
	#NAME?
	#NULL!
	#NUM!
	#REF!
125
	#VALUE!