Academic Year – Complete Exam Questions, Verified
Answers, PivotTable Exercises, and Excel Modeling
Practice Material
Introduction
This document contains C268 exam preparation material with
verified answers covering Excel spreadsheet modeling,
PivotTables, What-If Analysis, forecasting, confidence
intervals, correlations, profitability analysis, and financial
calculations. It includes step-by-step formulas, worksheet
tasks, data analysis exercises, and expected answers for
common assessment questions.
The content focuses heavily on Excel functions, business
analytics techniques, and spreadsheet decision-making
scenarios. It also provides guidance for constructing
PivotTables and interpreting analytical results.
Key words
C268
Excel modeling
PivotTables
What-If Analysis
Forecasting
Net Profit
Profitability Analysis
, Arena Fee
Attendance Forecast
Data Tables
Business Analytics
Confidence Interval
Correlation Analysis
FORECAST function
STDEV.S
AVERAGE function
PivotTable Reports
Merchandise Sales
Food Sales
Operating Expenses
Gross Profit
COGS
Excel Formulas
Spreadsheet Analysis
Financial Modeling
Decision Support Systems
Exam Questions and Answers
Calculate the "Net Profit" portion of the "Profit Summary"
section of the model by subtracting the arena fee from the
profit before the arena fee. --- correct precise answer ---
=C35-C36
Complete the data table in the "What-if Analysis" section of
the worksheet to compare the net profit for various values of