Index
A
1
=demo.query("select NAME as STATE, ABBR, CAPITAL, POPULATION from STATES")
2
=A1.pselect(left(STATE,1)=="N")
3
=A1.pselect@a(left(STATE,1)=="N")
4
=A1.pmax(POPULATION)
5
=A1.pmin(POPULATION)
6
=A1(5)

Of A2~A6 the computation results are as follows: