Exam 2 Chapters5-8

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

EMS/Module 7; Trauma-Practice Quiz

View Set