GeoGebra

This is read-only version of the old wiki, feel free to browse it for materials. If you want to share your own materials, please use GeoGebraTube instead. You are also welcome to help us enhance the new wiki. If any questions arise, please contact the webmaster.

CellRange Command

Command Descriptions

A

Angle AffineRatio AngleBisector Append Arc Area Asymptote Axes AxisStepX AxisStepY

B

BarChart BinomialCoefficient BoxPlot

C

CellRange Center Centroid Circle CircularArc CircularSector CircumcircularArc CircumcircularSector Circumference Column ColumnName Conic ConjugateDiameter ConstructionStep Corner CorrelationCoefficient CountIf Covariance CrossRatio Curvature CurvatureVector Curve

D

Delete Derivative Determinant Dilate Direction Directrix Distance Div

E

Element Ellipse Expand Extremum

F

Factor First FitExp FitLine FitLineX FitLog FitLogistic FitPoly FitPow FitSin Focus FormulaText FractionText Function

G

GCD

H

Histogram Hyperbola

I

If InflectionPoint Insert Integral Intersect Intersection InverseNormal Invert IsDefined IsInteger Iteration IterationList

J

Join

K

KeepIf

L

Last LCM Length LetterToUnicode Line LinearEccentricity Locus LowerSum

M

MajorAxis Max Mean MeanX MeanY Median Midpoint Min MinorAxis Mod Mode

N

Name Normal

O

Object OsculatingCircle

P

Parabola Parameter Perimeter PerpendicularBisector PerpendicularLine PerpendicularVector Point Polar Polygon Polynomial Product

Q

Q1 Q3

R

Radius RandomBetween RandomBinomial RandomNormal RandomPoisson Ray Reflect Relation RemoveUndefined Reverse Root Rotate

S

Row SD Sector Segment Semicircle SemiMajorAxisLength SemiMinorAxisLength Sequence SigmaXX SigmaXY SigmaYY Simplify Slope Sort Sum Sxx Sxy Syy

T

TableText Take Tangent TaylorPolynomial Text TextToUnicode Translate Transpose TrapezoidalSum

U

UnicodeToLetter UnicodeToText Union UnitPerpendicularVector UnitVector UpperSum

V

Variance Vector Vertex

Syntax

CellRange[cell A,cell B]

Action

Creates a list containing the cell values in this cell range ordered by columns.

Example

Enter the following values into the corresponding spreadsheet cells: A1 = 1, A2 = 4, B1 = 3, B2 = 9. The command CellRange[A1, B2] then gives you the list {1, 3, 4, 9}.

Notes

• CellRange[B1,A2], CellRange[A2,B1], CellRange[B2,A1] do the same as CellRange[A1,B2]