SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Business Analyst
Start Test
Study First
Subjects
:
certifications
,
business-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A collection of one or more related tables of data stored in rows and columns
pivot table
database integration
demographics
database
2. The idea that a brand's power depends on it's uniqueness
singularity
theme
Limited Liability Corporation (LLC)
business intelligence
3. A part of the spreadsheet - usually at the top - where the key variables are given their values.
scatterplot
form
latency
assumptions area
4. Usually the recommended way to start a small business. If the business goes under - you are not personally liable for the businesses debts.
business intelligence
contribution margin
enterprise resource planning
Limited Liability Corporation (LLC)
5. Accessing development software that lives in the cloud. The major advantage is that the development process tends to be greatly simplified.
cloud development
database
variable cost
contribution margin
6. The organization of items on a page. For example - a 2up layout consists of two blocks of images and/or text.
layout
scatterplot
website authoring tools
sensitivity analysis
7. The delivery of accurate - useful information to the appropriate decision makers within the necessary fime frame to support effective decision making.
pivot table
website authoring tools
drill down
business intelligence
8. This is a job title typical for an IS graduate. Business analysts work both with business units such as Human Resources and the programmers. They discover the needs of the business unit and then translate those needs into documentation for the progra
analytical design
business analyst
singularity
market segment
9. Describes how easy the system is to use and navigate
microfinance
payment (PMT) function
extract - transform - load (ETL)
usibility
10. Suggests causality by plotting independent and dependent variables on the same graph.
payment (PMT) function
website authoring tools
scatterplot
singularity
11. A marketing term that refers to the ability of a brand to stand out from the crowd.
differentiate
form
payment (PMT) function
foreign key
12. The ability to capture and store information gathered from a form into a database. Database integration also refers to the ability to extract and display information from a database on a website.
information systems
startup costs
business intelligence
database integration
13. Describes how best to represent information
pie chart
camelback notation
foreign key
analytical design
14. A wat to get information out of a database. Often a report will gather information together from multiple tables and present it as a single table
enterprise resource planning
report
page template
landscape orientation
15. What you make on every sale after subtracting variable costs.
database
scatterplot
contribution margin
information systems
16. Designing websites and applications to meet the needs of the user.
user centered design
market segment
master
fixed cost
17. Defines a set of background elements - colors - and fonts as well as a set of slide layouts.
dynamic reports
report
website authoring tools
theme
18. Running development software such as Dreamweaver on your workstation. The major advantage is that it runs very fast when running locally.
affinity
client side development
database
page template
19. A PowerPoint template well suited for creating schematic reports because of its small font size and versatile layouts.
Pitchbook
scatterplot
pie chart
client side development
20. The process of copying data from many databases throughout the enterprise into the datawarehouse
extract - transform - load (ETL)
dashboard
template
demographics
21. An analysis of the attractiveness of the industry in which the company operates.
industry Analysis
variable cost
usibility
latency
22. The combination of people - information technology - and business processes to accomplish a business objective.
bar graph
market segment
information systems
singularity
23. The cheapest way to start a business. It is just you doing business under another name. However - you are personally liable for business debts.
master
template
Doing Business As (DBA) license
business intelligence
24. A database that consists of related tables and nothing but tables.
singularity
business intelligence
differentiate
relational database
25. Compares discrete categories on a common measure.
pie chart
system development life cycle
Doing Business As (DBA) license
data mining
26. The process of fishing for patterns in the data using computing power because you really do not know what to look for.
landscape orientation
Porter's five forces
website authoring tools
data mining
27. A cost that business incurs on each sale. For apps - the variable cost is the iTunes store commission.
variable cost
foreign key
singularity
PowerPoint presentation
28. Make very small loans (typically under 500) to entrepreneurs in developing countries. Most Loans are repaid in six months to a year.
usibility
microfinance
user centered design
form
29. A way to get information into database. Each field in the form corresponds to a field in the database table
PowerPoint presentation
form
static reports
schematic report
30. A form of BI reporting with which we are most familiar-- summary reports distributed at regular intervals.
form
latency
static reports
enterprise systems
31. A visual query tool in excel that allows you to easily group and summarize data
database
pivot table
startup costs
camelback notation
32. A method for designing information systems. The life cycle proceeds through the following stages: an analysis of the current state - development of requirements - design of a solution - development from the design and finally to implementation or rol
information systems
cloud development
static reports
system development life cycle
33. One or more fields that uniquely identify each record in the table
template
schematic report
primary key
startup costs
34. The amount of time between the occurrence of a transaction and the loading of that transaction's information into the business intellegence system.
latency
line graph
page template
system development life cycle
35. An analysis of how the calculation results vary with changes in the initial assumptions.
analytical design
schematic report
sensitivity analysis
cloud development
36. A cost that the business must pay whether or not they sell anything. Examples include rent - legal fees - development costs and so forth.
layout
scatterplot
SQL
fixed cost
37. A high level management overview of the data--sometimes depicted using dials and needles similar to an automobile dashboard. In a car.
line graph
gadgets
dashboard
schematic report
38. Compares discrete (distinct) categories on a common measure
bar graph
data mining
sensitivity analysis
singularity
39. Repear the primary key from the parent table in each corresponding record of the child table as a foreign key to link tables together
Porter's five forces
foreign key
latency
singularity
40. Variable names created by capitalizing the first letter of each word and eliminating the spaces between words.
PowerPoint presentation
camelback notation
database integration
finance charge
41. Programs that greatly simplify the process of building a website. Google Sites is the authoring tool that we will use.
user centered design
primary key
website authoring tools
camelback notation
42. The largest systems of all. ERP systems tie together all aspects of the business from accounting to the shop floor.
fixed cost
enterprise resource planning
assumptions area
startup costs
43. A user-friendly way to get information into a database.
report
page template
drill down
form
44. These are fixed costs associated with starting a business. Often refers to one time costs.
Pitchbook
payment (PMT) function
startup costs
business intelligence
45. Similar to a template but without the placeholder text and images. A theme specifies formatting--layout - colors - and fonts
camelback notation
dynamic reports
theme
pivot table
46. A model report in which the theme is predefined. In some templates even some of the slides are already created. For example - the Pitchbook template includes a title slide - a table of contents slide - and a section heading slide.
latency
relational database
template
static reports
47. The opposite of contrast. Layouts demonstrating affinity show subtle variations in color or brightness.
Porter's five forces
latency
affinity
master
48. A business presentation combining concise text and graphics. Schematic reports should be brief - well organized - and easy to navigate. Though usually designed in PowerPoint - schematic reports are intended primarily to be read rather than projected.
market segment
schematic report
latency
form
49. The total interest paid over the life of the loan. The finance charge is calculated by adding up all of the loan payments and then subtracting from this total the amount originally borrowed.
finance charge
layout
data warehouse
user centered design
50. A built in Excel function that calculates loan payments. Inputs to the function include the loan amount (pv) - the interest rate (rate) - and the number of loan payments (nper).
cloud development
payment (PMT) function
database integration
static reports