Download Excel 2010 Expert.braindumps.77-888.v4-0.2018-12-21.1e.35q.vcex


Download Exam

File Info

Exam Excel 2010 Expert
Number 77-888
File Name Excel 2010 Expert.braindumps.77-888.v4-0.2018-12-21.1e.35q.vcex
Size 1.5 Mb
Posted December 21, 2018
Downloads 26



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

Question 1
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 at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub" 
Which of the following are the next steps that you will take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.

  • A: Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.
  • B: Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.
  • C: Reopen the workbook.
  • D: Click OK in the message box.



Question 2
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: 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.
  • B: Click Compare and Merge Workbooks on Quick Access Toolbar.
  • C: Open the copy of the shared workbook to merge the changes.
  • D: Save the workbook if prompted.
  • E: Add Compare and Merge Workbooks.
  • F: Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.



Question 3
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history. 
Which of the following will you use to accomplish the task? 
Each correct answer represents a complete solution. Choose all that apply.

  • A: History tracking
  • B: Onscreen highlighting
  • C: Slicer-enabled highlighting
  • D: Reviewing of changes



Question 4
You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team Using Microsoft Excel. You want the report to appear in the following format:

  

You want the Remark column to be filled through a conditional formula. The criteria to give the remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done"  
If the sales of the First Quarter is less than 1200, display "Improve in Next Quarter" 
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

  

Which of the following conditional formulas will you insert to accomplish the task?

  • A: =IF(E2>=1200,"Improve in Next Quarter","Well Done")
  • B: =IF(E2<=1200,"Well Done","Improve in Next Quarter")
  • C: =IF(E2>=1200,"Well Done","Improve in Next Quarter")
  • D: =IF(E2>1200,"Improve in Next Quarter","Well Done")



Question 5
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?

  • A: =&B&3/100 * E8
  • B: =B3/100 * E8
  • C: =B3/100 * &E&8
  • D: =$B$3/100 * E8
  • E: =B3/100 * $E$8



Question 6
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")



Question 7
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

  • A: Mark as Final
  • B: Encrypt with Password
  • C: Protect Current Sheet
  • D: Protect Workbook Structure



Question 8
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task? 
Each correct answer represents a part of the solution. Choose all that apply.

  • A: Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.
  • B: The Macro will be run in any worksheet of the Workbook.
  • C: Put the workbook in a trusted location.
  • D: The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.
  • E: Run the created Macro by using the shortcut key specified while creating the Macro.



Question 9
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 that is already formatted as text.
  • B: Excel is trying to reference an invalid cell.
  • C: You are inserting a new column, next to a column containing Dates or Times.
  • 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.



Question 10
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data. 
Which of the following options will you choose to accomplish the task?

  • A: Mark as Final
  • B: Protect Current Sheet
  • C: Encrypt with Password
  • D: Protect Workbook Structure








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset