MO-201 Cells Practice Questions
The free MO-201: Microsoft Excel Expert (Excel and Excel 2019) questions that deal with cells, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #1
When using the VLOOKUP function, which argument determines the range of cells to search?
Correct answer: B
Explanation
The Table_Array argument specifies the range of cells that contains the data.
Question #8
Which Excel function is used to calculate the average of a range of cells?
Correct answer: A
Explanation
The AVERAGE function calculates the mean of a specified range of numbers.
Question #10
How can you quickly apply the same formatting to multiple cells?
Correct answer: B
Explanation
The Format Painter is used to quickly copy formatting from one cell to another.
Continue with MO-201: Microsoft Excel Expert (Excel and Excel 2019)
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in MO-201: Microsoft Excel Expert (Excel and Excel 2019), the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All MO-201: Microsoft Excel Expert (Excel and Excel 2019) practice questions →