Excel assigns the name ____ to the first Excel table created in a workbook.
What is table1?
100
data about data
What is Megadata?
100
use statistical sampling procedures when conducting audits for their clients
What is Accounting?
100
a process of identifying the financial benefits and costs associated with a development project
What is Economic feasibility?
100
The ________ function calculates the average of vales in a range that meets criteria you specify.
What is AVERAGEIF?
200
When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.
What is Table?
200
shared, integrated computer structure that stores a collection of end-user data and metadata
What is Database?
200
use statistical information in making forecasts about the future of the economy or some aspect of it
What is Economics?
200
Assess the degree of approval/resistance to the new system
What is Human resources feasibility?
200
The ________ function calculates the number of cells in a range that match specified criteria.
What is COUNTIF?
300
a table name cannot include
What is spaces?
300
generation, storage, and retrieval of data
What is data management?
300
Advisers use price-earnings ratios and dividend yields to guide their investment advice
What is Finance?
300
What are the legal/political ramifications of the new system?
What is Legal/political feasibility?
300
The ________ function adds values in a range that meet your criteria.
What is SUMIF?
400
Which of the following is a valid table name?
What is newtable?
400
The application of software to derive information or meaning from data. The end result might be a report, an indication of status, or an action taken automatically based on the information received.
What is Data Analysis?
400
Electronic POS scanners at retail checkouts are used to collect data for a variety of market research applications
What is Marketing?
400
Degree to which current technical resources can be applied to the new system
What is Technically feasibility?
400
The ______ function is a text function to join two or more text strings into one string.
What is Concatenate?
500
A data ____ table describes the fields you plan to maintain in a table.
What is Definition?
500
stores data in a format optimized for decision support
What is Data Warehouse?
500
A variety of statistical quality control charts are used to monitor the output of a production process
What is Production?
500
In this stage, the project's alternatives are evaluated for their impact on the local and general culture.
What is cultural feasibility?
500
The ________ function looks for a value in the leftmost column of a table and returns a value from the same row from a column you specify.