Find the lowest January cost
What is the smallest value in the January column B2:B6?
Formula: =MIN(B2:B6) → 89
Hands-on Excel exercises
Practice for the MO-200 Excel Exam
Independent practice for skills covered by the MO-200 exam: formulas and functions. Not affiliated with Microsoft; desktop-only commands not simulated.
FormulaCamp is not affiliated with Microsoft. This is independent practice for skills covered by the MO-200 exam. It is not official training, not an official practice test, and not a promise of passing. It does not simulate the desktop application or cover macros.
MO-200 is a Microsoft certification exam for Excel. Its skill areas cover managing workbooks, working with data in cells and ranges, tables, formulas and functions, and charts. The exam is performed inside the desktop application, and Microsoft changes its objectives over time, so check the current skills outline on Microsoft's exam page before you plan your study. This page is independent practice and is not affiliated with Microsoft.
FormulaCamp practices the part that happens in the grid: references, calculation functions, simple logic, text functions, and charts. It does not simulate the desktop application. It does not cover commands such as page setup, workbook settings, protection, or printing, it has no macros, and it does not recreate the exam interface or scoring. If those areas are in the outline, practice them in Excel itself.
The live sheet is a two-month expense budget. Your task is to average January expenses and round the result, a typical calculation objective. The worked answers then find the lowest January cost, build a three-letter label from text, and compare two months with a simple IF. Nothing here promises an outcome; use the exercises to find weak areas, then verify each one against the current outline.
Your turn
Your turn: in F2, calculate the average January expense, rounded to a whole number.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Category | January | February | |||
| 2 | Rent | 1200 | 1200 | |||
| 3 | Travel | 340 | 415 | |||
| 4 | Software | 89 | 89 | |||
| 5 | Meals | 210 | 180 | |||
| 6 | Training | 150 | 320 |
Not yet solved.
Answer: =ROUND(AVERAGE(B2:B6),0)
Practice under a time limit
Try the free Sample mock exam with 4 tasks in 8 minutes, or browse the level and interview mock exams included with Pro + Exams.
Related exercises
Open a task in its lesson.
- In B4, enter the population of Phoenix: 1600000.
- In D2, calculate the total for bread: price × quantity.
- In D7, calculate the total amount of the purchase.
- In F2:F4, calculate each manager's revenue.
- In F2, calculate the total of Emma's deals in Boston.
- In F2:F4, look up the item name for each code in column E.
- Build a line chart of revenue and expenses together (A1:C7).
Worked answers
Try the spreadsheet first, then compare your formula and result.
Build a text label
Take the first three letters of the category in A3 and show them in capitals.
Formula: =UPPER(LEFT(A3,3)) → TRA
Compare two months
Return Same if the January and February rent match, otherwise Changed.
Formula: =IF(B2=C2,"Same","Changed") → Same
Frequently asked questions
Is this a Microsoft practice test for MO-200?
No. FormulaCamp is not affiliated with Microsoft, and this is independent practice for skills the exam covers.
Which exam objectives are not practiced here?
Anything that depends on the desktop application: workbook settings, page layout, protection, printing, macros, and the exam interface itself.
Where do I find the current objectives?
On Microsoft's exam page for MO-200. Objectives change, so use the current outline as your checklist.
Does practicing here predict my result?
No. Use it to find weak areas in calculations and functions, then confirm everything else against the outline.