77-727 Formula Practice Questions
The free 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation questions that deal with formula, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #4
Which formula correctly calculates the total sales from A1 to A10?
Correct answer: B
Explanation
SUM is the function used to add up all values in a given range.
Question #5
How can you quickly apply a formula to an entire column in Excel?
Correct answer: C
Explanation
Dragging the fill handle allows you to apply a formula quickly to adjacent cells.
Question #8
Which formula will count the number of non-empty cells in the range B1:B10?
Correct answer: B
Explanation
COUNTA counts the number of cells that are not empty in a range.
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 →