BNAL 206 FINAL EXAM QUESTIONS AND VERIFIED
ANSWERS
Big data refers to four concepts: - Answers - volume, variety, velocity and veracity
Which of the following is NOT a challenge for business analytics? - Answers - having
sufficient analytical skills
blank can be defined as numbers or textual data that are collected through some type of
measurement process - Answers - data
The concept of ___________ refers to the case in which data correctly measures what
it is supposed to measure . - Answers - validity
A manager at Gampco Inc. wishes to know the company's revenue and profit in its
previous quarter. Which of the following business analytics will help the manager? -
Answers - descriptive analytics
Predictive analytics: - Answers - detects patterns in historical data and extrapolates
them forward in time.
Which decision model incorporates the process of optimization? - Answers - prescriptive
During which phase in problem solving is a formal model often developed? - Answers -
structuring the problem
Using a $ sign before a row number and a column label ________. - Answers - keeps
the reference to both the row and column fixed
In the spreadsheet below, there is data on the price, cost, and quantity produced for an
item. - Answers - =B6*B8+B7
Below is a list of purchase orders for a computer hardware retailer. - Answers -
=COUNTIFS(H2:H6, "Small", A2:A6, "Rex Technologies")
Below is a spreadsheet of purchase orders for a computer hardware retailer. - Answers
- =SUMIF(A2:A7, "Rex Technologies", D2:D7)
Below is the spreadsheet for demand prediction of a company that sells chocolates.
, Given that D = a - bP, where D, is demand, "a" and "b," are linear constants, and P, is
price, from the above spreadsheet, how will the formula in B9 be represented in Excel
using relative references? - Answers - =B4-B5*A9
Which of the following is a differentiation between calculating using the functions
COUNT and COUNTIF? - Answers - COUNT only requires a range of cells, COUNTIF
requires range and special criteria to be calculated.
Which is NOT a method to create range names in Excel? - Answers - Highlight and drag
down
The easiest way to locate a particular function is to select a cell and click on the Insert
function button represented by ________ on the Excel ribbon. - Answers - fx
Below is a spreadsheet of purchase orders for a computer hardware retailer.
For which of the following columns can the COUNT function be performed? - Answers -
column E
In the rows of a two-dimensional table, we will find - Answers - records
What is a dataset? - Answers - simply a collection of data
In the advanced filter, multiple criteria in different rows are logically joined by _____. -
Answers - OR
________ is a logical function that returns one value if the condition is true and another
if the condition is false. - Answers - IF (condition, value if true, value if false)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
What will be the result of the function VLOOKUP(1004, A2:H7,6)? - Answers - 300
Below is a spreadsheet of purchase orders for a computer hardware retailer.
Which of the following Database functions calculates the count of purchase orders
made by Rex Technologies? - Answers - =DCOUNT(A3:H8,"Item Cost",A1:H2)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
Which of the following Database functions calculates the total cost charged to Rex
Technologies for large size orders? - Answers - =DSUM(A3:H8,"Cost per Order",A1:H2)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
ANSWERS
Big data refers to four concepts: - Answers - volume, variety, velocity and veracity
Which of the following is NOT a challenge for business analytics? - Answers - having
sufficient analytical skills
blank can be defined as numbers or textual data that are collected through some type of
measurement process - Answers - data
The concept of ___________ refers to the case in which data correctly measures what
it is supposed to measure . - Answers - validity
A manager at Gampco Inc. wishes to know the company's revenue and profit in its
previous quarter. Which of the following business analytics will help the manager? -
Answers - descriptive analytics
Predictive analytics: - Answers - detects patterns in historical data and extrapolates
them forward in time.
Which decision model incorporates the process of optimization? - Answers - prescriptive
During which phase in problem solving is a formal model often developed? - Answers -
structuring the problem
Using a $ sign before a row number and a column label ________. - Answers - keeps
the reference to both the row and column fixed
In the spreadsheet below, there is data on the price, cost, and quantity produced for an
item. - Answers - =B6*B8+B7
Below is a list of purchase orders for a computer hardware retailer. - Answers -
=COUNTIFS(H2:H6, "Small", A2:A6, "Rex Technologies")
Below is a spreadsheet of purchase orders for a computer hardware retailer. - Answers
- =SUMIF(A2:A7, "Rex Technologies", D2:D7)
Below is the spreadsheet for demand prediction of a company that sells chocolates.
, Given that D = a - bP, where D, is demand, "a" and "b," are linear constants, and P, is
price, from the above spreadsheet, how will the formula in B9 be represented in Excel
using relative references? - Answers - =B4-B5*A9
Which of the following is a differentiation between calculating using the functions
COUNT and COUNTIF? - Answers - COUNT only requires a range of cells, COUNTIF
requires range and special criteria to be calculated.
Which is NOT a method to create range names in Excel? - Answers - Highlight and drag
down
The easiest way to locate a particular function is to select a cell and click on the Insert
function button represented by ________ on the Excel ribbon. - Answers - fx
Below is a spreadsheet of purchase orders for a computer hardware retailer.
For which of the following columns can the COUNT function be performed? - Answers -
column E
In the rows of a two-dimensional table, we will find - Answers - records
What is a dataset? - Answers - simply a collection of data
In the advanced filter, multiple criteria in different rows are logically joined by _____. -
Answers - OR
________ is a logical function that returns one value if the condition is true and another
if the condition is false. - Answers - IF (condition, value if true, value if false)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
What will be the result of the function VLOOKUP(1004, A2:H7,6)? - Answers - 300
Below is a spreadsheet of purchase orders for a computer hardware retailer.
Which of the following Database functions calculates the count of purchase orders
made by Rex Technologies? - Answers - =DCOUNT(A3:H8,"Item Cost",A1:H2)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
Which of the following Database functions calculates the total cost charged to Rex
Technologies for large size orders? - Answers - =DSUM(A3:H8,"Cost per Order",A1:H2)
Below is a spreadsheet of purchase orders for a computer hardware retailer.
