Online Access Free 77-728 Practice Test

Exhibit:

Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.

Correct Answer:

See the explanation below.
Explanation
Select the chart and then go to chart elements - trendline - linear

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 5:
Exhibit:

In cell H7 on the "Event 1 -Stand Sales" worksheet, add a formula that uses a single logical function to display TRUE if everyone sold at least on hot dog and FALSE if even one person did not sell any hot dogs.

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.
Task3:
On the "Profits PivtChart" sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened.

Correct Answer:

See the explanation below.
Explanation
Right click on Pivottable and select Pivottable options
On the data tab click on "Refresh data when opening the file"

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