Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 1

Hands-on Course on Data Analytics and Fintech

Instructions: Choose the best answer for each question.

PART (A) – 50 MCQs

Section A — NumPy & Pandas (10 MCQs)
Q1. You load ABL and find volume is object. Which is the most robust one-liner to convert it to
numeric and keep non-parsable entries as NaN?
A) ABL['volume']=ABL['volume'].astype(float)
B) ABL['volume']=pd.to_numeric(ABL['volume'],errors='coerce')
C) [Link]=pd.to_numeric([Link])
D) [Link]=[Link]('category').astype(float)
Answer: B.
Explanation: pd.to_numeric(..., errors='coerce') converts cleanly; invalids become NaN (needed
before imputation).
Q2. To confirm the conversion worked, which command best verifies the dtype?
A) [Link]['volume']
B) type(ABL['volume'])
C) ABL['volume'].dtype
D) [Link]('volume')
Answer: C.
Explanation: Accessing the column’s .dtype is direct and unambiguous.
Q3. You must inspect all dtypes for MARI. Which is most informative for a large frame?
A) [Link]()
B) [Link]
C) [Link]()
D) type(MARI)
Answer: C.
Explanation: .info() shows column types, null counts, and memory footprint.

Q4. You need a fast daily percent change in close for ABL as percentchange. What’s best?
A) ABL['percentchange']=ABL['close'].pct_change()*100
B) ABL['percentchange']=(ABL['close']/ABL['close'].shift())*100
C) ABL['percentchange']=ABL['close'].diff()
D) ABL['percentchange']=[Link](ABL['close']).diff()
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 2

Answer: A.
Explanation: pct_change() is vectorized and returns % change; multiply by 100 for percentage.
Q5. You must compute correlation of ABL vs MCB closing prices on aligned dates only. Best
approach?
A) ABL['close'].corr(MCB['close'])
B) [Link]([ABL['close'],MCB['close']],axis=1).corr()
C) Merge on date then corr of the two close columns
D) Inner join on index after set_index('date') then corr
Answer: C.
Explanation: You must align by the same trading dates; merging on date ensures that.
Q6. After reading CSVs, you find duplicate dates in MCB. The safest dedup keeping the last
record?
A) MCB.drop_duplicates()
B) MCB.drop_duplicates('date')
C) MCB.drop_duplicates(subset=['date'],keep='last')
D) MCB=MCB[~[Link]()]
Answer: C.
Explanation: Explicit subset with keep='last' preserves the newest corrected row.
Q7. To efficiently compute rolling 5-day median on MARI['close'] ignoring NaN:
A) MARI['close'].rolling(5).median()
B) MARI['close'].rolling(window=5,min_periods=1).mean()
C) MARI['close'].expanding().median()
D) [Link](MARI['close'],5)
Answer: A.
Explanation: Rolling median uses the specified window and skips NaN by default.
Q8. For memory efficiency before joins, you downcast volume to smallest integer that fits ≥0.
A) ABL['volume']=ABL['volume'].astype('int64')
B) pd.to_numeric(ABL['volume'],downcast='integer')
C) ABL['volume']=ABL['volume'].astype('uint8')
D) ABL['volume']=pd.Int64Dtype()
Answer: B.
Explanation: downcast='integer' picks minimal int type that fits values.
Q9. You want a vectorized NumPy way to cap MCB['change'] at ±10.
A) MCB['change']=[Link](MCB['change'],-10,10)
B) MCB['change']=MCB['change'].apply(lambda x: max(-10,min(10,x)))
C) MCB['change']=[max(-10,min(10,x)) for x in MCB['change']]
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 3

D) MCB['change']=MCB['change'].where(MCB['change']<=10,10)
Answer: A.
Explanation: [Link] is vectorized and fastest.
Q10. To sort UBL by date ascending after parsing dates:
A) UBL.sort_values('date',ascending=True,inplace=True)
B) UBL['date']=UBL['date'].astype(str).sort_values()
C) UBL.sort_index()
D) UBL['date']=pd.to_datetime(UBL['date']).sort_index()
Answer: A.
Explanation: Sorting by column directly is clear; ensure date parsed beforehand.

Section B — ETL Process & Data Quality (8 MCQs)

Q11. In a clean ETL, the best order is:
A) Load → Transform → Extract
B) Extract → Load → Transform (ELT)
C) Extract → Transform → Load (ETL)
D) Transform → Extract → Load
Answer: C.
Explanation: Traditional pipelines transform before loading into the target analytics store.
Q12. For UBL missing-value strategy (mean of five preceding and five following values), best
Pandas approach?
A) fillna([Link]())
B) Rolling window centered fill using rolling(11, center=True).mean() on each numeric column
C) Forward fill then back fill
D) Interpolate(method='time')
Answer: B.
Explanation: Centered rolling mean over a window of 11 approximates “5 before & 5 after”.

Q13. You must ensure no missing values remain afterward for all columns. Which check is
concise?
A) [Link]().sum()==0
B) [Link]().[Link]()
C) [Link]().sum().sum()==0
D) [Link]()
Answer: C.
Explanation: Summing null counts across frame equals zero confirms no missing values.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 4

