// microsoft · analyzing-and-visualizing-data-with-microsoft-excel

// analyzing and visualizing data with microsoft excel

ANALYZING-AND-VISUALIZING-DATA-WITH-MICROSOFT-EXCEL

Prepare for the Microsoft Excel certification with focused practice and expert guidance to become a proficient data analyst.

questions

in exam

120m

duration

Choose your mode

at a glance

What you get

PDF US$10.00Sub US$10/mopass 700

Free practice questions are available without payment; anyone can start practicing at no cost.

access options

PDF bank or platform subscription?

Two separate purchases: a one-time PDF for 70-779, or a monthly subscription for online practice and simulators across the platform. A subscription does not include the PDF download.

option / 01 · pdf file

Full question bank PDF

US$10.00· one-time

Full question bank as a print-ready PDF
Lifetime access to this exam only
Domain-tagged questions with explanations
Separate from online practice — buy once

option / 02 · subscription

All exams · practice & simulator

US$10.00· per month

Practice & exam simulator on every bank
All current and future exams included
Personal analytics and retention tools
Cancel anytime — no per-exam upsells

Subscribe for platform access

sample · 1 of 71Shuffle

See what's in the bank.

You have a Power Pivot data model that contains a table named DimProduct. DimProduct has seven columns named ProductKey, ProductLabel, ProductName,
ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except Product Name.
What should you do?

Create a perspective that has only the ProductName field from DimProduct selected.

Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.

Edit the Table behavior settings for DimProduct and add ProductName to the Default Label.

Edit the Default Field Set for DimProduct and add ProductName to the Default Field.

04 · coverage

Exam domains

Data Analysis Fundamentals20%

0 q

Data Visualization25%

2 q

Data Manipulation25%

2 q

Advanced Features30%

4 q

Uncategorized89%

63 q

community questionsview all →

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

0.0 · 0 reviews

What candidates say

no reviews yet

Analyzing and Visualizing Data with Microsoft Excel

Prepare for the Microsoft Excel certification with focused practice and expert guidance to become a proficient data analyst.

// OFFICIAL EXAM LOGISTICS

source · microsoft

// PASSING SCORE

750 / 1000· scaled

minimum to pass

75%of scale

// QUESTIONS

40official

// DURATION

120min

// EXAM FEE

165usd

// ITEM TYPES

multiple choice

multiple response

case study

// questions

98in bank

// pass rate

92%self-reported

// last update

7h agoago

// add cadence · 12w

// downloadable pdf bank

Get the whole bank as a PDF

Every question tagged by domain, with a detailed explanation. Preview the first pages free — buy once for lifetime access to the full PDF.

98 questions

// what's inside

98 exam-style questions with verified answers
Every question tagged by domain (4 domains covered)
A detailed explanation / rationale for every question

// sample · 1 of 71

See what's in the bank.

Shuffle

#00415957-dad2-41ca-b662-a9feccbda639D1 · Hybridhard

↑ +47· 7 comments· seen 1,284×

Create a perspective that has only the ProductName field from DimProduct selected.

Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.

Edit the Table behavior settings for DimProduct and add ProductName to the Default Label.

Edit the Default Field Set for DimProduct and add ProductName to the Default Field.

Community converges on B. Official key confirms.

0 votes · last validated recently

// explanation

BFD with a 300 ms interval × multiplier 3 = 900 ms detection, well under one second. Combined with a redundant Direct Connect at a different DX location, BGP withdrawal handles the cutover cleanly. Tightening BGP timers alone causes flap during normal jitter; switching VIF types is not a failover mechanism.

contributed by

@netdiver· revised by @cloud_chris

← previous

// coverage · 5 domains

What this bank tests.

microsoft exam blueprint

Data Analysis Fundamentals0 q

20%

Data Visualization2 q

25%

Data Manipulation2 q

25%

Advanced Features4 q

30%

—

Uncategorized63 q

89%

// composition

By format & difficulty.

71 total

// by format

99%

single · 70multi · 1

// by difficulty

easy

2· 25%

medium

6· 75%

// contributors · 0 engineers

Built by people who took the exam.

Every question is contributed by someone who recently sat 70-779, then reviewed by an SME before landing in the bank. These are the most prolific contributors.

view leaderboard →

No contributors for this exam yet. Be the first to contribute a question.

// own this exam?Contribute a question, earn +10 points per approval, climb the leaderboard.

// community questions

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

// compare

One bank, or the whole platform?

this bank

$10.00· one-time

platform · subscribed

$10.00· per month

This bank

All other banks · 23+ exams

Lifetime access

All future updates included

Personal analytics + retention

Cancel anytime

—

// 0 reviews

0.0/ 5

No reviews yet. Be the first to share your experience with this question bank.

// faq

Things buyers ask before they buy.

open help center →

Can I practice for free?

Free practice questions are available without payment; anyone can start practicing at no cost.

What do subscribers get?

Subscribers unlock the full practice question bank for each certification exam.

How much can I see without a subscription?

Approximately 1/2 of the question bank is accessible without a subscription.

What is the passing score?

The official passing mark for this exam is 700.

How long is the certification valid?

The certification is valid for 2 years. Renew by passing the latest version of the exam or completing continuing education credits.

What experience is recommended?

1-2 years of experience working with Excel, including data analysis and visualization tasks.

// related

ANALYZING-AND-VISUALIZING-DATA-WITH-MICROSOFT-EXCEL

What you get

PDF bank or platform subscription?

Full question bank PDF

All exams · practice & simulator

See what's in the bank.

Exam domains

Questions from the community

What candidates say

You may also like

Analyzing and Visualizing Data with Microsoft Excel

Get the whole bank as a PDF

See what's in the bank.

What this bank tests.

By format & difficulty.

Built by people who took the exam.

Questions from the community

One bank, or the whole platform?

Things buyers ask before they buy.

You may also like