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

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.
Which of the following options will you choose to accomplish the task?

• A.Encrypt with Password
• B.Mark as Final
• C.Protect Current Sheet
• D.Protect Workbook Structure

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

Rick works as an Office Assistant for Tech Perfect Inc. He is responsible for preparing sales
reports of the company. He has created a sales report in a workbook of Excel 2013 and this workbook contains various worksheets as shown in the image given below:

Rick wants the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will Rick take to accomplish the task?

• A.Select the sheets containing charts. Right-click on the sheet tabs.
• B.Select the sheets containing charts. Select the Colors option in the Themes group on the
  Page Layout page.
• C.Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color Option from the shortcut menu.
• D.Select the sheets containing charts. Select the Effects option in the Themes group on the Page Layout page.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2013. You want to show the slope of data points in the chart to know the trend of the Business Intelligence data range. Which of the following will you use to accomplish the task?

• A.Sparkline
• B.Backstage view
• C.Trendline
• D.Line charts

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2013. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will
Rick use to accomplish the task?

• A.Form control
• B.Trust Center
• C.Accounting template
• D.Evaluate Formula