answersLogoWhite

0

A disjointed range in Excel consists of two or more separate ranges that are not contiguous. For example, if you want to select cells A1 to A5 and C1 to C5, you can specify this disjointed range as A1:A5, C1:C5 in a formula or function. This allows you to perform operations on non-adjacent cells simultaneously.

User Avatar

AnswerBot

4w ago

What else can I help you with?

Related Questions

What is a ranch in Excel terms?

I think you probably mean "range" instead of "ranch". In Excel, a range is a group of cells. A range can be as small as a single cell (for example, cell A1), block of cells (example, A1:B2), or even non-contiguous cell (example: A1,B2,C3). It could also be an entire column (A:A) or row (1:1). In the A1:B2 example above, this range would include four cells A1, A2, B1, and B2


What is a group of cells in excel?

range


Do hotels use Excel?

Any business can use Excel for a whole range of things.


What is an Excel cell range?

An excel cell range is the parameters you give Excel. For example, the cell range is "=$D$4:$L$28". That means the parameters are from columns D to L, rows 4 to 28. If you want to be more specific, like a few cells and a few cells there; here is an example. "=I16:N23,E25,H28,E31" are from columns I to N, rows 16 to 23, and cells E25, H28, and E31. Hope this explains it a little.


What is the name for a group of data in excel?

range


Where can you get multiple range test in excel?

50,70,80,50,60,44,70,50,70,60,50,50


What is criteria range?

The Criteria Range is a range of cells that hold cells from which criteria are tested for functions in Excel.


What is a selected group of cells in excel called?

range


What is B6-B12 in excel called?

A cell range


What are the two ranges of Excel?

You may be referring to a contiguous range and a non-contiguous range.


What is the range of cell when you select all cells in Excel?

That depends on the version of Excel. Up to Excel 2003 it would be A1:IV65536. From Excel 2007 onwards it would be A1:XFD1048576.


Can a named range begin with a letter or number in Excel?

A named range in Excel begins with a letter. A range can be something like A1 to A25. The letters are across the top of the page and are columns. The numbers are on the left and identify lines.