77-727 Online Practice Questions and Answers

Correct Answer: See explanation below.

Explanation:

1. Click Find and Select from the Home tab then click on Go To. OR

1.

Press Ctrl+G on the keyboard.

2.

Double-click the name range you want, in this case “Oregon”.

3.

Delete the contents in the selected cells by pressing Delete on your keyboard. References:

https://support.office.com/en-us/article/Find-named-ranges-14513DF5-0D79-4CD5-9A03-968905B244E6

Correct Answer: See explanation below.

Explanation:

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

1. Select Insert from the Home tab, then click Insert Sheet. References:

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

Correct Answer: See explanation below.

Explanation:

1.

Click Find and Select from the Editing group situated on the Home tab.

2.

Click Replace.

3.

Type the text “Pickup” in the Fine what box.

4.

Click Options to further define the search, specify the “Car Inventory” worksheet select Sheet in the Within box.

5.

Type “Truck” in the Replace with box.

6.

Click Find All, and then click Replace All.

7.

Finalize by clicking OK.

References:

https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef4808-b90f-fdb42f892e90

Correct Answer: See explanation below.

Explanation:

1.

Select the cell J9 where you want to modify the formatting.

2.

On the Home tab in the Cells group click on Format.

3.

Specify a row height by clicking Row Height and then typing in the desired height of 2 lines in the Row Height box.

References:

https://support.office.com/en-us/article/Wrap-text-in-a-cell-2A18CFF5-CCC1-4BCE-95E4-F0D4F3FF4E84

Correct Answer: See explanation below.

Explanation:

1.

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

2.

Click on Format as Table from the Home tab.

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-99C22F971C0E2370

Correct Answer: See explanation below.

Explanation:

1.

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

2.

Click Column in the Sparklines group from the Insert tab.

3.

Enter the range of cells in the Data Range box, in this case A10:A19.

OR

3.

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

4.

Click OK and the Sparkline Tools will appear, the Design tab can be used to customize the sparklines.

References:

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

Correct Answer: See explanation below.

Explanation:

1.

On the “Youth Program” worksheet, select Format as Table from the Home tab.

2.

Choose the desired style for the table.

3.

Select the desired cell range of A9:G19 in the Format as Table dialog box.

4.

Mark row 9 as a header.

5.

Click OK.

References:

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664

Correct Answer: See explanation below.

Explanation:

1. Select Format from the Home tab then choose Hide and Unhide then select Unhide. OR

1.

Hold on the Ctrl button on the keyboard and choose all the worksheet tabs then choose the Unhide option in the right menu.

2.

Click on the first worksheet tab, then hold down the Shift key on the keyboard as you click on the last worksheet tab, then choose the Unhide option.

OR

1.

From the View tab, click Custom Views in the Workbook Views group.

2.

Click the “Summary” view which is hidden, then click Show. References:

https://www.isunshare.com/blog/hide-or-unhide-sheets-in-excel-2016/

Correct Answer: See explanation below.

Explanation:

1.

Right-click the text title “Adult_Program” and click Format Object then click Alt Text.

2.

Type “Adult Enrollment” in the Title box as desired.

3.

Click OK.

References:

https://support.office.com/en-us/article/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-orother-object-44989b2a-903c-4d9a-b742-6a75b451c669#bkmk_o2016_2013

Correct Answer: See explanation below.

Explanation:

1.

Click on the title on the “Spring Sales” worksheet, then type “New Products”.

2.

You can edit the Font of the title from the mini-toolbar that appears OR from the Home tab.

3.

Click directly on either the x-axis or y-axis in the chart OR click the Chart Elements button.

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/