Q14. During extract, CSV has numeric columns with thousand separators. Most robust read?
A) pd.read_csv(path, decimal=',')
B) pd.read_csv(path, thousands=',')
C) pd.read_csv(path, dtype=float)
D) pd.read_csv(path, converters={'close':float})
Answer: B.
Explanation: thousands=',' parses strings like “1,234” as numbers.
Q15. To ensure schema consistency across ABL/MARI/MCB/UBL before concatenation:
A) Just [Link]([ABL,MARI,MCB,UBL])
B) Align columns by reindexing all frames to a standard column list
C) Use append
D) Convert all to strings
Answer: B.
Explanation: Reindexing/renaming ensures identical column order/names.
Q16. You validate “date strictly increasing” after transform. Efficient check?
A) UBL['date'].is_monotonic_increasing
B) UBL['date'].diff().sum()>0
C) UBL['date'].duplicated().any()
D) UBL['date'].is_unique
Answer: A.
Explanation: .is_monotonic_increasing directly answers the monotonicity check.
Q17. In production ETL for auditability, what’s MOST important?
A) Obfuscating logs for security
B) Random sampling of rows
C) Deterministic transforms with versioned code and data lineage
D) Non-deterministic multithreading
Answer: C.
Explanation: Audit requires reproducibility, lineage, and version control.
Q18. For idempotent loads into a warehouse (no dupes on re-runs), best pattern?
A) Truncate-and-load always
B) Insert without checks
C) Upsert (merge on business keys)
D) CSV replace in place
Answer: C.
Explanation: Upserts keep targets correct across repeated runs.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 5

Section C — Visualization with Matplotlib & Seaborn (8 MCQs)

Q19. A single line plot of MARI['close'] over time should treat date properly on x-axis. Best minimal
code pair?
A) [Link]([Link],[Link]); [Link](rotation=45)
B) [Link](x='date',y='close',data=MARI)
C) [Link](pd.to_datetime(MARI['date']),MARI['close'])
D) [Link](...)
Answer: C.
Explanation: Ensures datetime handling with Matplotlib and clean axis scaling.
Q20. To plot MCB close plus 10/20/30-day MAs clearly:
A) Use three subplots to avoid clutter
B) Overlay four lines with labels and legend
C) Combine as stacked area chart
D) Use bar chart for MAs
Answer: B.
Explanation: The assignment asks for MAs alongside actual price; legend clarifies.
Q21. To reduce over-plotting noise on long series:
A) Downsample dates (e.g., show monthly ticks)
B) Use thicker lines
C) Use pie chart
D) Use 3D line
Answer: A.
Explanation: Fewer tick labels and resampling improve readability.

Q22. You want consistent styling across all plots for the report:
A) Set [Link]('seaborn') at top
B) Manually style each plot
C) Use random colors
D) Use rcParams per-plot
Answer: A.
Explanation: A global style ensures uniform look with minimal code.
Q23. To highlight a crash region (e.g., March 2020) in the time series:
A) [Link]([Link]('2020-03-01'), [Link]('2020-03-31'), alpha=0.2)
B) [Link](...)
C) plt.fill_between(y1=close,y2=0)
D) [Link](...)
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 6

Answer: A.
Explanation: axvspan shades a vertical time interval.
Q24. You must visualize distribution of percentchange with outliers:
A) [Link](...)
B) [Link](x='percentchange',data=ABL)
C) [Link](...)
D) [Link](...)
Answer: B.
Explanation: Boxplots are ideal to show spread and outliers.
Q25. To show rolling correlation of ABL vs MCB close over 60 days:
A) [Link](...)
B) Plot of rolling(60).corr() series
C) Bar chart of monthly correlation
D) Pairplot of all columns
Answer: B.
Explanation: Rolling correlation plotted as a line reveals time-varying relationships.
Q26. You need a small-multiple grid by ticker for close trends. Quickest?
A) [Link](kind='line',col='ticker',x='date',y='close',data=long_df)
B) Loop and create subplots manually
C) [Link](...)
D) [Link](kind='line',...)
Answer: A.
Explanation: relplot(..., col=...) creates facet gridlines by category.

Section D — Descriptive & Statistical Analysis (10 MCQs)

Q27. For ABL open/close summary (count, mean, std, min, 25%, 50%, 75%, max):
A) ABL[['open','close']].describe()
B) [Link](include='all')
C) [Link](['mean','std'])
D) [Link]()
Answer: A.
Explanation: .describe() on selected numeric columns returns exactly the requested stats.
Q28. To compute range for close:
A) ABL['close'].ptp()
B) ABL['close'].max()-ABL['close'].min()
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 7

C) ABL['close'].var()
D) ABL['close'].std()
Answer: B.
Explanation: Range is max–min.
Q29. You need robust dispersion less sensitive to outliers:
A) Standard deviation
B) Variance
C) Interquartile range (IQR)
D) Range
Answer: C.
Explanation: IQR focuses on the middle 50%.
Q30. To get Q1, median, Q3 quickly:
A) [Link](series,[.25,.5,.75])
B) [Link]()
C) [Link]()
D) [Link]()['std']
Answer: A.
Explanation: [Link] returns requested quantiles.
Q31. The change column is the difference in closing prices of successive days (per brief). A sanity
check expecting its mean to be near zero works best when:
A) Prices trend upward
B) Series is stationary or detrended
C) Any time series
D) Only with monthly data
Answer: B.
Explanation: Mean of differences is meaningful under stationarity/detrending.
Q32. To summarize by month the average percentchange for ABL:
A) Group by ABL['date'].[Link] then .mean()
B) resample('M')['percentchange'].mean() on a datetime index
C) pivot_table(index='month',values='percentchange')
D) rolling(30).mean()
Answer: B.
Explanation: Resampling on a datetime index is idiomatic and concise.
Q33. Volatility proxy for MARI['close'] over 30 days is best captured by:
A) 30-day mean
B) 30-day standard deviation of returns
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 8

C) 30-day median of close

D) Count of days
Answer: B.
Explanation: Std dev of returns is a common volatility proxy.
Q34. To compare medians of percentchange across tickers without normality:
A) Paired t-test
B) ANOVA
C) Kruskal–Wallis test
D) Z-test
Answer: C.
Explanation: Nonparametric multi-group median test.
Q35. You suspect heavy tails in returns. Which diagnostic is most direct?
A) Q–Q plot vs normal
B) Bar chart of counts
C) Line plot of close
D) Pie chart of returns
Answer: A.
Explanation: Deviations from the diagonal show tail heaviness.
Q36. The best transformation to stabilize variance in prices for regression on levels:
A) Square
B) Sine
C) Log
D) Reciprocal
Answer: C.
Explanation: Logs stabilize multiplicative effects and heteroskedasticity.

