Online Access Free 077-427 Practice Test

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking. Which option can be used to view only the relevant records?

• A.Autofilter
• B.Find
• C.All filter
• D.Sort

You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.
Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Click the Insert tab and open the name sheet.
• B.Enter the name and click the OK button.
• C.Delete the old name, type the new name, and then click OK.
• D.Right-click on the Sheet tab and select the Rename option.

Which of the following is used to display a trend based on adjacent data in a clear and compact
graphical representation by taking up a small amount of space?

• A.Line chart
• B.Trendline
• C.Backstage view
• D.Sparkline

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• B.Click the slicer, and then press Delete.
• C.Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
• D.Right-click the slicer, and then click Remove <Name of slicer>.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another PivotTable. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.In the Slicer Connections dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.
• B.Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• C.In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.
• D.Click the slicer that you want to share in another PivotTable.