77-888 Test - Real Exam Questions

Practice Our 77-888 Test Exam Questions and Pass Your Exam Easily.


77-888 Test

If you are looking for free 77-888 dumps than here we have some 77-888 question answers available. You can prepare from our Microsoft 77-888 exam questions practice test and prepare exam with this 
 
You can prepare from these 77-888 exam questions or get help from 77-888 dumps for better preparation.


77-888 Quiz:

Question No :1

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem?
Each correct answer represents a complete solution. Choose all that apply.
A. You are inserting a new column, next to a column that is already formatted as text.
B. Excel is trying to reference an invalid cell.
C. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
D. You are referencing an entire worksheet by clicking on the grey square at the top left of
theworksheet.

Answer: B,D

Question No : 2


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. Goal Seek
B. Solver add-in
C. Data table
D. Scenario

Answer: C

Question No : 3

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:C5,"=Yes")
C. COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
D. COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

Answer: D

Question No :4

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windowsbased network. Rick wants to display data series, categories, data markers, and axes in the report. Which of the following actions will Rick take to accomplish the task?
A. He will use stand-alone slicers.
B. He will create a PivotTable report.
C. He will configure form controls.
D. He will create a PivotChart report.

Answer: D

Question No :5

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windowsbased network. He is creating a form through Microsoft Excel 2010. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use
to accomplish the task?
A. Form control
B. Accounting template
C. Trust Center
D. ActiveX control

Answer: D


page 1 from 1