Excel Lesson 1 & 2: Microsoft Excel Basics
Worksheet
A computerized spreadsheet.
Landscape orientation
A page turned so that its longer side is at top.
Portrait orientation
A page turned so that its shorter side is at top.
Row
Appears horizontally and is identified by numbers on the left side of the worksheet window.
Formula bar
Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
Column
Appears vertically and is identified by letters at the top of the worksheet window.
Number format
Change the way data looks in a cell.
Orientation
Changing the angle at which the data is displayed.
Format painter
Enables you to copy formatting from one worksheet cell to another without copying the cell's contents.
Cell reference
Identifies the cell, and is formed by combining the cell's column letter and row number.
Theme
Preset collection of design elements.
Sheet tab
Tab at the bottom of the worksheet window that displays the name of the worksheet.
Indent
Shifted to the right
Live preview
Shows the results of the different formatting options you can choose.
Active cell
The cell in the worksheet in which you can type data.
Column heading
The column letter.
Font
The design of text.
Workbook
The file used to store worksheets.
Cell
The intersection of a row and a column.
Microsoft Excel 2010 (Excel)
The spreadsheet program in Microsoft Office 2010.
Active worksheet
The worksheet that is displayed in the work area.
Formula
An equation that calculates a new value from values currently in a worksheet.
Adjacent range
All cells touch each other and form a rectangle.
Range
A group of selected cells.
Border
A line around a cell's edges.
Style
Combination of formatting characteristics such as alignment, font color, and borders.
Merge
Combine into one cell.
Row heading
The row number.
Font style
Using effects such as bold, italic, and underlining to add emphasis to a font.
Cell style
A collection of formatting characteristics you apply to a cell or range of data.
Spreadsheet
A grid of rows and columns in which you enter text, numbers, and the results of calculations
Points
A unit of measurement for font height.
Fill
Background color.
Name box
Cell reference area located below the Ribbon, displays the cell reference of the active cell.
AutoFit
Determines the best width for a column or the best height for a row, based on its contents.
Font size
Determines the height of characters as measured in points.
Range reference
How the range is identified: made up of the cell in its upper-left corner and the cell in its lower-left corner, separated by a colon.
Truncate
Hidden from view.
Nonadjacent range
Includes two or more adjacent ranges and selected cells.
Clear
Removes formatting applied to a cell or a range of cells.
Wrap text
When the row height adjusts automatically to include additional lines until all the text is visible.
Align
You can align the contents of a cell horizontally and vertically within the cell.
