Microsoft 77-888 - Excel 2010 Expert Exam
Page: 3 / 13
Total 61 questions
Question #11 (Topic: Topic 1)
Which of the following is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space?
A. Trendline
B. Line chart
C. Sparkline
D. Backstage view
Answer: C
Question #12 (Topic: Topic 1)
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?
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
Question #13 (Topic: Topic 1)
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.
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.
A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
B. Right-click the slicer, and then click Remove <Name of slicer>.
C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
D. Click the slicer, and then press Delete.
Answer: AC
Question #14 (Topic: Topic 1)
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet as shown below:
[Microsoft-77-888-1.0/xmlfile-16_1.jpg]
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.
[Microsoft-77-888-1.0/xmlfile-16_1.jpg]
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: ABD
Question #15 (Topic: Topic 1)
HOTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open
the application and see various changes in Excel 2010. 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.
Hot Area:
[Microsoft-77-888-1.0/xmlfile-17_1.jpg]
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open
the application and see various changes in Excel 2010. 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.
Hot Area:
[Microsoft-77-888-1.0/xmlfile-17_1.jpg]
Answer: [Microsoft-77-888-1.0/xmlfile-18_1.jpg]
