hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Which of the following statement is INCORRECT with reference to selecting a cell in MS Excel?
    Question

    Which of the following statement is INCORRECT with reference to selecting a cell in MS Excel?

    A.

    The row heading of the selected cell will not be highlighted.

    B.

    A border will appear around the selected cell.

    C.

    A cell will remain selected until another cell is clicked in the Worksheet.

    D.

    The column heading of the selected cell will be highlighted.

    Correct option is A

    In MS Excel, when a cell is selected, both the row heading and column heading of the selected cell are highlighted. This helps users visually identify the position of the selected cell in the grid of rows and columns.
    Here’s why the other options are correct:
    · A border will appear around the selected cell: When you select a cell, a border is placed around the selected cell, making it easier to identify the active cell.
    · A cell will remain selected until another cell is clicked in the Worksheet: The selected cell remains active and highlighted until you click on another cell. This behavior is standard in Excel.
    · The column heading of the selected cell will be highlighted: When you select a cell, the column heading (the letter at the top of the column) is highlighted to indicate which column the selected cell belongs to.
    Important Key Points:
    1. Cell Selection: When a cell is selected in Excel, it will show a border around it, and the row and column headings related to the selected cell will be highlighted for easy identification.
    2. Visual Indicators: The highlighting of row and column headings makes it easier to navigate and work with large spreadsheets.
    Knowledge Booster:
    · Row and Column Headings: The row and column headings are a critical part of Excel’s navigation system, helping users quickly locate and reference cells in large datasets.
    · Active Cell: The selected cell is also referred to as the active cell, and the border surrounding it helps differentiate it from other cells.

    Free Tests

    Free
    Must Attempt

    SSC GD PYP (Held on 4 Feb 2025 S1)

    languageIcon English
    • pdpQsnIcon80 Questions
    • pdpsheetsIcon160 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    Hindi Section Test 1

    languageIcon English
    • pdpQsnIcon20 Questions
    • pdpsheetsIcon40 Marks
    • timerIcon12 Mins
    languageIcon English
    Free
    Must Attempt

    SSC GD Constable Full Mock Test 1

    languageIcon English
    • pdpQsnIcon80 Questions
    • pdpsheetsIcon160 Marks
    • timerIcon60 Mins
    languageIcon English
    test-prime-package

    Access ‘Delhi Police Constable’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow