Este módulo aún no está traducido, así que sus lecciones están en inglés. Las fórmulas funcionan igual en el idioma de tu Excel.
Cells and ranges
Ejercicio 1 de 5
Each cell has an address: its column letter, then its row number. Click the cell that holds the price of apples.
Sobre esta lección
Every cell has an address made of its column letter and row number, and a block of cells is a range like A1:B3. Here you select them on the sheet: click a cell, drag over a range, and pick whole columns.
En esta lección
- Each cell has an address: its column letter, then its row number. Click the cell that holds the price of apples.
- A range is a block of cells, written as the first cell, a colon and the last cell. Drag from the first price to the last to select the prices of all three items.
- A range is a block of cells, written as the first cell, a colon and the last cell. How many cells are in
B2:C5? Drag over it on the sheet to count. - Select the whole of column A by clicking its letter at the top of the sheet.
- Select two rows at once: apples (A2:B2) and milk (A4:B4). Select the first, then hold Ctrl (Cmd on a Mac) while you drag over the second.
Usa las flechas para moverte entre celdas; cada celda se lee al pasar por ella. Escribe una fórmula y pulsa Intro. Debajo tienes la hoja también como tabla.
fx
Haz clic en una celda o arrastra sobre un rango. Se comprueba en cuanto la selección es correcta.