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
The function that allows you to make logical comparisons between a value and what you expect.
IF
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
The pathway used to protect a workbook.
Review tab > Protect group >Protect workbook
The formula used when you need to find things in a table or range by row.
VLOOKUP
_________________ 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)
What is something you cannot include in a name of a table?
A space
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
What is the process of tracking errors and checking worksheet logic?
Formula auditing
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.
CONCAT
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