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

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You are trying to intersect two ranges that do not intersect each
other. Which of the following errors will be occurred in this situation?

• A.#VALUE!
• B.#DIV/0!
• C.#NULL!
• D.#NAME?

You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.
Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Enter the name and click the OK button.
• B.Right-click on the Sheet tab and select the Rename option.
• C.Delete the old name, type the new name, and then click OK.
• D.Click the Insert tab and open the name sheet.

Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2013. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer message in the A1 cell of each sheet in the workbook as shown in the image given below: Which of the following is the easiest way to accomplish the task?

• A.Select all the five sheets.
  Write a disclaimer message in the A1 cell of the active sheet.
• B.Select all the five sheets. Click the first sheet.
  Write a disclaimer message in the A1 cell of the active sheet.
• C.Write a disclaimer message in the A1 cell of the first sheet.
  In the other sheets, insert a formula that points to the A1 cell of the first worksheet.
• D.Write a disclaimer message in the A1 cell of the first sheet.
  Copy the disclaimer message and paste it on the remaining sheets.

You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2013.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?

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

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity. Which of the following financial functions will you use to accomplish the task?

• A.PRICEMAT function
• B.PRICE function
• C.PRICEDISC function
• D.PPMT function