Online Access Free 077-427 Exam Questions

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. 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.The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
• B.The contents of the cells that are being compared may have different data types.
• 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 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.
  Select the Effects option in the Themes group on the Page Layout page.
• 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.
  Right-click on the sheet tabs.
  Choose the Sheet Color option from the shortcut menu.

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2013 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

• A.Choose one of the pre-built themes.
• B.Use the SmartArt option.
• C.Create a new workbook through a template. Copy all data and charts of the report to the new workbook.
• D.Select all the text of the document.
  Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?

• A.He will create a PivotTable report.
• B.He will use stand-alone slicers.
• C.He will create a PivotChart report.
• D.He will configure form controls.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick is creating a project through Microsoft Excel 2013. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

• A.Trust Center
• B.Form control
• C.Gantt Chart Template
• D.Accounting template