Accounting 2258 Exam 2

dependent

a cell that references another cell

linear programming

a complex mathematical process used to solve problems that include multiple variables and the minimizing or maximizing of result values

Information rights management (IRM)

a feature of excel that allows you to restrict access to workbooks

calculated field

a field with values not entered as data, but determined by computation involving data in other fields

constraint

a limitation on the possible values that a cell can contain

criteria

a logical rule by which data is tested and chosen

R-squared value

a number from 0 to 1 that measures the strength of the trend

treadline

a visual way to show how two variables relate to each other

scenario manager

a what-if analysis tool that allows you to record and save different sets of what-if assumptions sued to forecast the outcome of a worksheet model

changing or adjusted cells

cells modified by solver to solve the problem

filters

command that lets you choose to display data that meets specified criteria

DCOUNT function

counts the numbers of numeric entries in a table field that pass a test

which of the following is the path to the format as table button? a. (home tab/tables group) b. (page layout tab/convert group) c. (styles tab/tables group) d. (home tab/styles group)

d. (home tab/ styles group)

lookup value

data, or the location of the data that you want to look up

filter criterion

deselcting an item from the filter menu

tracer arrows

drawn from once cell to another, identifying cells that are related to other cells through use in a formula

a workbook which is not shored and can be opened only by a single user is called an.... workbook a. exclusive b. embargoed c. engaging d. enabled

exclusive

sort keys

field or fields you select to sort the records

wildcard characters

filter would display results such as flash drives

DAVERAGE function

finds the average of numbers in a table field that pass a test

lookup table

functions that allow you to assign such rankings

scenario summary worksheet/ scenario pivottable worksheet

generated by the scenario manager actually is a worksheet in outline format that you can print and manipulate

slicers

graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts

table arguments

left column values in a table array

table (database)

organized collection of data

outline symbols

plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups

query

process of filtering activity based on one or more filter criteria

column index number

represents the column location of the return value within the lookup table

Answer Report

shows the answer that solver founds

HLOOKUP

table direction is horizontal, or across the worksheet

VLOOKUP

table direction is vertical, or down the worksheet

record

the data related to each person or item

search string

the data you enter in the search box on the filter menu

control field

the field on which you sort

fields

the individual data items that make up a record

Which of the following is the path to the Track Changes button? a. (Review tab/changes group) b. (insert tab/changes group) c. (home tab/changes group) d. (view tab/changes group)

a. (review tab/changes group)

when creating a PivotTable report, the active cell should be positioned.... a. anywhere in the range that contains the data b. in cell a1 c. anywhere outside the range that contains the data d. there is no active cell in a pivotable report

a. anywhere in the range that contains the data

the Goal Seek command is located on the ... menu a. What-if Analysis b. Problem Solving Tools c. Calculation Settings d. none of the above

a. what-if analysis

database functions

allows you to evaluate numeric data in a table

formula auditing

allows you to examine formulas to determine which cells are referenced by those formulas and examine cells to determine which formulas are built upon these cells

data validation

allows you to set cells so that the values they accept are restricted in terms of type and range of data

solver

allows you to specify up to 200 cells that can be adjusted to find solution to a problem

Row label filters

allows you to view a subset of data

PivotChart report

an interactive chart that allows users to change the groupings that graphically present data

PivotTable report

an interactive view of worksheet data that gives users the ability to summarize the data by selecting categories in which to group their data

return value

answer you want to appear as a result of VLOOKUP

sorting

arranging records in a specific sequence

you can filter the PivotTable report shown in the accompanying filter by... a. total 2014 sales b. department and style c. total 2015 sales d. average 2014 sales

b. department and style

The (.....) function is used when the table direction is horizontal a. vlookup b. hlookup c. mlookup d. zlookup

b. hlookup

As shown in the accompanying figure, solver allows your o set a constraint that includes a cell referenced followed by a(n).... a. value b. operator c. format d. none of the above

b. operator

a.... should be formatted so that the records are easily distinguished. a. function b. table c. formula d. recordset

b. table

by default, Excel keeps a change history of... days for a shared workbook a. 10 b. 20 c. 30 d. 40

c. 30

structured reference

uses a combination of the table name, the column heading, and any named or special rows, rather than the usual column letter and row number references

trial and error

when trying to solve some problems, you can make an educated guess if you are familiar with the data and the structure of the workbook