Microsoft 77-420 Dumps

Exam: Excel 2013

77-420 Premium VCE File
77-420.vce - Exam-Labs Verified - Instant Download
Get Latest & Verified 77-420 Exam Questions with 30-Days Free Updates
30 Questions & Answers

Play Microsoft 77-420 VCE files with Avanset VCE Simulator

Microsoft 77-420 Exam Tutorial

Showing 1-20 of 30 Questions   (Page 1 out of 2)

Question No : 1

Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"

Question No : 2

Insert a picture.
To the right of the data
File source Books.jpg

Question No : 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 No : 4

Rename the title of the chart.
Text "All Zero Scores"

Question No : 5

Modify the document property.
Subject "Homework"

Question No : 6

Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.

Question No : 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 No : 8

Create a new named range.
Cell range C7:C29.
Name: "Homework"

Question No : 9

Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.

Question No : 10

Sort and Filter.
Apply a sort and a filter to the table.
Cell range B6:F29
Column Zero Scores Order Largest to Smallest
Column IDs Order Smallest to Largest
Hide students ids with no zero scores.

Question No : 11

Modify the cell format to date.
Cell range C2:S2
Type: 14-Mar
Locale (location): English (United States)

Question No : 12

Crop the picture.
Crop to Shape Snip Same Side Corner Rectangle.

Question No : 13

Insert data from a text file.
Cell A1.
File source Autumn.txt

Question No : 14

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 No : 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 No : 16

Change the color theme.

Question No : 17

Rename a table.
Cell range B6:F29
Name: "Overview"

Question No : 18

Add conditional formatting.
Color Scales: Green White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"

Question No : 19

Add a worksheet
After other worksheets
Rename "Section 5"

Question No : 20

Modify the cell alignment settings.
Cell range B3:B25
Horizontal: Right (Indent)

Showing 1-20 of 30 Questions   (Page 1 out of 2)

77-420 Training Products

77-420 Premium File

  • 30 Questions & Answers
  • Instant Download
  • $39.99

Site Search:



Exam-Labs PREMIUM Files

Get 10% Discount on all PREMIUM files!

Enter Your Email Address to Receive Your 10% Off Discount Code

A Confirmation Link will be sent to this email address to verify your login

We value your privacy.
We will not rent or sell your email address

Download Free Demo of VCE
Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Enter Your Email Address

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.