How do slicers enhance an Excel dashboard?
By allowing users to filter data visually and interactively
One-way ANOVA is most appropriate when you want to:
Compare means across three or more independent groups
Which AI tool is best for direct data analysis — allowing users to upload CSV/Excel files and ask questions in plain English to receive regressions, forecasts, and visualizations?
Julius AI
If df.shape returns (1000, 15), this means:
The dataset has 1000 rows and 15 columns
The operation df.groupby('category')['rating'].mean() is used to:
Calculate the average rating for each product category
How does Apple's decision-making approach differ from that of most companies?
It encourages collaborative debate between functional experts rather than top-down directives
Which of the following metrics measures forecast accuracy?
MAD
What does a business 'Agent' do that distinguishes it from a traditional Chatbot?
It lets the LLM decide the path at runtime and loops between thought, action, and observation
One of the goal of data architecture is to manage data and its flow through the enterprise. It follows a set of principles. Which of the following is a principle of data architecture?
Provide user interfaces for consuming data.
Why is business analytics described as 'uniquely well-suited' for agentic AI?
Because analytics tasks are tool-rich (SQL, Python, sheets) and goal-driven — exactly the conditions under which agents outperform single-shot LLM calls
Which SQL function is used to count the number of rows in a table?
COUNT()
What is the benefit of using a PivotTable in a dashboard?
It allows users to create dynamic charts and summaries easily
Which tool is best for 'long, parallelizable analytics tasks'?
Kimi K2.5
Which of the following statements is False?
Euclidean distance does not allow for diagonal movement, which may lead to inaccurate similarity assessments in high-dimensional spaces.
What does "Generalization" mean in the context of Machine Learning?
The ability of a model to make accurate predictions on unseen data
Which of the following is a common mistake when choosing a chart type for data visualization?
Using a pie chart with too many variables
Which of the following statement is INCORRECT in the perspective of data architecture and data modeling?
Data architecture is about the micro view that seeks to understand and support the relationships between an organization’s functions, technology, and data types.
In a linear programming problem, the objective function represents:
The quantity to be maximized or minimized
Which of the following best describes “phishing” as a cybersecurity threat?
Trickery used to obtain sensitive information by impersonating trusted entities
What does a lower MAPE value indicate about a forecasting model?
The forecast is more accurate
What is an example of disruptive technology?
Computers with word processors replacing typewriters
Which of the following describes Porter’s Generic Competitive Strategies?
Strategies for gaining a competitive advantage in the market
What is the primary function of similarity measures in data mining?
To quantify how data points are alike based on specific mathematical functions.
Which of the following is not one of the three core characteristics of cloud computing?
Fully managed by the user
Which regulation is specifically designed to protect the personal data of European Union citizens?
GDPR
Which algorithm is used for dimensionality reduction in Machine Learning?
Principal Component Analysis (PCA)
Which Excel feature is commonly used to filter data interactively on a dashboard?
Slicer
Pivot Tables are essential in dashboard creation because they:
Summarize and aggregate large datasets dynamically without changing source data
What is the primary purpose of Google's NotebookLM
To summarize long files and websites, and generate structured notes and study guides
In data inspection, conditional formatting is most useful for:
Visually identifying patterns such as missing values or outliers
In the context of linear programming, 'slack' refers to:
The unused portion of a resource constraint
Excel Solver is most appropriately used to:
Find optimal values for decision variables subject to constraints
Which of the following is a benefit of data literacy within an organization?
Improved cross-functional collaboration
What was the primary organizational change Steve Jobs implemented upon returning to Apple in 1997?
Eliminating general managers and restructuring into a functional organization
Why does Apple avoid tying senior R&D executives’ bonuses to individual product performance?
To encourage long-term innovation without short-term financial pressure
Each organization strives to be ethical, to be legally, and morally strong. Which of the following is NOT one of the principles of data ethics in the organization?
Foresightedness
Which of the following best describes strategy risks according to Kaplan and Mikes’ framework?
Risks taken voluntarily in pursuit of superior returns
In the context of a confusion matrix, what does a high false negative (FN) rate indicate in a fraud detection model?
The model is misclassifying a large number of fraudulent transactions as non-fraudulent.
Which algorithm is commonly used for clustering in unsupervised learning?
K-Means
Which library is commonly used in Google Colab for handling Excel files?
Pandas
Which of the following scenarios would most likely result in an underfitted model?
A decision tree with minimal depth that fails to capture patterns in the data.
A retail chain randomly selects entire cities for a sales performance survey, and all stores within those cities are included. Which sampling method is this, and what advantage does it provide?
Cluster sampling – simplifies data collection from large, dispersed populations
Which SQL clause is used to sort the result set of a query?
ORDER BY
Which Excel function would be most appropriate to count how many houses in the dataset have exactly 3 bedrooms AND are located in Seattle?
COUNTIFS()
A firm identifies that 25% of its records contain missing values for “Customer Income.” It chooses to compute averages from the same geographic area and fill these gaps. This practice best exemplifies:
Imputation
In an adjacency matrix for an undirected graph, which of the following is always true?
The matrix is symmetric (entry i,j equals entry j,i)
Which of the following best describes Platform-as-a-Service (PaaS) in cloud computing?
It delivers tools and infrastructure for developers to build applications over the Internet
What is the main challenge of reinforcement learning?
Balancing exploration and exploitation
What is the purpose of the PRIMARY KEY in a table?
To uniquely identify each record in a table
Converting a data range into an Excel Table (using Insert > Table) provides which primary advantage for data analysis?
It enables structured references and dynamic formulas that adjust as data changes
What does ERP stand for?
Enterprise Resource Planning
In network analysis, what do 'nodes' and 'edges' represent respectively?
Entities (e.g., people, companies) and the relationships or connections between them
What keyword is used to filter records in SQL?
WHERE
Microsoft’s acquisition of LinkedIn illustrates which core dimension of data monetization strategy?
Transformation of user engagement into revenue through enhanced contextual targeting
What lesson can other companies learn from Apple's approach to innovation?
Aligning decision-making authority with technical expertise can lead to sustained innovation
A logistics company wants to place a new distribution center so it can reach all retail locations with the fewest delivery hops. Which centrality measure should they prioritize?
Closeness Centrality — to find the location closest to all others
Which of the following is a common mistake in database design?
Ignoring Normalization, Communication issues between the business and tech, Redundant tables and fields
In regression output, a p-value less than 0.05 for a predictor variable (e.g., square footage) indicates:
The variable has a statistically significant relationship with the outcome
Based on the MIT finding that 83.3% of users could not recall sentences they wrote minutes earlier when using AI, what is a key concern for business analytics professionals?
Over-reliance on AI may reduce critical thinking
The R-squared value in regression analysis tells you:
The proportion of variance in the dependent variable explained by the independent variables
Which of the following statements is NOT correct?
Discovery Bank in South Africa believes there’s a correlation between fiscal responsibility and family size.
According to Gartner’s definition, which of the following is NOT a component of data literacy?
The capability to modify database schemas.
What is the primary function of data governance in an organization?
Controlling how data is stored, accessed, and maintained.
Which of the following best describes a decision variable in an optimization model?
A controllable factor that directly influences the outcome of an optimization problem.
What is the primary purpose of a Data as a Service (DaaS) model?
To provide on-demand access to data without managing infrastructure.
What is an example of predictive analytics in business?
None of the option
Which of the following statements is not a key principle of quality data?
Management success and quality data are inextricably linked.
Which of the following cloud computing service models provides a complete development and deployment environment without managing the underlying infrastructure?
Platform as a Service (PaaS)
What is the primary objective of data management in business analytics?
To organize, access, and govern data for improved decision-making
Effective data monetization can be a source of competitive advantage. Which of the following approaches is NOT related to data monetization?
Connecting suppliers to customers in the value chain
How does federated learning enhance data privacy in Big Data applications?
By training on decentralized devices without sharing raw data.
Which of the following is an example of semi-structured data?
JSON
Which of the following statements is NOT correct?
Data brokers' data can not be used for harmful purposes, such as identity theft, fraud, or targeted discrimination
Why is fixing data errors through cleanup considered ineffective?
It is expensive and time-consuming, and new errors keep emerging if the root cause is not addressed.
What is the primary role of business analytics in organizations?
To support data-driven decision-making using statistical and quantitative methods
Which of the following is False?
Cloud computing increases data processing latency by performing computations closer to data sources.
If you plan to start a real state business, which data brokers should you ask for data analytics?
CoreLogic
Which type of decision model assumes that all input parameters are known with certainty?
Deterministic Model
Which of the following statements is NOT correct?
Cloud computing is public, meaning that your data is also public.
What is the primary goal of start-ups like Trifacta and Paxata in the big data industry?
To automate the processes of data gathering, cleaning, and preparation.
Which of the following state is NOT correct for data brokerage?
They regulate the internet and monitor online activity for security purposes.
Which of the following tools provide the capability of data preparation with analytics?
Rocket
Which of the following options is correct?
McKinsey Triangle - Analyzing, Managing, and Presenting
Which of the following is NOT a real-world application of optimization in business?
Predicting stock market trends using historical data.
What kind of data does Apple collect when users send messages via iMessage?
encrypted text and anonymized metadata
Which of the following statements is correct?
Unlike physical assets, data increases in value when used multiple times.
How do data brokers collect consumer information?
By tracking social media posts, online transactions
In the McKinsey Global Institute study, what was identified as the primary economic impact of Big Data?
Transformation of economies by increasing productivity growth and consumer surplus.
Why is prescriptive analytics considered more advanced than predictive analytics?
It predicts future events with specific actions to achieve desired outcomes.
Which of the following tools is NOT used in Excel’s What-If Analysis?
Monte Carlo Simulation
Which of the following is NOT a key task in data wrangling?
Encryption
Which of the following statement is NOT correct?
Structured data is stored in databases with undefined schemas, while unstructured data follows some kind of tagging or metadata.
Why do companies like Amazon, and Capital One dominate their industries?
They use analytics across multiple business functions.
According to research, what percentage of business contacts experience some form of data change within a year?
70.8%
What is the primary reason organizations implement data localization laws?
None of the options
What was one of the major incentives for Microsoft's acquisition of LinkedIn in 2016?
To leverage LinkedIn’s user data for monetization through targeted advertising and professional insights.
Which of the following statements is NOT correct?
None of the options
What is digital mindset?
The attitudes and behaviors that enable people to see opportunities in data, AI, and algorithms.
Which of the following statements is NOT correct?
With PaaS, an organization shifts its hardware to the cloud by renting servers and data storage instead of buying and managing its own.