.
A graphical representation which follows the exact placement of data points.
The algorithm Excel 2016 uses when saving documents in 97-2003 format.
The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.
A line connecting data labels to their respective data points.
A line which conforms to a Company's Standards and Guidelines.
Trendlines
Charts
Category / Value Axis'
Elements
CubeSet
An interactive table that summarizes, organizes, and compares large amounts of worksheet data.
A chart with embedded data which can be manipulated.
An Excel tool which allows you to pivot between a Word Table and an Excel spreadsheet.
A static table that summarizes, organizes, and compares large amounts of worksheet data.
An Excel element that allows you to filter data in a static worksheet.
True
False
Grouping
Inserting
Placing
Combining
Nesting
Control + Shift + Enter
Control + Enter
Alt + Shift + Enter
Alt + Enter
Control + Shift + Alt + Enter
=TODAY(Date)
=TODAY()
=TODAY(05/05/2016)
=TODAY(A1)
=TODAY(A1:B2)
True
False
GREATER THAN
OR
NOT
AND
SUBSETS
LOOKUP
SEARCH
SUBTOTAL
VALUE
Click Clear Sort in the Sort command in the Sort & Filter group on the Data tab.
Right-click and choose Remove Sort.
Use the Undo command.
Save the workbook, close it and reopen it.
Sort another column.
Subtotals
Indentation
Outdent
Collapse / Expand
Outline
Raw data that has been summarized.
Data with both column labels and row labels.
Summarized data with row labels.
Raw data with column labels.
Summarized data with column labels.
SUMIF
COUNTIF
OFFSET
SUMIFS
SUBTOTAL
More Functions in the Function Library group on the Formulas tab
More Functions in the Function Library group on the Data tab
Insert Function in the Function Library group on the Formulas tab
Insert Function in the Function Library group on the Data tab
Click Help and type Functions.
Cell Range
Worksheet Range
Named Range
List Range
PIVOTDATA
SUMPIVOTDATA
ANALYZEPVT
GETPIVOTDATA
ANALYZEPIVOTDATA
Click once on the function or named range.
Highlight the function or named range and press the Tab key.
Highlight the function or named range and press the Enter key.
Highlight the function or named range and press the right arrow key.
DATETIME
Timeline
Chronological Filter
Quantum Analysis
ISOWEEKNUM
Define Name in the Defined Names group on the Formulas tab.
Use in Formula in the Defined Names group on the Formulas tab.
Name Manger in the Defined Names group on the Formulas tab.
Create from Selection in the Defined Names group on the Formulas tab.
Use Label Names in the Defined Names group on the Formulas tab.
Automatic Except for Data Tables
Manual
Calculate Now
Calculate on Save
Calculate Sheet
True
False
First column you sorted
Second column you sorted
Third column you sorted
None of the columns are sorted
You must use the Sort command to perform this task
A range of cells highlighted in Excel 2016.
Multiple worksheets grouped together.
A visual depiction of values from a range of cells.
The individual values saved in a range of individual cells.
A range of data entered into a computer's memory and accessed by Excel 2016.
Quiz Review Timeline (Updated): +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.