Donate
Back to Data Analysis with Excel & Google Sheets
Sign in to save your progress and earn a certificate.

Module 2: Navigating the Interface & Entering Data

Learning Objectives
  • Identify cells, rows, columns, and sheets/tabs
  • Enter and format different data types correctly
  • Use basic formatting to make data readable

A spreadsheet is organized into a grid of cells, each identified by a column letter and row number (for example, cell B2 is column B, row 2); multiple related tables can live on separate sheets, or tabs, within one file. Entering data correctly matters more than it seems: a date typed as text won't sort chronologically, and a number stored as text won't total in a SUM formula, so recognizing and correcting data type mismatches is a core early skill. Basic formatting -- bold headers, frozen header rows, column width, and number formats like currency or percentage -- doesn't change the underlying data but makes a sheet dramatically easier for others, and your future self, to read and trust.

Module Quiz

1. If a number is accidentally entered as text, what commonly goes wrong?

2. In a spreadsheet, cell 'C3' refers to: