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 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-a614dde8443579f8

Correct Answer: See explanation below.

Explanation:

1.

Select the cells below the rows and to the right of the columns you want to keep visible, which in this case is row 10 and column H.

2.

Click Freeze Panes from the Freeze Panes group in the View tab.

References: https://support.office.com/en-ie/article/Freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-812167dd25f2508f

Correct Answer: See explanation below.

Explanation:

1.

On the “Car Inventory” worksheet, click Print Titles from the Page Setup group, situated on the PageLayout tab.

2.

Under Print Titles, on the Sheet tab, type the reference of the row you want to reappear (row 9) in the Rows to repeat at top box.

References:

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

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.

Click Design from the Ribbon on Table Tools.

2.

In the Tools group, click on Convert to Range.

OR

1. Right-click the table then click on Table then press Convert to Range.

References:

https://support.office.com/en-us/article/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe84ea-786265d41c77?redirectSourcePath=%252fen-us%252farticle%252fRemove-a-table-without-losingthe-data-or-table-format-ADF88635-90F5-4FAA-9417-19862F38CCE8andui=en-USandrs=en-USandad=US

Correct Answer: See explanation below.

Explanation:

1. On the “Summer Bookings” worksheet, click Header and Footer from the Text group situation on the

Insert tab.

2.

Click Click to add footer which would display the Header and Footer tools which gets added to the Design tab.

3.

Specify where the page number should be by selecting the Center section box.

4.

On the Design tab in the Header and Footer Elements group, click Page Number.

5.

The placeholder and[Page] will appear in the selected section, to add the total number of pages type the word of followed by the space in the Header and Footer Elements group after clicking Number of Pages, then the placeholder and[Page] of and[Pages] appear.

6.

Click anywhere outside the header or footer area to display the page numbers in Page Layout View.

7.

Once you are done working in the Page Layout View, click Normal in the Workbook Views group situated on the View tab. OR You can also click Normal on the status bar.

References:

https://support.office.com/en-us/article/Insert-page-numbers-on-worksheets-27A88FB9-F54E-4AC4-84D7BF957C6CE29C

Correct Answer: See explanation below.

Explanation:

1.

Click on the 3-D Pie Chart on the “Spring Sales” worksheet.

2.

This would display the Chart Tools, click on the desired style which is Style 3 Monochromatic Color 2 from the Chart Styles group situated on the Design tab.

References:

https://support.office.com/en-us/article/Change-the-layout-or-style-of-a-chart-A346E438-D22A-4540-AA87BCE9FEB719CF

Correct Answer: See explanation below.

Explanation:

1.

Select the first row OR column on the “Summer Sales” worksheet and Copy either from the Home tab OR by pressing Ctrl+C on the keyboard.

2.

Select the first cell where you want to paste the data, then click on the arrow next to Paste situated on the Home tab, then select Transpose.

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-forMac-9c16dd55-ed1a-4aa2-8b74-b1b9211e2ede