Home MCQs Basic Computer/IT Question #11555
Back to Questions
Basic Computer/IT QUESTION #11555
Question 1
Which keyboard shortcut recalculates formulas on the active worksheet in Excel?
  • Ctrl + F9
  • Shift + F9✔️
  • F9
  • F7
Correct Answer Explanation
Shift+F9 recalculates only the active/current worksheet in MS Excel. F9 recalculates all open workbooks; Ctrl+Alt+F9 forces recalculation of all workbooks; Ctrl+F9 minimises the workbook window. This distinction matters for large spreadsheets where full recalculation is time-consuming.