Use column letters, row numbers, and the highlighted active cell to name any spot in the grid. Read addresses like B3 and understand how rows and columns cross to form cells.

Use what you learned in the previous lesson to solve real-world problems.

Check what you understood with a short quiz.

Read range names like A1:C5 as a rectangle of cells, then select ranges by dragging or using Shift. Recognize when a range is one cell, a block, a full row, or a full column.

Use what you learned in the previous lesson to solve real-world problems.

Select whole rows, whole columns, and the entire sheet using headers and the corner selector. Reason through how these selections differ from selecting only the visible cells with data.

Use what you learned in the previous lesson to solve real-world problems.

Check what you understood with a short quiz.

Move through the grid with scroll bars, the mouse wheel, arrow keys, Ctrl+Arrow, Home, and Go To. Choose the fastest move depending on whether nearby cells or a far-away address is your target.

Use sheet tabs to add, rename, move, copy, and delete worksheets within a workbook. Keep track of which sheet is active before you make a change.

Locate commands by reading ribbon tabs, groups, and buttons instead of memorizing every tool. Use the Search box or Tell Me feature when you know the action but not where Excel placed it.

Use what you learned in the previous lesson to solve real-world problems.

Use the formula bar to see the full contents of the active cell and the Name Box to confirm or jump to an address. Notice how these tools help you inspect a cell without changing what is in it.

Use what you learned in the previous lesson to solve real-world problems.

Check what you understood with a short quiz.

Save a workbook with a clear name, location, and file format using Save or Save As. Recognize how AutoSave works differently when a file is stored in OneDrive or SharePoint.

Choose between common Excel file types: .xlsx for standard workbooks, .xlsm for macro-enabled files, .csv for plain table data, .pdf for sharing a fixed view, and .xls for older compatibility.

Use what you learned in the previous lesson to solve real-world problems.

Use zoom and the status bar to make the grid easier to work with while you select cells. Read quick status bar clues such as count or sum without treating them as changes to the worksheet.

Check what you understood with a short quiz.

Review this chapter with practice based on your mistakes.