AR
ANALYTICSRISESystem Telemetry
Rank LevelLvl 04 Jr. Architect
Data Score14,200 XP
Active Streak12 Days
Simulator Module
EXCEL FORMULA PRACTICE LAB
X
LAB OBJECTIVES
Step 1: Calculate Net Profit
Select cell B5 (Q1 Net Profit). Write a formula subtracting Operating Cost (B4) from total sales (Enterprise Sales B2 + SMB Sales B3).
Target: =B2+B3-B4Step 2: Copy Across Quarters
Apply similar formulas to cells C5, D5, and E5 using corresponding column coordinates (C, D, E).
Step 3: Sum Annual Profits
Select cell B6. Use the SUM function to calculate the aggregate sum of all calculated Net Profits across Q1-Q4 (cells B5:E5).
Target: =SUM(B5:E5)--
fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Category | Q1 Sales | Q2 Sales | Q3 Sales | Q4 Sales | |
| 2 | Enterprise Sales | 45,000 | 52,000 | 49,000 | 65,000 | |
| 3 | SMB Sales | 15,000 | 18,000 | 16,500 | 22,000 | |
| 4 | Operating Cost | 38,000 | 41,000 | 39,500 | 45,000 | |
| 5 | Net Profit | |||||
| 6 | Total Annual Profit |
Dynamic Chart Preview: Net Profit Forecast
$0Q1
Q1 Profit: $0
$0Q2
Q2 Profit: $0
$0Q3
Q3 Profit: $0
$0Q4
Q4 Profit: $0