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

CDP Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon20 Mins
languageIcon English
Free
Must Attempt

EVS Subject Test 01

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon20 Mins
languageIcon English
Free
Must Attempt

CTET Paper-I PYP (07 July 2024)

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
340k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow