wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Charts

Total questions: 51

Worksheet time: 26mins

Name
Class
Date
1.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
2.
Part of a pie chart that represents one value from the series.
a)
axis
b)
data
c)
slice
d)
chart
3.
Data graphed as slices of a circular area is a 
a)
bar chart
b)
scatter plot
c)
pie chart
d)
column chart
4.
Corresponds to the category labels in a pie chart and series names in other charts.
a)
Plot area
b)
Legend
c)
Gridelines
d)
Slice
5.
This describes what is charted. It can be placed above or below the chart.
a)
Chart title
b)
chart area
c)
bar chart
d)
pie chart
6.
Once you have created a chart you cannot add another data series.
a)
True
b)
False
7.
A chart can be moved to a separate sheet.
a)
True
b)
False
8.
Once a type of graph is chosen, it can not be changed.
a)
True
b)
False
9.
When charts are pasted into a word file, they are no longer linked to the excel chart.
a)
True 
b)
False
c)
It depends how the chart is pasted.
10.
a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

11.
a)

BAR CLUSTER

b)

COMBO

c)

STOCK

d)

RADAR

12.
a)

RADAR

b)

STOCK

c)

BAR

d)

COMBO

13.
a)

RADAR

b)

LINE

c)

BAR

d)

STOCK

14.
a)

LINE

b)

CIRCLE

c)

PIE

d)

COMBO

15.
a)

BAR

b)

LINE

c)

STOCK

d)

BAR CLUSTER

16.
a)

COMBO

b)

BAR

c)

LINE

d)

HIERARCHY

17.
a)

Surface

b)

Line

c)

BAR

d)

COMBO

18.
a)

Histogram

b)

Stock

c)

Line

d)

Bar

19.
a)

Area

b)

Stock

c)

Sunburst

d)

Radar

20.
John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?
a)
PivotChart
b)
Line Chart
c)
Embedded Chart
d)
Linked Chart
21.
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
a)
Gridelines
b)
Arrows
c)
Pictures
d)
Labels
22.
Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
a)
PivotChart
b)
PivotTable
c)
PivotDate
d)
Rotate Table
23.
What ribbon contains the commands used to create a chart in Excel?
a)
Home Ribbon
b)
Insert Ribbon
c)
Formulas Ribbon
d)
Data Ribbon
24.
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
a)
Style
b)
Design
c)
Format
d)
Layout
25.
Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?
a)
Bar
b)
Column
c)
Line
d)
Pie
26.
In order to directly report the data, what must a PivotChart always be associated with?
a)
Table
b)
Range
c)
PivotTable
d)
Worksheet
27.
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a)
Bar
b)
Column
c)
Line
d)
Pie
28.
What is typically included in the range of data selected to create a chart?
a)
Titles only
b)
Numeric data and totals only
c)
Numeric data, totals, and titles
d)
Numeric data and titles
29.
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
a)
Style
b)
Design 
c)
Layout
d)
Format
30.
Which is the default method for summarizing data in a PivotTable?
a)
Count
b)
Average 
c)
Max
d)
Sum 
31.

Every chart must have a

a)

chart name

b)

chart title

c)

chart slogan

d)

chart word

32.

On our X and Y axis we must always

a)

insert axis titles

b)

leave these blank

c)

fill them in with numbers

d)

remove them

33.

Chart titles and axis titles should be

a)

shown in bold

b)

shown in capital letters

c)

shown in italics

d)

font size 14

34.

The key at the side of the chart is called

a)

a decoder

b)

a what is where

c)

a legend

d)

the axis

35.

we must add these so that the person reading the chart can see the exact figures clearly

a)

data labels

b)

information labels

c)

number labels

d)

item labels

36.

To make the chart easier to print we must

a)

print it as quickly as possible

b)

move it to a new sheet

c)

turn it upside down

d)

zoom in

37.

When adding up more than 2 cells in a spreadsheet we use

a)

=PLUS

b)

=ADD

c)

=SUM

d)

=SUBTRACT

38.

To find the average number in a range we use the formula

a)

=AVG

b)

=AVERAGE

c)

=AVERAGES

d)

=MEAN

39.
Which chart would you use to show change (trends) over time?
Example: Your grade in Reading since the beginning of this year. 
a)
Bar
b)
Line
c)
Column
d)
Pie
40.
Which chart would you use if you had two categories and you wanted to show distribution (how they add up to 100%) of those two categories?
Example: % of people who bought whole milk and % of people who bought skim milk in December. 
a)
Bar
b)
Line
c)
Column
d)
Pie
41.
Which chart would you use if you had several items in a specific range of values? Example: the number of matches the Panthers Volleyball team has won from each of the last 10 years.
a)
Bar
b)
Line
c)
Column
d)
Pie
42.
Which chart would you use if you wanted to show distribution of of items when there are more than 3 categories?
Example: To show the % of students in 6th grade that drink whole milk, 2% milk, 1% milk, and skim milk. 
a)
Bar
b)
Line
c)
Column
d)
Pie
43.
A11: E:31 is an example of a ___________________. 
a)
Selection
b)
Formula
c)
Range
44.
To go from one cell to the next horizontally (left to right), what key would you press on your keyboard?
a)
Shift
b)
Tab
c)
Space
d)
Enter
45.
To go from one row to the next, what key would you press on your keyboard?
a)
Shift
b)
Tab
c)
Space
d)
Enter
46.

What symbol does a formula have to start with in order for it to work?

a)

#

b)

$

c)

=

d)

@

47.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

48.

Why are charts/graphs used in spreadsheets?

a)

to show a visual of the data in a spreadsheet

b)

to make the spreadsheet look cool

c)

to backup the data you input into the spreadsheet

d)

all of these are reasons

49.

Which icon represents currency?

a)

*

b)

&

c)

$

d)

@

50.

What is the first thing you have to do in a spreadsheet before you can create a chart/graph?

a)

click insert charts/graphs

b)

go to file, print

c)

highlight the data with your mouse

d)

bold all the information

51.

Which is NOT an alignment icon?

a)

center

b)

align left

c)

align right

d)

tab

Similar Resources on Wayground

ktra hk2 công nghệ

54 questions

ktra hk2 công nghệ

quiz

Worksheet

•

11th Grade

Quiz Fungsi Excel

50 questions

Quiz Fungsi Excel

quiz

Worksheet

•

12th Grade

Pra UAS MPPL

50 questions

Pra UAS MPPL

quiz

Worksheet

•

University

PEMROGRAMAN DASAR

50 questions

PEMROGRAMAN DASAR

quiz

Worksheet

•

10th Grade

APPTITUDE TEST

50 questions

APPTITUDE TEST

quiz

Worksheet

•

University

Airplane Basics

50 questions

Airplane Basics

quiz

Worksheet

•

7th - 8th Grade

IDN ACE Test 1

50 questions

IDN ACE Test 1

quiz

Worksheet

•

1st - 10th Grade

Engine Repair Final

55 questions

Engine Repair Final

quiz

Worksheet

•

Professional Development