Excel 1
A text function sued to remove spaces from a string leaving a single space between words is the ______________________ fuction.
TRIM
A_______________is a chart element used to identify the data series in the chart.
Legend
The function returns a specified number of characters starting from a specified position in the data
MID
When data series in a chart have mixed types of data, you can use a ____________________ chart to plot a second value series.
dual axis
A ___________________is an object that can be inserted on a worksheet to provide additional information.
text box
The________________________worksheet is a temporary worksheet that displays the change history.
History
The _______________________function returns the characters starting from the left side of the string.
LEFT
A pre-maid Excel workbook________________ can be edited.
Template
In a database, a ___________________ is a collection of related data that displays in a row.
Record
The ______________________function returns a specified number of characters, starting from the right side of the data.
RIGHT
A Message that informs a user that invalid data has been entered in a cell is a(n)__________________.
error alert
A plus sign next to a group in a PivotTable report is a(n) ______________________ icon
expand
A tool used with a PivotTable to filter data based on distinct values in columns is a _____________________.
slicer
____________charts have only one data series.
Pie
A ___________________________is descriptive text that is added to worksheet cells without modifying the dtat.
comment
Once a worksheet is protected, you must __________________any cells to which you want to allow changes.
Unlock
Cells that contain comments display a comment indicator as a small ________________ triangle.
red
A trendine that has data points following a smooth curve to show data fluctuations is a(n) ________________ trendline.
Moving Average
A trendline that has data points following a nearly straight line is a(n) _________________ trendline.
Linear
When the data validation Error alert is set to ____________________the user is prevented from entering invalid data in the cell.
Stop
In a column chart, a group of related columns represents a ___________________in the chart.
Data series
The __________________command is used to summarize and report results from separate worksheets.
Consolidate
When the data validation Error alert is set to_____________________the user is given the option to proceed even if the data is invalid.
Warning
The ________________________worksheet displays the entire change in history and does not display again when the workbook is closed and reopened.
History
_____________________rules place restrictions on the types of data that can be entered into cells.
Data Validation