Excel Expert 2016 Lessons 3-4 Vocab Question Preview (ID: 47285)
Excel Expert 2016 Lessons 3-4 Vocab.
TEACHERS: click here for quick copy question ID numbers.
The parameters of a function.
a) argument
b) conditional formula
c) criteria
d) lookup functions
A formula in which the result is determined by the presence or absence of a particular condition.
a) argument
b) conditional formula
c) criteria
d) lookup functions
A condition you specify to limit which records are returned when filtering data.
a) argument
b) conditional formatting
c) criteria
d) lookup function
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) criteria
d) lookup function
A range of cells in a worksheet that contains related data and can be used by a lookup function.
a) table
b) table array
c) arguments
d) conditional formatting
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) table array
c) conditional formatting
d) criteria
A line bordering the chart plot area used as a frame of reference for measurement.
a) axis
b) chart
c) chart area
d) chart sheet
A graphical representation of numeric data in a worksheet.
a) axis
b) chart
c) chart area
d) chart sheet
The entire chart and all its elements.
a) axis
b) chart
c) chart area
d) chart sheet
A sheet that contains only a chart.
a) axis
b) chart
c) chart area
d) chart sheet
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) data series
c) dual axis chart
d) embedded chart
A row or column of data represented by a line, set of columns, bars, or other chart type.
a) data label
b) data series
c) dual axis chart
d) embedded chart
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 label
b) data series
c) dual axis chart
d) embedded chart
A chart placed on a worksheet rather than on a separate chart sheet.
a) data label
b) data series
c) dual axis chart
d) embedded chart
A graphical representation of the data in a PivotTable.
a) Pivot Chart
b) Pivot Table
c) Power Pivot
d) relationship
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) Pivot Table
c) Power Pivot
d) relationship
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) Pivot Chart
b) Pivot Table
c) Power Pivot
d) relationship
A term that describes when two tables have a connection between two fields.
a) Pivot Table
b) Pivot Chart
c) Power Pivot
d) relationship
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) slicer
b) relationship
c) Pivot Table
d) Pivot Chart
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 47285 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 47285 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register