BUS 119 Excel Chapters 4, 5, 6, 7, & 8
The default file format for Excel 2016
.xlsx
When you create a template, Excel adds the file extension
.xltx
In the Cell Styles gallery, the Currency [0] style and the Comma [0] style format the selected cell with how many decimal places?
0
Solver is a command in Excel's
Analysis group
A logical function that counts cells that meet multiple criteria in multiple ranges
COUNTIFS
A moving average calculates an average for a group of numbers over a specified
Interval
Functions that are used to test for specific conditions
Logical function
To create a custom number format to display the full name of each month, use
Mmmm
To determine a trend from a widely fluctuating set of numbers, you could calculate a
Moving average
A logical function that returns true if any of the conditions are true
OR function
If data is listed in rows but you need to work with it in columns, you can use the Paste option
Transpose
The area in the layout section of the PivotTable Fields pane where data is summarized is the
VALUES area
An Excel function that looks up values that are displayed vertically in a column is the
VLOOKUP
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
Tracer arrows are red if a cell contains
an error value
The operator that requires each and every one of the comparison criteria that you specify must be true is the
and comparison operator
The ____________ is a report in a workbook that is graphically represented in a PivotChart
associated pivottable
When you use a defined name in a formula, the result is the same as if you typed a
cell reference
A visual representation of numeric data in a worksheet is a
chart
The ____________ button removes a filter from a slicer
clear filter
PivotTable field names are formed from the source data's
column titles
A sort order that you can define is a
custom list
A diagram that shows a continual process
cycle
The graphic element that represents a single data point is a
data marker
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 range of cells that shows how changing certain values in your formulas affects the results of those formulas
data table
A word or string of characters that represents a cell, a range of cells, a formula, or a constant value is a
defined name
Cells that contain formulas that refer to other cells are
dependent cells
Numbers sorted 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
A single piece of information that is stored in 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
Slicers are used to
filter data
The command that locates and selects specific text, formatting, or type of information within a workbook quickly is
find
A method to find a specific value for a cell by adjusting the value of one other cell. With this, you can work backward from the desired outcome to find the number necessary to achieve your goal
goal seek
To prevent a user from making changes to an Excel worksheet, use the ___________ command so that the worksheet is not visible
hide
A diagram used to create an organization chart is a
hierarchy
The column and row headings selected that describe the values in a chart
labels
The data for a PivotTable should be in the format of a
list
Cells in a worksheet that cannot be edited are
locked cells
A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value is referred to as
lookup functions
A term sometimes used to refer to the first sort level in the Sort dialog box is
major sort
The value that determines the spacing between the gridlines in the plot area of a chart
major unit value
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a
pane
An optional element added to a template to prevent someone from disabling a worksheet's protection is a
password
A(n) __________ chart illustrates the relationship of each part to a whole
pie
The area of a chart bounded by the axes
plot areas
Cells that are referred to by a formula in another cell are
precedent cells
The process of locking cells in a workbook so that users cannot make any changes is
protection
The Excel feature that suggests charts based upon your data
recommended charts
To work with multiple tables in Excel, a __________ must be created between the tables
relationship
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
The location within which a name is recognized without qualification
scope
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
A predesigned set of colors, fonts, lines, and fill effects that look good together is a
theme
The command that displays arrows to indicate what cells affect the value of the cell that is selected is
trace precedents
A type of chart that shows trends over time
trendline
A list of values that are acceptable for a group of cells is a
validation list
The numbers along the left side of a chart display on the
vertical value axis
A feature with which you can insert decorative text into your worksheet is
wordart
loans are typically made for a period of
years
The future value at the end of a loan is typically
zero
Restrictions that are used in Solver to limit the results are called
Constraints
Features that are Add-ins are activated through the
Excel options dialog box
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
Examples of variable expenses in a restaurant are
Food and wages
To import data from Access into an Excel Data Model, use the __________ command
Get External Data
Command used to move to a specific cell or range of cells in a large worksheet
Go to
A language web browsers can interpret
HTML
A forecast is a prediction of the future, often based on
Past performances
A ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart
PivotChart
The tool that enables you to compare alternatives is
Scenario manager
The arrangement of the arguments in a function
Syntax
