Microsoft 77-727 Dumps Questions Answers

1. Select the data you would like to use, in this case it would be the data in the “Products” and “Total” columns from the “Summer Sales” worksheet.

2. Click onInsert Pie Chartsituation on theInserttab then pick the 3-D Pie chart as desired.

3. Format the chart as desired by usingChart Elements, theChart Styles, or theChart Filters.

4. Drag the Pie Chart to the desired location which is to the right of the column charts.

References:

https://support.office.com/en-us/article/Add-a-pie-chart-1A5F08AE-BA40-46F2-9ED0-FF84873B7863

1. In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.

2. Select cell J10, hold theShiftkey on your keyboard, and use the down arrow key until all the cells the formula is required to be applied (J40).

3. Hold down theCtrlkey on your keyboard and press D which would “copy down” the formula for the rows below.

OR

1. In cell J10 on the “Car Inventory” worksheet enter “=G10 *.95” OR “=G10 * 95%”.

2. Select cell J10, then Right-click and selectCopy,ORclickCopyfrom theClipboardgroup situated on theHometab.

3.Pastethe formula by selecting Paste from theClipboardgroup situated on theHometab,ORRight-click then selectPaste,ORclickPastefrom theClipboardgroup situated on theHometab, then clickPaste Specialand selectFormulas,ORyou could selectValuesfor the formula results instead.

4. Verify that the cell references in the formula are as desired.

References:

https://www.excelforum.com/excel-general/745891-calculate-discount-for-full-column.html

https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6

1. ClickSort Sheetsfrom theWorksheetgroup in theKutools Plustab.

2. Click theAlpha sortbuttonORtheAlpha Numeric Sortbutton in theSort Sheetsdialog box, the results can be previewed in theNew sheets tab orderlist box.

3. Use theMove uporMove downbutton to manually change the order of the sheets so that the “$5,000 Donors” worksheet is first in theNew sheet tabs orderlist.

4. ClickOKonce satisfied with the results.

References:

https://www.extendoffice.com/product/kutools-for-excel/sort-worksheets-in-one-workbook-in-alphabetical-order.html