Section E — Correlation, Hypothesis Testing & Predictive Thinking (7 MCQs)

Q37. After merging on date, Pearson correlation of ABL and MCB close is 0.92. Best
interpretation:
A) ABL causes MCB to rise
B) Strong linear co-movement, not causality
C) No relationship
D) Spurious unless negative
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 9

Answer: B.
Explanation: Correlation indicates association, not causation.
Q38. To test whether mean daily return of UBL differs from zero (unknown variance):
A) One-sample z-test
B) One-sample t-test
C) Paired t-test
D) Wilcoxon signed-rank requires symmetry only
Answer: B.
Explanation: Use a one-sample t-test when σ unknown.
Q39. Multiple testing across four tickers inflates false positives. A quick control is:
A) Increase α to 10%
B) Bonferroni or FDR correction
C) Use fewer data points
D) Ignore p-values
Answer: B.
Explanation: Adjust for multiplicity to control Type I error.
Q40. Serial correlation in returns invalidates i.i.d. assumptions. First diagnostic?
A) ACF/PACF plots
B) KDE of returns
C) Boxplot
D) Heatmap
Answer: A.
Explanation: Autocorrelation functions test serial dependence.
Q41. To forecast next-day MCB close with only past closes, a simple baseline is:
A) Ordinary least squares on close levels
B) Random forest on raw prices
C) Naïve forecast: tomorrow = today
D) K-means clustering
Answer: C.
Explanation: Naïve random walk is a strong baseline in finance.
Q42. If you regress ABL returns on MCB returns and find β≈0.8 (significant), interpretation?
A) 1% MCB move associates with ~0.8% ABL move
B) ABL leads MCB by one day
C) Perfect hedge
D) No effect
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 10

Answer: A.
Explanation: Slope in returns space measures sensitivity (beta-like co-movement).
Q43. For robust correlation under outliers:
A) Pearson
B) Spearman rank
C) Cosine similarity
D) Kendall’s τ is identical to Pearson
Answer: B.
Explanation: Spearman uses ranks and is less sensitive to outliers.

Section F — Python in Audit & Assurance (Controls, Evidence, Conclusions) (7 MCQs)

Q44. You design a control to ensure date is business day for PSX data. Best automated test?
A) Assert [Link]<5 after excluding exchange holidays calendar
B) Assume no weekends
C) Manually scan dates
D) Drop duplicates only
Answer: A.
Explanation: Programmatic calendar checks create repeatable evidence.
Q45. To evidence data completeness vs exchange official counts (Kaggle-style daily feed):
A) Compare row counts per day to official reference via left anti-join
B) Visual inspection
C) Assume equal
D) Drop missing days silently
Answer: A.
Explanation: Anti-joins enumerate missing days for audit evidence.
Q46. A control flags any close outside [low, high]. What is the best implementation?
A) assert (df['low']<=df['close']).all() and (df['close']<=df['high']).all()
B) Ignore; sometimes happens
C) Visual only
D) Sort values
Answer: A.
Explanation: Deterministic assertion surfaces integrity breaches.
Q47. As an auditor, you preserve an immutable copy of raw CSVs and the notebook hash. This
supports:
A) Confidentiality
B) Availability
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 11

C) Reproducibility and chain-of-custody

D) Aesthetics
Answer: C.
Explanation: Immutable artifacts allow re-performance and provenance.
Q48. You review an ETL log: 2 rows dropped due to volume < 0. Most appropriate next action?
A) Accept silently
B) Raise exception and quarantine rows to an “exceptions” table with metadata
C) Delete the log
D) Zero-fill volume
Answer: B.
Explanation: Exceptions handling preserves evidence and enables remediation.
Q49. For SOX-style control over transformations, what is MOST persuasive evidence?
A) Team email confirming steps were OK
B) Signed memo
C) Automated unit tests with CI logs tied to git commit of code used to produce tables
D) Screenshot of the plot
Answer: C.
Explanation: Executable tests and CI logs tie behavior to specific code versions.
Q50. You must conclude on reasonableness of the ABL vs MCB correlation result reported to
CRO/CFO. Best practice?
A) Report coefficient only
B) Include methodology (merge rule, date range), assumptions, robustness checks (Spearman,
rolling windows), and limitations
C) Provide raw CSVs only
D) Use bold fonts in slides
Answer: B.
Explanation: Clear, reproducible analytics with limitations enables sound assurance.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 12

PART (B) – 50 MCQs

Multiple Choice Questions (MCQs) for Data Analytics Program

Section A: Data Manipulation and ETL Process in Python (Pandas & Numpy)
1. Context: Referencing the task to load [Link] as the variable ABL. If the data file is
known to have a non-standard delimiter, which pandas function parameter is essential for
correctly loading the data? 1
A. header=None
B. sep=';'
C. index_col='date'
D. parse_dates=True
Correct Answer: B. sep=';'
Explanation: The sep (or delimiter) parameter in pd.read_csv() specifies the character used
to separate values in the file.
2. Context: Referencing the task to convert the data type of the 'volume' field in the ABL
dataset from object to float2. Which Python code snippet correctly performs this conversion,
assuming some non-numeric characters might need to be coerced?
A. ABL['volume'].astype(float)
B. ABL['volume'] = pd.to_numeric(ABL['volume'], errors='coerce')
C. ABL['volume'].apply(float)
D. ABL['volume'] = ABL['volume'].replace(',', '').astype('float')
Correct Answer: B. ABL['volume'] = pd.to_numeric(ABL['volume'], errors='coerce')
Explanation: pd.to_numeric is the most robust way to convert a series to a numeric type,
and errors='coerce' handles non-numeric values by converting them to NaN.
3. Context: In a typical financial dataset, the 'date' column 3 is initially loaded as an 'object'
type. Before performing time-series analysis on the stock data (ABL, MARI, MCB, UBL)4,
which pandas method is the most efficient and standard way to convert the 'date' column to
a proper datetime format?
A. df['date'].astype('datetime64[ns]')
B. pd.to_datetime(df['date'])
C. df['date'].apply(lambda x: [Link](x, '%Y-%m-%d'))
D. [Link](df['date'])
Correct Answer: B. pd.to_datetime(df['date'])
Explanation: pd.to_datetime() is the primary and optimized function in Pandas for
converting a column to datetime objects.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 13

