[Free] 2018(June) Ensurepass Microsoft 77-427 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 May Microsoft Official New Released 77-427
100% Free Download! 100% Pass Guaranteed!

Microsoft Excel 2013 Expert Part 1

Question No: 11

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:

Ensurepass 2018 PDF and VCE

Which of the following is the easiest way to accomplish the task?

  1. Write a disclaimer message in the A1 cell of the first sheet. Copy the disclaimer message and paste it on the remaining sheets.

  2. 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.

  3. Select all the five sheets. Click the first sheet.

    Write a disclaimer message in the A1 cell of the active sheet.

  4. Select all the five sheets.

Write a disclaimer message in the A1 cell of the active sheet.

Answer: D Explanation:

In order to accomplish the task, Rick should take the following steps: Select all the five sheets.

Write a disclaimer message in the A1 cell of the active sheet.

Grouping of sheets is a feature provided in Microsoft Office Excel 2013. Selecting more than one sheet groups those sheets. When multiple sheets are grouped, data that a user enters or edits in the active sheet is reflected in all sheets in the group. To select all sheets, right-click a sheet

tab, and then click Select All Sheets on the shortcut menu.

Ensurepass 2018 PDF and VCE

C:\Documents and Settings\Administrator\Desktop\1.JPG

Users can select multiple sheets by holding the Ctrl key while clicking the sheets.

Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the

sheets and the message will only get inserted in the first sheet.

Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets.

Users can select multiple sheets by holding the Ctrl key while clicking the sheets.

Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the

sheets and the message will only get inserted in the first sheet.

Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets.

Question No: 12

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable

report. Which of the following steps will you take next to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.

  1. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.

  2. Right-click the slicer, and then click Remove lt;Name of slicergt;.

  3. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort

    amp; Filter group.

  4. Click the slicer, and then press Delete.

Answer: A,C

Question No: 13 HOTSPOT

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flow- chart symbols in the report. Explanation: In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart

shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to

these shapes after inserting them in the document. Take the following steps to add a shape in a

document:

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Explanation:

C:\Documents and Settings\Administrator\Desktop\1.JPG

Ensurepass 2018 PDF and VCE

C:\Documents and Settings\Administrator\Desktop\1.JPG

Question No: 14

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 export XMLdata to your Excel 2013 worksheet. On exporting the XML data, the following error message appears:

quot;XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLEquot;

Which of the following are the reasons that are causing the above error? Each correct answer

represents a complete solution. Choose all that apply.

  1. The maxoccurs attribute is not equal to 1.

  2. The relationship of the mapped element with other elements is not preserved.

  3. The element is a recursive structure.

  4. The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table.

    Answer: A,B Explanation:

    The various issues with exporting XML data are as follows:

    1. MAP CAN BE EXPORTED BUT SOME REQUIRED ELEMENTS ARE NOT MAPPED: This error occurs under the following situations:

      The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table. The element is a recursive structure.

      The XML table contains a variety of mixed content.

    2. EXCEL CANNOT SAVE THE WORKBOOK BECAUSE IT DOES NOT CONTAIN ANY XML MAPPINGS: Excel cannot save the user#39;s workbook in the XML Data file unless one or more mapped ranges are created.

    3. XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE: An XML mapping cannot be exported if the relationship of the mapped element with other elements is not preserved due to the following reasons:

      The mapped element#39;s schema definition is contained within a sequence with the following attributes:

      The maxoccurs attribute is not equal to 1.

      The sequence has more than one direct child element defined or has an extra compositor as a direct child.

      Nonrepeating sibling elements with the same repeating parent element are mapped to dissimilar

      XML tables.

      Various repeating elements are mapped to the same XML table and the recurrence is not defined by an ancestor element.

      Child elements from various parents are mapped to the same XML table.

      XML schema constructs a list of lists, denormalized data, or a choice construct.

      Question No: 15

      You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. The report worksheet will include the sales made by all the sales

      managers in the month of January.

      Ensurepass 2018 PDF and VCE

      In the worksheet, you are required to place a pictorial representation displaying the percentage of

      total sales made by each sales manager in January. Which of the following charts will you use to

      accomplish the task?

      1. Bar

      2. Line

      3. Column

      4. Pie

Answer: D Explanation:

In order to accomplish the task, you will have to insert a pie chart in the worksheet. Excel provides a pie chart facility to display data that is arranged in one column or row on a worksheet.

