📚 Quick Study Guide: Google Sheets Basics
- 📊 Columns: These are the vertical divisions in a spreadsheet, identified by letters (e.g., A, B, C, ...). They extend downwards.
- ↔️ Rows: These are the horizontal divisions, identified by numbers (e.g., 1, 2, 3, ...). They extend across.
- 🎯 Cells: A cell is the intersection of a column and a row. Each cell has a unique address or reference, formed by its column letter and row number (e.g., A1, B5, C10).
- 🔢 Cell Address (Reference): The unique identifier for a cell (e.g., 'A1' refers to the cell in Column A, Row 1).
- 📍 Active Cell: This is the currently selected cell in the spreadsheet, usually highlighted with a border. Any data you type will go into the active cell.
- 🌐 Range: A collection of two or more cells. It's typically denoted by the addresses of the top-left and bottom-right cells separated by a colon (e.g., A1:C5 represents all cells from A1 to C5).
- ☁️ Google Sheets: A web-based spreadsheet program offered by Google, known for its collaborative features and accessibility from any device with internet access.
🧠 Practice Quiz: Test Your Spreadsheet Knowledge
Choose the best answer for each question.
Which of the following best describes a 'column' in Google Sheets?
A. A horizontal series of cells identified by a number
B. A vertical series of cells identified by a letter
C. The intersection of a row and a letter
D. A group of selected cells
How are 'rows' typically identified in a Google Sheet?
A. By letters (A, B, C, ...)
B. By symbols (!, @, #, ...)
C. By numbers (1, 2, 3, ...)
D. By colors
What is the unique address 'A5' an example of in a spreadsheet?
A. A column
B. A row
C. A cell reference
D. A range
If you select cells from B2 to D4, what is this group of cells commonly called?
A. A single cell
B. A column
C. A row
D. A range
Which term refers to the currently selected cell where data will be entered?
A. The home cell
B. The active cell
C. The primary cell
D. The input cell
In Google Sheets, what does 'C7' specifically refer to?
A. The seventh column
B. The third row
C. The cell at the intersection of Column C and Row 7
D. A formula calculating a value
What is a key characteristic of Google Sheets that differentiates it from traditional desktop spreadsheet software?
A. It can only store numbers
B. It is primarily designed for offline use
C. It is web-based and highly collaborative
D. It lacks basic spreadsheet functions
Click to see Answers
1. B. A vertical series of cells identified by a letter
2. C. By numbers (1, 2, 3, ...)
3. C. A cell reference
4. D. A range
5. B. The active cell
6. C. The cell at the intersection of Column C and Row 7
7. C. It is web-based and highly collaborative