4. Context: Referring to the dataset fields, specifically 'change', which is the difference
between closing prices of two successive days5. If a data scientist needs to quickly verify
this 'change' column using the 'close' price, which pandas operation is the most
appropriate?
A. df['close'].diff()
B. df['close'].shift(1)
C. df['close'].pct_change()
D. df['close'].rolling(2).sum()
Correct Answer: A. df['close'].diff()
Explanation: The .diff() method calculates the difference between the current element and
the preceding element, matching the definition of 'change'.
5. Context: A dataset containing sales transactions is loaded, and the analyst wants to find the
total sales amount. The 'Quantity' column is correctly numeric, but the 'Price' column is
loaded as an object due to a currency symbol (e.g., '$10.00' vs '10.00'). To correctly
calculate the total sales (Quantity x Price), what is the correct sequence of ETL steps?
A. Extract Price $\rightarrow$ Calculate Total Sales $\rightarrow$ Load
B. Extract Price $\rightarrow$ Remove currency symbol $\rightarrow$ Convert to numeric
$\rightarrow$ Calculate Total Sales $\rightarrow$ Load
C. Extract Price $\rightarrow$ Fill missing values $\rightarrow$ Calculate Total Sales
$\rightarrow$ Load
D. Extract Price $\rightarrow$ Convert to datetime $\rightarrow$ Calculate Total Sales
$\rightarrow$ Load
Correct Answer: B. Extract Price $\rightarrow$ Remove currency symbol $\rightarrow$
Convert to numeric $\rightarrow$ Calculate Total Sales $\rightarrow$ Load
Explanation: The currency symbol must be cleaned (removed) before the column can be
transformed (converted) to a numeric type for calculation.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 14

Section B: Missing Value Handling and Data Cleaning

6. Context: The task requires identifying and displaying the total number of missing values in
each field of the UBL dataset6. Which Python code chain will achieve this result?
A. [Link]()
B. [Link]()
C. [Link]().sum()
D. [Link]()
Correct Answer: C. [Link]().sum()
Explanation: .isnull() creates a boolean DataFrame, and .sum() counts the True values
(missing values) for each column.
7. Context: The task specifies filling missing values in UBL by replacing them with the mean of
the five preceding and five following values7. This specific method is an example of which
type of imputation?
A. Mean Imputation
B. Forward Fill (ffill)
C. Interpolation (specifically, window-based interpolation)
D. K-Nearest Neighbors (KNN) Imputation
Correct Answer: C. Interpolation (specifically, window-based interpolation)
Explanation: Averaging surrounding data points is a form of local or window-based
interpolation, which is useful for smoothing time series data like stock prices.
8. Context: In a real-world audit scenario, a dataset of employee expense claims has a few
records where the 'Approval_Date' is missing. If the claims are always approved within one
week of the 'Submission_Date', which imputation method is most justified and defensible to
an audit partner?
A. Drop the records with missing 'Approval_Date'.
B. Replace the missing values with the overall mean 'Approval_Date' from all other records.
C. Impute the 'Approval_Date' as 'Submission_Date' + 7 days (a domain-specific
calculation).
D. Use the mode of 'Approval_Date'.
Correct Answer: C. Impute the 'Approval_Date' as 'Submission_Date' + 7 days (a domain-
specific calculation).
Explanation: Using domain knowledge (business rules) to impute a value is highly
defensible in an audit as it is logically sound and minimally biases the data.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 15

9. Context: An analyst working with the MCB stock data finds a single day's 'close' price that is
ten times the preceding and following day's price—a clear data entry error (an outlier). The
best immediate ETL strategy to address this before further analysis is to:
A. Replace the value with the mean of the entire 'close' price column.
B. Replace the value with NaN and then use linear interpolation.
C. Censor the value by replacing it with the 95th percentile.
D. Winsorize the entire 'close' column.
Correct Answer: B. Replace the value with NaN and then use linear interpolation.
Explanation: Replacing the extreme outlier with NaN and interpolating effectively smooths
the value based on the trend of its neighbors, minimizing distortion while correcting the
error.

Section C: Descriptive and Statistical Analysis

10. Context: For the 'open' and 'close' fields in ABL, the requirement is to generate a statistical
summary including count, mean, standard deviation, minimum, maximum, and quartiles8.
Which single pandas function provides all of these metrics as a default output?
A. ABL[['open', 'close']].aggregate(['mean', 'std', 'min', 'max'])
B. ABL[['open', 'close']].info()
C. ABL[['open', 'close']].describe()
D. ABL[['open', 'close']].value_counts()
Correct Answer: C. ABL[['open', 'close']].describe()
Explanation: The .describe() method is the standard pandas tool that computes all the
specified descriptive statistics for numeric columns.
11. Context: An analyst computes the median closing price for the ABL stock. Why is the
median often preferred over the mean for summarizing financial time-series data like stock
prices?
A. The median is easier to calculate.
B. The median is more sensitive to day-to-day volatility.
C. The median is less affected by extreme values (outliers) or skewed distributions.
D. The median provides a better measure of the total value traded.
Correct Answer: C. The median is less affected by extreme values (outliers) or skewed
distributions.
Explanation: The median (50th percentile) provides a more robust measure of central
tendency than the mean when data contains significant outliers, common in financial
markets.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 16

