Excel Chapter 3

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Where does Excel display the Quick Analysis tool?

Bottom-right corner

Which axis in a chart displays the descriptive labels for the data points?

Category

Which of the following is not a chart element?

Chart Foreground

What icon is not displayed when you select a chart?

Chart Types

What is not found on the Chart Elements List?

Chart type

Which chart type displays the data vertically?

Column

Which chart type is best when you want to chart two unrelated data types

Combo chart

Which of the following is not a chart element?

Data area

What group is not found on the Sparkline Tools Design tab?

Format

Which chart element cannot be chosen from the Chart Elements dialog box?

Format Back Wall

What is not true about an effective chart?

It always contains more than one series.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

They are easier to read.

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

Top right

What should you not select when selecting data for a chart?

Worksheet titles

What does Excel not determine about the value axis when you create a chart?

average value

Which chart type displays the data horizontally?

bar

Which chart type is preferable when the category names are long?

bar

Which chart type cannot be displayed as a sparkline?

bar chart

What can you not do from the Select Data Source dialog box?

change chart type

Which group on the Design tab would you select if you wanted to change the source information in the chart?

data

Where does the primary axis display on a Combo chart?

left side

What chart type represents data as spokes going from the center to the outer edge of the chart?

radar

Which chart type is a visual "dashboard" of your data?

sparkline

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

sparkline

Which axis in a chart displays incremental numbers for the data points?

value

In a bar chart, which axis displays the categories?

vertical

Including what, distorts the effectiveness of charting data points?

Aggregates

As a general rule, Pie charts should be limited to how many slices?

7

How many sizing handle are found on embedded charts?

8

In the task pane, what does a diagonal white triangle next to a chart category indicate?

None of the category's options are displayed.

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

Pie

What is not a purpose of using an effective chart?

Reveals even subtle errors in formulas

What is a disadvantage of a stacked column chart?

Segments do not start at the same point.


Kaugnay na mga set ng pag-aaral

Things You Can Do To Improve Your English

View Set

Chapter 17: Transcription, RNA processing, & Translation

View Set

NURSING CONCEPTS NUTRITION AND BOWEL ELIMINATION

View Set

Ex. 02: Best of Homework - Organ Systems Overview

View Set

Chapter 44: Management of Patients with Biliary Disorders

View Set

Chapter 4 Common Gynecologic Issues PrepU

View Set

English 4 Final Speech Study Guide

View Set

Prometni znakovi - Znakovi opasnosti

View Set