Getting 77-727 Certification Made Easy!

1. Select the cells in the “CustomerID” column which you want to have checked for duplicates.

2. SelectRemove Duplicatesfrom theDatatab.

3. Select the “CustomerID” column which you want to have checked under theColumnsoptions.

4. ClickOK.

References:

https://support.office.com/en-us/article/Find-and-remove-duplicates-00E35BEA-B46A-4D5D-B28E-66A552DC138D

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

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

References:

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

1. ClickDesignfrom the Ribbon onTable Tools.

2. In theToolsgroup, click onConvert to Range.

OR

1. Right-click thetablethen click on Table then pressConvert to Range.

References:

https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77?redirectSourcePath=%252fen-us%252farticle%252fRemove-a-table-without-losing-the-data-or-table-format-ADF88635-90F5-4FAA-9417-19862F38CCE8 &ui=en-US&rs=en-US&ad=US

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. Click on the title on the “Spring Sales” worksheet, then type “New Products”.

2. You can edit theFontof the title from the mini-toolbar that appearsORfrom theHometab.

3. Click directly on either the x-axisory-axis in the chart OR click theChart Elementsbutton.

4. For editing the x-axis which is the horizontal category then type “Months”.

5. Do the same to edit the y-axis which is the vertical category and type “Gross Sales”.

6. You can further edit the text of the data in either of the axis as desired.

References:

https://www.dummies.com/software/microsoft-office/excel/how-to-edit-chart-titles-in-excel-2016/