Question # 1
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 to create
different
reports for your company. Drag and drop the appropriate methods for efficient data entry in
front
of their descriptions.
|
Question # 2
You work as a Sales Manager for Maini Industries. Your company manufactures and sells
construction equipment. You have to create a report that will show the highest selling items
of
each month. The report will be in the following format:
For the third column of the sheet, you want to use formulas to fill in the values. You want
the
cells in the third column to get automatically filled with the names corresponding to ItemID
in the second column. You want the exact values to be filled in the column. You select the
C2 cell in the third column.
Which of the following formulas will you enter in order to accomplish the task?
| | A. =VLOOKUP(B2,Item_table,2,FALSE)
| | B. VLOOKUP(B2,Item_table,2,TRUE)
| | C. =VLOOKUP(2,Item_table,B2,FALSE)
| | D. =VLOOKUP(2,Item_table,B2,TRUE) |
A. =VLOOKUP(B2,Item_table,2,FALSE)
In order to accomplish the task, you will use the following formula:
=VLOOKUP(B2,Item_table,2,FALSE)
Answer option B is incorrect. According to the question, you want the exact values in the
column.
The TRUE value in the range_lookupargument provides the approximate match.
Answer options C and D are incorrect. The VLOOKUP functions used in the formulas have
wrong syntaxes.
Question # 3
You work as an Office Manager for Blue Well Inc. The company has a Windows-based
network. You have two budget situations in which one is the worst case and the other is the
best case. You want to create both situations on the same worksheet and then switch
between them with the change in requirements. Which of the following will you use to
accomplish the task?
| | A. Goal Seek
| | B. Data table
| | C. Scenario
| | D. Solver add-in |
A scenario is defined as a type of what-if analysis tools. It is a set of values saved by Excel
and
can be substituted automatically in cells on a worksheet. A user can create and save
different
groups of values on a worksheet and then switch to any of these new scenarios to view
different
results. Scenario reports are not automatically recalculated. If the user changes the values
of a
scenario, those changes will not be displayed in an existing summary report and he must
create a
new summary report to show the reflection of the changed report.Answer option A is
incorrect.
Goal Seek is defined as a type of what-if analysis tools. It is used if a user knows the result
that he wants from a formula, but he is not sure what input value the formula needs to get
that
result. It works with only one variable input value.Answer option D is incorrect. The Solveradd-in is used if a user knows the result that he
wants from a formula, but he is not sure whatinput value the formula needs to get that
result. It is used for more than one input value. Itworks with a group of cells related to the
formula in the objective cell. Answer option B isincorrect. A data table is used to see all the
outcomes in one place. It is defined as a type ofwhat-if analysis tools. It is used if a user
has a formula that uses one or two variables ormultiple formulas that all use one common
variable. It is used to examine a range of possibilitiesat a glance and since the user
focuses on only one or two variables, results are easy to read andshare in tabular form. If
automatic recalculation is enabled, it is possible to recalculate thedata in data tables
immediately and as a result, the user always gets fresh data.
Question # 4
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through
Microsoft
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the
option that he will choose to accomplish the task.
|
Question # 5
You work as an Office Assistant for Tech Tree Inc. You have created a report in a
workbook in Microsoft Excel 2010. You have included various subtotals in a worksheet in
the report to verify data accuracy. You want to remove all subtotals from the sheet before
you send it to your manager.
Which of the following steps will you take to accomplish the task with the least
administrative effort?
| | A. Select all the subtotals.From the shortcut menu, click the Remove All Subtotals option.
| | B. Hide the rows containing subtotals.
| | C. Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the
Data
tab. Click the Remove All button.
| | D. Delete all the rows containing subtotals. |
C. Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the
Data
tab. Click the Remove All button.
Question # 6
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 |
D. Protect Workbook Structure
The various Protect Workbook options are as follows:
1.Mark as Final: This option is used to make the document read-only. When a spreadsheet
is marked as final, various options such as typing, editing commands, and proofing marks
are disabled or turned off and the spreadsheet becomes read-only. This command helps a
user to communicate that heis sharinga completed version ofa spreadsheet.This command
also preventsreviewersor readers from making inadvertent modifications to the
spreadsheet.
2.Encrypt with Password: When a user selects the Encrypt with Password option, the
Encrypt Documentdialog box appears. In the Password box, it is required to specify a
password. Microsoft is notable to retrieve lost or forgotten passwords, so it is necessary for
a user to keep a list ofpasswords and corresponding file names in a safe place.
3.Protect Current Sheet: This option is used to select password protection and permit or
prohibit
other users to select, format, insert, delete, sort, or edit areas of the spreadsheet. This
option
protects the worksheet and locked cells.
4.Protect Workbook Structure: This option is used to select password protection and select
optionsto prevent users from changing, moving, and deleting important data. This feature
enables a user toprotect the structure of the worksheet.
5.Restrict Permission by People: This option works on the basis of Window Rights
Management torestrict permissions. A user is required to use a Windows Live ID or a
Microsoft Windows account torestrict permissions. These permissions can be applied via a
template that is used bythe organization in which the user is working. These permissions
can also be added by clickingRestrict Access.
6.Add a Digital Signature: This option is used to add a visible or invisible digital signature. It
authenticatesdigitalinformationsuchasdocuments,e-mailmessages,andmacrosby
using computer cryptography. These signatures are created by specifying a signature or by
using an image of a signature for establishing authenticity, integrity, and non-repudiation.
Question # 7
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet as
shown below:
You want to use Excel Transpose Function for copying the contents of cells B1:B3 into
cells A5:C5.
You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel
#VALUE! error message because the cells are working independently and the function will
not work for each individual cell. Therefore, it is required to make the cells A5:C5 work
together as an ARRAY. For this purpose, you are required to use an array formula. Which
of the following steps will you take to input Excel array formulas in the spreadsheet?
Each correct answer represents a part of the solution. Choose all that apply.
| | A. Type the array formula into the first cell.
| | B. Highlight the range of cells that you want to use as an input in his array formula.
| | C. Press CTRL-SHIFT-Tab to remove the error message.
| | D. Press CTRL-SHIFT-Enter. |
A. Type the array formula into the first cell.
B. Highlight the range of cells that you want to use as an input in his array formula.
D. Press CTRL-SHIFT-Enter.
The following steps are taken to input Excel array formulas:
1.Highlight the range of cells that a user wants to use as an input in his array formula.
2.Type the array formula into the first cell or make this cell editable by pressing F2 or
clicking
in theformula bar if a user has already specified a value into the first cell.
3.Press CTRL-SHIFT-Enter.
Answer option C is incorrect. This is an invalid answer option.
Microsoft 77-888 Exam Dumps
5 out of 5
Pass Your Excel 2010 Expert Exam in First Attempt With 77-888 Exam Dumps. Real Microsoft Office Certification Exam Questions As in Actual Exam!
— 62 Questions With Valid Answers
— Updation Date : 3-Oct-2024
— Free 77-888 Updates for 90 Days
— 98% Excel 2010 Expert Exam Passing Rate
Speciality
Additional Information
Testimonials
Related Exams
- Number 1 Microsoft Microsoft Office Certification study material online
- Regular 77-888 dumps updates for free.
- Excel 2010 Expert Practice exam questions with their answers and explaination.
- Our commitment to your success continues through your exam with 24/7 support and long after with discounts on future study programs.
- Free 77-888 dumps updates for 90 days
- 97% more cost effective than traditional training
- Excel 2010 Expert Practice Questions to boost your knowledge
- 100% correct Microsoft Office Certification questions answers compiled by senior IT professionals
Microsoft 77-888 Braindumps
Realbraindumps.com is providing Microsoft Office Certification 77-888 braindumps which are accurate and of high-quality verified by the team of experts. The Microsoft 77-888 dumps are comprised of Excel 2010 Expert questions answers available in printable PDF files and online practice test formats. Our best recommended and an economical package is Microsoft Office Certification PDF file + test engine discount package along with 3 months free updates of 77-888 exam questions. We have compiled Microsoft Office Certification exam dumps question answers pdf file for you so that you can easily prepare for your exam. Our Microsoft braindumps will help you in exam. Obtaining valuable professional Microsoft Microsoft Office Certification certifications with 77-888 exam questions answers will always be beneficial to IT professionals by enhancing their knowledge and boosting their career.
Yes, really its not as tougher as before. Websites like Realbraindumps.com are playing a significant role to make this possible in this competitive world to pass exams with help of Microsoft Office Certification 77-888 dumps questions. We are here to encourage your ambition and helping you in all possible ways. Our excellent and incomparable Microsoft Excel 2010 Expert exam questions answers study material will help you to get through your certification 77-888 exam braindumps in the first attempt.
Pass Exam With Microsoft Microsoft Office Certification Dumps. We at Realbraindumps are committed to provide you Excel 2010 Expert braindumps questions answers online. We recommend you to prepare from our study material and boost your knowledge. You can also get discount on our Microsoft 77-888 dumps. Just talk with our support representatives and ask for special discount on Microsoft Office Certification exam braindumps. We have latest 77-888 exam dumps having all Microsoft Excel 2010 Expert dumps questions written to the highest standards of technical accuracy and can be instantly downloaded and accessed by the candidates when once purchased. Practicing Online Microsoft Office Certification 77-888 braindumps will help you to get wholly prepared and familiar with the real exam condition. Free Microsoft Office Certification exam braindumps demos are available for your satisfaction before purchase order.
Send us mail if you want to check Microsoft 77-888 Excel 2010 Expert DEMO before your purchase and our support team will send you in email.
If you don't find your dumps here then you can request what you need and we shall provide it to you.
Bulk Packages
$60
- Get 3 Exams PDF
- Get $33 Discount
- Mention Exam Codes in Payment Description.
Buy 3 Exams PDF
$90
- Get 5 Exams PDF
- Get $65 Discount
- Mention Exam Codes in Payment Description.
Buy 5 Exams PDF
$110
- Get 5 Exams PDF + Test Engine
- Get $105 Discount
- Mention Exam Codes in Payment Description.
Buy 5 Exams PDF + Engine
 Jessica Doe
Microsoft Office Certification
We are providing Microsoft 77-888 Braindumps with practice exam question answers. These will help you to prepare your Excel 2010 Expert exam. Buy Microsoft Office Certification 77-888 dumps and boost your knowledge.
|
