Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. Microsoft
  3. Microsoft Office Specialist
  4. 77-882 - Excel 2010

Microsoft 77-882 Excel 2010 Exam Practice Test

Note! Following 77-882 Exam is Retired now. Please select the alternative replacement for your Exam Certification.
Page: 1 / 3
Total 25 questions
Get 77-882 Full Access Download 77-882 PDF

Excel 2010 Questions and Answers

Question 1

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?

Options:

A.

COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")

B.

COUNTIFS(B2:C5,"=Yes")

C.

COUNTIF(B2:C5,"=Yes")

D.

COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

Question 2

You are creating a business report by using Microsoft Excel 2010. You have arranged sales data as shown below:

You want to provide pictorial representation of the trend of these sales data in front of each row. Which of the following steps will you choose to accomplish the task involving the least amount of administrative burden?

Options:

A.

Use charts.

B.

Use illustrations.

C.

Use conditional formatting.

D.

Use spark lines.

Question 3

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:

VLOOKUP(12, A2:C10, 3, FALSE )

Which of the following actions will be performed by the formula?

Options:

A.

Search the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.

B.

Wrong syntax used.

C.

Search the value 12 in the third column of the range and then returns the value that is

contained in the 12th column of the range and on the same column as the lookup value.

D.

Search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

Load More 77-882 Questions 
Page: 1 / 3
Total 25 questions
Get 77-882 Full Access Download 77-882 PDF