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