12. Context: A new column, 'percentchange', is required in ABL, calculated as the daily
percentage change in closing price compared to the previous day's closing price9. Which
Python code correctly calculates this metric?
A. ABL['percentchange'] = ABL['close'].diff() / ABL['close'].shift(1)
B. ABL['percentchange'] = ABL['close'].diff()
C. ABL['percentchange'] = ABL['close'] / ABL['close'].shift(1) - 1
D. ABL['percentchange'] = ABL['close'].pct_change()
Correct Answer: D. ABL['percentchange'] = ABL['close'].pct_change()
Explanation: The .pct_change() method is the dedicated and most efficient pandas function
for calculating the percentage change over the previous period.
13. Context: The Interquartile Range (IQR) is a robust measure of statistical dispersion. If the
25th percentile (Q1) of ABL's 'open' price is 95.00 and the 75th percentile (Q3) is 108.00,
what is the most appropriate interpretation of the IQR?
A. The stock price has a minimum variability of 13.00.
B. 50% of the daily opening prices fall within a 13.00 range.
C. The average deviation of the opening price is 13.00.
D. The stock price's standard deviation is 13.00.
Correct Answer: B. 50% of the daily opening prices fall within a 13.00 range.
Explanation: The IQR ($Q3 - Q1 = 13.00$) by definition covers the middle 50% of the data
distribution.
14. Context: A Chartered Accountant (CA) is assessing the internal control over asset
valuation, using a dataset of fixed asset costs. The variance of asset costs is computed as
50,000. Why is the standard deviation a more practically useful metric for reporting to the
audit partner?
A. Standard deviation is easier to calculate.
B. Standard deviation is always a larger number than variance.
C. Standard deviation is in the same units as the mean (e.g., currency), making it directly
interpretable.
D. Standard deviation only measures relative dispersion.
Correct Answer: C. Standard deviation is in the same units as the mean (e.g., currency),
making it directly interpretable.
Explanation: Standard deviation is the square root of variance, which restores the measure
of spread to the original data units, providing better business context.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 17

Section D: Correlation and Advanced Analytical Concepts

15. Context: The task requires computing the correlation between the closing prices of ABL and
MCB10. A value of +0.85 is obtained. What does this result imply from an investment
perspective?
A. The stocks are negatively correlated, one will rise when the other falls.
B. The stocks move largely in the same direction and are poorly suited for diversification.
C. The stocks are almost independent of each other.
D. The price of ABL is always 85% of the price of MCB.
Correct Answer: B. The stocks move largely in the same direction and are poorly suited for
diversification.
Explanation: A correlation of +0.85 indicates a strong positive linear relationship, meaning
both stocks rise and fall together, reducing portfolio diversification benefits.
16. Context: A fund manager at Unparallel Investment (UI) 11 is evaluating a portfolio's risk.
They compute the correlation between ABL and MARI returns and find it to be -0.15. This
value suggests that:
A. The correlation is strong enough to rely on for diversification.
B. There is a very weak inverse linear relationship between the returns.
C. The stocks perfectly hedge each other's risk.
D. The correlation is statistically significant at the 95% confidence level.
Correct Answer: B. There is a very weak inverse linear relationship between the returns.
Explanation: A value of -0.15 is close to 0, indicating a weak linear relationship, even
though the negative sign shows a slight tendency to move inversely.
17. Context: In hypothesis testing, a CA is testing the null hypothesis ($H_0$): "The average
claim amount for the past year is equal to the budget of $100$". The p-value calculated
from the sample data is 0.005. Assuming an Alpha ($\alpha$) level of 0.05, what is the
correct conclusion?
A. Accept $H_0$; the average claim amount is equal to $100$.
B. Fail to reject $H_0$; there is not enough evidence to say the average is different from
$100$.
C. Reject $H_0$; there is statistically significant evidence that the average claim amount is
not $100$.
D. The data is insufficient for any conclusion.
Correct Answer: C. Reject $H_0$; there is statistically significant evidence that the average
claim amount is not $100$.
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 18

Explanation: Since p-value (0.005) is less than $\alpha$ (0.05), the null hypothesis is
rejected.
18. Context: Which of the following analytical tasks falls under Predictive Analytics in Gartner’s
Model?
A. Calculating the average daily trading volume for UBL stock last quarter12.
B. Identifying why MCB stock price dropped sharply on a specific date (Root Cause
Analysis).
C. Forecasting the MARI stock price for the next 30 days using a time-series model.
D. Recommending the optimal quantity of ABL stock to buy to maximize profit.
Correct Answer: C. Forecasting the MARI stock price for the next 30 days using a time-
series model.
Explanation: Predictive Analytics uses historical data to forecast what will happen in the
future.
19. Context: A model determines the optimal cash reserves a company should hold to minimize
opportunity cost while meeting all expected liabilities. This analysis belongs to which
category of Gartner's Analytics Model?
A. Descriptive Analytics
B. Diagnostic Analytics
C. Predictive Analytics
D. Prescriptive Analytics
Correct Answer: D. Prescriptive Analytics
Explanation: Prescriptive Analytics recommends the best course of action (i.e.,
optimization) to achieve a desired outcome.

Section E: Data Visualization (Matplotlib & Seaborn)

20. Context: The assignment requires drawing a line plot showing the closing price trend of
MARI over the available time period13. Which matplotlib command, assuming 'date' is on
the x-axis and 'close' on the y-axis, is the foundational method for creating this plot?
A. [Link](MARI['close'])
B. [Link](MARI['date'], MARI['close'])
C. [Link](MARI['date'], MARI['close'])
D. [Link](MARI['date'], MARI['close'])
Correct Answer: D. [Link](MARI['date'], MARI['close'])
Explanation: [Link]() is the core function in matplotlib used to generate line plots, which are
ideal for visualizing time-series trends.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 19

