Practice question

In Microsoft Excel, a cell contains the formula '=AVERAGE(B2:B9)'. When a new valid numeric row is inserted directly above row 2 inside the referenced block, what typically happens?

  1. Expands the reference automatically to B2:B10 and includes the new value in the average
  2. Deletes the inserted row to protect the formula
  3. Converts the function AVERAGE into SUM without warning
  4. Locks the spreadsheet so no further edits are possible

Answer: A — Expands the reference automatically to B2:B10 and includes the new value in the average

The correct answer is shown above. Try the full quiz for additional practice.

Practice more: NAV Brasil ATCO (PTNA) Practice Questions - NAV Brasil Air Traffic Controller Public Competitive Hiring Examination - Profissional Técnico de Navegação Aérea (PTNA) Exam →