Excel 1
The PivotTable___________________pane is used to change fields from rows to columns, to add or remove fields, and to change the fields used to calculate values.
Filter
A text function used to return a specified number of characters starting from the left side of the data.
LEFT function
When data validation Error alert is set to ________________, the user is the given the option to proceed even if the data is invalid.
Warning
When using validation rules you can choose an option that will circle invalid data. What color is this circle
Red
A text function used to remove all spaces from a text string exept for single spaces between words.
TRIM function
A data validation message that informs the data entry operator about the types of data that can be entered into the cell.
Input message
In an Excel chart, a(n) __________________can be added to identify the data series or categories in the chart.
Legend
Categories of data organized into columns.
Fields
Delimiter
A text function used to return a specified number of characters starting from a specified position in the data.
MID function
_________________ is when a DATA SERIES in a chart has mixed typed of data. (one or more data series are plotted on a secondary axis)
dual axis (chart)
A small red triangle or purple in the upper right corner of a cell
Comment indicator
In a column chart, a group of related columns represents a _____________________in the chart.
data series
A command used to summarize and report results from separate worksheets.
Consolidate
In Excel, a file that is not the current Excel 2016 format is a _________________file.
non-native
Dynamic visual representation of data
PivotChart
A tool that is used to filter data in PivotTable views
Slicer
Located in the first column of a PivotTable report, these fields are used to categorize the rows
Row labels
A text function used to join the text from two or more cells into one cell.
Concatenate
A stored set of instructions that automates common tasks.
Macro
Data points follow nearly a straight line.
Linear trendline
Places a restriction on the types of data that can be entered into cells
Data validation rule
A trendline that has data points following a smooth curve.
Moving average
Descriptive text that you can add to cells without modifying the data in the worksheet.
Comment
Collections of related data that display in a single row in a database table.
Records