Microsoft Excel 2016: Core Data Analysis, Manipulation, and Presentation 77-727 Exam Dumps: Updated Questions & Answers (December 2025)

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. ClickIncrease Decimaltill the desired decimal places of three is selected, this is found on theHometab.

OR

1. Select the cells in the “Weight” column which you want to apply the number formatting to.

2. On theHometab, in theNumbergroup, click the arrow next to the list of number formats, then selectMore Number Formats.

3. Select the type of data you have in theCategorylist, in this case it would beScientific.

4. Enter the desired amount ofdecimal placesyou want to display in the Decimal places box, in this case it would be three.

References:

https://support.office.com/en-us/article/Round-a-number-to-the-decimal-places-I-want-49B936F9-6904-425D-AA98-02FFB7F9A17B

1. In cell M10 on the “Summer Bookings”, insert the followingSUMIFformula: “=SUMIF(G6:G24, “>= 12”, I6:I24).”’

References:

https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B

1. On the “Inventory” table, click on any cell.

2. Click onFormat as Tablefrom theHometab.

3. Select the Rose, Table Style Light 17 as desired.

References:

https://support.office.com/en-us/article/Format-an-Excel-table-6789619F-C889-495C-99C2-2F971C0E2370

1. Select the first row OR column on the “Summer Sales” worksheet andCopyeither from theHometabORby pressing Ctrl+C on the keyboard.

2. Select the first cell where you want topastethe data, then click on the arrow next to Paste situated on theHometab, then selectTranspose.

3. Pick a spot with enough space to paste your data, the copied data will overwrite the already existing data that is already there.

4. Once completed, you can delete the original data if desired.

References:

https://support.office.com/en-us/article/Transpose-data-from-rows-to-columns-or-vice-versa-in-Excel-for-Mac-9c16dd55-ed1a-4aa2-8b74-b1b9211e2ede

1. Select the rows you want to hide, in this case rows number 29 and 30 by clicking on them.

2. Right-click on the selected rows then click Hide.

References:

https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8

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

OR

1. SelectInsertfrom theHometab, then clickInsert Sheet.

References:

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

1. On the “Car Inventory” worksheet, clickPrint Titlesfrom thePage Setupgroup, situated on thePage Layouttab.

2. UnderPrint Titles, on theSheettab, type the reference of the row you want to reappear (row 9) in theRows to repeat at topbox.

References:

https://support.office.com/en-us/article/Print-rows-with-column-headers-on-top-of-every-page-D3550133-F6A1-4C72-AD70-5309A2E8FE8C

1. Click on cell C3.

2. Enter the following formula: “=HYPERLINK(john@bellowsollege.com, C3)

References:

https://support.office.com/en-us/article/HYPERLINK-function-333C7CE6-C5AE-4164-9C47-7DE9B76F577F

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/

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