Multiple choice general knowledge

Which key is used to calculate the active worksheet

  1. Ctrl + 3

  2. Shift + F7

  3. Alt + F7

  4. Shift + F9

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Shift+F9 recalculates all formulas in the active worksheet only. This differs from F9 which calculates the entire workbook, making it useful when working with large files to save time.