Multiple choice general knowledge

Use __________________ to select data ranges that are not next to each other.

  1. Ctrl + home

  2. Ctrl + click and drag

  3. Shift + double click

  4. Shift + home
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Ctrl + click and drag allows selecting multiple non-adjacent cells or ranges by holding Ctrl while clicking different areas. This is essential when you need to format, copy, or manipulate data that is scattered across different parts of a spreadsheet.

Keep practicing — related questions