Quiz 5 review
Merge and Center
1. A command that joins selected cells in a workbook into one larger cell and centers the contents in the merged cell:
Workbook
1. An Excel file that contains one or more worksheets
Formula
10. An equation that performs mathematical calculations on values in a worksheet
Sparklines
10. Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
Auto fit
11. An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is
Number Values
11. Constant values consisting of only numbers
Cell Address
12. Another name for a cell reference
Quick Analysis tool
13. 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:
Value
13. Another name for a constant value
Fill Handle
14. The small black square in the lower right corner of a selected cell
Range Finder
15. A feature that outlines cells in color to indicate which cells are used in a formula is called:
Chart
15. The graphic representation of data in a worksheet
Cell
3. The intersection of a column and a row
Select all box
4. A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
Sheet Tabs
4. The labels along the lower border of the Excel window that identify each worksheet
Column
5. A vertical group of cells in a worksheet
Auto Fill
6. The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:
Cell Content
7. Anything typed into a cell
Data
8. Text or numbers in a cell
underlying value
8. The data that displays in the Formula Bar is referred to as the:
Constant Value
9. Numbers, text, dates, or times of day that you type into a cell
Absolute
9. The type of cell reference that refers to cells by their fixed position in a worksheet
Active Cell
A cell surrounded by a black border and ready to receive data is the:
Row
A horizontal group of cells in a worksheet
Formula bar
An element in the Excel window that displays the value or formula contained in the active cell is the:
Name Box
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the
Spreadsheet
Another name for a worksheet.
Category Axis
The area along the bottom of a chart that identifies the categories of data is the:
General format
The default format that Excel applies to numbers is the:
Operators
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are: