original questions 77-882 Microsoft cert24
original questions 77-882 Microsoft cert24
Every Certification candidate knows how costly it can be to obtain relevant and reliable dumps for exams. Our products are cost-effective and come with one year of free updates. Our Certification solutions are readily available from our website! A leading provider of quality exams dumps, We have the Exam you need to pass your test. 
77-882 Excel 2010 The Certification study materials that can provide are based on the extensive research and experiences from our online trainers, with over 10 years of IT and certification experience. study materials, including questions and answers feed into our larger product base.
original questions 77-882 Microsoft cert24
QUESTION NO: 1
Your work at ABC.com includes the preparation of workbooks using Microsoft Office Excel 2010.
You have finished a lengthy report about product sales for the past year and project sales for the next year. The workbook lists the name of a product multiple times.
The company releases a new version of the product and the product name is changed to reflect the update.
You want to use the Replace dialog box to change every instance of the product name throughout the spreadsheet.
Which of the following key combinations opens the Replace dialog box?
A. Ctrl + R
B. Ctrl + B
C. Ctrl + H
D. Ctrl + F
Answer: C
QUESTION NO: 2
You work as the Financial Director at ABC.com. You are using Microsoft Office Excel 2010 to review the end-of-year financial reports from the ABC.com Sales department and from a partner company named Weyland Industries.
Weyland Industries is based in Mexico. The Weyland Industries financial report contains some text written in Spanish. To discover the meaning of the Spanish text, you navigate to the Proofing group on the Review tab and click the Translate button.
Which of the following would also give you the option to translate the Spanish text?
A. The Lookup and Reference function in the Function Library group on the Formulas tab.
B. The Format option in the Cells group on the Home tab.
C. The Research function in the Proofing group on the Review tab.
D. The Thesaurus function in the Proofing group on the Review tab.
Answer: C
QUESTION NO: 3
Your work as a Sales Administrator in the ABC.com Sales office includes the production of
workbooks using Microsoft Office Excel 2010.
You are working on a Sales report for the last quarter. You insert a table into a worksheet and populate the table with the names of the Sales people and their total sales over the last three months.
Which of the following Excel functions can you NOT do if your workbook contains a table?
A. You will be unable to mark the workbook as final.
B. You will be unable to share the workbook.
C. You will be unable to encrypt the workbook.
D. You will be unable to run the Document Inspector.
Answer: B
original questions 77-882 Microsoft cert24