Correct Answer:
B. Shift+F9
📊 Excel Calculation Shortcuts
In Microsoft Excel, pressing Shift + F9 instructs the system to recalculate formulas and updating charts exclusively within the active (current) worksheet. This focused calculation approach optimizes processing speeds when handling heavy workbooks with multiple sheets.
⌨️ Sheet vs. Workbook Calculations
| Shortcut Key | Scope of Calculation |
|---|---|
| Shift + F9 | Recalculates the active worksheet only. |
| F9 | Recalculates all sheets across all open workbooks. |
| Ctrl + Alt + F9 | Forces a complete recalculation of all open workbooks from scratch. |
If you think there is any confusion in given MCQS You can comment.
Drop of Change Academy is Pakistan No.1 online Plate form to prepare all types of Exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, And for all one paper MCQS , Pedagogy MCQS, docmcqs general knowledge MCQS, current affair MCQS and alot more