- # -

#DIV/0!

#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

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

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

AutoFilter

AutoFormat

Automatic percent input

Auto-Recover

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

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)

Axis title (in charts)

- B -

B (compatibility function)

Background color

of cells

of text

Backup copies

Backup folder

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

Category axis (in charts)

CEILING (round up to a multiple of base)

Cell

alignment

borders

change size

delete

do not print

enter data

fill automatically

hide

insert

merge

number format

protect

protection

select

shading

CELL (information about a cell)

Cell address as text (ADDRESS)

Cell contents

copy

cut

delete

paste

Cell formatting, transfer

Cell frame

Cell marker

Cell protection

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

font color

font size

italic

kerning

letter spacing

small caps

strikethrough

superscripts and subscripts

text styles

underline

Character formatting

apply to entire words

reset

Character pitch

Character styles

apply

based on

change

create

default style "Normal"

shortcut keys

Chart (dialog box)

Chart (ribbon tab)

Chart area

Chart title

Charts

add/delete data series

arrangement of data series

change chart location

change chart type

change properties

data in columns

data in rows

edit

insert

save as picture

select chart elements

update

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

Classic menus with toolbars

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

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)

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

Data labels (in charts)

Data points (in charts)

Data series (in charts)

add

delete

edit

Data series, fill automatically

Data source area (of charts)

Data 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

Default number format

Default template (document template)

"Normal"

change

switch

Default unit of measure

Defined names

Defined names (for cell ranges)

apply in existing formulas

export names as list

DEGREES (convert radians to degrees)

Degrees to radians (RADIANS)

Delete

cell contents

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)

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

Document protection

Document statistics

Document summary

enter

prompt for summary information when saving

Document tabs

Document templates

apply

change

create

default template "Normal"

Document, print

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

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

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)

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)

Error function

ERF

ERFC (complement)

Error type (ERROR.TYPE)

Error values in calculations

ERROR.TYPE (error type)

EUROCONVERT (convert EU currencies)

EVEN (round up to next even number)

EXACT (compare texts)

Excel file format

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

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

File manager

File properties

Calculate tab

Colors tab

Fonts tab

Options tab

Protection tab

Statistics tab

Summary tab

File type

File versions

File: Close

File: Exit

File: New

File: Open

File: Page setup

File: Print

File: Print preview

File: Properties

File: Save

File: Save all

File: Save as

FILENAME (file name of the document)

Fill

of objects

Fill cells (automatically)

Filling

of cells

Filters

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

Font

bold

italic

underline

Font color

Font lists, hide fonts

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

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

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

HARMEAN (harmonic mean)

Harmonic mean (HARMEAN)

Headers and footers

Height of a row

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)

HOLIDAY (dates of movable Christian holidays)

Horizontal alignment of cell contents

HOUR (hour)

HTML document

Hunspell dictionaries

Hyperbolic cosine (COSH)

Hyperbolic cotangent (COTH)

Hyperbolic sine (SINH)

Hyperbolic tangent (TANH)

Hypergeometric distribution

HYPGEOM.DIST

HYPGEOMDIST

HYPERLINK (function: hyperlink)

Hyperlinks (links)

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

of text in AutoShapes

Input method (Android)

Input validation

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?)

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)

- 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)

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)

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

Manage (button in the settings)

Manual (PlanMaker)

Margins

inner margins of AutoShapes

inner margins of cells

inner margins of text frames

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?

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)

apply in existing formulas

assign

create from selection

edit

insert list

Names (of objects)

Names (of tables)

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)

New pivot table

New program window

New table (tables in worksheets)

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

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

Number of periods (NPER)

Number of worksheets (SHEETS)

Number separators

Number series, fill automatically

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

for pictures

for pushbuttons

for radio buttons

for scrollbars

for spinners

for text frames

general properties

Objects

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

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

edit

edit links

Equation Editor

insert

update links

warning when loading

Open (File)

Operators in formulas

Optimum height

Optimum width

OR (logical OR function)

