Which function results can be displayed in Auto Calculate?
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → SUM and AVERAGE
AutoCalculate shows a quick result for the cells selected in the worksheet, on the status bar, without a formula being typed into a cell. SUM and AVERAGE are functions whose results it displays. LOOK, LABEL and BLANK are not functions whose results AutoCalculate shows, so Options (2), (3) and (4) each include one that it cannot display.
NCERT (2026-27 edition):
|

