Microsoft 77-727 Online Practice Questions and Exam Preparation

Microsoft 77-727 Online Questions & Answers

• Question 31:

  SIMULATION

  Project 7 of 7: Farmers Market Overview

  You are the Director of a local farmers’ market. You are creating and modifying charts for a report which shows the amounts and variety of products sold during the season.

  

  

  On the “Summer Sales” worksheet, add the “Total” data series to the “Top Sellers” column chart. Include the total only for “Fruits”, “Vegetables”, and “Jams and Honey”.

  A. See explanation below.
  A. See explanation below.

  ---

  1.

  Select the “Top Sellers” column chart.

  2.

  Click on the particular data point you want to label, click Add Chart Element +, from the upper right corner next to the chart, then select Data Labels.

  3.

  Then click Format Data Labels.

  4.

  The Data Label Range dialog box would appear, select the data range which are the cell values you want to appear in the labels, in this case it would be the “Total” colunn for “Fruits”, “Vegetables”, and “Jams and Honey”, then click OK.

  References: https://support.office.com/en-us/article/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d

• Question 32:

  SIMULATION

  Project 2 of 7: Donor List

  Overview

  You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.

  

  Navigate to the range named “Oregon”, and remove the contents of the selected cells.

  A. See explanation below.
  A. See explanation below.

  ---

  1. Click Find and Select from the Home tab then click on Go To. OR

  1.

  Press Ctrl+G on the keyboard.

  2.

  Double-click the name range you want, in this case “Oregon”.

  3.

  Delete the contents in the selected cells by pressing Delete on your keyboard.

  References: https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

• Question 33:

  SIMULATION

  Project 5 of 7: City Sports Overview

  The city events manager wants to analyze the enrollment changes over the past five years for various adult and youth sports programs. You have been tasked to prepare tables for the analysis.

  

  

  Add the Alternative Text Title “Adult Enrollment” to the “Adult_Program” table.

  A. See explanation below.
  A. See explanation below.

  ---

  1.

  Right-click the text title “Adult_Program” and click Format Object then click Alt Text.

  2.

  Type “Adult Enrollment” in the Title box as desired.

  3.

  Click OK.

  References: https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

• Question 34:

  SIMULATION

  Project 1 of 7: Tailspin Toys

  Overview

  You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  

  On the “Customers” worksheet, enter a formula in cell N2 that uses an Excel function to return the average age of the customers based on the values in the “CurrentAge” column.

  A. See explanation below.
  A. See explanation below.

  ---

  1.

  Select cell N2 on the “Customers” worksheet, which is where you want the Excel function to return the result to.

  2.

  In the Address bar, type the average function syntax; =AVERAGE(K1:K101).

  References: https://support.office.com/en-us/article/AVERAGE-function-047BAC88-D466-426C-A32B-8F33EB960CF6

• Question 35:

  SIMULATION

  Project 2 of 7: Donor List Overview

  You are an executive assistant for a non-profit organization named Bellows College. You are updating a workbook containing lists of donors.

  

  Add a new worksheet named “$1,000 Donors” to the workbook.

  A. See explanation below.
  A. See explanation below.

  ---

  1. Select the plus icon at the bottom of the screen. OR

  1. Select Insert from the Home tab, then click Insert Sheet.

  References: https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2