Question

How can you select a range from c5 to e7 using the mouse

Answer 1

Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet. This does not require holding down keys during selection.