Free Microsoft 77-888 Exam Dumps Questions & Answers

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are
facing a problem that when you type in a function and press Enter, the cell shows the function as
you typed it, instead of returning the function's value as shown below:
Which of the following is the reason that is causing the above problem?

• A.You are inserting a new column, next to a column containing Dates or Times.
• B.Excel is trying to reference an invalid cell.
• C.You are inserting a new column, next to a column that is already formatted as text.
• D.The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.

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.Backstage view
• C.Line chart
• D.Sparkline

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common
variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?

• A.Scenario
• B.Goal Seek
• C.Solver add-in
• D.Data table

HOTSPOT
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are required to set the security level temporarily for enabling all macros. Mark the option that you will choose first to accomplish the task.

Correct Answer:

Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Click Compare and Merge Workbooks on Quick Access Toolbar.
• B.Add Compare and Merge Workbooks.
• C.Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.
• D.Open the copy of the shared workbook to merge the changes.
• E.Save the workbook if prompted.
• F.In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.