Excel

1. indirect 函数：返回对应的引用（reference），而不是值

=MAX(INDIRECT("D1:D11"))

单元格当前列自增

=MAX(INDIRECT( ADDRESS(1,COLUMN()) & ":" & ADDRESS(ROW()-1, COLUMN(),4)))+1

2. LOOKUP(A1,{0,60,70,80,90},{"不及格","及格","良好","优秀","优异"})

3.