Microsoft 77-888 Excel Expert Practice Exams

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Write down your full name. *

Write down your phone number. *

Write down your e-mail address *

QUESTION NO: 1 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’s office have Windows 7 installed, and run Microsoft Office 2010.You are creating a Microsoft Excel 2010 spreadsheet. When the spreadsheet is completed, it must be signed off by your manager.You would like to make provision for this at the end of the spreadsheet.Which of the following actions should you take? *

1 point

A. You should consider making use of the Signature Line option from the Text of the Insert tab

B. You should consider making use of the Footer option from the Header & Footer group of the Insert tab

C. You should consider making use of the Header option from the Header & Footer group of the Insert tab

D. You should consider making use of the SmartArt option from the Illustrations group of the Insert tab

QUESTION NO: 2 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You have been instructed to create a Microsoft Excel 2010 report from an existing TestKing.comsales report. You have been informed that the report you create should provide for the sales report data to be represented graphically, as well as interactively.What option should you choose to achieve this? *

1 point

A. You should consider generating a PivotChart report via the Insert tab.

B. You should consider inserting a chart into the existing report.

C. You should consider making use of SmartArt.

D. You should consider inserting a table into the existing report.

QUESTION NO: 3 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You want to create a Microsoft Excel 2010 project for a project you are currently running. You have decided to make use of the Gantt Chart Template to track the project’s development.Which of the following is TRUE with regards to using the Gantt Chart Template? *

1 point

A. It allows for viewing a maximum of 100 project tasks.

B. It allows for viewing a maximum of 75 project tasks.

C. It allows for viewing a maximum of 50 project tasks.

D. It allows for viewing a maximum of 25 project tasks.

QUESTION NO: 4 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You have previously created a PivotTable report in Microsoft Excel 2010. You want to make sure that you are able to sift data in the easiest way possible.What option should you make use of? *

1 point

A. You should consider inserting a table.

B. You should consider inserting a slicer filter.

C. You should consider creating a PivotChart report

D. You should consider disconnecting the slicer filter.

QUESTION NO: 5 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You are currently working with a Microsoft Excel 2010 spreadsheet. The spreadsheet has a column that displays numerical values returned by a formula You want to view all the formulas in the column.What option should you use? *

1 point

A. You should consider selecting the entire column and using the Text to Columns option from the Data Tools group on the Data tab.

B. You should consider selecting the entire column and using the Filter option from the Sort & Filter group on the Data tab.

C. You should consider selecting the entire column and using the Data Validation option from the Data Tools group on the Data tab

D. You should consider selecting the entire column and using the Group option from the Outline group on the Data tab.

QUESTION NO: 6 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You are working in a Microsoft Excel 2010 sales report that contains the sales stats ofTestKing.com’s top items. You then attempt to reveal the corresponding values for the items.Your attempt is unsuccessful due to the corresponding value not being identifiable by Microsoft Excel 2010. You want to make sure that you are able to compare data.What option could you make use of? *

1 point

A. You should consider making sure that the data being compared is the same type.

B. You should consider making sure that the lookup_value is valid.

C. You should consider making use of the Data Validation option from the Data Tools group on the Data tab.

D. You should consider making use of the Consolidate option from the Data Tools group on the Data tab.

QUESTION NO: 7 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You are creating a sales report using Microsoft Excel 2010. You want to make sure that each product's sales are added up using the least amount of effort.How would you achieve this? *

1 point

A. You should consider accessing the Data tab to select the Group option from the Outline group.

B. You should consider accessing the Data tab to select the Ungroup option from the Outline group.

C. You should consider accessing the Data tab to select the Subtotal option from the Outline group.

D. You should consider inserting a function.

QUESTION NO: 8 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You are creating a sales report using Microsoft Excel 2010. The report has a Total column that has a formula configured.While entering data, you notice that some of the cells in the Total column only display consecutive# symbols.What action should you use to rectify this? *

1 point

A. You should consider increasing the width of the column.

B. You should consider reformatting the cell.

C. You should consider making use of the Data Validation option from the Data Tools group on the Data tab.

D. You should consider making use of the Consolidation option from the Data Tools group on the Data tab

QUESTION NO: 9 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’soffice have Windows 7 installed, and run Microsoft Office 2010.You are creating a sales report using Microsoft Excel 2010. You want to make use of a formula that searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.What function should you include in this formula? *

1 point

A. You should consider making use of the HLOOKUP function.

B. You should consider making use of the VLOOKUP function.

C. You should consider making use of the LOOKUP function.

D. You should consider making use of the INDEX function.

QUESTION NO: 10 You are employed as an office administrator at TestKing.com. All workstations in TestKing.com’s office have Windows 7 installed, and run Microsoft Office 2010.You have been instructed to create an Excel 2010 worksheet that includes three possible budget instances. You have also been informed that, depending on necessity, the solution you choose should be interchangeable.How would you achieve this? *

1 point

A. You should consider making use of the targeted budgeting tool to create the worksheet.

B. You should consider creating a quarterly budget analysis worksheet.

C. You should consider creating a scenario analysis budget worksheet.

D. You should consider creating a flexible budget.

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms