Practice Free 77-420 Excel 2013 Exam Questions Answers With Explanation

Step 1:Click cell B6, and Shift-click cell F29.

Step 2:Click theInserttab, and click the Table button.

Step 3:In the Create Table dialog box click OK.

Step 4:In the Design tab, Table Styles select Table Style Medium 4.

Step 5:In the Design tab enable First Column.

Step 1:Click cell A1.

Step 2:Click the Data tab, and click the From Text button.

The Text Import Wizard starts.

Step 3:Make sure Delimited is select, and click Next.

Step 4:Make sure Delimiters: Tab is selected. Then click Next.

Step 5:Finish the wizard by click the Finish Button.

Step 6: Confirm with OK in the Import Data dialog box.

Step 1:Click on the chart.

Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.

Step 1:Click cell A2.

Step 2:On the Insert tab, in the Links group, click Hyperlink.

Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference 'Section 3', and click OK.