Filters
Question type

Dashboards may include tabular as well as visual data to help a manager to quickly locate key information.

A) True
B) False

Correct Answer

verifed

verified

To select data bars in Excel from the Home tab, which command would have to be accessed?


A) Find & Select under Editing group
B) Conditional Formatting under Styles group
C) Format under Cell group
D) None of the above

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Philip wishes to understand the relative proportion of each data source to the total. Which of the following charts must Philip use?


A) Pie chart
B) Bar chart
C) Scatter chart
D) Column chart

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

Color Scales are one of the options under Conditional Formatting.

A) True
B) False

Correct Answer

verifed

verified

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?


A) Line chart
B) Clustered column chart
C) Pie chart
D) Stacked column chart

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

How is the color-coding of quantitative data commonly called?


A) Heatmap
B) Rainbow
C) Scaling
D) Hot & Cold

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

Win/Loss Sparklines can only be used on quantitative data.

A) True
B) False

Correct Answer

verifed

verified

How does Excel distinguish between vertical and horizontal bar charts?

Correct Answer

verifed

verified

Excel distinguishes between vertical and...

View Answer

Observations consisting of pairs of variable data are required to construct a chart.


A) doughnut
B) scatter
C) radar
D) line

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

Construct a PivotChart to visualize the purchase order total units for steel forks and ceramic bowls within each region.

Correct Answer

verifed

verified

Choose the whole range of data...

View Answer

Showing 21 - 30 of 30

Related Exams

Show Answer