Excel 2016
Metadata
Information that describes the content.
Portable Document File (PDF) is a file format designed by Adobe to enable the printing and viewing of documents. Any formatting used in the document will appear the same regardless of the operating system.
SUM
A formula in Excel which is used to add all the numbers in a cell range.
COUNT
A formula used in Excel to simply display the number of cells there are in a range of cells.
LOWER
A function in Excel used to make every character in a cell range lowercase.
UPPER
A function in Excel used to make every character in a cell range uppercase.
LEFT
A function in Excel used to move a number of characters and numbers from one cell to another based on user specifications starting from the left side of the cell.
SUMIF
A function used in Excel to add all the numbers in a cell range based on a given condition.
MIN
A function used in Excel to display the smallest number value in a range of cells.
Subtotal
A function used in Excel to provide formulas to preselected cell ranges inside an Excel worksheet.
PROPER
A function used to capitalize the first character of every word in a cell range in an Excel workbook.
RIGHT
A function used to move characters and numbers from one cell in Excel to another starting from the right side of the cell.
Cell Range
A group of at least two or more cells on an Excel worksheet.
Row
A group of cells arranged horizontally within an Excel worksheet.
AVERAGE
A preset formula in Excel used to process the average numeric value of a cell range.
Formula
A set of mathematical instructions in Excel which can be used to add.
Sparkline
A small chart placed within an Excel cell which provides a visual representation of a cell range in an Excel worksheet.
Absolute Reference
A term used to describe how formulas remain constant and do not change when they are copied in Excel.
Filter
A tool inside of an Excel table which is used to sort columns and rows according to the users needs.
Secondary Axis
A tool used in Excel charts that have high number values and low number values. It displays the lower number values more prominently than charts with a single axis.
Merge & Center
A tool used in Excel to merge the contents of one or more cells and place the contents in the center of the merged cells.
Print Preview
A tool used in Excel to view a publication as it would appear in print. Print Preview does not show layout guides.
Zoom
A tool used to alter the magnification of an Excel document.
Template
A tool used to create an Excel workbook. It comes with preset themes.
Table Style
A tool used to give Excel tables different color schemes.
Table
A tool used to organize and sort data in an Excel worksheet. Unlike a normal cell range.
Gridlines
A tool used to provide reference points to the user inside of a chart.
Find and Replace
A tool which allows an entry to be searched for and replaced with another entry.
Pie Chart
A type of chart which works better with one data series. It displays the given data in a circular way.
Bar Chart
Similar to a column chart.
Conditional Formatting
A type of formatting Excel executes on cells automatically if certain conditions are met.
Print Title
A type of label placed over a column or row in an Excel worksheet. It provides a point of reference for when the worksheet is printed.
Total Row
A type of row in an Excel table used to automatically process the columns and rows of a table in a number of formulas including SUM.
Text Box
A type of shape in Excel which is used to leave comments on an Excel document.
Page Break Preview
A type of worksheet view which shows the user how a worksheet will be printed.
AutoFill
An Excel feature which automatically enters contextual numbers and text into a specified cell range.
Hyperlink
(Gmetrix definition is - a word. ) Actual Definition - a link from a hypertext file or document to another location or file, typically activated by clicking on a highlighted word or image on the screen.
Excel
A Microsoft Office application which acts as a spreadsheet application that provides intricate mathematical formatting and data analysis.
Delimiter
A character or group of characters used in computer applications to set apart individual items in a program or data set. Some of the commonly used characters are commas.
Column Chart
A chart in Excel which is used to display data in vertical columns.
Line Chart
A chart often used with data that requires a secondary axis. It displays data in a simple line.
COUNTIF
A combination of the COUNT and IF functions. It is used to count the number of cells in a range given specific parameters.
IF
A conditional function in Excel which is used to test whether a cell meets certain requirements. The formula will return a True or False depending on the outcome.
Chart
A data presentation method which is used to display data in Excel in a more visual manner.
Ribbon
A feature first introduced in Excel 2007 which is located just below the title bar of the Excel 2016 interface. It provides various shortcuts and replacements to older versions of Excel as well as new features.
Wrap Text
A feature in Excel used to break a line of text in a cell. This makes it so the text can be viewed without having to alter the dimensions of the cell.
New Window
A feature used in Excel which allows users to create a mirror image of the current worksheet.
Name Box
A field in the upper-left corner of an Excel worksheet which displays the current name or address of the active cell.
CONCATENATE
A preset formula in Excel which is used to combine the text from one cell to another all in the same cell.
Function
A preset formula used in Excel to prevent common syntax errors.
Landscape
A print orientation which allows a worksheet to be printed horizontally.
Outline
A range of cells in Excel which have been grouped together in order to summarize data within an Excel worksheet.
Column
A series of cells arranged vertically within an Excel worksheet.
Print Area
A type of cell range in Excel. It is used to designate a range of cells to be printed when the user does not wish to print the entire worksheet. If there is a print area on a worksheet.
Freeze Pane
An Excel feature which allows all information above or to the left of a specified point to be frozen in place. This allows items such as titles to be viewed even when scrolling. Items can be frozen both vertically and horizontally.
Workbook
An Excel file containing one or more pages or worksheets.
Go To
An Excel tool used to navigate within Excel worksheets using cell references and titles.
Split
An Excel view feature which divides the current display area into multiple sections allowing the user to view different elements of the same file simultaneously.
Formula Bar
An area inside of Excel above the column headers which displays the contents of the active cell. The formula bar also displays information such as text or formulas.
Cell
An individual box of an Excel document that is formed by the intersection of a row and a column. Each cell can contain text.
Duplicate Records
Data found inside an Excel table that is considered repetitive. It is left to the user to decide what is considered repetitive data.
AVERAGEIF
Similar to other IF functions.
MID
Similar to the LEFT function.
MAX
Similar to the MIN function.
Export
The act of sending or transferring a saved file or document to another application.
Active Cell
The cell inside of Excel which is currently selected and ready to receive data. The active cell in Excel is displayed with a black border around it.
Paste Area
The cell range a user designates in an Excel workbook where data will be pasted. The paste area does not have to be the same size as the highlighted copy area.
Copy Area
The cell range a user designates to be copied to a new area in an Excel workbook.
Portrait
The default print orientation which allows a worksheet to be printed vertically.
Worksheet
The primary document used in Excel consisting of cells which are used to store and work with data; also known as a spreadsheet.