NEW
Font size
S
M
L
XL
WorksheetsMOAC Excel 2016 Lesson 12
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Which chart type shows values as parts of a whole?
a)
Clumn
b)
Bar
c)
Area
d)
Pie
2.
Which chart type appears on a worksheet with other data?
a)
Chart Sheet
b)
Embededed
c)
PivotChart
d)
Mixed
3.
Which part of a chart do you click when you want to select the entire chart?
a)
Chart Area
b)
Plot area
c)
Chart Title
d)
Legend
4.
Which of the following happens to a chart when the source data is deleted?
a)
Nothing
b)
The chart will move to the area where the data was located.
c)
The data in the chart is deleted, the chart is blank
d)
The chart will move to the area where the data was located.
e)
You will be asked if you want the chart deleted.
5.
Which of the following is the first step that should be taken when creating a chart?
a)
Providing a name for the chart
b)
Selecting the chart type
c)
Selecting the range of cells that contain the data the chart will use
d)
Choosing the data labels that will be used in the chart
6.
When you want to print only the chart in a worksheet, which of the following steps should be taken before printing?
a)
Click the chart to select it and then print.
b)
Select the Print chart only option in the Page Setup dialog box.
c)
Move the chart to a new sheet by itself and then print that sheet.
d)
You cannot print only the chart if it is part of a larger worksheet.
7.
A bar chart represents values as which of the following?
a)
Horizontal bars
b)
Vertical bars
c)
Horizontal lines
d)
Vertical lines
8.
A column chart represents values as which of the following?
a)
Horizontal bars
b)
Vertical bars
c)
Horizontal lines
d)
Vertical lines
9.
Which of the following steps should be performed to move a chart from a worksheet to a chart sheet?
a)
Use the move handles and drag it to the new location.
b)
Use the Move Chart button on the Chart Design tab
c)
Cut the chart from the worksheet and paste it to a new workbook sheet.
d)
You cannot move the chart after it has been created.
10.
Which of the following statements is NOT true?
a)
You can change both the height and width of a chart with commands on the Format tab.
b)
You can use the sizing handles to change the height and width of a chart.
c)
You must delete an existing chart in order to have the data displayed in a different chart type.
d)
When a chart sheet is created, the chart no longer appears on the worksheet containing the data series.
Reset
