77-420 Cells Practice Questions
The free 77-420: Excel 2013 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 #4
A colleague asks you to format a range of cells as a table. What is the quickest way to achieve this?
Correct answer: C
Explanation
The Insert tab contains the option to format a range of cells as a table quickly.
Question #6
How can you apply conditional formatting to highlight cells with values above 100?
Correct answer: D
Explanation
Conditional formatting allows you to highlight cells based on specific criteria, like being above 100.
Question #10
In Excel, which function is best used to count the number of blank cells in a range?
Correct answer: B
Explanation
The COUNTBLANK function counts the number of empty cells in a specified range.
Continue with 77-420: Excel 2013
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in 77-420: Excel 2013, 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.