Microsoft 77-728 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 26

$59.00

Exam Details

Exam Name:

Excel 2016 Expert: Interpreting Data for Insights

Exam Code:

77-728

Total Questions in Exam:

Demo Questions

Q1. You are working with a large Excel workbook that includes multiple linked files and external data connections. You want to ensure that the workbook automatically updates its external links while also allowing users to manually control updates if needed. What is the best approach?

A.Enable "Update links to other documents" under Excel Options > Advanced

B. Use the Edit Links option in the Data tab and select "Automatic Update"

C. Disable "Ask to update automatic links" in Trust Center Settings

D. Set up a VBA macro to control the link updates

Answer

Answer: B

Q2. A financial analyst needs to format negative numbers in red and enclosed in parentheses while ensuring positive values display in green. Which custom number format should be used?

A.#,##0.00_);[Red](#,##0.00)

B. [Green]#,##0.00;[Red](#,##0.00)

C. #,##0.00;[Red]#,##0.00

D. [Green]#,##0.00;[Red]-#,##0.00

Answer

Answer: B

Q3. You are working with a dataset where you need to return the second-highest sales figure from a range (A2:A100). Which formula should you use?

A.'=LARGE(A2:A100,2)

B. '=RANK(A2:A100,2)

C. '=INDEX(A2:A100,2,1)

D. '=MAX(A2:A100)-1

Answer

Answer: A

Q4. A business analyst wants to create a forecasting model using historical sales data. Which of the following Excel tools should they use to predict future trends?

A.TREND and FORECAST functions

B. A standard bar chart with trendlines

C. Slicers and PivotTables

D. The CONCATENATE function

Answer

Answer: A

Answer

$59.00

Reviews

There are no reviews yet.

Be the first to review “Microsoft 77-728 Exam Dumps”

Microsoft 77-728 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 26

Exam Details

Demo Questions

Q1. You are working with a large Excel workbook that includes multiple linked files and external data connections. You want to ensure that the workbook automatically updates its external links while also allowing users to manually control updates if needed. What is the best approach?

A.Enable "Update links to other documents" under Excel Options > Advanced

B. Use the Edit Links option in the Data tab and select "Automatic Update"

C. Disable "Ask to update automatic links" in Trust Center Settings

D. Set up a VBA macro to control the link updates

Q2. A financial analyst needs to format negative numbers in red and enclosed in parentheses while ensuring positive values display in green. Which custom number format should be used?

A.#,##0.00_);[Red](#,##0.00)

B. [Green]#,##0.00;[Red](#,##0.00)

C. #,##0.00;[Red]#,##0.00

D. [Green]#,##0.00;[Red]-#,##0.00

Q3. You are working with a dataset where you need to return the second-highest sales figure from a range (A2:A100). Which formula should you use?

A.'=LARGE(A2:A100,2)

B. '=RANK(A2:A100,2)

C. '=INDEX(A2:A100,2,1)

D. '=MAX(A2:A100)-1

Q4. A business analyst wants to create a forecasting model using historical sales data. Which of the following Excel tools should they use to predict future trends?

A.TREND and FORECAST functions

B. A standard bar chart with trendlines

C. Slicers and PivotTables

D. The CONCATENATE function

Reviews

Quick Links

Contact Us