www.cert24.com,test dumps, practice test, pdf 77-882
www.cert24.com,test dumps, practice test, pdf 77-882
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions
77-882 Excel 2010 We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.
www.cert24.com,test dumps, practice test, pdf 77-882
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
www.cert24.com,test dumps, practice test, pdf 77-882