77-727 Practice Exam Questions with Answers Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification

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. 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. Select the worksheet you want to apply the margin changes to.

2. Select Margins in thePage Setupgroup from thePage Layouttab.

3. ClickCustom Margins, then in theTopandBottomdialog box enter 1.0’’ (2,54cm), in theLeftandRightdialog box enter 0.75’’(1.90cm), and enter 0.5’’(1.27cm) in theHeaderandFooterdialog box.

References:

https://support.office.com/en-us/article/Set-page-margins-before-printing-a-worksheet-353F52FC-0D2C-4958-9166-99FBD22B963A

1. In cell C8 on the “Summer Bookings” worksheet, insert the followingCONCATfunction: “=CONCAT(E6 “, “D6)”OR“=E6& “, “, D6”.

References:

https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6

1. On the “Adult Program” worksheet, select the area you want the sparkline to be inserted.

2. Click Column in theSparklinesgroup from theInserttab.

3. Enter the range of cells in theData Rangebox, in this caseA10:A19.

OR

3. Select the range of cells by temporarily collapsing the dialog box and manually selecting the cells.

4. ClickOKand theSparkline Toolswill appear, theDesigntab can be used to customize the sparklines.

References:

https://support.office.com/en-us/article/analyze-trends-in-data-using-sparklines-be6579cf-a8e3-471a-a459-873614413ce1