Microsoft 77-420 Excel 2013 Exam Practice Test

Page: 1 / 14
Total 30 questions

Question 1

Apply a style to the chart.

Chart.

Chart Styles Style 7



Answer : A

Question 2

Formula.

Insert text using a formula

Cell K2

Use Function CONCATENATE

Text1 : "Students with no "

Text 2: header of column F

Absolute Reference



Answer : A

Question 3

Insert data from a text file.

Cell A1.

File source Autumn.txt

Tab-delimited



Answer : A

Question 4

Create a hyperlink to another worksheet.

Cell A2.

Cell reference "A3"

Sheet reference "Section 3" worksheet.



Answer : A

Question 5

Change the color theme.

MathTracker.xlsx

Slipstream



Answer : A

Page:    1 / 14   
Total 30 questions