wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Functions and Charts

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.
  Which function will result in the total number of entries in the cell range B5 to B14?   
a)
  Count 
b)
 Max
c)
  Min
d)
  Sum
2.
Which function can an accounting department use in Cell A2 that will result in the current date?  
a)
  Count
b)
  Count A 
c)
  Days360 
d)
 Now
3.

What feature should be added to explain the chart's purpose?

a)

X-axis

b)

Y-axis

c)

Legend

d)

Chart title

4.

What feature lists the salespeople?

a)

X-axis

b)

Y-axis

c)

Legend

d)

Chart title

5.
 What functions will produce results that indicate whether a student has passed or failed a course by entering the text “Pass” or “Fail”?  
a)
 Count
b)
  Count A
c)
 If 
d)
  Sum
6.

Which one is a column chart?

a)

A

b)

B

c)

C

7.
What functions are used to calculate a period of time. 
a)
Date Function
b)
If Statements
c)
List Functions
d)
Count Functions
8.
Calculates the difference in days between 2 dates
a)
Date360
b)
Now
c)
Date Function
d)
Count Function
9.
Function used to compare a cell value to a group of cells in two column vectors
a)
VLookup Function
b)
List Function
c)
Lookup Functions
d)
Count Functions
10.
Used when there are more than two columns in a spreadsheet (looking up information in a table) 
a)
VLookup Function
b)
Lookup Function
c)
Array
d)
List Function
11.
Returns the number of cells in a range that contains numbers
a)
Count
b)
CountA
c)
CountIf
d)
List
12.
A function that is used to assist in organizing information, control content and filter content. 
a)
Lookup
b)
Count 
c)
List
d)
If Statements
13.
Returns the number of cells in a range that contain any value/label
a)
Count
b)
CountA
c)
CountIf
d)
List
14.
What does "A" refers to?
a)
 horizontal axis
b)
 vertical axis
c)
 source
d)
 legend
15.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

16.

Which feature is used to indicate the sales amounts in the plot area?

a)

Axis title

b)

Data label

c)

Legend

d)

Data series

17.

This chart represents the sum of more than one value and compares the contribution of individuals to the whole.

a)

Pie

b)

Line

c)

Stacked Bar

d)

Column

18.

This chart is used to show trends or changes in data over time.

a)

Line

b)

XY scatter

c)

Column

d)

Stacked Bar

19.

This chart is used to represent only one series of data to the whole.

a)

Stacked bar

b)

Pie

c)

Exploded pie

d)

Line

20.

This chart is used to indicate the correlation of two or more sets of data.

a)

XY Scatter

b)

Line

c)

Pie

d)

Stacked bar

Similar Resources on Wayground

REVISION 2 : TOPIC 7, 8 & 9

20 questions

REVISION 2 : TOPIC 7, 8 & 9

quiz

Worksheet

•

1st Grade - University

Business organization and environment

16 questions

Business organization and environment

quiz

Worksheet

•

10th Grade - University

unit 3 quiz 5

20 questions

unit 3 quiz 5

quiz

Worksheet

•

10th Grade

Excel

15 questions

Excel

quiz

Worksheet

•

6th - 8th Grade

BIM I

15 questions

BIM I

quiz

Worksheet

•

9th - 12th Grade

F 4-T3-FUNCTIONAL AREAS OF A BUSINESS

15 questions

F 4-T3-FUNCTIONAL AREAS OF A BUSINESS

quiz

Worksheet

•

9th Grade

10 BS Mid Sem 1 Review 2122

20 questions

10 BS Mid Sem 1 Review 2122

quiz

Worksheet

•

10th Grade