WorksheetsCharts and Graphs in Excel
Total questions: 20
Worksheet time: 10mins
What do you use to create a chart?
A.Pie Wizard
B.Excel Wizard
C.Data Wizard
D.Chart Wizard
What type of chart will you use to compare performance of sales of two products ?
A.Column Chart
B.Line Chart
C.Pie Chart
D.Both A and B
Which answer best describes a chart?
A. A chart is most commonly used to display trends.
B. A chart is most commonly used to display comparisons
C. A chart is usually displayed in columns.
D. A chart is usually displayed using lines.
Which of these charts does not exist in MS Excel
A. Scatter
B. Line
C. Doughnut
D. Graph
Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”?
A) Axes
B) Data Label
C) Data Series
D) Data Table
Which option of Chart Wizard contains the option of Series Name, Category and Value in Data?
A) Legend
B) Chart area
C) Data label
D) Data Titles
Which types of charts can excel produce?
A. Line graphs and pie charts only
B. Only line graphs
C. Bar charts, line graphs and pie charts
D. Bar charts and line graphs only D. Bar charts and line graphs only
What is the total region surrounding the chart?
(A) Chart area
(B) legend
(C) Clipart area
(D) Plot area
In excel, which chart is also known as X Y chart
Pie Chart
Bar Chart
Area Chart
Scatter Chart
The Chart title option is available in
A. Format
B. Design
C. Developer
D. Layout
In a computer, when we create an Excel chart as a separate sheet, it is stored in a
A. current worksheet
B. separate workbook
C. current book
D. A or C
In MS-Excel Graphics objects on a chart are used to
A.Add emphasis to chart data
B.Add interest to a chart
C.Help explain the chart data
D.All of the above
Part of a pie chart that represents one value from the series.
A. axis
B. data
C. slice
D. chart
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A.Style
B.Design
C.Layout
D.Format
Why are charts/graphs used in spreadsheets?
to show a visual of the data in a spreadsheet
to make the spreadsheet look cool
to backup the data you input into the spreadsheet
all of these are reasons
What is the first thing you have to do in a spreadsheet before you can create a chart/graph?
click insert charts/graphs
go to file, print
highlight the data with your mouse
bold all the information
Which chart would you use to show trends or changes over time?
stacked bar chart
pie chart
bar chart
line chart
A pie chart is used to do what?
show trends over time
represent only one series of data
show the correlation of two or more sets of data
show how many pieces you can eat
Is a column vertical or horizontal?
vertical
horizontal
Every chart must have a
chart name
chart title
chart slogan
chart word
