The purpose of this Sample Question Set is to provide you with information about the Microsoft Excel Expert - Office 2016 exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the 77-728 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Excel Expert (Office 2016) Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Office Specialist - Excel Expert (Office 2016) certification exam.
These sample questions are simple and basic questions that represent likeness to the real Microsoft 77-728 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Excel Expert (Office 2016) Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
Microsoft 77-728 Sample Questions:
01. Which Excel functions are best for statistical operations on data meeting specific criteria?
(Choose Three)
a) COUNT()
b) SUMIF()
c) COUNTIFS()
d) AVERAGEIFS()
e) SUM()
02. Custom themes can be saved and reused across multiple workbooks by saving them in the ____ folder.
a) Default
b) Themes
c) Office
d) Excel
03. Which of the following are valid ways to troubleshoot formulas in Excel?
(Choose Two)
a) Use the Error Checking feature
b) Preview formula results with Quick Analysis
c) Monitor cells with the Watch Window
d) Validate data with Data Validation
04. For complex data analysis, which Excel feature allows you to explore different outcomes based on various data scenarios?
a) Data Validation
b) Conditional Formatting
c) What-if Analysis
d) Data Mining
05. Which functions are essential for time-sensitive financial calculations?
(Choose Three)
a) FV()
b) NOW()
c) PMT()
d) RATE()
e) TODAY()
06. How do you create dynamic ranges in Excel that can expand with added data?
a) Name Manager with OFFSET formula
b) Data Validation with dynamic arrays
c) Conditional Formatting
d) Simple cell naming
07. Which tools are essential for troubleshooting complex formulas in Excel?
(Choose Two)
a) Error Checking
b) Conditional Formatting
c) Watch Window
d) Evaluate Formula
08. In Excel, how would you make sure that your formulas reference the correct range dynamically as data changes?
a) Use absolute cell references
b) Use mixed cell references
c) Define named ranges that can expand or contract
d) Lock cells with formulas
09. You can create a PivotChart from a PivotTable by choosing 'PivotChart' from the ____ menu.
a) Insert
b) Format
c) Tools
d) Analyze
10. Select the functions that can dynamically update the current date and time in a worksheet.
(Choose Three)
a) TODAY()
b) NOW()
c) DATE()
d) TIME()
e) TIMESTAMP()
Answers:
Question: 01
Answer: b, c, d |
Question: 02
Answer: b |
Question: 03
Answer: a, c |
Question: 04
Answer: c |
Question: 05
Answer: a, c, d |
Question: 06
Answer: a |
Question: 07
Answer: a, d |
Question: 08
Answer: c |
Question: 09
Answer: d |
Question: 10
Answer: a, b, d |
Note: For any error in Microsoft Office Specialist - Excel Expert (Office 2016) (77-728) certification exam sample questions, please update us by writing an email on feedback@edusum.com.
