Address of a cell indicating its column and row location

Address of a cell range based on the relative position of the cell

Contains both relative and absolute references

View of workbook contents which displays formulas instead of resulting values

Shows the contents of the worksheet

Displays the location of different page breaks within a worksheet

Shows how the worksheet will appear on the page or pages when they are printed

Named operation which returns a value

Creates a date value for the date represented by the year, month and day arguments

Works with values which are either true or false

Displays the current date and time according to the formatting of the cell

Places current date in a cell

Text printed on the bottom margin of each page

Text printed in the top margin of each page

Shortcuts to different locations

Grid of rows and columns in which text and numbers are entered and results are calculated

File used to store worksheets

Sheets containing formulas, functions, values, text and graphics which make up a

workbook

Allows a user to specify where a page break is located in a worksheet

Page is longer than its width

Page is wider than its length

Numerical value which can be used in a mathematical calculation

Symbol which indicates the relationship between two values

Applies formatting only when a cell’s value meets a specified criterion

Expression which returns a value

Range of values which is plotted as a single unit on the chart

Range which contains the data selected to display in the chart

Tiny chart in a worksheet cell which provide a visual representation of data

Combination of letters, numbers and some symbols which form words and sentences 

Recognized formats for date and time values

Displays only data which meets certain criteria

Sort data by text, numbers, formatting and dates and times in one or more columns

Tests whether conditions are true or false and makes logical comparisons between

expressions

Function used to perform operations or calculations

Feature which updates the web page each time a change is saved on the source

workbook or worksheet

Function requiring two values, a date and the number of months which need to be

added or subtracted

Provides a convenient way to enter or display one complete row of information in a

range or table without scrolling horizontally

Document designed with a standard structure and format which makes it easier to

capture, organize and edit information

Used to analyze, explore and present data

Identify the purpose of a cell or text box

Puts related controls into one visual unit

Displays options from which the user can choose

Allows a single selection from a list of options

Increases or decreases a value such as a number, time or date