Download Demo

Printable PDF

Microsoft 77-427 Exam Dumps

Vendor: Microsoft
Exam Code: 77-427
Exam Name: Excel 2013 Expert Part One
Certification: Microsoft Office Specialist
Total Questions: 62 Q&A
Updated on: Dec 18, 2024
Note: Product instant download. Please sign in and click My account to download your product.

PDF Only: $49.99 VCE Only: $55.99 PDF + VCE: $65.99

99.5% pass rate

12 Years experience

7000+ IT Exam Q&As

70000+ satisfied customers

365 days Free Update

3 days of preparation before your test

100% Safe shopping experience

24/7 Support

Microsoft 77-427 Last Month Results

821

Successful Stories of Microsoft 77-427 Exam

99.1%

High Score Rate in Actual Microsoft Exams

95.6%

Same Questions from the Latest Real Exam

Free 77-427 Exam Questions in PDF Format

File
Size
Microsoft_leads4pass_77-427_by_dhl_57.pdf
315.22 KB
Microsoft_leads4pass_77-427_by_ANDRIVE_50.pdf
386.95 KB
Microsoft_leads4pass_77-427_by_Amar_55.pdf
225.04 KB
Microsoft_leads4pass_77-427_by_Uzale_51.pdf
285.22 KB
Microsoft_leads4pass_77-427_by_mohammed_elmustafa_61.pdf
288.88 KB
Microsoft_leads4pass_77-427_by_aud_57.pdf
290.29 KB

77-427 Online Practice Questions and Answers

Questions 1

You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.

Select and Place:

Show Answer

Questions 2

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?

Each correct answer represents a part of the solution. Choose all that apply.

A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.

B. Right-click the slicer, and then click Remove .

C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort and Filter group.

D. Click the slicer, and then press Delete.

Show Answer

Questions 3

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining financial budget and other financial calculations. You want to return the depreciation of an asset for a specified period by using the fixed-declining balance method and to return the future value of a starting principal after applying a series of compound interest rates.

Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

A. DB function

B. NPV function

C. DDB function

D. FVSCHEDULE function

Show Answer More Questions

Correct Answer: AD

Various financial functions (reference) are as follows:

ACCRINT function: It is used to return the accrued interest for a security that pays periodic interest.

ACCRINTM function: It is used to return the accrued interest for a security that pays interest at maturity.

AMORDEGRC function: It is used to return the depreciation for each accounting period by using a depreciation coefficient.

COUPDAYBS function: It is used to return the number of days from the beginning of the coupon period to the settlement date.

AMORLINC function: It is used to return the depreciation for each accounting period.

COUPDAYS function: It is used to return the number of days in the coupon period containing the settlement date.

COUPDAYSNC function: It is used to return the number of days from the settlement date to the next coupon date.

COUPNCD function: It is used to return the next coupon date after the settlement date.

COUPNUM function: It is used to return the number of coupons payable between the settlement date and maturity date.

10.

COUPPCD function: It is used to return the previous coupon date before the settlement date.

11.

CUMIPMT function: It is used to return the cumulative interest paid between two periods.

12.

CUMPRINC function: It is used to return the cumulative principal paid on a loan between two periods.

13.

DB function: It is used to return the depreciation of an asset for a specified period by using the fixed-declining balance method.

14.

DDB function: It is used to return the depreciation of an asset for a particular period by using the double-declining balance method.

15.

DISC function: It is used to return the discount rate for a security.

16.

DOLLARDE function: It is used to convert a dollar price that is expressed as a fraction into a dollar price that is expressed as a decimal number.

17.

DOLLARFR function: It is used to convert a dollar price that is expressed as a decimal number into a dollar price that is expressed as a fraction.

18.

DURATION function: It is used to return the annual duration of a security with periodic interest payments.

19.

EFFECT function: It is used to return the effective annual interest rate.

20.

FV function: It is used to return the future value of an investment.

21.

FVSCHEDULE function: It is used to return the future value of a starting principal after applying a series of compound interest rates.

22.

INTRATE function: It is used to return the interest rate for a fully invested security.

23.

IPMT function: It is used to return the interest payment for an investment for a specified period.

24.

