Google Sheets Basics
What is a cell?
A single unit where you can enter data.
What is a row?
A horizontal set of cells labeled by numbers.
Name three home row keys.
A, S, D
Name three top row keys.
Q, W, E
What does Ctrl + C do?
Copies selected data.
What is a column?
A vertical set of cells labeled by letters.
How do you change cell color?
Click on the "Fill Color" icon or use the "Format" menu.
Which fingers press A and ;?
Left pinky for A, right pinky for ;
Which fingers press P and Q?
Right pinky for P, left pinky for Q
What does Ctrl + Z do?
Undoes the last action.
What does merging cells do?
Combines multiple cells into one larger cell.
What is the purpose of a bar chart?
To visually display data in a graph format.
Why is home row important?
It’s the starting point for efficient touch typing.
How does top row differ from home row?
Top row keys are typed using the fingers above the home row.
How do you resize a column?
Hover between the column letters and drag.
What is the formula bar used for?
To enter or edit data in a cell.
How do you insert a chart?
Highlight data and click "Insert," then "Chart."
What is proper posture for typing?
Sit up straight, feet flat on the floor, hands on the home row.
Why is accuracy more important than speed?
It ensures fewer mistakes and less time spent correcting errors.
What does SUM do in Google Sheets?
Adds up the numbers in a selected range.
What shortcut selects the entire sheet?
Ctrl + A
What is conditional formatting?
Automatically changing the cell format based on data values.
How does touch typing help with speed?
It reduces the need to look at the keyboard, improving efficiency.
What is the best way to practice top row typing?
Consistent practice with proper technique.
How do you freeze the top row in Google Sheets?
Go to "View," then "Freeze," and select "1 row."