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