Question 1

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures.
Describe which chart type you should use to show how three of the departments compared to each other for all of the quarters.

Accepted Answer

The answer of You put together a spreadsheet for your...

Question 2

Match between columns
                        Premises: The chart type that shows the relationship between two kinds of related data.

Accepted Answer

The Answer of area and column and line and pie is...

Question 3

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures.
Describe which chart type(s) you should use to display how all of the departments performed for the first quarter.

Accepted Answer

The answer of You put together a spreadsheet for your...

Question 4

Match between columns
                        Premises: The chart type that describes the relationships of parts to the whole.

Accepted Answer

The Answer of pie and column and area and line is...

Question 5

Describe how to print a chart without printing the worksheet data.

Accepted Answer

The answer of Describe how to print a chart without...

Question 6

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

Accepted Answer

The answer of A(n) _____________________ in a chart is a...

Question 7

Compare a chart layout to a chart style.

Accepted Answer

The answer of Compare a chart layout to a chart...

Question 8

The Chart ________________ gallery shows four Colorful palette options and several Monochromatic palette options.

Accepted Answer

The answer of The Chart ________________ gallery shows four Colorful...

Question 9

Match between columns
                        Premises: The chart type that compares values across categories over time.

Accepted Answer

The Answer of scatter and area and line and column is...

Question 10

Match between columns
                        Premises: The chart type that shows trends by category over time.

Accepted Answer

The Answer of column and area and line and pie is...

Question 11

Match between columns
                        Premises: The chart type that shows the relative importance of values over a period of time.

Accepted Answer

The Answer of line and pie and scatter and area is...

Question 12

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

Accepted Answer

The answer of The _____________________ is the part of the...

Question 13

Your supervisor has created a spreadsheet and a chart is included in the workbook.
Your supervisor thinks the chart legend is too large, how should you fix the chart?

Accepted Answer

The answer of Your supervisor has created a spreadsheet and...

Question 14

Your supervisor has created a spreadsheet and a chart is included in the workbook.
Describe how you should change the chart to have an overall theme of purple elements.

Accepted Answer

The answer of Your supervisor has created a spreadsheet and...

Question 15

You put together a spreadsheet for your company containing the quarterly sales figures for each region. Each column of the spreadsheet represents a quarter and each row represents a department's figures.
Describe which chart type you should use to show how each quarter contributed to the total sales for a single department.

Accepted Answer

The answer of You put together a spreadsheet for your...

Question 16

To remove a data table from a chart click the Data Table check box in the Chart _____________ menu to remove it.

Accepted Answer

The answer of To remove a data table from a...

Question 17

Primary Major Horizontal is an example of a type of  _____________________.

Accepted Answer

The answer of Primary Major Horizontal is an example of...

Question 18

Explain what a data table is.

Accepted Answer

The answer of Explain what a data table is....

Question 19

On the Chart Tools Format tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

Accepted Answer

The answer of On the Chart Tools Format tab, click...

Question 20

The Offset Bottom Shadow style is an example of a shape _______________ that can be added to a chart element.

Accepted Answer

The answer of The Offset Bottom Shadow style is an...

Quiz 4: Excel

Match each item with a statement below.

Match each item with a statement below.

Describe how to print a chart without printing the worksheet data.

A(n) _____________________ in a chart is a grid containing the chart's underlying worksheet data.

Compare a chart layout to a chart style.

The Chart ________________ gallery shows four Colorful palette options and several Monochromatic palette options.

Match each item with a statement below.

Match each item with a statement below.

Match each item with a statement below.

The _____________________ is the part of the chart contained within the horizontal and vertical axes.

Your supervisor has created a spreadsheet and a chart is included in the workbook. Your supervisor thinks the chart legend is too large, how should you fix the chart?

Your supervisor has created a spreadsheet and a chart is included in the workbook. Describe how you should change the chart to have an overall theme of purple elements.

To remove a data table from a chart click the Data Table check box in the Chart _____________ menu to remove it.

Primary Major Horizontal is an example of a type of _____________________.

Explain what a data table is.

On the Chart Tools Format tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

The Offset Bottom Shadow style is an example of a shape _______________ that can be added to a chart element.