Excel Chapter 1B
Select All Box
A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.
Switch Row/ Column
A charting command to swap the data over the axis- data being charted on the vertical axis will move to the horizontal axis and vice versa.
Show Formulas
A command that displays the formula in each cell instead of the resulting value.
Value Axis
A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the Y-axis.
Worksheet Grid Area
A part of the Excel window that displays the columns and rows that intersect to form the worksheet's cells.
Picture Element
A point of light measured in dots per square inch on a screen, 64 pixels equals 8.43 characters, which is the average number of characters that will fit in a cell in an Excel worksheet using the default font.
SUM Function
A predefined formula that adds all the numbers in a selected range of cells.
Number Format
A specific way in which excel displays numbers in a cell.
Sparkline
A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.
Quick Analysis Tool
A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.
Recommended Charts
An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you selected.
Range Finder
An Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.
X-Axis
Another name for the horizontal (category) axis.
Y-Axis
Another name for the vertical (value) axis.
Workbook-Level Buttons
Buttons at the far right of the ribbon tabs that minimize or restore a displayed workbook.
Sheet Tab Scrolling Button
Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.
Number Values
Constant values consisting of only numbers.
Relative Cell Reference
In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.
Underlying Value
The data that displays in the Formula Bar.
Underlying Formula
The formula entered in a cell and visible only on the Formula Bar.
Operators
The symbol with which you can specify the type of calculation you want to perform in an Excel formula.
Range
Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.