Which of the following Excel screen components cannot be turned on or off?
2019
Which of the following Excel screen components cannot be turned on or off?
- A.
Formula Bar
- B.
Status Bar
- C.
Tool Bar
- D.
None of these
- E.
Scroll Bar
Attempted by 644 students.
Show answer & explanation
Correct answer: D
Concept
Nearly every screen element in Excel — the Formula Bar, the Status Bar, the Ribbon (Excel's modern toolbar), and the worksheet's scroll bars — is a display option, not a fixed part of the window. Excel exposes a switch for each one, either as a ribbon/Options-dialog checkbox or, where no direct checkbox exists, as a VBA display property.
Application: how each component is switched off or on
Component | How you can turn it off/on |
|---|---|
Formula Bar | View tab > Show group > "Formula Bar" checkbox, or File > Options > Advanced > Display > "Show formula bar" |
Tool Bar (Ribbon) | View tab > Ribbon Display Options, or Ctrl+F1 to collapse/expand it |
Scroll Bar | File > Options > Advanced > Display options for this workbook > "Show horizontal/vertical scroll bar" checkboxes |
Status Bar | No ribbon checkbox, but Application.DisplayStatusBar = False in VBA hides it |
Cross-check
Since each of Formula Bar, Status Bar, Tool Bar, and Scroll Bar has a supported way to switch it off, none of them is an element that can never be turned off. So the only option that correctly describes the set is "None of these."