Cells – Video

Introduction:

Data are entered and managed in an Excel worksheet. The worksheet contains several rectangles called cells for entering numeric and nonnumeric data. Each cell in an Excel worksheet contains an address, which is defined by a column letter followed by a row number. For instance, the upper-left cell address is referenced as A1, with A representing the column letter and 1 representing the row number. The cell reference is displayed in the Name box and its contents will be displayed in the Formula bar.

When a cell is active, it is highlighted with a dark green border and will accept numeric and nonnumeric data. Likewise, the column letter and row number will also be shaded a different color to help you identify the active cell. Cells can be aligned, formatted, copied, moved, or deleted.

Learning:

What is a Cell, Range, Column, and Row in Excel

Moving and Copying Data in an Excel Worksheet

Sources:

“What is a Cell, Range, Column, and Row in Excel” by TheCleverLab. Retrieved from: https://youtu.be/5ignfTPZsjY

“Moving and copying data in an excel worksheet.” By Study Hours. Retrieved from: https://www.youtube.com/watch?v=dKE3Nl93vqA&list=PLGKyA5Ih-Sk_XNsKmYVqOuiYTTwIdv8Jj&index=19&t=0s Licensed under: CC-BY

License

COM112 – Fundamentals of Spreadsheets Copyright © by The American Women's College. All Rights Reserved.