Online Access Free 77-427 Exam Questions

You work as an Office Assistant for Tech Perfect Inc.
You are working in a spreadsheet as shown below:
You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5.
You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Press CTRL-SHIFT-Tab to remove the error message.
• B.Type the array formula into the first cell.
• C.Press CTRL-SHIFT-Enter.
• D.Highlight the range of cells that you want to use as an input in his array formula.

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.Reviewing of changes
• B.History tracking
• C.Onscreen highlighting
• D.Slicer-enabled highlighting

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

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.Protect Workbook Structure
• C.Mark as Final
• D.Protect Current Sheet

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; Excel is not able to recognize the matching value. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. 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.Select Text and click the Finish button in Column Data Formats.
• B.Remove the unseen spaces at the start or end of the first Macro cell.
• C.Select the Delimited option and click Next
• D.Select the Text to Columns option from the Data tab at the top of the Excel workbook.
• E.Select the cells to convert their data to text.
• F.Make sure that all delimiter options are unselected, and then again click Next.