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