BUS 225 Chapter 1
Select all box
A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.
Merge and Center
A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:
Quick Analysis tool
A feature 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
Range finder
A feature that outlines cells in color to indicate which cells are used in a formula
Chart
A graphical representation of data in a worksheet
Row
A horizontal group of cells
Column
A vertical group of cells in a table.
AutoFit
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.
Workbook
An Excel file with one or more worksheets.
Formula Bar
An element in the Excel window that displays the value or formula contained in the active cell
Name box
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Formula
An equation that performs mathematical calculations on values in a worksheet.
Cell Address
Another name for a cell reference.
Spreadsheet
Another name for a worksheet.
Cell content
Anything typed into a cell.
Number values
Constant values consisting of only numbers.
Constant value
Numbers, text, dates, or times of day that you type into a cell.
AutoFill
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells
Category axis
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis
Active cell
The cell, surrounded by a black border, ready to receive data
Underlying value
The data that displays in the Formula Bar is referred to as the:
General format
The default format that Excel applies to numbers
Sheet tabs
The labels along the lower border of the Excel window that identify each worksheet.
Fill handle
The small black square in the lower right corner of a selected cell
Operators
The symbols with which you can specify the type of calculation you want to perform in an Excel formula.
Absolute
The type of cell reference that refers to cells by their fixed position in a worksheet
Sparklines
Tiny charts embedded in a cell that give a visual trend summary alongside your data
Value
another name for constant value
Cell
intersection of a column and a row
Data
texts or numbers in a cell
