arrays
| Test | Subject | Formula | Category | DVs |
|---|---|---|---|---|
sequence-scalar |
SEQUENCE | =SEQUENCE(1) |
value | |
sequence-column |
SEQUENCE | =SEQUENCE(3) |
value | |
sequence-2d |
SEQUENCE | =SEQUENCE(2, 3) |
value | |
hstack |
HSTACK | =HSTACK(1, 2, 3) |
value | |
vstack |
VSTACK | =VSTACK(1, 2, 3) |
value | |
index-into-grid |
INDEX | =INDEX(A1:B2, 2, 1) |
value | |
sort-array |
SORT | =SORT({3;1;2}) |
value |