Microsoft Excel 2013 - 77-420 Exam Practice Test
CORRECT TEXT
Insert a picture.
To the right of the data
File source Books.jpg
Insert a picture.
To the right of the data
File source Books.jpg
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click in a cell to the right of the data.
Step 2:Click the INSERT tab, and then the Pictures command.
Step 3:From the Insert Picture dialog box select the Books.jpg file.
Explanation:
Step 1:Click in a cell to the right of the data.
Step 2:Click the INSERT tab, and then the Pictures command.
Step 3:From the Insert Picture dialog box select the Books.jpg file.
CORRECT TEXT
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
Correct Answer:
Use the following steps to complete this task in
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. Microsoft 77-420 : Practice Test
Step 4:In the Design tab, Table Styles select Table Style Medium 4.
Step 5:In the Design tab enable First Column.
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. Microsoft 77-420 : Practice Test
Step 4:In the Design tab, Table Styles select Table Style Medium 4.
Step 5:In the Design tab enable First Column.
CORRECT TEXT
Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Correct Answer:
Use the following steps to complete this task in
Explanation:
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.
Explanation:
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.