21. Context: For MCB, the task involves plotting the 10-day, 20-day, and 30-day moving
averages alongside the actual closing price14. Which pandas function is used to calculate
the simple moving average (SMA) for a time series?
A. MCB['close'].mean()
B. MCB['close'].diff(10)
C. MCB['close'].rolling(window=10).mean()
D. MCB['close'].shift(10)
Correct Answer: C. MCB['close'].rolling(window=10).mean()
Explanation: The .rolling(window=N).mean() method calculates the N-period simple moving
average, the standard technique for smoothing time-series data.
22. Context: A fund manager wants to compare the distribution of daily 'volume' traded across
all four companies (ABL, MARI, MCB, UBL) on a single chart to identify which stock has the
most sporadic trading activity. Which type of plot is best suited for this comparison of
distributions?
A. Scatter Plot
B. Bar Chart
C. Line Plot
D. Box Plot
Correct Answer: D. Box Plot
Explanation: Box plots are excellent for visually comparing the distribution, spread (IQR),
median, and outliers of a single numeric variable across multiple categories.
23. Context: To visualize the computed correlation between the 'close' prices of ABL and
MCB15, which plot type is the most direct and effective?
A. Histogram of ABL 'close' price
B. Bar chart of average 'close' prices
C. Scatter Plot of ABL 'close' vs. MCB 'close'
D. Heatmap of a single column's values
Correct Answer: C. Scatter Plot of ABL 'close' vs. MCB 'close'
Explanation: A scatter plot visually represents the relationship between two variables,
making it the ideal tool to assess the linearity, direction, and strength of correlation.
24. Context: In financial data visualization, Candlestick Charts are common. Candlestick charts
visually encode which four essential daily price points?
A. Open, Close, High, Volume
B. Open, Close, Low, Volume
C. High, Low, Volume, Change
D. Open, Close, High, Low
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 20

Correct Answer: D. Open, Close, High, Low 16

Explanation: Candlestick charts show the open, close (the body of the candle), and the high
and low (the wicks/shadows) for a given trading period.

Section F: Python in Audit and Assurance

25. Context: A CA is using Python to perform an internal control evaluation on a company's
purchasing process. The control states: "Any purchase order (PO) over $5,000$ must be
signed by a Director." Which Python/Pandas technique would efficiently identify potential
control exceptions (evidence collection)?
A. Calculating the mean PO amount.
B. Generating a Seaborn box plot of all PO amounts.
C. Filtering the PO dataset using a boolean condition: df[(df['Amount'] > 5000) &
(df['Director_Signature'] == 'No')].
D. Grouping the PO amounts by vendor.
Correct Answer: C. Filtering the PO dataset using a boolean condition: df[(df['Amount'] >
5000) & (df['Director_Signature'] == 'No')].
Explanation: Boolean filtering directly isolates the transactions that violate the established
control, providing concrete evidence of control failure.
26. Context: A firm is auditing inventory valuation. A material misstatement risk is that inventory
items are valued at a price significantly higher than their next closest price. Which
Numpy/Pandas technique would an auditor use to identify these "high outliers" in the
'Inventory_Unit_Cost' column for targeted testing?
A. Calculate the Z-score for each unit cost and filter for scores > 3.
B. Plot a line chart of the unit costs.
C. Calculate the total cost using a groupby.
D. Impute the mean for all unit costs.
Correct Answer: A. Calculate the Z-score for each unit cost and filter for scores > 3.
Explanation: Z-scores objectively measure the distance of an observation from the mean in
standard deviations; scores above 3 are conventionally treated as extreme outliers, suitable
for high-risk item selection.
27. Context: The primary advantage of using Jupyter Notebook (as specified in the assignment
17) in an audit context, compared to using a local Python script, is:
A. Jupyter Notebooks execute Python code faster.
B. They require less computing memory.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 21

C. The notebook provides a self-documenting, cell-by-cell audit trail of the data extraction,
transformation, analysis, and conclusion steps.
D. Jupyter Notebooks can only handle small datasets.
Correct Answer: C. The notebook provides a self-documenting, cell-by-cell audit trail of the
data extraction, transformation, analysis, and conclusion steps.
Explanation: The linear, combined code/narrative format of Jupyter is perfect for audit
documentation, ensuring reproducibility and clear review.
28. Context: An auditor uses Python to analyze a dataset of journal entries. They find a high
volume of entries posted after the fiscal year-end date. This finding primarily supports which
stage of the audit conclusion process?
A. Forming a conclusion on the client's credit risk.
B. Evidence of potential period-end cutoff misstatements.
C. Assessing the validity of the going concern assumption.
D. Verifying the physical existence of assets.
Correct Answer: B. Evidence of potential period-end cutoff misstatements.
Explanation: Transactions recorded after the year-end date often indicate a failure in the
accounting cutoff assertion.
29. Context: Which Numpy operation is most useful for an auditor who needs to create a
summary table that cross-references the counts of transactions by two categorical factors
(e.g., 'Region' and 'Transaction Type')?
A. [Link]()
B. [Link]()
C. pd.pivot_table()
D. [Link]()
Correct Answer: C. pd.pivot_table()
Explanation: The pivot_table function is the most flexible Pandas tool for summarizing
(aggregating counts, sums, means) data across two or more dimensions, forming a cross-
reference table.
30. Context: In performing a substantive test of detail on a large accounts receivable balance,
an auditor uses stratified sampling to ensure high-value accounts are selected. Which
Pandas method facilitates this selection process?
A. [Link](100)
B. [Link](frac=0.1)
C. [Link]('Value_Band').sample(n=10, replace=False)
D. [Link]()
Correct Answer: C. [Link]('Value_Band').sample(n=10, replace=False)
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 22

Explanation: Stratified sampling requires drawing samples from pre-defined groups (strata),
which is achieved efficiently in Pandas using the groupby().sample() chain.

Section G: Integrated Scenarios and Advanced Data Analysis

