Excel
Select all box
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:
Absolute
The type of cell reference that refers to cells by their fixed position in a worksheet is:
Absolute
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:
Table
A series of rows and columns with related data that is managed independently other data is a:
Data bar
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
Fund
A sum of money set aside for a specific purpose is a:
Point
A value that originates in a worksheet cell and that is represented in a chart by a data mark is a data:
Summary sheet
A worksheet where totals from other worksheets are displayed and summarized is a :
Name box
An Excel window element that displays the name of the selected cell, table, chart, or object is the:
Workbook
On startup, Excel displays a new blank:
Print titles
The Excel command that enables you to specify rows and columns to repeat on each printed page is:
Active cell
A cell surrounded by a black border and ready to receive data is the:
Line chart
A chart type that displays trends over time is a:
Shape effects
A gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text is:
Formula bar
An Excel window element that displays the value or formula contained in the active cell is the:
Series
Related data points represented by data markers are referred to as the data:
Explode
The action of pulling out a pie slice from a pie chart is called:
Axis area
The area bounded by the axes of a chart, including all the data series is the:
Freeze panes
The command that enables you to select one or more rows or columns and lock them into place is:
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 is the:
Auto fill
The feature that generates and extends values into adjacent cells based on the values of selected cells is:
NOW function
The function that retrieves and then displays the date and time from your computer is the:
Sheet tabs
The labels along the lower border of a workbook window that identify each worksheet are the:
Increase
The percent by which one number increases over another number is the percentage rate of:
Sorting
The process of arranging data in a specific order based on the value in each field is called:
Filtering
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:
Detail sheets
The worksheets that contain the details of the information summarized on a summary sheet are called:
Data axis
The x-axis is also known as the:
Sparklines
Tiny charts embedded in a cell that give a visual trend summary alongside your data are: