hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Which of the following is true about cell range in MS Excel?
    Question

    Which of the following is true about cell range in MS Excel?

    A.

    Collection of chosen cells

    B.

    Collection of formula

    C.

    Collection of values

    D.

    Collection of occupied cells

    Correct option is A

    The correct answer is (a) Collection of chosen cells
    Explanation:
    ● A cell range is defined as a selection of two or more cells in a spreadsheet.
    ● It can be a contiguous block (like A1:B10) or a non-contiguous collection of various selected cells.
    ● This range is used for applying formatting, performing calculations, or creating charts.
    Information Booster:
    ● To select a range, click and drag or use the Shift key with arrow keys.
    ● Ranges are denoted by the top-left cell and bottom-right cell separated by a colon (e.g., C2:E5).
    ● Named Ranges can be created to make formulas easier to read.
    Additional Knowledge:
    ● Formula Bar – Where you enter or edit data and formulas for the active cell.

    Free Tests

    Free
    Must Attempt

    UPTET Paper 1: PYP Held on 23rd Jan 2022 (Shift 1)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    Free
    Must Attempt

    UPTET Paper 2 Social Science : PYP Held on 23rd Jan 2022 (Shift 2)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    Free
    Must Attempt

    UPTET Paper 2 Maths & Science : PYP Held on 23rd Jan 2022 (Shift 2)

    languageIcon English
    • pdpQsnIcon150 Questions
    • pdpsheetsIcon150 Marks
    • timerIcon150 Mins
    languageIcon English
    test-prime-package

    Access ‘KVS PGT’ 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