Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

Which bar displays the contents of the active cell in Excel?

A. Active Cell
B. Formula Bar
C. Title Bar
D. Name Box
Correct Answer: B. Formula Bar

In Microsoft Excel, the Formula Bar is the specific component that displays the contents of the active (currently selected) cell. Located directly above the worksheet grid, it serves as a primary area for viewing, entering, and editing data or formulas. If a cell contains a formula, the Formula Bar shows the formula itself, while the cell displays the calculated result. If the cell contains text or a numerical value, that exact content is shown in the Formula Bar.

  • The Active Cell is the selected cell itself, not a bar that displays its contents.
  • The Title Bar is at the top of the Excel window, displaying the workbook name and application name, not cell contents.
  • The Name Box, situated to the left of the Formula Bar, displays the address (e.g., A1) or name of the active cell or selected range, not its content.

Leave a Comment

Join Our WhatsApp Channel ×
Scroll to Top