0
0
Google Sheetsspreadsheet~5 mins

Selecting cells, rows, and columns in Google Sheets - Cheat Sheet & Quick Revision

Choose your learning style9 modes available
Recall & Review
beginner
How do you select a single cell in Google Sheets?
Click on the cell you want to select. For example, clicking on cell B2 will select it.
Click to reveal answer
beginner
What is the easiest way to select an entire row?
Click the row number on the left side of the sheet. For example, clicking '3' selects all cells in row 3.
Click to reveal answer
beginner
How can you select multiple adjacent columns at once?
Click the first column letter, hold the Shift key, then click the last column letter you want to select.
Click to reveal answer
intermediate
What keyboard shortcut helps you select an entire column quickly?
Press Ctrl + Space (Cmd + Space on Mac) to select the entire column of the active cell.
Click to reveal answer
intermediate
How do you select non-adjacent cells or ranges?
Hold the Ctrl key (Cmd on Mac) and click each cell or drag to select ranges you want to include.
Click to reveal answer
What happens when you click the letter 'C' at the top of a Google Sheets spreadsheet?
ASelects column C
BSelects row C
CSelects cell C1 only
DDeletes column C
Which key should you hold to select multiple adjacent rows?
ACtrl
BAlt
CShift
DTab
How do you select the entire row of the active cell using the keyboard?
AShift + Space
BCtrl + Space
CAlt + Space
DCtrl + Shift + Space
To select multiple non-adjacent cells, which key do you hold while clicking?
AEnter
BShift
CAlt
DCtrl (Cmd on Mac)
What is the first step to select a range of cells from A1 to C3?
AClick cell C3 only
BClick cell A1, then drag to C3
CClick row 1
DClick column A
Explain how to select an entire column and an entire row in Google Sheets.
Think about the labels on the top and left of the sheet.
You got /3 concepts.
    Describe the steps to select multiple non-adjacent cells or ranges.
    It’s like picking different fruits from different baskets without picking everything in between.
    You got /3 concepts.