Question

Select the two non-contiguous ranges (not next to each other) C8:C11 and E8:E11. What is the average showing on your status bar for the two ranges

Answer 1

Answer:

Explanation:

Just prass and hold down the CTRL key,and you can select multiple non-abjacent cells or ranges with mouse clicking or dargging in active worksheet.this does not require holding down key during selection.A non-contiguous range consists of to or more separate blocks of cells. this blocks can be separated by rows or columns as shown by the ranges A1 to A5 and C1 to C5 both contiguous and non-contiguous ranges can include hundreds of even thousand of cells and span worksheet and workbook