Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Expert 2016 Lessons 3-4 Vocab
Test Description: Excel Expert 2016 lessons 3-4 vocab
Instructions: Answer all questions to get your test result.
1) The parameters of a function.
A
conditional formula
B
argument
C
lookup functions
D
criteria
2) A formula in which the result is determined by the presence or absence of a particular condition.
A
argument
B
criteria
C
conditional formula
D
lookup functions
3) A condition you specify to limit which records are returned when filtering data.
A
lookup function
B
conditional formatting
C
argument
D
criteria
4) An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
A
argument
B
conditional formatting
C
lookup function
D
criteria
5) A range of cells in a worksheet that contains related data and can be used by a lookup function.
A
arguments
B
table array
C
conditional formatting
D
table
6) Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.
A
arguments
B
conditional formatting
C
criteria
D
table array
7) A line bordering the chart plot area used as a frame of reference for measurement.
A
chart
B
axis
C
chart sheet
D
chart area
8) A graphical representation of numeric data in a worksheet.
A
chart area
B
chart
C
axis
D
chart sheet
9) The entire chart and all its elements.
A
chart
B
chart area
C
chart sheet
D
axis
10) A sheet that contains only a chart.
A
axis
B
chart sheet
C
chart
D
chart area
11) Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.
A
data label
B
embedded chart
C
data series
D
dual axis chart
12) A row or column of data represented by a line, set of columns, bars, or other chart type.
A
dual axis chart
B
data label
C
data series
D
embedded chart
13) A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)
A
data series
B
embedded chart
C
data label
D
dual axis chart
14) A chart placed on a worksheet rather than on a separate chart sheet.
A
dual axis chart
B
embedded chart
C
data label
D
data series
15) A graphical representation of the data in a PivotTable.
A
Power Pivot
B
Pivot Table
C
Pivot Chart
D
relationship
16) A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
A
Pivot Chart
B
Power Pivot
C
Pivot Table
D
relationship
17) A tool that offers Excel users the ability to generate PivotTables very quickly on very large data sets of tens or even hundreds of millions of rows.
A
Power Pivot
B
Pivot Chart
C
Pivot Table
D
relationship
18) A term that describes when two tables have a connection between two fields.
A
Pivot Chart
B
relationship
C
Pivot Table
D
Power Pivot
19) A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.
A
relationship
B
Pivot Table
C
Pivot Chart
D
slicer
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?