Question

You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.

1) Alt
2) Ctrl
3) F5
4) F7

Answer 1

To select a noncontiguous range of cells in a spreadsheet, you would use the Ctrl key. This allows flexibility in selecting and manipulating multiple blocks of data that are not adjacent to each other.

Step-by-step explanation:

You can select a noncontiguous range of cells by pressing and holding the Ctrl key when using it in combination with other navigation keys and/or the mouse. The correct option from the list provided is 2) Ctrl.

The Ctrl key allows you to add to your selection of cells without the need for them to be next to each other, which enables more flexibility when working with complex spreadsheets. This is a handy trick to know for tasks requiring you to manipulate or format separate blocks of data within the same worksheet.