Office 2016 Excel Chapter 1
Select all box
A box in the upper left corner of the worksheet grid that selects all the cells
Active cell
A cell surrounded by a black border and ready to receive data
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
Number Format
A format that controls how numerical data is displayed, including the use of commas, dollar signs and number of decimal places
Range
A group of adjacent or contiguous cells in a worksheet.
Row
A horizontal group of cells in a worksheet
Column
A vertical group of cells in a worksheet
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 that contains one or more worksheets
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
Value
Are numbers that represent a quantity or a measurable amount
Number values
Constant values consisting of only numbers
Name box
Displays the name of the selected cell, table, chart, or object
Formula bar
Displays the value or formula contained in the active cell
Workbook
On startup Excel displays a new blank
Data
Text or numbers in a cell
Underlying value
The data that displays in the formula bar is referred to as
General format
The default format that Excel applies to numbers
Auto fill
The excel feature that generates and extends values into adjacent cells based on the values of selected cells
Chart
The graphic representation of data in a worksheet
Cell
The intersection of a column and a row
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 wany to perform in an Excel formula
Absolute
The type of cell reference that refers to cells by their fixed position in a worksheet