VIP Exclusive
CES Certified Excel Specialist VIP Practice Exam
CES — The Certified Excel Specialist (CES) credential is offered by various training organizations (including Certiport/Microsoft Office Specialist pathways and independent providers); the most widely recognized analogue is the Microsoft Office Specialist (MOS): Excel Expert exam, which is task-based, scored 1–1000 (passing ≈ 700), and covers advanced formulas, data analysis, PivotTables, macros, and data visualization — this practice set mirrors that expert-level content domain coverage in multiple-choice format.
57
Questions
60m
Time Limit
75.00%
To Pass
Question 1 of 57👑 VIP
A financial analyst has a dataset in columns A through E with 10,000 rows. She needs to return the unit price from column D for any product whose SKU (column B) matches a value she types into cell H2, but the SKU column is not the leftmost column in her range. Which function is MOST appropriate for this task without restructuring the data?
Questions 2–57 and full explanations are VIP-exclusive.