Online Access Free 77-882 Exam Questions

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.

How can you display the formula as a value?

• A.You should consider deselecting the Show Formulas option on the Formulas tab.
• B.You should consider changing the format of the cell.
• C.You should consider removing the blank space in the cell before the formula.
• D.You should consider clicking the Evaluate Formula option on the Formulas tab.

You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for
creating various types of reports. You have created a report in the format given below:

In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the
B7 cell. Which of the following formulas will provide the required result?

• A.COUNTIF(B2:C5,"=Yes")
• B.COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
• C.COUNTIFS(B2:C5,"=Yes")
• D.COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")

You work as Technical Support personnel for Media Perfect Inc. You have created a worksheet in
Excel. The worksheet contains the sales data as shown in the image given below:

You are required to predict the future sales target of Sasha based on her current figures. The future
prediction should be based on linear trend. The chart must be able to predict future sales figure for
at least next three intervals. Take the required steps to accomplish the task.

Correct Answer:

Explanation:
According to the question, you are required to summarize the sales data of Sasha and predict her
future sales target based on the current sales figure. The question also states that the future
prediction should be based on linear trend. Furthermore, the chart must predict future sales figure
for at least next three intervals. In order to accomplish the task, you will have to take the following
steps:
Select the chart. Click the Trendline option in the Analysis group on the Layout tab. Click the
More Trendline option. Select the Linear radio-button in the Trend Type section. Provide value 3
for the Forward Forecast period. The linear trendline uses a best-fit straight line to display simple
linear data sets that contain data values that increase or decrease at a steady rate. This type of
trendline uses the following linear equation:
y = mx + b
Here, m is the slope and b is the intercept.
Here, m is the slope and b is the intercept.

It will not forecast the sales figure for next three intervals.
The backward forecast stretches trend line for backward intervals.

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?

• A.Select all rows in the table. Drag the border of one of the selected rows to the required height.
• B.Select all rows in the table. Click the Format option in the Cells group on the Home tab. Click
  Row Height. In the Row Height dialog box, provide the required value.
• C.Select all rows in the table. Right-click on the selected rows and click the Row Height option. In
  the Row Height dialog box, provide the required value.
• D.Select individual rows. Drag the border of rows to the required height.

Kara Lang works as the Human Resources manager at ABC.com. She is using Microsoft Office Excel 2010 to create a workbook. The workbook will be used to record days taken off for vacations or illness.
The company contains departments named Sales, Marketing, Production and IT.
Kara often needs to enter the names of company employees when she creates workbooks. Kara wants to be able to use the Fill Handle function to ease the task of entering names in a workbook. She asks you for assistance in enabling the Fill Handle function.
How can you help Kara?

• A.You should advise Kara to create a workbook saved as a template for each department that contains the names of the employees.
• B.You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate rows for each department.
• C.You should advise Kara to create a single workbook saved as a template with the names of the employees listed in separate columns for each department.
• D.You should advise Kara to create a custom list for each department that contains the names of the employees.