# Microsoft 77-420 Exam Dumps, Microsoft 77-420 Practice Test Questions

Pass your next exam with Exam-Labs VCE files and 100% free questions for 77-420 Excel 2013. Questions formatted with comments for Microsoft Excel 77-420 exam dumps along with study guide and training courses. Pass using VCE formtatted files for Microsoft Excel 77-420 practice test questions and answers.

77-420 PREMIUM Bundle

- Guaranteed to have Latest Exam Questions
- 100% Accurate & Verified Answers
- Fast Free Updates to Cover Latest Pool of Questions
- Instant Download
- 98.4% Pass Rate

Purchase Microsoft Excel 77-420 Exam Training Products Individually

Download Free Microsoft 77-420 Exam Questions, Microsoft Excel 77-420 Practice Test Questions

File Name | Size | Downloads | |
---|---|---|---|

File Name microsoft |
Size 2.4 MB |
Downloads 344 |
Download |

File Name microsoft |
Size 2.4 MB |
Downloads 465 |
Download |

File Name microsoft |
Size 3.7 KB |
Downloads 569 |
Download |

File Name microsoft |
Size 3 MB |
Downloads 1846 |
Download |

Microsoft Excel 77-420 Exam Dumps, Study Guide and Training Courses in VCE File Format Which Can be Opened with Avanset VCE Player. Microsoft Excel 77-420 Practice Test Questions & Answers to Help You Prepare Easily.

Questions & Answers for Microsoft 77-420

Showing 1-30 of 30 Questions

Question #1

Insert the instructor's name for column B.

Cell B5.

Use Function RIGHT

Text: B2

Absolute reference

Num_chars: "16"

Question #3

Create a chart.

To the right of the data

Chart 3-D Clustered Column

Exclude all filtered rows

Horizontal Axis Labels: "IDs" column in table

Series 1: "Zero Scores" column in table.

Question #6

Create a hyperlink to another worksheet.

Cell A2.

Cell reference "A3"

Sheet reference "Section 3" worksheet.

Question #7

Formula. Find the average of each student's homework scores.

Cell range C7:C29

Use Function AVERAGE

Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"

Question #9

Configure page layout options.

Cell range B3:S25.

Set Print Area.

Enable the Gridlines Print option.

Question #10

Sort and Filter.

Apply a sort and a filter to the table.

Cell range B6:F29

Sort

Column Zero Scores Order Largest to Smallest

Column IDs Order Smallest to Largest

Filter

Hide students ids with no zero scores.

Question #11

Modify the cell format to date.

Cell range C2:S2

Type: 14-Mar

Locale (location): English (United States)

Question #12

Crop the picture.

Books.jpg

Crop to Shape Snip Same Side Corner Rectangle.

Question #13

Insert data from a text file.

Cell A1.

File source Autumn.txt

Tab-delimited

Question #14

Formula.

Find themaximum homework score for each student.

Cell rangeE7:E29

Use Function MAX

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

Question #15

Add a header and the date for each of the columns (assignments) in the range.

Cell B2.

Text "Date".

Cell Range C2: S2

Text: "22-Aug, 29-Aug,12-Dec"

Question #18

Add conditional formatting.

Color Scales: Green White-Red Color Scale

Midpoint: Percentile, "70"

Maximum: Number, "25"

Question #20

Modify the cell alignment settings.

Cell range B3:B25

Horizontal: Right (Indent)

Question #21

Create a table and modify the table styles.

Cell range B6:F29

Table Style Medium 4

Enable the First Column Style

Question #22

Formula.

Count the number of 0 homework scores for each student.

Cell range F7:F29

Use function COUNTIF

Range: all possible homework scores for each student on "Section 3" worksheet.

Criteria: 0

Question #23

Formula

Find the average score of all student ids without a zero homework score.

Cell L2

Use Function AVERAGEIF

Range F7:F29

Criteria: "0"

Average_range: "Homework"

Question #27

Formula.

Find the minimum homework score for each student.

Cell range D7:D29

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

Question #29

Modify the text in the title.

Cell A1.

Text "Math 1080 - Section 3 Assignments"

Question #30

Formula.

Insert text using a formula

Cell K2

Use Function CONCATENATE

Text1 : "Students with no "

Text 2: header of column F

Absolute Reference

Pass with Microsoft Excel 77-420 exam practice test questions, study guide & training course. After studying all these free questions you can be confident on Microsoft Excel 77-420 practice test questions and answers from Exam-Labs. Apart from these online questions you can also study Microsoft Excel 77-420 exam practice test questions and answers in VCE file format which can be opened with Avanset VCE exam simulator.