[Free] 2018(Aug) Ensurepass Microsoft 77-888 Dumps with VCE and PDF 31-40

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

Microsoft Excel 2010 Expert

Question No: 31

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet.

You are

facing a problem that when you type in a function and press Enter, the cell shows the function as

you typed it, instead of returning the function#39;s value as shown below:

Which of the following is the reason that is causing the above problem?

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

  2. Excel is trying to reference an invalid cell.

  3. You are inserting a new column, next to a column containing Dates or Times.

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

the start or end of that cell.

Answer: A Explanation:

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 isalreadyformattedastext due to which the newcolumn inheritstheformatting of the adjacent column. Answer option D is incorrect. The Failure to Look Up Values in

Excel erroroccurs when a user gets an unexpected error while trying to look up or match a lookup_value withinan array and Excel is not able to recognize the matching value. If the lookup_value or the arraythe user is searching resides in a cell, the user can have unseen spaces at the start or end ofthat 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 thecells cause the cells to have slightly different content. The other reason is that the contents ofthe cells that are being compared may have different data types.

Answer option B is incorrect. The Lookup Function Won#39;t Copy Down to Other Rows error occurs when auser uses a function in one cell and it works perfectly but when he attempts to copy the functiondown to other rows, he gets the #REF error. The #REF! error arises when Excel tries to reference aninvalid cell. This error occurs if the user has referenced an entire worksheet by clicking on thegrey 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 whenthis cell is copied down to other rows in the spreadsheet. Answer option C is incorrect. The Cell Shows a Date or Time Instead of a Number error occursbecause the cell that contains the formula is formatted as a #39;date#39; or #39;time#39; instead of a#39;General#39; type or a number. This situation arises because a user has inserted a new column, next toa column containing Dates or Times, the new column has

#39;inherited#39; the formatting of the adjacentcolumn.

Question No: 32

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. 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.

  1. To assign an existing macro to the graphic object, double-click the macro or enter its name in

    TheMacro name box.

  2. Click the arrow next to Shape Outline, and then click No Outline. C. Right-click the created hot spot, and then click Assign Macro.

  3. To create a hot spot on the existing object, on the Insert tab, in the Illustrations group, ClickShapes, select the shape that you want to use, and then draw that shape on the existing object.

  4. Click the name of the macro in the Macro name box, click Edit, and then click OK to edit an

    existing macro.

  5. Click the arrow next to Shape Fill, and then click No Fill on the Format tab.

  6. Click Record, type a name for the macro in the Record Macro dialog box, and then click OK to start the recording of the macro.

  7. Select the hot spot in the worksheet to display Drawing Tools for adding the Format tab.

  8. Click Slicer, type a name for the macro in the Slicer Macro dialog box, and then click OK to

start the recording of the macro.

Answer: A,B,C,D,E,F,G,H

Question No: 33

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

  1. Create a copy of a slicer connected with the PivotTable.

  2. Create a slicer connected with the PivotTable.

  3. Create a slicer by disabling Macros associated with the PivotTable.

  4. Use an existing slicer connected with another PivotTable.

Answer: A,B,D Explanation:

The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are

as follows:

1.Createa slicer connected with the PivotTable. 2.Createa copy of a slicer connected with the PivotTable.

3.Usean existing slicer connected with another PivotTable. Answer option C is incorrect. This is an invalid answer option.

Question No: 34

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:

VLOOKUP(12, A2:C10, 3, FALSE )

Which of the following actions will be performed by the formula?

  1. Search for the value 12 in the first column of the range, and then returns the value that is

    contained in the third column of the range and on the same row as the lookup value.

  2. Wrong syntax used.

  3. Search the value 3 in the last column of the range, and then returns the value that is in the

    column of the range and on the same row as the lookup value.

  4. Search the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.

Answer: A Explanation:

The formula will search for the value 12 in the first column of the range, and then returns the

value that is contained in the third column of the range and on the same row as the lookup value.

Question No: 35

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 theSort amp; Filter group.

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

Answer: B,D

Question No: 36

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You have changed some data in the worksheet of the company. You are submitting the sell workbook of the company to the Administrator of the company for comments. Now, you want to merge input that you receive into a copy of that workbook, including the changes and comments that you want to keep. 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?

  1. Slicer-enabled highlighting

  2. Onscreen highlighting

  3. Reviewing of changes

  4. History tracking

Answer: C

Explanation:

The following ways are provided by Excel to access and use the stored change history: 1.Onscreen highlighting: It is used when a workbook does not contain many changes and a user

wants to see all changes at a glance.

  1. History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes.

  2. Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option A is incorrect. This is an invalid answer option.

Question No: 37

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in

Microsoft Excel 2010. You want to export XMLdata to your Excel 2010 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 to1.

  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 XMLtable. Theelement 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 to1.

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: 38

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2010 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?

  1. Use the SmartArt option.

  2. Create a new workbook through a template.Copy all data and charts of the report to the new workbook.

  3. Choose one of the pre-built themes.

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

Ensurepass 2018 PDF and VCE

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

Microsoft Excel 2010 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 gt; 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.

Question No: 39

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the

company#39;s high selling products. You are trying to intersect two ranges that do not intersect each

other. Which of the following errors will be occurred in this situation?

  1. #VALUE!

  2. #NAME?

  3. #NULL!

  4. #DIV/0!

Answer: C Explanation:

The #NULL! error is produced by Excel when a user attempts to intersect two ranges that do not

intersecteachother.Thiserrorcanberesolved byreviewingtheformulaandthen

eitherby changing the variables to ensure that the user is getting a valid intersection or by using the Excel Iferror function to identify a null range and take the required action.

Answer option D is incorrect. Excel #DIV/0! is produced when a formula attempts to divide by zero and a division by zero produces infinity that cannot be represented by a spreadsheet value. This error can be corrected or overcome by using the Excel IF function to identify a possible division by zero and produce an alternative result.

Answer option A is incorrect. The #VALUE! Excel formula error occurs when any of the variables in a formula is of the wrong type. To correct this error, it is required to check each individual part of the formula to make sure that the correct argument types are used. If the function contains nested functions, the best way is to copy each of the arguments into a separate cell to check what they evaluate to. If the formula contains a number of terms, break down each term further to find out its components, until the source of the error is found.

Answer option B is incorrect. The #NAME? error occurs when Excel encounters text in a formula and tries to interpret that text as a reference, a named range, or a function name but is not able to recognize the text as any of these. The best way to approach the

#NAME?

Excel function error is to check the correct spelling of the function names, references, and named

ranges and to check that the variables used as text values are entered in double quotes. If the

formula contains nested functions, it is required to check the results of these individually, until

the source of the error is identified.

Question No: 40

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another 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.

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

    amp; Filter group.

  2. In the Slicer Connections dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.

  3. In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.

  4. Click the slicer that you want to share in another PivotTable.

Answer: C,D

100% Ensurepass Free Download!
77-888 PDF
100% Ensurepass Free Guaranteed!
77-888 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.