IRR function: It is used to return the internal rate of return for a series of cash flows.

25.

ISPMT function: It is used to calculate the interest paid during a particular period of an investment.

26.

MDURATION function: It is used to return the Macauley modified duration for a security with an assumed par value of $100.

27.

MIRR function: It is used to return the internal rate of return in which positive and negative cash flows are financed at different rates.

28.

NOMINAL function: It is used to return the annual nominal interest rate.

29.

NPER function: It is used to return the number of periods for an investment.

30.

NPV function: It is used to return the net present value of an investment on the basis of a series of periodic cash flows and a discount rate.

31.

ODDFPRICE function: It is used to return the price per $100 face value of a security with an odd first period.

32.

ODDFYIELD function: It is used to return the yield of a security with an odd first period.

33.

ODDLPRICE function: It is used to return the price per $100 face value of a security with an odd last period.

34.

ODDLYIELD function: It is used to return the yield of a security with an odd last period.

35.

PMT function: It is used to return the periodic payment for an annuity.

36.

PPMT function: It is used to return the payment on the principal for an investment for a particular defined period.

37.

PRICE function: It is used to return the price per $100 face value of a security that pays Periodic interest.

38.

PRICEDISC function: It is used to return the price per $100 face value of a discounted security.

39.

PRICEMAT function: It is used to return the price per $100 face value of a security that pays interest at maturity.

40.

PV function: It is used to return the current value of an investment.

41.

RATE function: It is use d to return the interest rate per period of an annuity.

42.

RECEIVED function: It is used to return the amount received at maturity for a fully invested security.

43.

SLN function: It is used to return the straight-line depreciation of an asset for one period.

44.

SYD function: It is used to return the sum-of-years' digits depreciation of an asset for a particular period.

45.

TBILLEQ function: It is used to return the bond-equivalent yield for a Treasury bill.

46.

TBILLPRICE function: It is used to return the price per $100 face value for a Treasury bill.

47.

TBILLYIELD function: It is used to return the yield for a Treasury bill.

48.

VDB function: It is used to return the depreciation of an asset for a specified or partial period by using a declining balance method.

49.

XIRR function: It is used to return the internal rate of return for a schedule of cash flows that is not necessarily periodic.

50.

XNPV function: It is used to return the net present value for a schedule of cash flows that is not necessarily periodic.

51.

YIELD function: It is used to return the yield on a security that pays periodic interest.

52.

YIELDDISC function: It is used to return the annual yield for a discounted security.

53.

YIELDMAT function: It is used to return the annual yield of a security that pays interest at maturity.

Hot Exams

Related Microsoft Certifications

Why 77-427 Dumps Are Worth It

Hannah Johnson

Leads4Pass is one of the best websites I have ever used. It only took me 3 days of preparation to complete my goal plan. Not only that, I was successful with high scores.

Joel C

It was the 16th when I purchased the Leads4Pass materials. They updated the materials on the 18th. When I asked them to send me the latest materials, they quickly sent me the latest ones. The new materials included several of the latest core question types. Finally, I succeeded. Six of the new core questions were completely matched. Thank you!

Martha W

I have used free materials, the privacy is poor, the public content matching rate is too low,I gave up on them because they failed me once. Leads4Pass was recommended by a friend. Both the privacy protection and the preciousness of the materials are very high. By the way, I won this time.

David Frazier

There is nothing more satisfying than success! Their question types are very similar, and they were very helpful to my progress in answering questions during the exam. Thank you.

Dolores N

I need to take multiple certification exams for my organization. There are so many certification exams that I can't help but choose supporting materials. I have tried multiple platforms with some success and failure. In the end, I chose Leads4Pass. It was instant for me. Effective materials are where the real value lies.

Helen Kovac

I was despised by a close friend until he failed twice and I passed once and then he changed his mind. He shared his failure experience with me. He told me that he had been learning through books and looking for free materials. These outdated contents could not really help him. Later I recommended him Leads4Passs and he also succeeded.

Raymond I

I was lucky enough to choose Leads4Pass for the first time. I used their VCE tool to learn, and it was really easy and efficient. I think what’s really amazing is that they can ensure that all materials are industry-leading, which is really amazing.