Free Microsoft 77-882 Exam Dumps Questions & Answers
| Exam Code/Number: | 77-882Join the discussion |
| Exam Name: | Excel 2010 |
| Certification: | Microsoft |
| Free Question Number: | 90 |
| Publish Date: | Aug 08, 2026 |
| # of views: | 2545 |
|
|
|
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales
incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a
worksheet for preparing the report. You have inserted the sales figures of all sales managers as
shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total
first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to
the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8
cell. Which of the following formulas will you insert to accomplish the task?
You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network. Some of the workbooks have the same name.
To avoid any confusion over which workbook you are currently working on, you want to display the full path and file name of the workbook in the workbook.
Which combination of the following actions would configure the workbook to display the filename and path in a worksheet cell? Choose all that apply.
You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003.
The computers in the Sales office run either Windows 7 Professional or Windows XP Professional.
All computers have monitors with the display resolution set to 1024 x 768 pixels.
A sales assistant named Kara Lang complains that she does not see all of the icons or the text to describe the commands on the Ribbon when compared to other computers.
What should you do to resolve the problem?
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Excel 2010.
He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will
choose to accomplish the task.
You work as an Office Assistant for Blue Well Inc. You are creating a report in a worksheet in
Excel. You have prepared a table as shown below:
You want to increase the height of each row in such a manner that all rows have the same height.
Which of the following steps will you take to accomplish the task easily?