Order (of objects)

Orientation

of printed pages

Other file formats

Outline pane

Outlines

automatically show outline pane

change settings

clear outline

group cells

options

protect

show/hide grouped cells

ungroup

Overlapping objects

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

page margins

page number

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

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

PI (pi)

Picture (dialog box)

Picture (ribbon tab)

Pictures

change properties

change source

copy to document's folder

export

from scanner

insert

recolor

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

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

report filter

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

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

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

Statistics tab

Summary tab

Properties (object)

for charts

for checkboxes

for drawings

for dropdown lists

for groupboxes

for labels

for listboxes

for OLE objects

for pictures

for pushbuttons

for radio buttons

for scrollbars

for spinners

for text frames

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

customize icons

Quick paths

QUOTIENT (quotient of a division)

- R -

Radar chart

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)

Redo

Redo (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)

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

PDF export options

picture settings

ribbon

SoftMaker Office settings

toolbars

Revert to previous version (file)

Ribbon

create user-defined icons

customize

customize groups

customize icons

list of all ribbon commands and menu commands

manage

reset

show/hide

user interface

Ribbon or menus with toolbars?

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

cell contents

objects

text in AutoShapes

text in text frames

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

delete

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)

Scale document

Scaling (of printed pages)

Scan pictures

Scenarios

Scientific (number format)

Scribble mode on iOS

Scripts

Scrollbars (form object)

Scrollbars, show/hide

Search (file manager)

Search (function)

FIND (search for text)

FIND (search text in string)

HLOOKUP

LOOKUP

SEARCH (search text in string)

VLOOKUP

Search (ribbon command Home | Search)

cell contents

search again

Search again

Search files (file manager)

SECOND (second)

Secondary axes (in charts)

Select

cells

objects

Select all

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)

SERIESSUM (sum of a power series)

Set as default

document template

object properties

Settings (PlanMaker)

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

Sheet grid (gridlines), show

Sheet protection

SHEETNAME (name of a worksheet)

SHEETNUMBER (compatibility function)

SHEETS (number of worksheets)

Shortcut keys

customize

for cell styles

for 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

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

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

SmartText entries

create

edit

expand

insert

replace automatically

Smooth edges of pictures

Smooth edges of screen fonts

Snapshots (backup copies)

Soft edges effect (for objects)

Soft hyphen

SoftMaker

SoftMaker Basic

SoftMaker Equation Editor

Sort and filter

SORTM (sort function)

SORTV (sort function)

Spaces, different widths

Special filter

Spell check

as you type

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

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

Text filters (AutoFilter)

Text frame

paragraph format

Text frames

add/edit text

change properties

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

Text to columns, split

TextArt objects

change properties

drawing

transformation

TEXTJOIN (concatenate strings with separators)

TextMaker file format

Thousands separator

Three dimensional calculations

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

Toolbars for classic menus

create user-defined icons

customize

delete

locked

manage

position

rename

reset

show/hide

user interface

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)

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)

Ungroup

cells (outliner)

objects

Unit conversion (CONVERT)

Unit of measure

Unpinned files

Unpinned templates

Up/down bars (in charts)

Update

charts

external references

pivot tables

worksheet (calculations)

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

User info (USERFIELD)

User interface (ribbon or menus?)

User interface on Android/iOS

User interface size

User-defined number formats

USERFIELD (output user info)

- V -

VALUE (convert text into a number)

Value axis (in charts)

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

Version management

Vertical alignment

of cell contents

of text frames

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

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

alternating shade

change properties

change sheet direction

copy

delete

hide sheet

insert

move

rename

select multiple

show sheet

visibility

Worksheet register

change color

display

font size

Worksheets

edit

format

protect

select

update calculations

Workspace color

Wrap text

- X -

X axis (in charts)

XLS file format

XLSX file format

XNPV (net present value)

XOR (logical XOR function)

XY scatter chart

- Y -

Y axis (in charts)

YEAR (year of a date)

- Z -

Z axis (in charts)

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)