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.