Question

discuss the different data selection techniques available in MS Excel​

Answer 1

Answer:

Explanation:

Selection Techniques

Control+A  –  Select an entire worksheet.

Single Click  –  Select a single cell

Double Click  –  Select the contents of a cell.  You may also select the contents of a cell in the formula bar.

The Name Box – You can select ranges of data in Excel by typing the range within the Name Box.  As an example, type A1:A20 in the Name Box and Excel will select the range A1:A20 for you

Shift+Click  –  Selects a contiguous (adjacent) range of cells.  Place your cursor at the first insertion point, then hold down the shift key and keep it held down, click at the last insertion point and then let go of the shift key.  This is a great way to select large ranges of data that are adjacent to each other without having to drag your mouse through them to make a selection.

Shift+Control+Home  –  Selects an entire range of data above and to the left of the active cell (great for quickly selecting a print area or deleting content).

Shift+Control+End  –  Selects an entire range of data below and to the right of the active cell (great for quickly selecting a print area or deleting content).

Control+Click  –  Selects a non-contiguous (non-adjacent) range of cells.  Select your first cell, hold the control key down and keep it held down and click to select the rest of the cells.  Then let go of the control key.  This is a great way to select numerous cells at one time and can really speed things up when formatting in Excel.  Simply select all your cells at one time and make the formatting change only once.