INTERMEDIATE EXCEL FINAL
QUESTIONS AND ANSWERS
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? -
Correct Answers -Numbers and labels.
What does Excel call the element normally found at the top of a chart that is used as an
informative header? - Correct Answers -Chart title.
What chart option allows you to insert labels such as a number, percentage, or category
name to each column, line, or pie slice of a chart? - Correct Answers -Data labels.
If you want to move your chart location, which tab on the Chart Tools Ribbon is the
Move Chart option found on? - Correct Answers -Design
If you change one or more of the numbers in a worksheet from which a chart was
derived, how will the chart respond? - Correct Answers -The chart will change
automatically to reflect the new numbers.
Which chart type fills gaps in knowledge about the collected data? - Correct Answers -
Line
Which chart type do scientists, engineers, and statisticians use to create scatter plots? -
Correct Answers -X Y scatter
Which chart type allows you to associate three numbers with each data point? - Correct
Answers -Bubble
Which type of chart works like a pie chart but can graph multiple columns of numbers
instead of one? - Correct Answers -Doughnut
Which chart is ideal for a quick view of a profit and loss financial statement? - Correct
Answers -Waterfall
What does Excel call a worksheet area with an initial row of labels? - Correct Answers -
Table
How do the AutoFilter arrow buttons change when you're filtering your table? - Correct
Answers -A mini filter symbol appears next to the down arrow.
What do you call a short program that you can write to automate a task you find yourself
performing repeatedly? - Correct Answers -Macroi
QUESTIONS AND ANSWERS
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? -
Correct Answers -Numbers and labels.
What does Excel call the element normally found at the top of a chart that is used as an
informative header? - Correct Answers -Chart title.
What chart option allows you to insert labels such as a number, percentage, or category
name to each column, line, or pie slice of a chart? - Correct Answers -Data labels.
If you want to move your chart location, which tab on the Chart Tools Ribbon is the
Move Chart option found on? - Correct Answers -Design
If you change one or more of the numbers in a worksheet from which a chart was
derived, how will the chart respond? - Correct Answers -The chart will change
automatically to reflect the new numbers.
Which chart type fills gaps in knowledge about the collected data? - Correct Answers -
Line
Which chart type do scientists, engineers, and statisticians use to create scatter plots? -
Correct Answers -X Y scatter
Which chart type allows you to associate three numbers with each data point? - Correct
Answers -Bubble
Which type of chart works like a pie chart but can graph multiple columns of numbers
instead of one? - Correct Answers -Doughnut
Which chart is ideal for a quick view of a profit and loss financial statement? - Correct
Answers -Waterfall
What does Excel call a worksheet area with an initial row of labels? - Correct Answers -
Table
How do the AutoFilter arrow buttons change when you're filtering your table? - Correct
Answers -A mini filter symbol appears next to the down arrow.
What do you call a short program that you can write to automate a task you find yourself
performing repeatedly? - Correct Answers -Macroi
