Microsoft 77-427 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 12

$59.00

Exam Details

Exam Name:

Excel 2013 Expert Part One

Exam Code:

77-427

Total Questions in Exam:

Demo Questions

Q1. A finance team is collaborating on a shared workbook that contains sensitive data. They need to allow multiple users to edit the workbook while preventing unauthorized modifications. Which of the following features should be used?

A.Enable Track Changes and Protect Workbook with a password

B. Use the Share Workbook feature and enable Read-Only mode

C. Enable Workbook Protection and apply worksheet-level permissions

D. Use Co-Authoring in Excel Online and disable automatic changes

Answer

Answer: C

Q2. You want to create a custom number format that displays negative numbers in red with parentheses, while positive numbers appear in green. Which format string should you use?

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

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

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

D. #,##0.00;[Red](#,##0.00);0

Answer

Answer: A

Q3. You are working with a dataset and need to retrieve the third highest value from a range (B2:B100). Which formula should you use?

A.'=MAX(B2:B100)-2

B. '=LARGE(B2:B100,3)

C. '=RANK(B2:B100,3,0)

D. '=INDEX(B2:B100,3,1)

Answer

Answer: B

Answer

$59.00

Reviews

There are no reviews yet.

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

Microsoft 77-427 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 12

Exam Details

Demo Questions

Q1. A finance team is collaborating on a shared workbook that contains sensitive data. They need to allow multiple users to edit the workbook while preventing unauthorized modifications. Which of the following features should be used?

A.Enable Track Changes and Protect Workbook with a password

B. Use the Share Workbook feature and enable Read-Only mode

C. Enable Workbook Protection and apply worksheet-level permissions

D. Use Co-Authoring in Excel Online and disable automatic changes

Q2. You want to create a custom number format that displays negative numbers in red with parentheses, while positive numbers appear in green. Which format string should you use?

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

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

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

D. #,##0.00;[Red](#,##0.00);0

Q3. You are working with a dataset and need to retrieve the third highest value from a range (B2:B100). Which formula should you use?

A.'=MAX(B2:B100)-2

B. '=LARGE(B2:B100,3)

C. '=RANK(B2:B100,3,0)

D. '=INDEX(B2:B100,3,1)

Reviews

Quick Links

Contact Us