Exam 2 Chapters5-8
The file type developed by Adobe Systems that is a visual representation of a document
PDF (portable document format)
The upper portion of the PivotTable Fields pane containing the fields- column titles- from your source data; use this area to add fields to and remove fields from the PivotTable
Field section
Optional commands and features that are not immediately available and must be installed or activated to use.
Add-ins
Solver is a command in Excel's:
Analysis group
The operator that requires each and every one of the comparison criteria that you specify must be true is the:
And comparison operator
A process by which you can limit the display of data to only specific information
Filter
To pull out multiple sets of data for comparison purposes
Extract
A single piece of information that is stored in every record:
field
Examples of variable expenses in a restaurant are:
food and wages
All of the categories of data pertaining to one person, place, thing, event or idea
Record
The command to update a worksheet to reflect new data
Refresh
A function that adds values in a specified range that meet a certain conditions or criteria.
SUMIF
A what-if analysis tool that compares alternatives.
Scenario Manager
The tool that enables you to compare alternatives is:
Scenario Manager
Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way
Slicer
The top of a slicer that indicates the category of the slicer items
Slicer header
The command that tiles all open program windows on the screen
Arrange all
A moving average calculates an average for a group of numbers over a specified:
interval
A set of values that Excel saves and can substitute automatically in your worksheet.
Scenario
A point at which an entity covers its cost and starts to make a profit.
Break-even
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is:
scaling
A window that lists the fields from source data and an area in which you can arrange the fields in the PivotTable
PivotTable Fields pane
Slicers are used to:
filter data
An area to position fields that contain data that is summarized in a PivotTable or PivotChart report
Values area
The area in the layout section of the PivotTable Fields pane where data is summarized is the
Values area
In Solver, cells that will change to achieve a desired result.
Decision variables
Expenses that remain the same each month.
Fixed expenses
PivotTable field names are formed from the source data's:
column titles
Restrictions that are used in Solver to limit the results are called:
constraints
A sort order that you can define is a:
custom list
The cells in which the values will change to achieve the desired results in Solver are called:
variable cells
One possible source of data for a PivotTable is a(n):
Access database file
A(n) ______ chart illustrates the relationship of each part to a whole.
pie
To work with multiple tables in Excel, a ________ must be created between the tables.
relationship
A forecast is a prediction of the future, often based on:
past performances
The default file format for Excel 2016:
.xlsx
A logical function that counts cells that meet multiple criteria in multiple ranges.
COUNTIFS
A set of formatting characteristics that you can apply to a cell
Cell styles
The Equal sign(=), Greater Than sign(>), or Less Than sign(<) used singly or in combinations to compare two values
Comparison operators
The term used for conditions that you specify that must be matched for the record to be included in the search results
Criteria
An organized collection of facts related to a specific topic
Database
The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the:
Filters area
The command that locates and selects specific text, formatting, or type of information within a workbook quickly is:
Find
A prediction of the future, often based on past performances.
Forecast
Command used to move to a specific cell or range of cells in a large worksheet:
Go To
In a moving average, the number of cells to include in the average.
Interval
The lower portion of the PivotTable Fields pane where you build the PivotTable report by rearranging and repositioning fields
Layout section
A function that is contained inside another function.
Nested Function
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a:
Pane
A _______ displays data series, categories, data markers, axes in the dame manner as a standard chart.
PivotChart
A graphical representation of the data in a PivotTable
PivotChart
An interactive Excel report that summarizes and analyzes large amounts of data
PivotTable
A what-if analysis tool that can help you find an optimal value for a formula in one cell---subject to constraints on the values of other formula cells on a worksheet.
Solver
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source
Source data
The arrangement of the arguments in a function.
Syntax
If data is listed in rows but you need to work with it in columns, you can use the Paste option:
Transpose (T)
Numbers ordered from highest to lowest are sorted in:
descending order
The area where you place the results when copying the results of a filter to another location in the worksheet:
extract area
The data for a PivotTable should be in the format of a:
list
A term used to refer to the first sort level in the Sort dialog box is:
major sort
To create a custom number format to display the full name of each month, use:
mmmm
To determine a trend from widely fluctuation set of numbers, you could calculate a:
moving average
To organize data in a particular order is to:
sort
The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row:
tab delimited text file
Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the ________.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet
Data model
Features that are Add-ins are activated through the:
Excel Options dialog box
A single piece of information for every record
Field
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:
Field buttons
A language web browsers can interpret
HTML
Values sorted from A to Z
Ascending
A predesigned set of colors, fonts, lines and fill effects that look good together is a:
theme
The ____ is a report in a workbook that is graphically represented in a PivotChart.
Associated PivotTable
A menu of filtering commands that displays when you click one of the filter arrows in an Excel table
AutoFilter menu
The column titles from source data that form categories of data for a PivotTable
Field names
The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet
Freeze panes
To import data from Access into an Excel Data Model, use the ________ command.
Get External Data
To prevent a user from making changes to an Excel worksheet, use the ______ command so that the worksheet is not visible.
Hide
Colored and underlined text that, when clicked, takes you to another location in the worksheet, to another file, to a Web page on the internet, or on your organization's intranet
Hyperlink
Functions that are used to test for specific conditions:
Logical function
A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly.
Moving Average
A logical function that returns true if any of the conditions are true.
OR function
In Solver, a cell that contains a formula for the results you are trying to determine, usually defined as a minimum, a maximum, or a specified value.
Objective cell
Expenses that vary depending upon the amount of sales.
Variable expenses
The general process of changing values in cells to see the effect on formulas in other cells.
What-if analysis
A character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records
Wildcard
The file type that saves an Excel file so that there is a comma between each cell and a paragraph return at the end of each row
CSV (comma separated values file)
The _____ button removes a filter from a slicer.
Clear filter
The field used to uniquely identify a record in an Access table
Primary key
The term that refers to asking a question of the data in a database
Query
