Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Unit #5 | Worksheet #2

Total questions: 16

Worksheet time: 11mins

Name
Class
Date
1.

The physical rearrangement of data in ascending or descending order is called ...?

a)

Arranging

b)

Sorting

c)

Filtering

d)

Ordering

2.
(Let the GIF Play)
How are we sorting the data in this clip?
a)
Custom Sort by T-Shirt Size
b)
Alphabetically by First Name
c)
Alphabetically by Last Name
d)
Numerically by Homeroom Number
3.

The arrangement of data in Z to A will arrange the data in __________ order.

a)

Ascending

b)

Descending

4.

A features that displays only the data in column (s) according to specified criteria

a)

Formula

b)

Sorting

c)

Filtering

d)

Pivot Table

5.

What type of chart will you use to compare performance of two employees in the year 2016 ?

a)

Column Chart

b)

Pie Chart

c)

Dot Graph

d)

Line Chart

6.

How will you graphically represent expenditure in different departments ?

a)

Column Chart

b)

Pie Chart

c)

Line Chart

d)

Dot Chart

7.

What type of chart is useful for showing trends or changes over time ?

a)

Line Chart

b)

Bar Chart

c)

Pie Chart

d)

Line Chart

8.

If you wanted to sort data in reverse alphabetical order, which option would you choose?

a)

Search Z to A

b)

Filter A to Z

c)

Sort Z to A

d)

Sort A to Z

9.
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
10.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
11.
A chart can be moved to a separate sheet.
a)
True
b)
False
12.
Once a type of graph is chosen, it can not be changed.
a)
True
b)
False
13.

What type of chart is this?

a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

14.

What type of chart is this?

a)

LINE

b)

DONUT

c)

PIE

d)

COMBO

15.

What type of chart is this?

a)

BAR

b)

LINE

c)

STOCK

d)

COLUMN

16.

What type of chart is this?

a)

Area

b)

Stock

c)

Sunburst

d)

Radar