Microsoft 77-727 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 35

$59.00

Exam Details

Exam Name:

Excel 2016: Core Data Analysis, Manipulation, and Presentation

Exam Code:

77-727

Total Questions in Exam:

Demo Questions

Q1. You are working with a dataset in Excel and need to extract only the first three characters from a column containing product codes (e.g., "XYZ-123"). Which formula should you use to achieve this?

A.'=RIGHT(A2,3)

B. '=MID(A2,1,3)

C. '=LEFT(A2,3)

D. '=TEXT(A2, "000")

Answer

Answer: C

Q2. You want to highlight all cells in column B that contain a value greater than the average of all values in column B. Which method should you use?

A.Apply a filter in column B and sort by highest value

B. Use the SUMIF function to check the values manually.

C. Apply conditional formatting with the formula =B2>AVERAGE(B:B).

D. Use the IF function in a new column to check each value

Answer

Answer: C

Q3. You have created a clustered column chart displaying quarterly sales data. You want to add a secondary axis to show profit margins as a line graph on the same chart. What is the correct way to do this?

A.Select the chart, go to Chart Tools > Format > Change Chart Type, and select "Line" for one of the data series.

B. Right-click the profit margin data series, select Format Data Series, and choose Secondary Axis.

C. Copy the profit margin data, paste it into a new column, and create a separate chart.

D. Select the chart, go to Insert > Combo Chart, and manually add a second chart.

Answer

Answer: B

Q4. You need to count the number of orders in a dataset where the total sales are greater than $500 and the customer is from "New York". Which function combination should you use?

A.'=COUNTIF(A:A, ">500")

B. '=COUNTIFS(A:A, ">500", B:B, "New York")

C. '=IF(A2>500, COUNT(B:B, "New York"))

D. '=SUMPRODUCT((A:A>500)*(B:B="New York"))

Answer

Answer: B)

Answer

$59.00

Reviews

There are no reviews yet.

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

Microsoft 77-727 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 35

Exam Details

Demo Questions

Q1. You are working with a dataset in Excel and need to extract only the first three characters from a column containing product codes (e.g., "XYZ-123"). Which formula should you use to achieve this?

A.'=RIGHT(A2,3)

B. '=MID(A2,1,3)

C. '=LEFT(A2,3)

D. '=TEXT(A2, "000")

Q2. You want to highlight all cells in column B that contain a value greater than the average of all values in column B. Which method should you use?

A.Apply a filter in column B and sort by highest value

B. Use the SUMIF function to check the values manually.

C. Apply conditional formatting with the formula =B2>AVERAGE(B:B).

D. Use the IF function in a new column to check each value

Q3. You have created a clustered column chart displaying quarterly sales data. You want to add a secondary axis to show profit margins as a line graph on the same chart. What is the correct way to do this?

A.Select the chart, go to Chart Tools > Format > Change Chart Type, and select "Line" for one of the data series.

B. Right-click the profit margin data series, select Format Data Series, and choose Secondary Axis.

C. Copy the profit margin data, paste it into a new column, and create a separate chart.

D. Select the chart, go to Insert > Combo Chart, and manually add a second chart.

Q4. You need to count the number of orders in a dataset where the total sales are greater than $500 and the customer is from "New York". Which function combination should you use?

A.'=COUNTIF(A:A, ">500")

B. '=COUNTIFS(A:A, ">500", B:B, "New York")

C. '=IF(A2>500, COUNT(B:B, "New York"))

D. '=SUMPRODUCT((A:A>500)*(B:B="New York"))

Reviews

Quick Links

Contact Us