Pie charts display the size of items in one data series, proportional to the sum of the items.

Question No: 16 HOTSPOT

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

The following figure shows the option used to insert a signature line that specifies the individual

who must sign.

Ensurepass 2018 PDF and VCE

C:\Documents and Settings\Administrator\Desktop\1.JPG

Question No: 17

Ensurepass 2018 PDF and VCE

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 #39;=TRANSPOSE( B1:B3 )#39; 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.

  1. Type the array formula into the first cell.

  2. Highlight the range of cells that you want to use as an input in his array formula.

  3. Press CTRL-SHIFT-Tab to remove the error message.

  4. 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.

      Question No: 18

      You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to get the trend of the Business data range. For this purpose, you want to use trendlines in the chart. Which of the following steps will you take to apply the trendlines in the chart?

      Each correct answer represents a part of the solution. Choose all that apply.

      1. Clear the check box of any Trendline fields to disconnect a slicer.

      2. Select the type that you want from Trendline options.

      3. Click the Insert Trendline arrow, and then click Trendline Connections on the Options tab in the Sort amp; Filter group.

      4. Select a chart and then navigate to the Chart Tools Layout tab.

Answer: B,D

Question No: 19

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.

  1. The lookup_value or the array you are searching resides in a cell containing unseen spaces at

    the start or end of that cell.

  2. The contents of the cells that are being compared may have different data types.

  3. Excel is trying to reference an invalid cell.

  4. You are inserting a new column, next to a column that is already formatted as text.

Answer: A,B Explanation:

The Failure to Look Up Values in Excel error occurs when a user gets an unexpected error while trying to look up or match a lookup_value within an array and Excel is not able to recognize the matching value. If the lookup_value or the array the user is searching resides in a cell, the user can have unseen spaces at the start or end of that cell. This will create the situation where the contents of the two cells that the user is comparing look the same but extra spaces in one of the cells cause the cells to have slightly different content. The other reason is that the contents of the cells that are being compared may have different data types. Answer option C is incorrect. The Lookup Function Won#39;t Copy Down to Other Rows error occurs when a user uses a function in one cell and it works perfectly but when he attempts to copy the function down to other rows, he gets the #REF error. The #REF! error arises when Excel tries to reference an invalid cell. This error occurs if the user has referenced an entire worksheet by clicking on the grey square at the top left of the worksheet. For Excel, this reference range is 1 to 1048576. Since the references are Relative References, Excel automatically increases the row references when this cell is copied down to other rows in the spreadsheet.

Answer option D is incorrect. The Excel Won#39;t Calculate My Function error occurs when a user types in a function and presses Enter, the cell shows the function as the user typed it, instead of returning the function#39;s value. The reason that causes this problem is that the cells containing the formula are formatted as #39;text#39; instead of the #39;General#39; type. This happens when the user inserts a new column, next to a column that is already formatted as text due to which the new column inherits the formatting of the adjacent column.

Question No: 20 DRAG DROP

You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different

reports for your company. Drag and drop the appropriate methods for efficient data entry in front

of their descriptions.

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Explanation:

Ensurepass 2018 PDF and VCE

C:\Documents and Settings\Administrator\Desktop\1.JPG

Excel provides multiple methods for fast data entry into a worksheet. These data entry techniques help users to quickly enter data wherever required. The following methods help users in speeding-up their data entry work:

AutoFill: The AutoFill feature recognizes the series a user wants to enter and fills the series when the fill handle is dragged.

FillSeries: In FillSeries method, a user enters the first two values in a series and then by selecting both the cells and dragging the selected cells through the fill handle, extends the series. AutoComplete: The AutoComplete feature provides users a facility to enter few words in a cell. If this entry matches with any of the entries done before in other cells, it suggests users for the same. The user can press the Enter key to get the same entry in the cell. Pick from Drop-down List: The Pick from Drop-down List option displays the unique entries from the column of a cell. A user can choose an entry from the list to quickly fill the entry.

Ensurepass 2018 PDF and VCE

C:\Documents and Settings\Administrator\Desktop\1.JPG

Ctrl Enter: Ctrl Enter key combination is used to quickly fill a range of cells with the same

entry. For this, select a range of cells to contain the same data, type the data in the active cell, and press Ctrl Enter keys.

100% Ensurepass Free Download!
Download Free Demo:77-427 Demo PDF
100% Ensurepass Free Guaranteed!
77-427 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *