77-427 Exam
Renewal Microsoft 77-427 - An Overview 31 to 37
Our pass rate is high to 98.9% and the similarity percentage between our 77-427 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 77-427 exam in just one try? I am currently studying for the Microsoft 77-427 exam. Latest Microsoft 77-427 Test exam practice questions and answers, Try Microsoft 77-427 Brain Dumps First.
Q31. You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below:
You want to provide pictorial representation of the trend of the sales data in front of each row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?
A. Use stand-alone slicers.
B. Configure form controls.
C. Create sparklines.
D. Create a PivotTable report.
Answer: C
Explanation:
C:\Documents and Settings\Administrator\Desktop\1.JPG In order to accomplish the task with the least amount of administrative burden, use sparklines. Sparklines, introduced in Microsoft Office 2013, are tiny charts that can fit in a cell. The sparklines can be used to show trends in a small amount of space. The sparklines visually summarize trends alongside data. The sparklines can be added through the Insert tab. Answer option A is incorrect. Stand-alone slicers are referenced from Online Analytical Processing (OLAP) Cube functions. These stand-alone slicers can be connected with any PivotTable in future. They can be added by using the slicer button on the Ribbon. They need to be manually linked into grids as required. Answer option B is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option D is incorrect. A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data.
Q32. 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. Click the Insert tab and open the name sheet.
B. Enter the name and click the OK button.
C. Right-click on the Sheet tab and select the Rename option.
D. Delete the old name, type the new name, and then click OK.
Answer: B,C
Q33. 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. Accounting template
B. Trust Center
C. Form control
D. Evaluate Formula
Answer: C
Explanation:
A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option A is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of months. Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result.Answer option B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.
Q34. OTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2013 application on the network. You open the application and see various changes in Excel 2013. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.
Answer:
Q35. 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. Choose one of the pre-built themes.
D. Select all the text of the document.
Change font style to Verdana and font color to light gray. Use vibrant colors for charts.
Answer: C
Explanation:
In order to accomplish the task, you will have to choose one of the pre-built themes.
Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document.
C:\Documents and Settings\Administrator\Desktop\1.JPG
Microsoft Excel 2013 comes with a large collection of pre-built themes. Users can create their own themes for a document. Themes can be specified through Page Layout >
Themes.
Answer option A is incorrect. The SmartArt option does not produce soothing graphic
effects, soft fonts, and light colors.
Answer options B and D are incorrect. These options involve manual processing.
Therefore, any formatting done manually will increase the administrative burden.
Q36. 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. Choose Select a table or range under Choose the data that you want to analyze.
C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
E. Click a cell in the cell range that contains data for using worksheet data as the data source.
Answer: A,B,D,E
Q37. 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. Type the array formula into the first cell.
B. Highlight the range of cells that you want to use as an input in his array formula.
C. Press CTRL-SHIFT-Tab to remove the error message.
D. Press CTRL-SHIFT-Enter.
Answer: A,B,D
Explanation:
The following steps are taken to input Excel array formulas:
1. Highlight the range of cells that a user wants to use as an input in his array formula.
2. Type the array formula into the first cell or make this cell editable by pressing F2 or clicking in the formula bar if a user has already specified a value into the first cell.
3. Press CTRL-SHIFT-Enter.
Answer option C is incorrect. This is an invalid answer option.