EXCEL TASK
MS Excel Oil Company Tasks
Below are 10 tasks to practice preparing Excel reports for an oil company. Each task includes a table to be filled or calculated.
Task 1: Monthly Oil Production
Fill in the revenue column using =OilSold*PricePerBarrel.
| Month | Oil Produced (Barrels) | Oil Sold (Barrels) | Price per Barrel ($) | Revenue ($) |
|---|---|---|---|---|
| Jan | 5000 | 4800 | 60 | |
| Feb | 5200 | 5100 | 62 | |
| Mar | 4800 | 4700 | 61 |
Task 2: Worker Hours
Calculate total hours using =DaysWorked*HoursPerDay.
| Worker | Days Worked | Hours per Day | Total Hours |
|---|---|---|---|
| John | 20 | 8 | |
| Mary | 22 | 7.5 | |
| Ali | 18 | 8 |
Task 3: Production Efficiency
Calculate efficiency (%) using =OilSold/OilProduced*100.
| Month | Oil Produced | Oil Sold | Efficiency (%) |
|---|---|---|---|
| Jan | 5000 | 4800 | |
| Feb | 5200 | 5100 | |
| Mar | 4800 | 4700 |
Task 4: Total Production and Revenue
Calculate totals using =SUM(...).
| Total Production | Total Revenue |
|---|---|
Task 5: Average Price per Barrel
Use =AVERAGE(PriceColumn).
| Month | Price per Barrel ($) |
|---|---|
| Jan | 60 |
| Feb | 62 |
| Mar | 61 |
Average Price:
Task 6: Profit Analysis
Use =IF(Revenue>50000,"Profitable","Not Profitable").
| Month | Revenue | Profit Status |
|---|---|---|
| Jan | ||
| Feb | ||
| Mar |
Task 7: Conditional Formatting
Highlight efficiency < 97% using Conditional Formatting.
Apply to Task 3 Efficiency Column.
Task 8: Efficiency per Worker Hour
Calculate using =TotalProduction/TotalWorkerHours.
| Month | Total Production | Total Worker Hours | Efficiency/Hour |
|---|---|---|---|
| Jan | 5000 | ||
| Feb | 5200 | ||
| Mar | 4800 |
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home