When you open a new Google Sheet, you'll see a large grid of empty boxes. This is your canvas. The layout is simple but powerful.

Columns run vertically and are labeled with letters (A, B, C...). Rows run horizontally and are labeled with numbers (1, 2, 3...). The box where a column and a row intersect is called a cell.

The Formula Bar, marked with an fx symbol, shows the content of the selected cell. This is where you'll type and edit data or formulas. The grid itself is where all your data lives, neatly organized.

Every cell has a unique address, called a cell reference. This is how you tell the sheet exactly which data you want to work with. Think of it like a mailing address for your information.

A cell reference is simply the column letter followed by the row number. The cell in the top-left corner is A1. The cell to its right is B1. The cell below A1 is A2, and so on.

You can also refer to a group of cells, called a range. A range is defined by its top-left and bottom-right cells, separated by a colon. For example:

• A1:A5 refers to the first five cells in column A.
• A1:D1 refers to the first four cells in row 1.
• A1:C3 refers to a block of cells three rows tall and three columns wide.

The real power of a spreadsheet comes from its ability to perform calculations using formulas. A formula is an expression that calculates a value in a cell.

All formulas in Google Sheets start with an equals sign (=). This tells the sheet, "Don't just show the text I'm typing—calculate it!"

You can use standard math operators: + (add), - (subtract), * (multiply), and / (divide). The real magic happens when you use cell references in your formulas. If cell A1 contains the number 10 and B1 contains 5, you could type =A1*B1 into cell C1. Cell C1 would then display the result, 50. If you later change the value in A1 to 20, the result in C1 automatically updates to 100.

Beyond basic math, Sheets has hundreds of built-in functions. A function is a preset formula that performs a specific calculation. They save you time and handle complex tasks easily.

Functions follow a specific structure: the function name, followed by parentheses containing the inputs, or arguments. For example, the SUM function adds up a range of numbers.

This formula tells Sheets to add all the numbers in the cells from A1 down to A10. Here are a few other common functions you'll use all the time:

To use a function, just type = followed by the function name, an open parenthesis, select the cells you want to apply it to, and then close the parenthesis. Sheets will even suggest functions as you start typing.

Getting comfortable with these basics is the first step toward using Google Sheets to organize and analyze data effectively. Practice navigating the grid, referencing cells, and trying out a few simple formulas.