hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Identify the false statement about MS Excel
    Question

    Identify the false statement about MS Excel

    A.

    You can protect individual cells by locking/unlocking

    B.

    Charts in Excel help visualize numerical data

    C.

    A worksheet can have a maximum of 16,384 columns

    D.

    Excel allows users to create dropdown lists

    E.

    None of the above

    Correct option is E


    • Statement (a) is TRUE → Excel allows cell-level protection through Format Cells → Protection combined with Protect Sheet.
    • Statement (b) is TRUE → Charts support data interpretation, trend analysis, comparison, and visual summaries.
    • Statement (c) is TRUE → Latest Excel versions (Excel 2016 onward) have 1,048,576 rows × 16,384 columns (A to XFD).
    • Statement (d) is TRUE → Data Validation tool supports creation of drop-down lists, improving data uniformity.
    • Therefore, because all statements are correct, the option None of the above becomes the correct answer.
    Key Concept: Excel supports data security, visualization, and structured entry with high capacity for large datasets.

    Free Tests

    Free
    Must Attempt

    IBPS Agriculture Field Officer (Mains) Mock 02

    languageIcon English
    • pdpQsnIcon60 Questions
    • pdpsheetsIcon60 Marks
    • timerIcon45 Mins
    languageIcon English
    Free
    Must Attempt

    UPSSSC AGTA PYP Held on July 13, 2025

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon120 Mins
    languageIcon English
    Free
    Must Attempt

    UPSSSC AG TA Full Length Mock 01

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon120 Mins
    languageIcon English
    test-prime-package

    Access ‘UPSSSC AG TA’ Mock Tests with

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