Microsoft 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Exam Practice Test

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:

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:

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:

1. On the “Youth Program” worksheet, selectFormat as Tablefrom theHometab.

2. Choose the desired style for the table.

3. Select the desired cell range of A9:G19 in theFormat as Tabledialog box.

4. Mark row 9 as a header.

5. ClickOK.

References:

1. On the “Summer Bookings” worksheet, clickHeader & Footerfrom theTextgroup situation on theInserttab.

2. ClickClick to add footerwhich would display theHeader & Footertools which gets added to theDesigntab.

3. Specify where the page number should be by selecting theCenter sectionbox.

4. On theDesigntab in theHeader & Footer Elementsgroup, clickPage Number.

5. The placeholder&[Page]will appear in the selected section, to add the total numberofpages type the word of followed by the space in theHeader & Footer Elementsgroup after clickingNumber of Pages, then the placeholder&[Page] of &[Pages]appear.

6. Click anywhere outside the header or footer area to display the page numbers inPage Layout View.

7. Once you are done working in thePage Layout View, clickNormalin theWorkbook Viewsgroup situated on theViewtab. OR You can also clickNormalon the status bar.

References: