VIP Exclusive
Microsoft Excel Advanced Practice Test VIP Exam
Excel Practice Test — This exam mirrors the Microsoft Office Specialist (MOS): Excel Associate and Expert certifications (Exam MO-200 and MO-201), issued by Microsoft and administered by Certiport. The real exams are performance-based, task-driven assessments; this written practice set covers the same knowledge domains at equivalent difficulty.
30
Questions
60m
Time Limit
70.00%
To Pass
Question 1 of 30👑 VIP
You have a sales table in columns A–D (columns: Region, Product, Quarter, Revenue). You need a single formula in cell F2 that returns the Revenue for any row where Region is 'West' AND Product is 'Widget A'. Which formula correctly handles this using a modern Excel function available in Microsoft 365?
Questions 2–30 and full explanations are VIP-exclusive.