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. 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. Which of the following steps will you take to resolve the problem? Each correct answer represents a part of the solution. Choose all that apply.
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook inMicrosoft Excel 2010. You want to export XMLdata to your Excel 2010 worksheet. On exporting the XML data, the following error message appears:"XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE"Which of the following are the reasons that are causing the above error? Each correct answer represents a complete solution. Choose all that apply.
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.
HOTSPOT -You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2010. 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 call outs. 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:Hot Area:
Rick works as an Office Assistant for Tech Perfect Inc. He is responsible for preparing sales reports of the company. He has created a sales report in a workbook of Excel 2010 and this workbook contains various worksheets as shown in the image given below:Rick wants the sheet tabs of the sheets containing charts to appear in red color. Which of the following steps will Rick take to accomplish the task?
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 delete the slicer. Which of the following steps can you take to accomplish the task?Each correct answer represents a complete solution. Choose all that apply.
