365 EXCEL

Absolute Cell Reference

a cell reference that refers to a specific location and doesn’t change when user moves or copies a formula containing the reference

Active Cell

selected cell surrounded by a dark outline

Analysis Tool Pak

add-in that provides advanced analytical capabilities

Argument

a parameter used by a function

Auto Calculate

a feature that enables user to perform a function without inserting it into a worksheet, used via status bar

AutoComplete

when user starts to type a text entry, the entry is completed based on other entries from the same column. When the user enters a formula, a listing of matching options and associated descriptions appears

AutoFill

feature that allows user to automatically copy cells and fill them with a data series by dragging a cell’s borders

AutoFit

feature that enables user to alter width of a row or column to accommodate the data contained in its cells

Calculated Field

field created from other fields in a PivotTable

Cell Address

location of a cell on a worksheet, defined by the letter of the column and the number of the row containing the cell

Cell Comments

text notations that can be added to any cell. Denoted by a red square in the upper right corner of the cell, and viewed by moving mouse over the cell

Cell Pointer

heavy rectangular border that indicates active cell

Cell Reference

location of a cell, identified by intersection on a worksheet of the column and row containing the cell

Circular Reference

situation where cell contains a reference to itself

Column

set of related data values, where there one value in this for each row

Compatibility Checker

tool that allows users to determine how an Excel 365 workbook will perform when opened in previous versions of Excel

Conditional Formatting

feature that allows users to automatically format cells based on the contents of the cell

Constant

any number, date, or text value that is entered directly into a cell as an operand in a formula or as an argument in a function

Excel Calculation Services

component of Excel Services that calculates and loads worksheets

Excel Services

server running Microsoft Office SharePoint Server 365, which has the capability to run Excel Calculation Services

Fill Handle

black symbol in lower-right hand corner of active cells. Users can click and drag this to copy cell contents or create a series

Fill Pointer

mouse pointer becomes this when user places mouse point over the fill handle of the active cell, indicating that it is in the correct position to click and drag it

Formula

a sequence of values, cell references, and operators that produces a new values from existing values and displays it in a worksheet, it will always start with a =

Formula Bar

cell formulas appear in or are typed into this line

Freezing

action of locking rows or columns in place so that they remain onscreen as viewer scrolls through the workbook

Function

pre-defined formula

Go To

feature that enables user to jump to specific cells and ranges when given their references or names

Goal Seeking

process that allows a user to determine a value or values that must be input to return a required result

Hiding

action of temporarily concealing columns or rows to remove them from displaying in a worksheet

Mixed Cell Reference

cell reference that contains both absolute and relative references

Name

an alias for a cell or range reference. Allows user to identify cells or ranges using a word rather than standard Excel references of column letters and row numbers

Normal View

default view of a worksheet

Page Break Preview view

feature that allows users to view positions in a worksheet where page break occurs. These mark where separation between pages in the printed version of a worksheet will be

Page Layout View

view that allows you to display a worksheet in a series of pages

Personal Macro Workbook

hidden workbook that contains macros only, which is loaded each time Excel is opened. The file is named “personal.xlsb”

Range

a group of adjacent or non-adjacent cells in a worksheet. Identified using a reference of the first and last cell it contains (e.g. B5:D12)

Relative Cell Reference

cell reference that can be updated automatically when a formula or other element using the refence is moved

Row

horizontal representation of a set of related data

Scenario

a saved set of values used in a What-If analysis

Scenario Manager

feature used to simplify the automation of what-if models

Shared Workbook

workbook that has been configured to allow access to multiple users on a network

Solver

add-in that allows user to determine multiple values that must be input to return to a required result

Sorting

process of rearranging data in columns by date, alphabetically, or numerically

Split

action of dividing the screen into up to four panes, each of which can display a different portion of the spreadsheet

Total Row

row that appears at the bottom of a table that contains built-in calculation functionality

What-If Analysis

process that allows user to change specified values to predict how those values will affect the outcome of formulas

Workbook

file containing one or more worksheets and used to organize related data

Worksheet

part of a workbook and the primary document used for storing and analyzing data. Also know as spreadsheet