31. Context: ABL stock data is analyzed. A Jarque–Bera test for normality on the
'percentchange' column yields a test statistic with a p-value of 0.001. What does this result,
in conjunction with a histogram showing a long right tail, suggest to the Fund Manager?
A. The daily returns are normally distributed.
B. The returns exhibit positive skewness (heavy upward outliers/large positive changes)
and are not normal.
C. The returns follow a Poisson distribution.
D. The average return is zero.
Correct Answer: B. The returns exhibit positive skewness (heavy upward outliers/large
positive changes) and are not normal.
Explanation: A low p-value (less than 0.05) rejects the null hypothesis of normality. A long
right tail indicates positive skewness (more large positive returns than large negative
returns).
32. Context: An analyst wants to calculate the VWAP (Volume-Weighted Average Price) for
MCB to determine the true average price a share traded at. Given the 'close' price and
'volume' columns18, what is the correct calculation logic?
A. VWAP = Mean(close)
B. VWAP = Sum(close $\times$ volume) / Sum(volume)
C. VWAP = Mean(close) $\times$ Mean(volume)
D. VWAP = close / volume
Correct Answer: B. VWAP = Sum(close $\times$ volume) / Sum(volume)
Explanation: VWAP is a weighted average where price is weighted by volume. The total
dollar value traded (price $\times$ volume) is divided by the total volume traded.
33. Context: Using the 'change' field in the dataset19, a NumPy array is created. A Fund
Manager wants to calculate the Cumulative Return over the entire period (i.e., the total
effect of all daily changes). Which NumPy function is best suited for computing this running
total?
A. [Link]()
B. [Link]()
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 23

C. [Link]()
D. [Link]()
Correct Answer: C. [Link]()
Explanation: [Link]() computes the running sum of an array, which translates directly
to the cumulative change over time.
34. Context: A data scientist is analyzing the impact of interest rate announcements on all four
stocks. They need to merge the stock datasets (ABL, MARI, MCB, UBL) 20 with an external
'[Link]' file containing a 'Date' column and an 'Announcement_Impact'
column. Which type of pandas merge/join operation is typically used to combine two
datasets based on a common 'Date' column?
A. [Link]()
B. [Link](..., on='date', how='inner')
C. [Link]()
D. [Link]()
Correct Answer: B. [Link](..., on='date', how='inner')
Explanation: [Link]() is the function used to combine DataFrames based on common
key columns, in this case, the 'date'.
35. Context: Which of the following Pandas operations would be the most computationally
expensive on a massive 10-year daily stock price dataset?
A. Calculating the mean 'close' price.
B. Filtering the data for prices greater than 100.
C. Calculating a 200-day Exponential Moving Average (EMA) using the ewm() method.
D. Displaying the first 5 rows (.head()).
Correct Answer: C. Calculating a 200-day Exponential Moving Average (EMA) using the
ewm() method.
Explanation: EMA is computationally intensive because it's a recursive calculation where
each day's value depends on the previous day's EMA, requiring processing of all prior data
points.

Section H: NumPy Fundamentals and Operations

36. Which NumPy function is used to convert a Pandas Series (like ABL['close']) into a NumPy
array for high-performance numerical operations?
A. ABL['close'].tolist()
B. ABL['close'].to_numpy()
C. ABL['close'].to_csv()
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 24

D. [Link](ABL['close'])
Correct Answer: B. ABL['close'].to_numpy()
Explanation: .to_numpy() is the modern and preferred method in Pandas to efficiently
extract the underlying data as a NumPy array.

37. A Fund Manager needs to simulate a Monte Carlo analysis for UBL stock returns. Which
fundamental NumPy module is required to generate a large number of random samples
from a specified probability distribution?
A. [Link]
B. [Link]
C. [Link]
D. [Link]
Correct Answer: B. [Link]
Explanation: The [Link] module provides the core functions for generating random
numbers and samples from various statistical distributions, essential for simulations.
38. If arr = [Link]([1, 2, 3, 4, 5]) is the 'close' price of MCB for 5 days, and the analyst runs
arr[arr > 3], what NumPy concept is being demonstrated?
A. Array concatenation
B. Boolean Indexing
C. Slicing
D. Vector product
Correct Answer: B. Boolean Indexing
Explanation: Boolean Indexing uses a True/False array (generated by the condition $arr >
3$) to select elements from the original array where the condition is True.

Section I: Data Visualization (Advanced)

39. To compare the relative volatility of ABL versus MCB using their respective daily
'percentchange' distributions, which Seaborn plot is the most effective for a direct visual
comparison of the underlying densities?
A. [Link]()
B. [Link]()
C. [Link]()
D. [Link]() with hue or two separate plots on the same axis
Correct Answer: D. [Link]() with hue or two separate plots on the same axis
 Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 25

Explanation: A Kernel Density Estimate (KDE) plot visualizes the probability density
function, making it ideal for comparing the spread and shape of two distributions (volatility).

40. An analyst creates a Heatmap of the correlation matrix for all four stocks (ABL, MARI, MCB,
UBL). If the color scale ranges from dark blue (-1) to dark red (+1), what does a white or
light gray square in the center of the heatmap signify?
A. Perfect positive correlation (+1).
B. Perfect negative correlation (-1).
C. Zero or very low linear correlation (~ 0).
D. Missing data (NaN).
Correct Answer: C. Zero or very low linear correlation (~ 0).
Explanation: In a diverging color scale used for correlation, the neutral or lightest color
typically represents the midpoint, which is a correlation value of 0.
41. A Pair Plot (or Scatterplot Matrix) is generated for the 'open', 'high', 'low', and 'close' prices
of the UBL stock21. What does the Pair Plot display on its diagonal cells by default?
A. A single scatter plot of 'high' vs. 'low'.
B. The correlation coefficient for the two adjacent variables.
C. Univariate distributions (usually Histograms or KDEs) for each variable.
D. A time-series line plot.
Correct Answer: C. Univariate distributions (usually Histograms or KDEs) for each variable.
Explanation: The diagonal of a Pair Plot shows the relationship of a variable with itself,
which is best represented by its distribution (histogram or KDE).

