77-727 Cells Practice Questions
The free 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation 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
What function would you use to find the maximum value in a range of cells?
Correct answer: A
Explanation
The MAX function returns the largest value in a set of values.
Question #7
To ensure your cells do not overflow into adjacent empty cells, which formatting option would you use?
Correct answer: B
Explanation
Wrap Text formats cells so that text will break into multiple lines within the same cell.
Continue with 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation, 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 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation practice questions →