Free 77-882 Exam Braindumps

Pass your 77-882 exam with these free latest Questions and Answers


  • Exam Code: 77-882
    Exam Title: - Excel 2010 (RETIRED)
  • Provider: Microsoft
  • Questions: 50
  • Updated On: 22-Jan-2023


QUESTION: 1
You work in the Sales office at Company.com. You use Microsoft Office Excel 2010 to create
company sales reports.
It is the end of the financial year and you are working on a final sales report for the year. A copy
of the report wil be handed out to Sales Account Managers and Senior Management for
discussion in an annual Sales Review meeting.
There are five worksheets in the workbook, one worksheet for each quarter and a fifth
worksheet with combined totals and analysis of the quarterly figures.
You have entered all the data for each quarter and configured tables for the data. On the fifth
worksheet, you have included graphical representations of the data using various types of
charts.
You now want apply a consistent formatting across the entire workbook. You want to give the
workbook a professional look by applying graphics effects, light colors and easy to read fonts.

What is the easiest way to prepare the workbook?

A. You should configure a custom view to the workbook.
B. You should apply a Theme to the workbook.
C. You should use the Cell Styles function.
D. You should select all the cells in the first worksheet and apply suitable formatting. Repeat the
process for the remaining worksheets.

Answer(s): B

QUESTION: 2
You work as the Finance Manager at Company.com. It is the end of the financial year and you
are auditing the accounts for the last year. You have imported the records from last year's
company bank statements into a Microsoft Office Excel 2010 workbook.
You want to list all payments to a partner company named Weyland Industries with the category
name of Services.

How can you configure the workbook to display only the records that contain Weyland Industries
and Services?

A. You should consider making use of the Sort Ascending function.
B. You should consider making use of the Sort Descending function.
C. You should consider making use of the AutoFilter function.
D. You should consider making use of the Hide function.

Answer(s): C
QUESTION: 3
You work as the Sales Manager at Company.com. You are using Microsoft Office Excel 2010 to
create a sales report.
The report contains the table shown below.

You want to include a chart in the report to display a graphical comparison of the sales figures
for the sales staff listed in the table.


2

Post your Comments and Discuss Microsoft 77-882 with other Community members:


Guss
Please, I need this exam.
FRANCE
Upvote


m7md ibrahim
i think answer of Q 462 is variance analysis
Anonymous
Upvote


Shahzad
Does anybody Pass this Exam
Anonymous
Upvote


Siri
Yes, please upload
INDIA
Upvote


Mirex
Am preparing for Exam ,Just nice questions
Anonymous
Upvote


John smith
hell not bad
Anonymous
Upvote


kenny Rollan
not bad. U can try yourself
Anonymous
Upvote


Sam
Thank you for providing these dumps for free. It is truly appreciated!
AUSTRALIA
Upvote


Abdollah
can anyone send me the dump please abdullahmokhlis76@gmail.com
UNITED STATES
Upvote


Basit
please send me on baxit.ashraf@yahoo.com
Anonymous
Upvote


Tehu
Hi I need see questions
Anonymous
Upvote


Aoue
Good short test
Anonymous
Upvote


Ram
Best Questions
UNITED STATES
Upvote


Raj
Nice questions
UNITED STATES
Upvote


Suresh
Nice Questions
UNITED STATES
Upvote


Revanth
Question number 22 answer was wrong.
INDIA
Upvote


Jay jain
This is nice platform
Anonymous
Upvote


Korea
excelent material
KOREA REPUBLIC OF
Upvote


Timbo
Study questions were perfect, prepared me well!
SOUTH AFRICA
Upvote


Yady
These questions look good.
SINGAPORE
Upvote


Terry
I can practice for exam
Anonymous
Upvote


Anonymous
Is there any difference in format or questions if we study from 8.7dump CSA and give exam for latest version 8.8?
Anonymous
Upvote


abdo jms
yes i need it
Anonymous
Upvote


BLESSING
Hello, I need the dumps
Anonymous
Upvote


Rekha
Useful dump
Anonymous
Upvote


Guss
Hi, could you please upload NS0-527, thx in advance
Anonymous
Upvote


Japles
Password lockout being the correct answer for question 37 does not make sense. It should be geofencing.
Anonymous
Upvote


Synt
need to view
UNITED STATES
Upvote


QA Automation
Can you please upload back?
UNITED KINGDOM
Upvote


Guss
Hi, could you please add the last update of NS0-527
Anonymous
Upvote

DOWNLOAD PREMIUM VERSION

Get All 50 Questions
in PDF Format

FOR $32.00 ONLY