Section J: Audit and Assurance Case Studies

42. An auditor uses Python to analyze a General Ledger (GL) transaction dataset. They identify
all entries where the debit and credit sides do not balance to zero. This test primarily targets
which financial statement assertion for the GL?
A. Valuation and Allocation
B. Completeness
C. Accuracy and Classification
D. Rights and Obligations
Correct Answer: C. Accuracy and Classification
Explanation: An imbalance between debit and credit is a fundamental violation of double-
entry bookkeeping, directly impairing the accuracy of the recorded transaction.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 26

43. An auditor wants to identify all vendors in the 'Vendor_Payments' dataset who have an
'Invoice_Date' before the 'Service_Rendered_Date', which is an impossible sequence
indicating a data integrity issue. Which Pandas technique is the most efficient way to
generate the list of unique vendors involved in these exceptions?
A. df[df['Invoice_Date'] < df['Service_Rendered_Date']]['Vendor_ID'].value_counts()
B. df.pivot_table(index='Vendor_ID', values='Amount', aggfunc='mean')
C. [Link](other_df, on='Vendor_ID')
D. [Link]()
Correct Answer: A. df[df['Invoice_Date'] <
df['Service_Rendered_Date']]['Vendor_ID'].value_counts()
Explanation: This uses boolean indexing to filter for the impossible exceptions and then
counts the frequency of the 'Vendor_ID' in the resulting subset.
44. A CA uses Python to perform Benford's Law analysis on inventory quantities. Benford's Law
tests the expected frequency distribution of the first digit in naturally occurring numbers. If a
significant deviation is detected (a high $\chi^2$ test statistic), this is strong evidence of:
A. The data being normally distributed.
B. The inventory quantities being very high.
C. Potential manipulation or fabrication of the numbers.
D. The numbers following a Uniform distribution.
Correct Answer: C. Potential manipulation or fabrication of the numbers.
Explanation: Benford's Law is a primary forensic tool; significant deviation suggests the
numbers were not naturally generated (e.g., they were manually entered or altered).
45. In a real-world scenario, an auditor is tasked with assessing the Going Concern
assumption. Which analytical task, using Python, would provide the strongest quantitative
evidence for this assessment?
A. Calculating the average office supply expense.
B. Performing time-series forecasting on the company's working capital for the next 12
months.
C. Plotting a histogram of the sales staff's commission rates.
D. Computing the correlation between sales and marketing spend.
Correct Answer: B. Performing time-series forecasting on the company's working capital for
the next 12 months.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 27

Explanation: Forecasting financial viability (cash flow or working capital) is central to the
Going Concern assessment.

46. Which of the following is an example of an audit use case for Predictive Analytics?
A. Using an SQL query to list all outstanding invoices over 90 days.
B. Identifying the GL account with the highest mean balance last year.
C. Training a machine learning model to predict the likelihood of a customer default (bad
debt) to inform the allowance for doubtful accounts.
D. Plotting a bar chart of the top 10 vendors by payment volume.
Correct Answer: C. Training a machine learning model to predict the likelihood of a
customer default (bad debt) to inform the allowance for doubtful accounts.
Explanation: Predicting future outcomes (like default probability) is the core function of
Predictive Analytics.
47. A large Pandas DataFrame of UBL stock data is created. To conserve memory and speed
up subsequent analysis, a Fund Manager decides to drop all columns except 'date' and
'close'. Which of the following Pandas methods is the correct and most efficient way to
achieve this?
A. [Link](columns=['open', 'high', 'low', 'volume', 'change'], inplace=True)
B. UBL[['date', 'close']]
C. [Link]()
D. [Link]()
Correct Answer: A. [Link](columns=['open', 'high', 'low', 'volume', 'change'],
inplace=True)
Explanation: Using .drop() with inplace=True modifies the existing DataFrame in memory by
removing specified columns, which is an efficient cleaning technique.
48. A Seaborn Violin Plot is created for the daily ABL returns. How does it enhance the
visualization of the data distribution compared to a simple Box Plot?
A. It only shows the median and quartiles.
B. It displays a regression line for the data.
C. It shows the full kernel density estimate (KDE) of the distribution, not just the summary
statistics.
D. It plots all the individual data points as a swarmplot.
Correct Answer: C. It shows the full kernel density estimate (KDE) of the distribution, not
just the summary statistics.
Instructor: Syed Ali Ameer 100 Practice MCQs – Python Programming 28

Explanation: The Violin Plot's shape represents the KDE, revealing the density, modality,
and shape of the data distribution, unlike the box plot which is limited to quartiles.

49. Context: The MCB moving average task is part of technical analysis22. The primary reason
for plotting both the 10-day (short-term) and 30-day (long-term) moving averages is to:
A. Calculate the stock's RSI.
B. Identify the "golden cross" or "death cross" signals by observing when the short-term
average crosses the long-term average.
C. Determine the P/E ratio.
D. Forecast the daily closing price with high accuracy.
Correct Answer: B. Identify the "golden cross" or "death cross" signals by observing when
the short-term average crosses the long-term average.
Explanation: The crossing of different period SMAs (e.g., a short-term moving average
crossing above a long-term one) is a key trend change signal in technical analysis.
50. NumPy's broadcasting feature is a key reason for Python's speed in data analytics. If a
Fund Manager calculates the Excess Return for all stocks by subtracting a Risk-Free Rate
(e.g., 0.0001) from every element of the 'percentchange' column, this is an example of:
A. Matrix multiplication
B. Broadcasting
C. Array stacking
D. NumPy Looping
Correct Answer: B. Broadcasting
Explanation: Broadcasting is the NumPy mechanism that allows arithmetic operations
between arrays of different shapes (like a 1D array of returns and a single scalar
value/float) by implicitly extending the scalar to match the array's shape.