Microsoft 077-427 - Microsoft Excel 2013 Expert Part One

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. Line charts
• C. Trendline
• D. Backstage view

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 protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

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

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. 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. Click OK.
• B. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
• C. Choose Select a table or range under Choose the data that you want to analyze.
• D. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
• E. Click a cell in the cell range that contains data for using worksheet data as the data source.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick has to perform the following tasks:
Summarize large amounts of data. Analyze numeric data.
Answer unexpected questions about data.
Which of the following actions will Rick take to accomplish the task?

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

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. Remove the unseen spaces at the start or end of the first Macro cell.
• B. Select the Text to Columns option from the Data tab at the top of the Excel workbook.
• C. Select the cells to convert their data to text.
• D. Select Text and click the Finish button in Column Data Formats.
• E. Make sure that all delimiter options are unselected, and then again click Next.
• F. Select the Delimited option and click Next