Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
Recognize the main terms used to describe Excel’s work canvas.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the Excel workbook used in the video tutorial and try the lesson yourself.The Work Surface.xlsx
Application Terminology – The Work Surface.
When to use
Use to understand the main terms used to describe Excel’s work canvas.
Reading the Grid
- Excel’s grid is broken into columns (lettered across the top of the grid) and rows (numbered down the left side of the grid)
- Cells are referred to by the coordinates, always citing the column first, then the row (i.e. A1, B10, D15)
The Name Box
- Located above the upper left of the grid, but below the Ribbon
- This box returns the address (coordinates) of the top left selected cell
- Entering a cell address in this box and pressing Enter will take you there
- If you have named objects in your workbook (like tables), selecting the name from this list will select the object
- Located in the bottom left corner of the interface
- Allows you to select different worksheets in the workbook
- Located above the grid, right of the Name box and below the Ribbon
- Shows you the true contents of the top left selected cell (i.e. formulas instead of the value that shows in the grid itself)
- Can be used to edit cell contents
- Located on the right edge (vertical) and bottom right corner (horizontal)
- These bars allow you to move the focus of the worksheet to other areas
- Located in the bottom right corner of the application
- Allows you to zoom in or out of the worksheet, making it appear larger or smaller
Quick Info Area
- Located in the bottom right corner, to the left of the Zoom Slider
- Takes effect when multiple cells are selected
- Provides quick information like SUMs and AVERAGEs of selected values
Lesson notes are only available for subscribers.