NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets
Total questions: 36
Worksheet time: 18mins
Name
Class
Date
1.
Results are returned IF the data specified in an equation meets conditions set by the formula; conditional operators.
a)
NOW
b)
Days 360
c)
IF Statement
d)
LookUp
2.
Returns the current date.
a)
NOW
b)
Days 360
c)
VLookUp
d)
List
3.
Used for two column vectors.
a)
Days 360
b)
IF Statements
c)
NOW
d)
LookUp
4.
Used to assist in organizing information.
a)
NOW
b)
Column Chart
c)
List
d)
Table
5.
Used when there is more than two columns in a table.
a)
VLookUp
b)
LookUp
c)
List
d)
NOW
6.
A list that limits data entry to specific choices programmed into the function.
a)
Validated
b)
Non-Validated
c)
Count
d)
Graph
7.
A list that allows additional entries other than those provided in the drop-down menu.
a)
CountA
b)
CountIf
c)
Non-Validated
d)
Validated
8.
A chart in which the individual components are enhanced.
a)
Pie Chart
b)
Exploded Pie Chart
c)
Stacked Bar Chart
d)
XY Scatter Chart
9.
A chart used to represent the contribution of each component of one series of data to the whole, (percentages).
a)
Pie Chart
b)
Exploded Pie Chart
c)
Line Chart
d)
Column Chart
10.
A chart used to show trends or changes in data over time.
a)
Stacked Bar Chart
b)
Line Chart
c)
Pie Chart
d)
XY Scatter Chart
11.
A chart used to show the correlation of two or more sets of data sets.
a)
XY Scatter Chart
b)
Pie Chart
c)
Line Chart
d)
Stacked Bar Chart
12.
A chart used to represent the sum or more than one value and compare the contribution of individuals to the whole.
a)
Exploded Pie Chart
b)
Stacked Bar Chart
c)
Line Chart
d)
Pie Chart
13.
A chart used to make comparisons and generalizations about groups of data.
a)
Line Chart
b)
Pie Chart
c)
Column Chart
d)
Stacked Bar Chart
14.
The left vertical side of the graph. It contains numerical data.
a)
Chart Title
b)
Y-Axis
c)
X-Axis
d)
Gridline
15.
The bottom horizontal side of the graph. It contains the category information.
a)
Y-Axis
b)
X-Axis
c)
Tick Mart
d)
Gridline
16.
Used in a graph to indicate data values.
a)
Data Markers
b)
Data Series
c)
Plot Area
d)
Gridline
17.
A collection of related values, such as one row or column from a spreadsheet.
a)
Data Markers
b)
Data Label
c)
Data Series
d)
Tick Mart
18.
The horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification to the data.
a)
Chart Title
b)
Data Label
c)
Gridline
d)
Plot Area
19.
An object that explains the symbols, colors, or patterns used to differentiate the data.
a)
Legend
b)
Plot Area
c)
Gridline
d)
X-Axis Title
20.
Used in a graph to clarify data categories or values.
a)
Plot Area
b)
Linked Chart
c)
Data Series
d)
Tick Mark
21.
The main heading, which describes the purpose and content.
a)
Chart Title
b)
Y-Axis Title
c)
X-Axis Title
d)
Data Label
22.
A single value or text explanation used to explain the data in a series.
a)
Data Label
b)
Linked Chart
c)
Tick Mark
d)
Chart Title
23.
Describes the horizontal data.
a)
X-Axis Title
b)
Y-Axis Title
c)
Main Title
d)
Legend
24.
Describes the vertical data.
a)
Chart Title
b)
Data Label
c)
Y-Axis Title
d)
X-Axis Title
25.
A chart that appears on the same sheet as the spreadsheet it represents.
a)
EmbeddedChart
b)
Column Chart
c)
Line Chart
d)
Linked Chart
26.
A chart that reflects changes made to the spreadsheet it represents.
a)
Line Chart
b)
Embedded Chart
c)
Column Chart
d)
Linked Chart
27.
Which function will automatically add up a range of cells.
a)
AutoSum
b)
Average
c)
Freeze Pane
d)
Fill Handle
28.
A stacked bar chart was created to represent the total sales of each employee over a four month period. Which feature will make the plot area easier to read?
a)
Chart Title
b)
Axis Title
c)
Gridlines
d)
Data Series
29.
Which chart will best represent a comparison of the number of students from each grade level (6th, 7th, and 8th) to their daily attendance at school?
a)
Pie Chart
b)
Line Chart
c)
Column Chart
d)
Stacked Bar Chart
30.
Which type of chart will best represent the correlation between a person's heart rate and daily exercise, such as jogging or running?
a)
Pie Chart
b)
Exploded Pie Chart
c)
XY Scatter Chart
d)
Line Chart
31.
Which type of chart will best represent the total sales for 3 departments to the whole sales for Macy's?
a)
Line Chart
b)
Pie Chart
c)
Exploded Pie Chart
d)
Stacked Bar Chart
32.
Which type of chart will best represent the growth of sales for the new I-Phone 6 over the next several months?
a)
Line Chart
b)
Column Chart
c)
Stacked Bar Chart
d)
Pie Chart
33.
Which chart will best represent the percentage of expenditures to the total budget?
a)
Exploded Pie Chart
b)
Pie Chart
c)
Column Chart
d)
Line Chart
34.
Which chart will BEST represent a comparison of three students from each class (Sophomores, Juniors, and Seniors) to their attendance at school?
a)
Column Chart
b)
Line Chart
c)
Embedded Chart
d)
Pie Chart
35.
Which chart will BEST represent the increase of sales for the X-Box One over the past 2 months?
a)
Column Chart
b)
Line Chart
c)
Pie Chart
d)
Linked Chart
36.
Which function can a credit card company use to determine the time that has elapsed since a customer's last payment was received?
a)
NOW
b)
Count
c)
Days 360
d)
CountIf
Reset
