Exam2pass
0 items Sign In or Register
  • Home
  • IT Exams
  • Guarantee
  • FAQs
  • Reviews
  • Contact Us
  • Demo
Home > Microsoft > Microsoft Certifications > 77-420
Microsoft 77-420 Exam Questions & Answers
Download Demo

  Printable PDF

Microsoft 77-420 Exam Questions & Answers


Want to pass your Microsoft 77-420 exam in the very first attempt? Try Exam2pass! It is equally effective for both starters and IT professionals.

  • Vendor: Microsoft

    Exam Code: 77-420

    Exam Name: Excel 2013

    Certification Provider: Microsoft

    Total Questions: 30 Q&A

    Updated on: Feb 10, 2025

    Note: Product instant download. Please sign in and click My account to download your product.
  • Updated exam questions with all objectives covered
    Verified answers
    365 days free updates
    99% success rate
    100% money back guarantee
    24/7 customer support

  • PDF Only: $45.99 Software Only: $49.99 Software + PDF: $59.99

Related Exams

  • 62-193 Technology Literacy for Educators
  • 70-243 Administering and Deploying System Center 2012 Configuration Manager
  • 70-355 Universal Windows Platform – App Data, Services, and Coding Patterns
  • 77-420 Excel 2013
  • 77-427 Excel 2013 Expert Part One
  • 77-725 Word 2016 Core Document Creation, Collaboration and Communication
  • 77-726 Word 2016 Expert Creating Documents for Effective Communication
  • 77-727 Excel 2016 Core Data Analysis, Manipulation, and Presentation
  • 77-728 Excel 2016 Expert: Interpreting Data for Insights
  • 77-731 Outlook 2016 Core Communication, Collaboration and Email Skills
  • 77-882 Excel 2010
  • 77-886 SharePoint 2010
  • 77-888 Excel 2010 Expert
  • 98-349 Windows Operating System Fundamentals
  • 98-361 Software Development Fundamentals
  • 98-364 Database Fundamentals
  • 98-365 Windows Server Administration Fundamentals
  • 98-366 Networking Fundamentals
  • 98-367 Security Fundamentals
  • 98-368 Mobility and Devices Fundamentals
  • 98-375 HTML5 Application Development Fundamentals
  • 98-381 Introduction to Programming Using Python
  • 98-382 Introduction to Programming Using JavaScript
  • 98-383 Introduction to Programming Using HTML and CSS
  • 98-388 Introduction to Programming Using Java
  • AI-102 Designing and Implementing a Microsoft Azure AI Solution
  • AI-900 Microsoft Azure AI Fundamentals
  • AZ-104 Microsoft Azure Administrator
  • AZ-120 Planning and Administering Microsoft Azure for SAP Workloads
  • AZ-140 Configuring and Operating Windows Virtual Desktop on Microsoft Azure

Related Certifications

  • Dynamics C5
  • Dynamics-POS-2009
  • MCITP
  • MCSE
  • MCTS
  • Microsoft Business I...
  • Microsoft Business S...
  • Microsoft Certificat...
  • Microsoft Certified ...
  • Microsoft Dynamics
  • Microsoft Dynamics 3...
  • Microsoft Dynamics A...
  • Microsoft Dynamics A...
  • Microsoft Dynamics C...
  • Microsoft Dynamics C...
  • Microsoft Dynamics C...
  • Microsoft Dynamics G...
  • Microsoft Dynamics N...
  • Microsoft Dynamics S...
  • Microsoft other Cert...

77-420 Online Practice Questions and Answers

Questions 1

Add conditional formatting.

Color Scales: Green –White-Red Color Scale

Midpoint: Percentile, "70"

Maximum: Number, "25"

Show Answer

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell C3

Step 2:Shift-Click cell S25.

Step 3:On the Home tab, under Format, choose Conditional Formatting, and choose New Rule...

Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green. Step 5:In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.

Questions 2

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.

Show Answer

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click a cell in the table.

Step 2:On the Home tab select the Sort and Filter button, and select Custom sort (needed to sort on more than one column at a time).

Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.

Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button. Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.

Step 6: In the Custom AutoFilter enter 0, and click OK

The result will look like:

Questions 3

Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference

Show Answer More Questions

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click K2andClick on the insert function button.

Step 2:Select Category: Text, the CONCATENATE function, and click OK.

Step 3:In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key

Step 4:Press the OK button in the Function Arguments dialog box.

Why Choose Exam2pass 77-420 Exam PDF and VCE Simulator?

  • 100% Pass and Money Back Guarantee

    Exam2pass 77-420 exam dumps are contained with latest 77-420 real exam questions and answers. Exam2pass 77-420 PDF and VCE simulator are revised by the most professional 77-420 expert team. All the 77-420 exam questions are selected from the latest real exam and answers are revised to be accurate. 100% pass guarantee and money back on exam failure.

  • The Most Professional Support Service

    Exam2pass has the most skillful 77-420 experts. Candidates can get timely help when needed. Exam2pass 77-420 exam PDF and VCE simulator are the most up-to-date and valid. The most professional support service are provided to help the 77-420 candidates at anytime and anywhere.

  • 365 Days Free Update Download

    Exam2pass 77-420 exam PDF and VCE simulator are timely updated in 365 days a year. Users can download the update for free for 365 days after payment. Exam2pass 77-420 exam dumps are updated frequently by the most professional 77-420 expert team. 77-420 candidates can have the most valid 77-420 exam PDF and VCE at any time when needed.

  • Free Demo Download

    Download free demo of the Exam2pass exam PDF and VCE simulator and try it. Do not need to pay for the whole product before you try the free trial version. Get familiar about the exam questions and exam structure by trying the free sample questions of the exam PDF and VCE simulator. Try before purchase now!

Exam2Pass----The Most Reliable Exam Preparation Assistance

There are tens of thousands of certification exam dumps provided on the internet. And how to choose the most reliable one among them is the first problem one certification candidate should face. Exam2Pass provide a shot cut to pass the exam and get the certification. If you need help on any questions or any Exam2Pass exam PDF and VCE simulators, customer support team is ready to help at any time when required.

Home | Guarantee & Policy |  Privacy & Policy |  Terms & Conditions |  How to buy |  FAQs |  About Us |  Contact Us |  Demo |  Reviews

2025 Copyright @ exam2pass.com All trademarks are the property of their respective vendors. We are not associated with any of them.