77-427 무료 덤프문제 온라인 액세스

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.FVSCHEDULE function
• B.DDB function
• C.DB function
• D.NPV function

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem?
Each correct answer represents a complete solution. Choose all that apply.

• A.You are referencing an entire worksheet by clicking on the grey square at the top left of the worksheet.
• B.The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
• C.You are inserting a new column, next to a column that is already formatted as text.
• D.Excel is trying to reference an invalid cell.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

• A.Onscreen highlighting
• B.Reviewing of changes
• C.Slicer-enabled highlighting
• D.History tracking

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Reopen the workbook.
• B.Click OK in the message box.
• C.Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.
• D.Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. The report worksheet will include the sales made by all the sales managers in the month of January.

In the worksheet, you are required to place a pictorial representation displaying the percentage of
total sales made by each sales manager in January. Which of the following charts will you use to
accomplish the task?

• A.Line
• B.Bar
• C.Column
• D.Pie