Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Microsoft 77-420 Excel 2013 Exam Practice Test

Demo: 4 questions
Total 30 questions

Excel 2013 Questions and Answers

Question 1

Create a table and modify the table styles.

Cell range B6:F29

Table Style Medium 4

Enable the First Column Style

Options:

Question 2

Insert data from a text file.

Cell A1.

File source Autumn.txt

Tab-delimited

Options:

Question 3

Formula.

Insert text using a formula

Cell K2

Use Function CONCATENATE

Text1 : "Students with no "

Text 2: header of column F

Absolute Reference

Options:

Question 4

Formula.

Find the maximum homework score for each student.

Cell range E7:E29

Use Function MAX

Number 1: maximum homework score for each student on "Section 3" worksheet.

Options:

Demo: 4 questions
Total 30 questions