- # -

#DIV/0!

#N/A

IconError values
IconERROR.TYPE (error type)
IconISERR (is an error value other than #N/A?)
IconISNA (is not available?)
IconNA (error value #N/A)

#NAME?

#NULL!

#NUM!

#REF!

#VALUE!

- $ -

$ sign

- % -

% sign (operator)

- 3 -

3D effect (for objects)

3D view

for charts

- A -

ABS (absolute value)

Absolute cell references

Absolute value (ABS)

Accounting (number format)

ACOS (arccosine)

ACOSH (inverse hyperbolic cosine)

ACOT (arccotangent)

ACOTH (inverse hyperbolic cotangent)

Actual size (view)

Add/edit text

for AutoShapes

for text frames

Addition (operator)

ADDRESS (cell address as text)

Align (object)

align and distribute objects

snap to cells

to other objects with guides

Alignment

of cell contents

of text in text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

All caps

option for the character format

PROPER (function)

UPPER (function)

Analyze sheets

AND (logical AND function)

Android/iOS

context menu

input method

select

share a document

user interface

Annuity

see PMT

ANSI code of a character (CODE)

Anti-aliasing

Arabic scripts

IconWorking with Arabic text
IconSettings, General tab

Arccosine (ACOS)

Arccotangent (ACOT)

Arcsine (ASIN)

Arctangent

ATAN

ATAN2

Area chart

AREAS (number of areas)

Array functions

MDETERM (matrix determinant)

MINVERSE (inverse)

MMULT (product of matrices)

MSOLVE (solution)

TRANSPOSE (transpose matrix)

working with arrays

Asian scripts

ASIN (arcsine)

ASINH (inverse hyperbolic sine)

Associate file types

ATAN (arctangent)

ATAN2 (arctangent)

ATANH (inverse hyperbolic tangent)

Auto input mode

Autocomplete cells

IconEntering data in cells
IconSettings, Edit tab

AutoFilter

AutoFormat

Automatic percent input

Auto-Recover

IconSettings, Files tab
IconSettings, Backup tab

AutoShape

add/edit text

AutoShape effects

AutoShape templates

change on ribbon tab Object

change on the ribbon tab Object

change text area

change via the dialog box

IconObject properties, AutoShapes tab
IconAutoShapes tab (available only for AutoShapes)

drawing

AutoSum

AutoText

AVEDEV (average deviation)

Average

arithmetic mean (AVERAGE)

arithmetic mean (AVERAGEA)

if condition is true (AVERAGEIF)

if condition is true (AVERAGEIFS)

AVERAGE (arithmetic mean)

Average deviation (AVEDEV)

Average square deviation (DEVSQ)

AVERAGEA (arithmetic mean)

AVERAGEIF (average if condition is true)

AVERAGEIFS (average if conditions are true)

Axes (in charts)

IconShowing/hiding axes and axis titles
IconCategory axis (X axis)
IconValue axis (Y axis)
IconSeries axis (Z axis)
IconChart title

Axis title (in charts)

IconShowing/hiding axes and axis titles
IconAxis title

- B -

B (compatibility function)

Background color

of cells

of text

Backup copies

IconBackup copies (file versions)
IconSettings, Backup tab

Backup folder

IconBackup copies (file versions)
IconSettings, Backup tab

BAK files

Banded rows and columns

Bar chart

BASE (convert decimal number into another base)

Based on (for cell styles)

Based on (for character styles)

BasicMaker

Beep on errors

Beep on errors (for spell check)

BESSELI (modified Bessel function In(x))

BESSELJ (Bessel function Jn(x))

BESSELK (modified Bessel function Kn(x))

BESSELY (Bessel function Yn(x))

Beta distribution

BETA.DIST

BETA.INV

BETADIST

BETAINV

BETA.DIST (beta distribution)

BETA.INV (percentiles of the beta distribution)

BETADIST (beta distribution)

BETAINV (percentiles of the beta distribution)

BIN2DEC (binary to decimal)

BIN2HEX (binary to hexadecimal)

BIN2OCT (binary to octal)

Binary to decimal (BIN2DEC)

Binary to hexadecimal (BIN2HEX)

Binary to octal (BIN2OCT)

BINOM.DIST (binomial distribution)

BINOM.DIST.RANGE (binomial distribution)

BINOM.INV (binomial distribution)

BINOMDIST (binomial distribution)

Binomial distribution

BINOM.DIST

BINOM.DIST.RANGE

BINOM.INV

BINOMDIST

CRITBINOM

NEGBINOM.DIST

NEGBINOMDIST

Bold (font)

Boolean (number format)

Borders

of cells

of objects

Box and whisker plot

Boxplot chart

Bring forward one level (object)

Bring to front (object)

Bubble chart

- C -

Calculation in status bar

Calculations

update

IconUpdating sheets
IconDocument properties, Calculate tab

Category axis (in charts)

IconShowing/hiding axes and axis titles
IconCategory axis (X axis)

CEILING (round up to a multiple of base)

Cell

alignment

borders

change size

delete

do not print

enter data

fill automatically

IconFilling cells automatically
IconEditing lists for automatic filling

hide

insert

merge

number format

IconNumber format
IconList of all number formats
IconWorking with custom number formats

protect

protection

select

IconSelecting cells and cell content
IconSelecting in the Windows, Mac or Linux version

shading

CELL (information about a cell)

Cell address as text (ADDRESS)

Cell contents

copy

cut

delete

paste

Cell formatting, transfer

Cell frame

IconMoving within a worksheet
IconSettings, View tab

Cell marker

Cell protection

Cell styles

IconCell styles
IconCreating cell styles

apply

based on

change

create

default style "Normal"

shortcut keys

Centered

Change shape

Change text area

of AutoShapes

of text frames

CHAR (character from ANSI code)

Character format

all caps

background color

bold

character pitch

font

IconCharacter format
IconFont and font size

font color

font size

IconCharacter format
IconFont and font size

italic

kerning

letter spacing

small caps

strikethrough

superscripts and subscripts

text styles

IconCharacter format
IconText styles

underline

Character formatting

apply to entire words

reset

IconResetting the character formatting
IconScope of character styles

Character pitch

Character styles

apply

based on

change

create

default style "Normal"

shortcut keys

IconCreating character styles
IconApplying character styles

Chart (dialog box)

Chart (ribbon tab)

Chart area

Chart title

IconShowing/hiding chart titles
IconChart title
IconChart properties, Elements tab

Charts

add/delete data series

arrangement of data series

IconChanging the arrangement of data series
IconChart properties, Data source tab

change chart location

change chart type

change properties

data in columns

data in rows

edit

insert

save as picture

select chart elements

update

IconUpdating charts
IconDocument properties, Calculate tab

Check for updates

Checkboxes (form object)

CHIDIST (chi-square distribution)

CHIINV (percentiles of the chi-square distribution)

CHISQ.DIST.RT (chi-square distribution)

CHISQ.INV.RT (percentiles of the chi-square distribution)

CHISQ.TEST (chi-square test)

Chi-square distribution

CHIDIST

CHIINV

CHISQ.DIST.RT

CHISQ.INV.RT

Chi-square test

CHISQ.TEST

CHITEST

CHITEST (chi-square test)

CHOICE (x>0, x=0, x<0?)

CHOOSE (choose value from list)

Circular reference

IconStatus bar
IconDocument properties, Calculate tab

Classic menus with toolbars

IconWelcome!
IconSettings, Appearance tab

list of all ribbon commands and menu commands

user interface

CLEAN (remove non-printable characters)

Close (File)

Close document

CODE (ANSI code of a character)

Color

of cells

of objects

of text

Color gradient (for objects)

Column

change width

IconCell size
IconChanging cell sizes via commands

delete

hide/show

insert

optimum width

select

COLUMN (function: column number of cells)

Column chart

Column header

change column width

print

show/hide

use for selection

COLUMNS (function: number of columns)

COMBIN (combinations)

Combine (object shapes)

Combine shapes

Command-line parameters

Comments

always show

delete

edit

insert

print

show always

Common logarithm (LOG10)

Complex numbers

absolute value (IMABS)

angle (IMARGUMENT)

build complex number (COMPLEX)

conjugate (IMCONJUGATE)

cosine (IMCOS)

difference (IMSUB)

division (IMDIV)

exponential (IMEXP)

imaginary coefficient (IMAGINARY)

logarithm, base 10 (IMLOG10 )

logarithm, base 2 (IMLOG2 )

negative value (IMNEG)

power (IMPOWER)

product (IMPRODUCT)

real coefficient (IMREAL)

sine (IMSIN)

square root (IMSQRT)

sum (IMSUM)

Complex scripts

CONCAT (concatenate strings from list)

CONCATENATE (concatenate text strings)

Concatenation (operator)

Concatenation of strings (functions)

CONCAT

CONCATENATE

TEXTJOIN

Condition

CHOICE

IF

IFS

Conditional formatting

delete rules in selected cells

manage rules

new rule

types of conditions

Cone chart

CONFIDENCE (confidence interval)

Confidence interval

CONFIDENCE

CONFIDENCE.NORM

CONFIDENCE.NORM (confidence interval)

Consolidate data

Context menu

CONVERT (unit conversion)

Convert decimal number into another base (BASE)

Convert EU currencies (EUROCONVERT)

Copy

cell contents

formula

insert copied cells

object

text

Corners (in charts)

CORREL (correlation coefficient)

Correlation coefficient

CORREL

PEARSON

Correlation coefficient (RSQ)

COS (cosine)

COSH (hyperbolic cosine)

Cosine (COS)

COT (cotangent)

Cotangent (COT)

COTH (hyperbolic cotangent)

Count

COUNT

COUNTA

COUNTBLANK

COUNTIF

COUNTIFS

COUNT (number of cells filled with numbers)

COUNTA (number of cells filled)

COUNTBLANK (number of blank cells)

COUNTIF (count if condition is true)

COUNTIFS (count if conditions are true)

COUNTP (PlanMaker 97 compatibility function)

COVAR (population covariance)

Covariance

COVAR (population)

COVARIANCE.P (population)

COVARIANCE.S (sample)

COVARIANCE.P (population covariance)

COVARIANCE.S (sample covariance)

Create a complex number (COMPLEX)

Create new document

CREATEDATE (date the document was created)

Creation date

CRITBINOM (binomial distribution)

Cropping (of pictures)

IconChanging picture properties via the ribbon tab
IconChanging picture properties via the dialog box

CSV file format

CUMIPMT (cumulative interest)

CUMPRINC (cumulative principal)

CURRENCY (format number as currency)

Currency (number format)

Custom number formats

Customize

create user-defined icons

customize shortcut keys

customize toolbars

ribbon

Cut

cell contents

formula

object

text

Cylinder chart

- D -

Data consolidation

IconConsolidating data
IconConsolidating data by position
IconConsolidating data by labels
IconEditing and updating consolidations

Data labels (in charts)

IconShowing/hiding data labels
IconData series and data points

Data points (in charts)

Data series (in charts)

add

delete

edit

Data series, fill automatically

IconFilling cells automatically
IconEditing lists for automatic filling

Data source area (of charts)

IconChart properties, Data source tab
IconChart properties, Series tab

Data validation

IconDetecting invalid data in cells
IconInput validation

Database functions

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

Date

create a date value (DATE)

current (TODAY)

current, with time (NOW)

enter

DATE (create a date value)

Date before/after n months (EDATE)

Date difference (DATEDIF)

Date filters (AutoFilter)

Date last changed

Date the document was created (CREATEDATE)

Date/time (number format)

DATEDIF (date difference)

DATEVALUE (convert text into date value)

DAVERAGE (database function)

DAY (day of a date)

DAYS (days between two dates)

DAYS360 (days between two dates)

DAYSP (compatibility function)

DAYSPERMONTH (days per month)

DAYSPERYEAR (days per year)

DB (fixed-declining balance depreciation)

dBASE file format

DCOUNT (database function)

DCOUNTA (database function)

DDB (double-declining balance depreciation)

DEC2BIN (decimal to binary)

DEC2HEX (decimal to hexadecimal)

DEC2OCT (decimal to octal)

DECIBEL (decibel value of two quantities)

DECIMAL (convert number from any base into decimal)

Decimal point after input

Decimal separator

Decimal to binary (DEC2BIN)

Decimal to hexadecimal (DEC2HEX)

Decimal to octal (DEC2OCT)

DECIMALS (fractional part of a number)

Default cell style "Normal"

Default character style "Normal"

Default currency

Default file format when saving

Default language for spell check

IconSetting the language
IconSettings, Language tab

Default number format

Default template (document template)

"Normal"

IconStarting a new document
Icon"Normal.pmvx" document template

change

switch

Default unit of measure

Defined names

IconNaming cell ranges
IconUsing named ranges

Defined names (for cell ranges)

apply in existing formulas

export names as list

DEGREES (convert radians to degrees)

Degrees to radians (RADIANS)

Delete

IconDeleting data
IconDeleting the content of cells

cell contents

cells

IconDeleting cells and cell content
IconDeleting whole cells

duplicate rows

empty rows

object

special

text

DELTA (test for equality)

Depreciation

double-declining balance (DDB)

fixed-declining balance (DB)

straight-line (SLN)

sum-of-years’ digits (SYD)

Design Science

Determinant of a matrix (MDET)

DEVSQ (average square deviation)

DGET (database function)

Dialog language

Dictionaries for spell check

edit

install

Disable sheet protection

Display help content (F1 key)

IconShortcut keys in Windows and Linux versions
IconShortcut keys in Mac version

Display the formula a cell contains (FORMULATEXT)

Distance to edge

Distribute (object)

Division (operator)

DMAX (database function)

DMIN (database function)

Document management

Document properties

Calculate tab

Colors tab

Fonts tab

Options tab

Protection tab

Statistics tab

Summary tab

IconDocument summary
IconDocument properties, Summary tab

Document protection

Document statistics

Document summary

enter

prompt for summary information when saving

Document tabs

IconDocument tabs
IconWorking with multiple documents

Document templates

apply

change

create

default template "Normal"

Document, print

IconPrinting a document
IconPrinting a document

Document, save

DOLLARDE (convert to dollar price decimal)

DOLLARFR (convert to dollar price fraction)

Doughnut chart

DPRODUCT (database function)

Drag and drop

Draw circles

Draw connectors

Draw curves

Draw ellipses

Draw rectangles

Drawing object (dialog box)

Drawing object (ribbon tab)

Drawings

change properties

IconChanging drawing properties via the ribbon tab
IconChanging drawing properties via the dialog box

combine

edit retroactively

insert

rotate

Dropdown lists (form object)

DSTDEV (database function)

DSTDEVP (database function)

DSUM (database function)

Duplicate (objects)

Duplicate rows (delete)

DVAR (database function)

DVARP (database function)

Dynamic tables

- E -

EDATE (date before/after n months)

Edit

links (OLE objects)

Edit chart elements

axis title

chart area

chart title

IconChart title
IconChart properties, Elements tab

corners

data labels

data series

error bars

floor

gridlines

legend

lines

plot area

trendline

up/down bars

walls

X axis

Y axis

Z axis

Edit color palette

Edit lists (for filling)

IconFilling cells automatically
IconEditing lists for automatic filling

Edit mode

Edit points (of objects)

Edit script

Edit shapes retroactively

Edit toolbar

EFFECT (effective interest rate)

Effective interest rate (EFFECT)

Effects (for objects)

E-mail a document

Empty rows, remove

En dashes, different widths

Enable OpenGL for AutoShapes

Encryption

Enter data in cells

EOMONTH (end of month in n months)

Equality (DELTA)

Equation Editor

ERF (Gaussian error function)

ERFC (complement to Gaussian error function)

Error bar (in charts)

IconShowing/hiding error bars
IconData series and data points

Error function

ERF

ERFC (complement)

Error type (ERROR.TYPE)

Error values in calculations

IconDetecting errors in calculations
IconError values
IconISERR (is an error value other than #N/A?)
IconISERROR (is an error value?)

ERROR.TYPE (error type)

EUROCONVERT (convert EU currencies)

EVEN (round up to next even number)

EXACT (compare texts)

Excel file format

IconForm objects and Excel macros and scripts
IconSaving and opening files in other file formats
IconNotes on the Excel format
IconOpening and saving Excel files
IconDifferences between PlanMaker and Excel

Exclusive or (XOR)

Exit (file)

EXP (power of e)

EXPON.DIST (exponential distribution)

EXPONDIST (exponential distribution)

Exponential distribution

EXPON.DIST

EXPONDIST

Exponential regression

statistics (LOGEST)

values (GROWTH)

Exponentiation

operator

POWER function

Export (other file format)

Export/Import of settings

Extended support

for Arabic text

IconEnabling extended support for Arabic text
IconSettings, General tab

for Asian fonts

External cell references

External references

enter

manage

update

- F -

F distribution

F.DIST.RT

F.INV.RT

FDIST

FINV

F.DIST.RT (F distribution)

F.INV.RT (percentiles of the F distribution)

F.TEST (F-test)

FACT (factorial)

FACTDOUBLE (double factorial)

FALSE (logical value FALSE)

FDIST (F distribution)

Fields (in headers/footers)

File

export as PDF

send by e-mail

File formats

IconWorking with other file formats
IconSaving and opening files in other file formats

File manager

File properties

Calculate tab

Colors tab

Fonts tab

Options tab

Protection tab

IconEnabling document protection
IconDocument properties, Protection tab

Statistics tab

Summary tab

IconDocument summary
IconDocument properties, Summary tab

File type

File versions

IconBackup copies (file versions)
IconSettings, Backup tab

File: Close

File: Exit

File: New

File: Open

IconOpening a document
IconSaving and opening files in other file formats

File: Page setup

IconSet page format
IconSetting page format options
IconSetting up headers and footers

File: Print

IconPrinting a document
IconPrinting a document

File: Print preview

File: Properties

File: Save

File: Save all

File: Save as

IconSaving a document
IconSaving and opening files in other file formats

FILENAME (file name of the document)

Fill

of objects

Fill cells (automatically)

IconFilling cells automatically
IconEditing lists for automatic filling

Filling

of cells

Filters

IconFiltering cells by their content
IconSUBTOTAL (calculations without hidden cells)

AutoFilter

special filter

FIND (search for text)

FINV (percentiles of the F distribution)

First column (emphasize)

First column, freeze

FISHER (Fisher transformation)

FISHERINV (Inverse of the Fisher transformation)

FIXED (format number as text with fixed decimals)

Flip (objects)

Floor (in charts)

FLOOR (rounding off to a multiple of n)

Folder for file versions

IconBackup copies (file versions)
IconSettings, Backup tab

Font

IconCharacter format
IconFont and font size

bold

italic

underline

Font color

Font lists, hide fonts

Font size

IconCharacter format
IconFont and font size

Footers

FORECAST (forecast using linear regression)

Form object (ribbon tab)

Form objects

edit

evaluate

Form objects, insert

checkboxes

dropdown lists

groupboxes

labels

listboxes

pushbuttons

radio buttons

scrollbars

spinners

Format painter

Formatting toolbar

Forms

Formula auditing

IconFormula auditing
IconDisplaying the relationships between cells
IconDetecting errors in calculations
IconDetecting invalid data in cells

Formulas

FORMULATEXT (display formula contained in cell)

Fraction (number format)

Freehand drawing

Freeze rows/columns

FREQUENCY (frequency)

F-test

F.TEST

FTEST

Full screen mode (view)

Functions

functions from A to Z

insert

Future value

FV

FVSCHEDULE

FV (future value)

FVSCHEDULE (future value)

- G -

GAMMA (gamma function)

Gamma distribution

GAMMA.DIST

GAMMA.INV

GAMMADIST

GAMMAINV

Gamma function

GAMMA

GAMMALN

GAMMA.DIST (gamma distribution)

GAMMA.INV (percentiles of the gamma distribution)

GAMMADIST (gamma distribution)

GAMMAINV (percentiles of the gamma distribution)

GAMMALN (logarithm of the gamma function)

GAUSS (standard normal distribution)

Gauss test

Z.TEST

ZTEST

Gaussian distribution (NORM.DIST)

Gaussian distribution (NORMDIST)

Gaussian error function

ERF

ERFC complement

GCD (greatest common divisor)

GEOMEAN (geometric mean)

Geometric mean (GEOMEAN)

GESTEP (number greater or equal to threshold value?)

GETPIVOTDATA

Glow effect (for objects)

Go to

Goal seek

Greatest common divisor (GCD)

Gridlines between table cells

paint behind cells

print

show

Gridlines in charts

IconShowing/hiding gridlines
IconGridlines

Group

cells (outliner)

in pivot tables

objects

show/hide cells

Groupboxes (form object)

GROWTH (values of an exponential regression)

Guidelines for text frames, show

- H -

Hamburger menu

IconApplication window
IconUser interface: Ribbon

HARMEAN (harmonic mean)

Harmonic mean (HARMEAN)

Headers and footers

Height of a row

IconCell size
IconChanging cell sizes via commands

HEX2BIN (hexadecimal to binary)

HEX2DEC (hexadecimal to decimal)

HEX2OCT (hexadecimal to octal)

Hexadecimal to binary (HEX2BIN)

Hexadecimal to decimal (HEX2DEC)

Hexadecimal to octal (HEX2OCT)

Hide

cells contents

objects

Hide cells

manually

using the outliner

High-low chart

HLOOKUP (look up row-wise)

IconHLOOKUP (look up row-wise)
IconXIRR (internal rate of return)

HOLIDAY (dates of movable Christian holidays)

Horizontal alignment of cell contents

HOUR (hour)

HTML document

IconInternet functions
IconSaving documents in HTML format

Hunspell dictionaries

IconSettings, Language tab
IconInstalling additional dictionaries

Hyperbolic cosine (COSH)

Hyperbolic cotangent (COTH)

Hyperbolic sine (SINH)

Hyperbolic tangent (TANH)

Hypergeometric distribution

HYPGEOM.DIST

HYPGEOMDIST

HYPERLINK (function: hyperlink)

Hyperlinks (links)

IconInternet functions
IconUsing hyperlinks

applied to cells

for objects

for OLE objects

HYPERLINK function

remove

to jump target

HYPGEOM.DIST (hypergeometric distribution)

HYPGEOMDIST (hypergeometric distribution)

Hyphen

non-breaking hyphen

soft hyphen

Hyphenation

in table cells

in text frames

set language

- I -

IF (if-then-else condition)

IFEMPTY (return a value if cell is empty)

IFERROR (return a value on errors)

IFNA (return defined value for #N/A)

IFS (first condition met)

Ignore words that start with a number

IMABS (absolute value of a complex number)

IMAGINARY (imaginary coefficient of a complex number)

IMARGUMENT (angle of a complex number)

IMCONJUGATE (conjugate a complex number)

IMCOS (cosine of a complex number)

IMDIV (division of complex numbers)

IMEXP (exponential of a complex number)

IMLN (natural logarithm of a complex number)

IMLOG10 (base-10 logarithm of a complex number)

IMLOG2 (base-2 logarithm of a complex number)

IMNEG (negative value of a complex number)

Import (other file format)

Import/Export of settings

IMPOWER (power of a complex number)

IMPRODUCT (product of complex numbers)

IMREAL (real coefficient of a complex number)

IMSIN (sine of a complex number)

IMSQRT (square root of acomplex number)

IMSUB (difference of complex numbers)

IMSUM (sum of complex numbers)

In-cell editing

Indents (text frames only)

INDEX (cell in a particular row/column)

INDIRECT (create reference from text)

Information about a cell (CELL)

Inner margins

of cells

of text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

of text in AutoShapes

Input method (Android)

Input validation

IconDetecting invalid data in cells
IconInput validation
IconSettings for input validation
IconDetect invalid data

Insert

cells

characters

charts

columns

comments

copied cells

drawings

Equation Editor objects

form objects

functions

headers and footers

objects

OLE objects

page break

pictures

rows

SmartText entries

special characters

text frames

Insert characters

Insert frames and drawings immediately

Insert mode / Overwrite mode

disable

Insert pictures from the gallery/camera (Android and iOS only)

Insert special characters

Installation

Android

iOS

Linux

macOS

Windows

INT (round down to nearest integer)

INTERCEPT (intercept point of a regression line)

Interest payment

(IPMT)

CUMIPMT (cumulative)

ISPMT

Interest rate

PCF

per period (RATE)

RRI

Internal rate of return

IRR

MIRR

Intersection

INTERSECTION function

operator

INTERSECTION (intersection of two ranges)

Inverse hyperbolic cosine (ACOSH)

Inverse hyperbolic cotangent (ACOTH)

Inverse hyperbolic sine (ASINH)

Inverse hyperbolic tangent (ATANH)

Inverse matrix (MINVERSE)

iOS/Android

context menu

input method

select

share a document

user interface

IPMT (interest payment)

IRR (internal rate of return)

ISBLANK (is empty?)

ISERR (is an error value except #N/A?)

ISERR (is an error value other than #N/A?)

ISERROR (is an error value?)

IconError values
IconISERROR (is an error value?)

ISEVEN (is an even number?)

ISFORMULA (is a formula?)

ISLOGICAL (is a logical value?)

ISNA (is not available?)

ISNONTEXT (is no text?)

ISNUMBER (is numeric?)

ISNUMBERP (PlanMaker 97 compatibility function)

ISODD (is an odd number?)

ISOWEEK (ISO week number)

ISOWEEKNUM (ISO week number)

ISPMT (interest payment)

ISREF (is a valid reference?)

ISTEXT (is text?)

Italic (font)

Iterations for calculations

- J -

Jump target (hyperlink)

Justification (in text frames)

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

- K -

Keep aspect ratio

Keep scaling

Kerning

KURT (kurtosis)

Kurtosis (KURT)

- L -

Labels (form object)

Landscape format

Language

for spell check and hyphenation

for user interface

LARGE (k-th largest number)

Last column (emphasize)

LASTPRINTED (date last printed)

LASTSAVED (date last saved)

LCM (least common multiple)

Least common multiple (LCM)

LEFT (function: left part of a text string)

Left align

Left arrow key never exits cell editing

Legend (in charts)

IconShowing/hiding the legend
IconLegend

LEN (length)

Letter spacing

Line chart

Line spacing (text frame)

Linear regression

FORECAST

INTERCEPT

show trend in charts

statistics (LINEST)

values (TREND)

Lines

as borders of objects

drawing

Lines (in charts)

IconShowing/hiding lines
IconData series and data points

LINEST (statistics of a linear regression)

Links (hyperlinks)

applied to cells

for objects

HYPERLINK function

Links (OLE objects)

edit

update

Listboxes (form object)

Live preview

LN (natural logarithm)

LOG (logarithm)

LOG10 (base-10 logarithm)

Logarithm

any base (LOG)

base 10 (LOG10)

natural (LN)

LOGEST (statistics of an exponential regression)

LOGINV (percentiles of the lognormal distribution)

LOGNORM.DIST (lognormal distribution)

LOGNORM.INV (percentiles of the lognormal distribution)

Lognormal distribution

LOGINV

LOGNORM.DIST

LOGNORM.INV

LOGNORMDIST

LOGNORMDIST (lognormal distribution)

LOOKUP (search cell range)

LOWER (convert text to lower case)

Lower case

LOWER

PROPER

- M -

Macros

IconForm objects and Excel macros and scripts
IconDifferences between PlanMaker and Excel

Manage (button in the settings)

Manual (PlanMaker)

Margins

inner margins of AutoShapes

inner margins of cells

inner margins of text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

page margins

Mark invalid data

MATCH (relative position in a range)

MathType

Matrix equation (MSOLVE)

MAX (maximum)

MAXA (maximum)

MAXIFS (conditional maximum)

Maximum number of undo steps

MDETERM (matrix determinant)

Mean

geometric (GEOMEAN)

harmonic (HARMEAN)

without marginal values (TRIMMEAN)

MEDIAN

Menu bar

Menus with toolbars or ribbon?

IconApplication window
IconSettings, Appearance tab

MID (part of a text string)

Middle mouse button

MILLISECONDS (milliseconds)

MIN (minimum)

MINA (minimum)

MINIFS (conditional minimum)

MINUTE (minute)

MINVERSE (inverse matrix)

MIRR (modified internal rate of return)

Mirror (objects)

MMULT (product of matrices)

MOD (remainder of a division, Excel method)

MODE (most frequently occurring value)

MODE.SNGL (most frequently occurring value)

Modified internal rate of return

MIRR

MODP (remainder of a division, PlanMaker method)

MONTH (month of a date)

Move by ... decimals

Move selection after input to ...

MROUND (round to a multiple of base)

MSOLVE (solution of matrix equation Ax=B)

MULTINOMIAL (multinomial coefficient)

Multinomial coefficient

MULTINOMIAL

POLYNOMIAL

Multiplication (operator)

- N -

N (convert value into number)

NA (error value #N/A)

Name of a worksheet (SHEETNAME)

Names (for cell ranges)

IconNaming cell ranges
IconUsing named ranges

apply in existing formulas

assign

create from selection

edit

insert list

Names (of objects)

Names (of tables)

IconFormatting tables in worksheets
IconTables in worksheets and cell references
IconChanging the names of objects

NEG (negative value)

Negation (NEG)

Negative binomial distribution

NEGBINOM.DIST

NEGBINOMDIST

NEGBINOM.DIST (negative binomial distribution)

NEGBINOMDIST (negative binomial distribution)

Net present value

NPV

XNPV

NETWORKDAYS (number of workdays)

Neumann function (BESSELY)

New (File)

IconStarting a new document
IconDocument templates
IconUsing document templates

New pivot table

New program window

New table (tables in worksheets)

IconTables in worksheets
IconCreating tables in worksheets
IconRibbon tab "Table"

NOMINAL (nominal interest rate)

Non-breaking hyphen

Non-breaking space

NORM.DIST (normal distribution)

NORM.INV (percentiles of the normal distribution)

NORM.S.DIST (standard normal distribution)

NORM.S.INV (percentiles of the standard distribution)

Normal

cell style

character style

Normal distribution

NORM.DIST

NORM.INV

NORMDIST

NORMINV

Normal distribution, logarithmic

LOGINV

LOGNORM.DIST

LOGNORM.INV

LOGNORMDIST

Normal.pmvx

IconStarting a new document
Icon"Normal.pmvx" document template

NORMDIST (normal distribution)

NORMINV (percentiles of the normal distribution)

NORMSDIST (standard normal distribution)

NORMSINV (percentiles of the standard distribution)

NOT (logical NOT function)

NOW (current date and time)

NPER (number of periods)

NPV (net present value)

Number (number format)

Number filters (AutoFilter)

Number format

IconNumber format
IconList of all number formats
IconWorking with custom number formats
IconStructure of a custom number format

Number of periods (NPER)

Number of worksheets (SHEETS)

Number separators

Number series, fill automatically

IconFilling cells automatically
IconEditing lists for automatic filling

Numbers, enter

NUMBERVALUE (convert text to a number)

- O -

Object

copy

cut

delete

paste

select

Object (dialog box)

Object mode

Object properties

change default settings

for charts

for checkboxes

for drawings

for dropdown lists

for groupboxes

for labels

for listboxes

for OLE objects

IconChanging OLE object properties via the ribbon tab
IconChanging OLE object properties via the dialog box

for pictures

for pushbuttons

for radio buttons

for scrollbars

for spinners

for text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

general properties

Objects

IconObjects
IconObjects – basic procedures

align and distribute

change order

change position and size

change properties

combine

distribute

duplicate

edit retroactively

group

hide

insert

rotate

rotate or flip

show hidden objects

IconHiding objects
IconDocument properties, Options tab

show text frame guidelines

ungroup

OCT2BIN (octal to binary)

OCT2DEC (octal to decimal)

OCT2HEX (octal to hexadecimal)

Octal to binary (OCT2BIN)

Octal to decimal (OCT2DEC)

Octal to hexadecimal (OCT2HEX)

ODD (round up to next odd number)

OFFSET (shifted reference)

OLE object (dialog box)

OLE object (ribbon tab)

OLE objects

change properties

IconChanging OLE object properties via the ribbon tab
IconChanging OLE object properties via the dialog box

edit

edit links

Equation Editor

insert

update links

warning when loading

Open (File)

IconOpening a document
IconChanging document templates
IconSaving and opening files in other file formats

Operators in formulas

Optimum height

Optimum width

OR (logical OR function)

Order (of objects)

Orientation

of printed pages

Other file formats

Outline pane

IconOutlines
IconChanging outline settings

Outlines

IconOutlines
IconGrouping cells
IconShowing/hiding grouped cells
IconChanging outline settings

automatically show outline pane

change settings

clear outline

group cells

options

protect

show/hide grouped cells

ungroup

Overlapping objects

IconChanging text frame properties via the dialog box
IconInner text tab (available for AutoShapes with text added)

Overwrite mode / Insert mode

disable

- P -

Page break preview

Page breaks

adjust manually

show/hide

Page setup

copy to other worksheets

headers and footers

number of pages

page format

IconPage setup
IconSet page format

page margins

page number

IconSetting page format options
IconSetting up headers and footers

page orientation

page size

print options

Paper size

Paper trays

Paragraph format (text frame)

line spacing

spacing above/below

text alignment

Paragraph format (text frames)

indents

Pascal distribution

NEGBINOM.DIST

NEGBINOMDIST

Paste

contents (selective)

reference

Paste copied content

Paste reference

IconPaste (special)
IconEntering external cell references

Paste special

Payment (PMT)

PCF (interest rate)

PDF export

PDF/A, create

Peakedness of a distribution (KURT)

PEARSON (Pearson correlation coefficient)

Percent (operator)

Percentage (number format)

PERCENTILE (percentiles of a data set)

PERCENTILE.EXC (percentiles of a data set)

PERCENTILE.INC (percentiles of a data set)

PERCENTRANK (percent rank in a data set)

PERCENTRANK.EXC (percent rank in a data set)

PERCENTRANK.INC (percent rank in a data set)

PERIOD (duration of fixed-interest investments)

PERMUT

PHI (standard normal distribution)

Photo frames

IconChanging the AutoShape of objects
IconChanging picture properties via the ribbon tab

PI (pi)

Picture (dialog box)

Picture (ribbon tab)

Pictures

change properties

change source

copy to document's folder

export

from scanner

insert

recolor

IconChanging picture properties via the ribbon tab
IconChanging picture properties via the dialog box

rotate or flip

save within document

select source

Pie chart

Pinned files

Pinned templates

Pivot tables

change the source data range

column labels

copy

create from existing data

create from external data

create from tables in worksheets

custom name for fields

IconWorking with the field list: Fields section
IconWorking with the field list: Areas section
IconField settings (Row/column labels area)
IconValue settings (Values area) 

custom name for pivot table

defer layout update

delete

field list: areas section

field list: configure the pivot table

field list: exercises

field list: fields section

field list: further options

field list: starting screen

field settings

fields: move and remove

filter

filter labels/filter values

form (field settings)

GETPIVOTDATA

group

layout (pivot table settings)

modify pivot table ranges

move

number format

outline form

pivot table settings

Pivot table sidebar

refresh when opening the file

IconPivot table settings
IconUpdating pivot tables and changing data range

report filter

IconStarting with the pivot table field list
IconSorting and filtering pivot tables

row labels

save source data with file

sort A-Z (fields in the field list)

sort A-Z (fields in the pivot report)

styles for pivot tables

subtotals

tabular form

update

value settings

values area

Plain text file format

IconSaving and opening files in other file formats
IconNotes on the text format

PlanMaker

basics

customize

settings

user interface

PlanMaker basics

PlanMaker file format

PlanMaker manual

PlanMaker Tour

Plot area (in charts)

PMBAK files

PMD file format

PMDX file format

PMT (payment)

POISSON (Poisson distribution)

Poisson distribution

POISSON

POISSON.DIST

POISSON.DIST (Poisson distribution)

POLYNOMIAL (polynomial coefficient)

Polynomial coefficient

MULTINOMIAL

POLYNOMIAL

Portrait format

Position (of objects)

Position of a value in a range (MATCH)

POWER (power)

PPMT (payment on the principal)

Precision as displayed

Present value (PV)

Preview (of a document)

Primary axes (in charts)

Principal

CUMPRINC (cumulative)

PPMT

Print a document

IconPrinting a document
IconPrinting a document

Print date

Print order

Print preview

Print range

define print range

remove print range

Print time

PROB (probability)

PRODUCT (product)

Product of matrices (MMULT)

Prompt for summary information when saving

PROPER (convert text to upper/lower case)

Properties (document)

Calculate tab

Colors tab

Fonts tab

Options tab

Protection tab

IconEnabling document protection
IconDocument properties, Protection tab

Statistics tab

Summary tab

IconDocument summary
IconDocument properties, Summary tab

Properties (object)

for charts

for checkboxes

for drawings

IconChanging drawing properties via the ribbon tab
IconChanging drawing properties via the dialog box

for dropdown lists

for groupboxes

for labels

for listboxes

for OLE objects

IconChanging OLE object properties via the ribbon tab
IconChanging OLE object properties via the dialog box

for pictures

for pushbuttons

for radio buttons

for scrollbars

for spinners

for text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

Properties (objects in general)

change default settings

general properties

Properties (worksheet)

Protect

cell protection

documents

sheet protection

workbooks

Protect outline

Protection indicator

Pushbuttons (form object)

PV (present value)

Pyramid chart

- Q -

QUARTILE (quartiles of a data set)

QUARTILE.EXC (quartiles of a data set)

QUARTILE.INC (quartiles of a data set)

Quick access toolbar

change position

IconSettings, Appearance tab
IconChanging the position of the Quick access toolbar

customize icons

Quick paths

QUOTIENT (quotient of a division)

- R -

Radar chart

IconChanging the chart type
IconChart properties, Radar tab

RADIANS (convert degrees to radians)

Radians to degrees (DEGREES)

Radio buttons (form object)

RAND (random value)

RANDBETWEEN (random value)

Rank

PERCENTRANK

PERCENTRANK.EXC

PERCENTRANK.INC

RANK

RANK.AVG

RANK.EQ

RANK (rank in a data set)

RANK.AVG (rank in a data set)

RANK.EQ (rank in a data set)

RATE (interest rate per period)

Rate of return

IRR

MIRR

Recalc automatically

Recalc only before ...

Recalculate (sheet)

IconUpdating sheets
IconDocument properties, Calculate tab

Redo

IconUndoing changes
IconUndoing changes

Redo (changes)

IconUndoing changes
IconUndoing changes

Reflection effect (for objects)

Refresh data for pivot table

Regression, exponential

statistics (LOGEST)

values (GROWTH)

Regression, linear

statistics (LINEST)

values (TREND)

Relative cell references

Remainder of a division

MOD (Excel method)

MODP (PlanMaker method)

Remove

duplicate rows

empty rows

Remove duplicate rows

Remove non-printable characters (CLEAN)

Remove spaces (TRIM)

Repeat (commands)

Repeated columns

Repeated rows

REPLACE (replace text in a text string)

Replace (ribbon command Home | Search)

IconReplace
IconAdvanced search options

Replace again (ribbon command Home | Search)

Replace text in a text string

REPLACE

SUBSTITUTE

REPT (repeat text string n times)

Research via the Internet

Reset

character formatting

IconResetting the character formatting
IconScope of character styles

PDF export options

picture settings

ribbon

SoftMaker Office settings

toolbars

Revert to previous version (file)

Ribbon

IconWelcome!
IconUser interface: Ribbon

create user-defined icons

customize

customize groups

customize icons

list of all ribbon commands and menu commands

manage

reset

show/hide

user interface

IconUser interface: Ribbon
IconSettings, Appearance tab
IconCustomizing the ribbon

Ribbon or menus with toolbars?

IconApplication window
IconSettings, Appearance tab

RIGHT (right part of a text string)

Right align

ROMAN (Roman numeral)

Root

n-th root (ROOTN)

square root (SQRT)

square root of x*Pi (SQRTPI)

ROOTN (n-th root)

Rotate

axis labels

IconCategory axis (X axis)
IconValue axis (Y axis)
IconSeries axis (Z axis)
IconChart title

cell contents

objects

IconRotating and flipping objects
IconObject properties, Format tab

text in AutoShapes

text in text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

Rotate or flip (objects)

Round

CEILING

EVEN

FIXED

FLOOR

INT

MROUND

ODD

ROUND

ROUNDDOWN

ROUNDUP

TRUNC

ROUND (round to n digits)

ROUNDDOWN (round down to n digits)

Rounding

display numbers rounded

final result

intermediate results

precision as displayed

ROUNDUP (round up to n digits)

Row

change height

IconCell size
IconChanging cell sizes via commands

delete

IconDeleting whole cells
IconDeleting empty rows
IconDeleting duplicate rows

hide/show

insert

optimum height

select

Row & column headers

ROW (function: row number of cells)

Row header

change row height

print

show/hide

use for selection

Row number of cells (ROW)

ROWS (function: number of rows in a range)

RRI (interest rate)

RSQ (square of Pearson)

- S -

Save (File)

Save all (File)

Save as (File)

IconSaving a document
IconSaving and opening files in other file formats

Scale document

Scaling (of printed pages)

Scan pictures

Scenarios

Scientific (number format)

Scribble mode on iOS

Scripts

IconForm objects and Excel macros and scripts
IconDifferences between PlanMaker and Excel
IconScripts (BasicMaker)

Scrollbars (form object)

Scrollbars, show/hide

Search (file manager)

Search (function)

FIND (search for text)

FIND (search text in string)

HLOOKUP

IconHLOOKUP (look up row-wise)
IconXIRR (internal rate of return)

LOOKUP

SEARCH (search text in string)

VLOOKUP

Search (ribbon command Home | Search)

IconSearching and replacing
IconSearch
IconAdvanced search options

cell contents

search again

Search again

Search files (file manager)

SECOND (second)

Secondary axes (in charts)

IconChart properties, Series tab
IconChart properties, Elements tab

Select

cells

objects

Select all

IconSelecting in the Windows, Mac or Linux version
IconObject mode

Select chart elements

Select source (file)

Send a document by e-mail

Send backward one level (object)

Send to back (object)

Series axis (in charts)

IconShowing/hiding axes and axis titles
IconSeries axis (Z axis)
IconChart title

SERIESSUM (sum of a power series)

Set as default

document template

object properties

Settings (PlanMaker)

IconCustomizing PlanMaker
IconChanging PlanMaker settings

Appearance tab

Backup tab

Edit tab

Files tab

Fonts tab

General tab

Language tab

System tab

View tab

Settings (SoftMaker Office)

export/import

reset

Shading (of cells)

Shadow (for objects)

Share a document (via Android/iOS)

Sheet

change properties

copy

delete

hide sheet

insert

move

rename

show sheet

visibility

SHEET (index of a worksheet)

Sheet direction

IconChanging the direction of worksheets
IconChanging worksheet properties

Sheet grid (gridlines), show

Sheet protection

IconSheet protection
IconStep 2: Enabling sheet protection

SHEETNAME (name of a worksheet)

SHEETNUMBER (compatibility function)

SHEETS (number of worksheets)

Shortcut keys

customize

for cell styles

for character styles

IconCreating character styles
IconApplying character styles

for special characters

predefined: Mac

predefined: Windows/Linux

Show cells

Show fonts in font list

Show formulas

Show hidden files and folders

Show hidden objects

IconHiding objects
IconDocument properties, Options tab

Show indicators (for comments)

Show tooltips

for commands

for formulas

Show warning when loading OLE objects

Show watch list

Show/hide chart elements

axes (X, Y, Z)

axis title

chart title

IconShowing/hiding chart titles
IconChart properties, Elements tab

data labels

error bars

gridlines

legend

lines

trendline

up/down bars

Show/hide keyboard automatically

Sidebar for the pivot table

Sign (operator)

SIGN (sign of a number)

SIN (sine)

Sine (SIN)

SINH (hyperbolic sine)

Size

of cells

of objects

SKEW (skewness of a distribution)

SLN (straight-line depreciation)

SLOPE (slope of a linear trend)

SMALL (k-th smallest number)

Small caps

SmartText

IconSmartText
IconInserting SmartText entries

SmartText entries

create

edit

expand

insert

replace automatically

Smooth edges of pictures

Smooth edges of screen fonts

Snapshots (backup copies)

IconBackup copies (file versions)
IconSettings, Backup tab

Soft edges effect (for objects)

Soft hyphen

SoftMaker

SoftMaker Basic

SoftMaker Equation Editor

Sort and filter

IconSorting cells
IconFiltering cells by their content

SORTM (sort function)

SORTV (sort function)

Spaces, different widths

Special filter

Spell check

as you type

IconCheck spelling as you type
IconSettings, Language tab

edit user dictionaries

install additional dictionaries

manual

set language

Spinners (form object)

SQRT (square root)

SQRTPI (square root of x*Pi)

Standard deviation

entire population (STDEV.P)

entire population (STDEVP)

entire population (STDEVPA)

sample (STDEV)

sample (STDEV.S)

sample (STDEVA)

Standard error of a linear regression (STEYX)

Standard normal distribution

GAUSS

NORM.S.DIST

NORM.S.INV

NORMSDIST

NORMSINV

PHI

Standard toolbar

STANDARDIZE (standardized value)

Start script

Statistics (of document)

Statistics of a regression

LINEST (linear)

LOGEST (exponential)

Status bar

show/hide

STDEV (standard deviation of a sample)

STDEV.P (standard deviation of entire population)

STDEV.S (standard deviation of a sample)

STDEVA (standard deviation of a sample)

STDEVP (standard deviation of entire population)

STDEVPA (standard deviation of entire population)

STEYX (standard error of a linear regression)

Stock chart

Strikethrough

Student’s t-distribution

T.DIST

T.DIST.2T (two-tailed)

T.DIST.RT (right-tailed)

T.INV (left-tailed)

T.INV.2T (two-tailed)

TDIST

TINV

Student’s t-test (T.TEST)

Student’s t-test (TTEST)

Subscripts

SUBSTITUTE (replace text in a text string)

SUBTOTAL (calculations without hidden cells)

Subtraction (operator)

SUM (Sum)

SUMIF (sum if condition is true)

SUMIFS (sum if conditions are true)

SUMPRODUCT (sum of products)

SUMSQ (sum of squares)

SUMX2MY2 (sum of x^2 - y^2)

SUMX2PY2 (sum of x^2 + y^2)

SUMXMY2 (sum of (x - y)^2)

Superscripts

Support

Surface chart

SWITCH (categorize initial value)

SYD (sum-of-years’ digits depreciation)

Syntax highlighting

System requirements

- T -

T (convert value into text string)

T.DIST (t-distribution)

T.DIST.2T (t-distribution two-tailed)

T.DIST.RT (t-distribution right-tailed)

T.INV (percentiles of the t-distribution left-tailed)

T.INV.2T (percentiles of the t-distribution two-tailed)

T.TEST (t-test)

Tab width (in text frames)

Table (ribbon tab)

Tables in worksheets

banded rows and columns

cell references

convert to range

create

delete rows/columns

delete table

emphasize first column

emphasize last column

expand automatically

insert rows/columns

name of table

select rows/columns

select table

summarize as pivot table

table name

table properties

table range

table styles

totals row

using names and specifiers

Tablet mode (Android/iOS)

Tabs for documents

IconDocument tabs
IconWorking with multiple documents

TAN (tangent)

Tangent (TAN)

TANH (hyperbolic tangent)

TDIST (t-distribution)

t-distribution

T.DIST

T.DIST.2T (two-tailed)

T.DIST.RT (right-tailed)

T.INV (left-tailed)

T.INV.2T (two-tailed)

TDIST

TINV

Technical support

Template folder

Text

copy

cut

delete

enter

paste

TEXT (convert number into text string)

Text (number format)

Text (Object properties tab)

Text alignment (text frame)

Text direction

IconChanging the text direction in table cells
IconChanging the text direction in text frames
IconChanging the direction of worksheets

Text filters (AutoFilter)

Text frame

paragraph format

Text frames

add/edit text

change properties

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

change text area

hyphenation

insert

Text input mode

Text strings

compare (EXACT)

concatenate (CONCAT)

concatenate (CONCATENATE)

concatenate (TEXTJOIN)

convert into a number (VALUE)

convert to a number (NUMBERVALUE)

cut a part (LEFT)

cut out part (RIGHT)

cut part (MID)

repeat n times (REPT)

Text styles

IconCharacter format
IconText styles

Text to columns, split

TextArt objects

change properties

drawing

transformation

TEXTJOIN (concatenate strings with separators)

TextMaker file format

Thousands separator

Three dimensional calculations

IconGoing three-dimensional
IconCalculating in three dimensions

Threshold value (GESTEP)

TIME (create time)

Time, enter

TIMEDIFF (time difference)

TIMEVALUE (convert text into time)

TINV (percentiles of the t-distribution)

Title (of charts)

Title bar

TODAY (current date)

Toolbar

Toolbars for Android/iOS

customize

user interface

IconUser interface on Android/iOS
IconSettings, Appearance tab

Toolbars for classic menus

create user-defined icons

customize

IconCustomizing toolbars
IconCustomizing toolbar icons

delete

locked

manage

position

rename

reset

show/hide

user interface

IconSettings, Appearance tab
IconCustomizing toolbars

visible in mode

Top row, freeze

Touch mode

Trace to error

Transformation (of TextArt objects)

Transparency (of pictures)

Transpose

matrix (MTRANS)

ribbon command Data | Edit

TRANSPOSE (transpose matrix)

TREND (values of a linear regression)

Trendline (in charts)

IconShowing/hiding the trendline
IconTrendlines

TRIM (remove spaces from text)

TRIMMEAN (mean without marginal values)

TRUE (logical value TRUE)

TRUNC (truncate a number)

TTEST (t-test)

TYPE (type of a value)

- U -

Underline (font)

Undo (changes)

IconUndoing changes
IconUndoing changes

Ungroup

cells (outliner)

objects

Unit conversion (CONVERT)

Unit of measure

Unpinned files

Unpinned templates

Up/down bars (in charts)

IconShowing/hiding up/down bars
IconData series and data points

Update

charts

IconUpdating charts
IconDocument properties, Calculate tab

external references

pivot tables

worksheet (calculations)

IconUpdating sheets
IconDocument properties, Calculate tab

Updates

Upper

option for the charcater format

PROPER (function)

UPPER (function)

UPPER (convert text to upper case)

Use left Alt as shortcut key

Use OpenGL engine

Use SHM extensions

Use system file dialogs

Use system menus

Use XIM

User dictionaries

User info

IconSettings, General tab
IconUSERFIELD (output user info)

User info (USERFIELD)

User interface (ribbon or menus?)

IconApplication window
IconSettings, Appearance tab

User interface on Android/iOS

IconUser interface on Android/iOS
IconSettings, Appearance tab

User interface size

User-defined number formats

IconWorking with custom number formats
IconStructure of a custom number format

USERFIELD (output user info)

- V -

VALUE (convert text into a number)

Value axis (in charts)

IconShowing/hiding axes and axis titles
IconValue axis (Y axis)

VAR (variance of a sample)

VAR.P (variance of entire population)

VAR.S (variance of a sample)

VARA (variance of a sample)

Variance

of a sample (VAR)

of a sample (VAR.S)

of a sample (VARA)

of entire population (VAR.P)

of entire population (VARP)

of entire population (VARPA)

VARP (variance of entire population)

VARPA (variance of entire population)

VBA scripts

IconForm objects and Excel macros and scripts
IconDifferences between PlanMaker and Excel
IconScripts (BasicMaker)

Version management

IconBackup copies (file versions)
IconSettings, Backup tab

Vertical alignment

of cell contents

of text frames

IconChanging text frame properties via the ribbon tab
IconChanging text frame properties via the dialog box

of text in AutoShapes

Vertical text

View

edit mode

full screen

object mode

touch mode

windows

zoom level

View side by side (windows)

Visibility

columns

rows

worksheet

Visual Basic

VLOOKUP (look up column-wise)

- W -

Walls (in charts)

Warning if a formula contains errors

Watch window

Weber function (BESSELY)

Week number

ISOWEEK

ISOWEEKNUM

WEEKNUM

WEEKDAY (weekday)

WEEKNUM (week number)

WEIBULL (Weibull distribution)

WEIBULL.DIST (Weibull distribution)

Width of a column

IconCell size
IconChanging cell sizes via commands

Window

close all

view side by side

Workbook

Workbook properties

Workbook protection

disable

enable

WORKDAY (date after x workdays)

Workdays

count (NETWORKDAYS)

date after x workdays (WORKDAY)

Worksheet

IconWorking with multiple worksheets
IconChanging worksheet properties

alternating shade

change properties

IconManaging worksheets
IconChanging worksheet properties

change sheet direction

copy

delete

hide sheet

insert

IconCreating new worksheets
IconWorking with the worksheet register

move

IconWorking with the worksheet register
IconManaging worksheets

rename

IconWorking with the worksheet register
IconManaging worksheets

select multiple

show sheet

visibility

Worksheet register

IconWorksheet register
IconWorking with the worksheet register

change color

display

font size

Worksheets

edit

format

protect

select

update calculations

IconUpdating sheets
IconDocument properties, Calculate tab

Workspace color

Wrap text

- X -

X axis (in charts)

IconShowing/hiding axes and axis titles
IconCategory axis (X axis)

XLS file format

XLSX file format

XNPV (net present value)

XOR (logical XOR function)

XY scatter chart

- Y -

Y axis (in charts)

IconShowing/hiding axes and axis titles
IconValue axis (Y axis)

YEAR (year of a date)

- Z -

Z axis (in charts)

IconShowing/hiding axes and axis titles
IconSeries axis (Z axis)
IconChart title

Z.TEST (z-test)

Zeros, show/hide

for number formats of cells

worksheet properties

Zoom level (view)

z-test

Z.TEST

ZTEST

ZTEST (z-test)