Changing Chart Types

10 Questions | By Nsurani | Updated: Mar 21, 2022 | Attempts: 324

Questions

Settings

Create your own Quiz

Questions and Answers

1.

In Which of these Tab "Change Chart Type" option Found ?
- A.
  
  Design
- B.
  
  Format
- C.
  
  Layout
2.

Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
- A.
  
  True
- B.
  
  False
3.

Having Created the Chart Which new Tab Genrate for use the option Change Chart Type ?
- A.
  
  View
- B.
  
  Design
- C.
  
  Data
4.

in which Group of design Tab Change Chart Type option Located ?
- A.
  
  Type
- B.
  
  Data
- C.
  
  Chart layout
5.

If you want to move your chart location, which tab on the Chart Tools Ribbon is the Move Chart option found on?
- A.
  
  Page Layout.
- B.
  
  Format.
- C.
  
  Layout.
- D.
  
  Design.
6.

If you change one or more of the numbers in a worksheet from which a chart was derived, how will the chart respond?
- A.
  
  The chart will change automatically to reflect the new numbers.
- B.
  
  The chart will not respond in any way, no matter how many numbers you change. Once a chart has been created, it never changes.
- C.
  
  The chart will display an error message reminding you to start the Chart Wizard and update the chart.
- D.
  
  A second copy of the chart will be automatically created so that you have before and after images of the chart.
7.

What can you use to add arrows, lines, ovals, rectangles, and callouts to your chart?
- A.
  
  Format Legend dialog box.
- B.
  
  Change Chart Type.
- C.
  
  Shapes.
- D.
  
  Size.
8.

What does Excel call the element normally found at the top of a chart that is used as an informative header?
- A.
  
  Chart title.
- B.
  
  Data labels.
- C.
  
  Subtypes.
- D.
  
  Data table.
9.

In order to create a meaningful bar, line, pie, or column chart in Excel, what must your worksheet have present and available for selection before you create the chart?
- A.
  
  Numbers and labels.
- B.
  
  Formulas and functions.
- C.
  
  A column of numbers sorted in descending order.
- D.
  
  An operand.
10.

We can Change the Charts with shapes.
- A.
  
  True
- B.
  
  False