Free Microsoft 77-728 Exam Dumps Questions & Answers

Exhibit:

You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 4:
Exhibit:

Add cells C53 E56 on the "Workforce Statistics" worksheet to the Watch Window.

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task3:
Create new customized colors with the Accent 1 option to RGB "255", "153", "51".
Name the customized colors "Orange Table".

Correct Answer:

See the explanation below.
Explanation
* Go to Page layout - colors - customize colors

* In Accent 1 go to more colors and enter the required RGB valuesand give it the nameorange Table

Exhibit:

You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 1:

Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.

Correct Answer:

See the explanation below.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.

Exhibit:

Task 1:
On the "Batches in progress" worksheet format columns C and D to display numeric values to three decimal places.
The format should be applied to existing and new row.

Correct Answer:

See the explanation below.
Explanation
Select the entire column C and D and from Home tab click on increase decimals which will turn the decimal to three points