- # -
#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 or remove spaces when pasting
Add spacing around punctuation marks (French)
Add/edit text
for AutoShapes
for text frames
Addition (operator)
ADDRESS (cell address as text)
After input, move selection...
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
Analyze sheets
AND (logical AND function)
Android/iOS
context menu
input mode
select
share a document
unlock commands
unlock locked commands
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 (determinant)
MINVERSE (inverse)
MMULT (product)
MSOLVE (solution of matrix equation)
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 correction
Auto input mode
Autocomplete cells
AutoFill
AutoFilter
AutoFormat
Automatic percent input
Automatically recalc (worksheets)
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 conditions are 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
of the program
Backup copies
Backup folder
BAK files
Banded rows and columns
Bar chart
Barcode, generate
BASE (decimal number to another base)
Base-10 logarithm (LOG10)
Based on (for cell styles)
Based on (for character styles)
BasicMaker
Beep on errors (for spell check)
Beep on errors (for warning messages)
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)
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
iterative
update
Capitalize first letter of sentences
Category axis (in charts)
CEILING (round up to a multiple of base)
Cell
alignment
borders
change size
delete
do not display (protection)
do not print (protection)
enter data
fill automatically
insert
merge
number format
protect
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 references
absolute/relative
paste from clipboard
show cell contents in objects
to dynamic tables
Cell references, external
Enter
manage
update
Cell styles
apply
based on
create
default style "Normal"
delete
edit
rename
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
change
reset
Character pitch
Character styles
apply
based on
create
default style "Normal"
delete
edit
rename
shortcut keys
Chart (dialog box)
Chart (ribbon tab)
Chart area
Chart title
Charts
add/delete data series
change 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 for independence)
CHITEST (chi-square test for independence)
CHOICE (x>0, x=0, x<0?)
CHOOSE (choose value from list)
Circles, draw
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
insert
optimum width
select
show/hide
COLUMN (function: column number of cells)
Column chart
Column header
change column width
print
show/hide
use for selection
COLUMNS (function: number of columns in a range)
COMBIN (combinations)
Combine (object shapes)
Combine shapes
Command-line parameters
Commands, repeat
Comments
always show
delete
edit
insert
show in PDF export
show in the printout
Complex numbers
absolute value (IMABS)
angle (IMARGUMENT)
conjugate (IMCONJUGATE)
cosine (IMCOS)
create complex number (COMPLEX)
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
Compress pictures
CONCAT (concatenate strings from list)
CONCATENATE (concatenate text strings)
Concatenation (operator)
Concatenation of text 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)
Connectors, draw
Consolidate data
Context menu
CONVERT (unit conversion)
Convert EU currencies (EUROCONVERT)
Copy
cell contents
formula
insert copied cells
object
text
Corners (in charts)
Correct first TWo UPpercase LEtters
CORREL (correlation coefficient)
Correlation coefficient
CORREL
PEARSON
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 empty 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 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)
Current date (dynamic)
with time: NOW function
without time: TODAY function
Current date (static)
insert date via shortcut key
insert time via shortcut key
Curves, draw
Custom number formats
Customize
create user-defined icons
customize shortcut keys
customize toolbars
ribbon
Cut
cell contents
formula
object
text
Cylinder chart
- D -
Dark mode
for the user interface
for worksheets
Data consolidation
Data labels (in charts)
Data points (in charts)
Data series (in charts)
add
delete
edit
Data series, fill automatically
Data source area, change
for charts
for pivot tables
Data validation
Database functions
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
Date
create a date value (DATE function)
current (static), insert via shortcut key
enter in cell
updated, with time: NOW function
updated, without time: TODAY function
DATE (create a date value)
Date before/after n months (EDATE)
Date difference (DATEDIF)
Date filter (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 number to another base (BASE)
Decimal places, increase/decrease
Decimal places, increase/decrease
Decimal point after input
Decimal separator, change
Decimal to binary (DEC2BIN)
Decimal to hexadecimal (DEZ2HEX)
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 program to open
Default template (document template)
"Normal"
change
switch
Default unit of measure
Defined names
apply names to existing formulas
assign names
create a list of all named ranges
DEGREES (convert radians to degrees)
Degrees to radians (RADIANS)
Delete
cell content
cells
columns/rows
duplicate rows
empty rows
object
text
Delete special (cell content)
DELTA (test for equality)
Depreciation
double-declining balance (DDB)
fixed-declining balance (DB)
straight-line (SLN)
sum-of-years’ digits (SYD)
Design Science
Desktop mode (Android/iOS)
Determinant of a matrix (MDETERM)
DEVSQ (average square deviation)
DGET (database function)
Dialog language
Dictionaries for spell check
edit user dictionaries
export/import user dictionaries
install
Display formula contained in cell (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 template folder
create
default template "Normal"
edit
Document, print
Document, save
Documents, view side by side
Dollar (number format)
DOLLARDE (convert to dollar price decimal)
DOLLARFR (convert to dollar price fraction)
Doughnut chart
DPRODUCT (database function)
Drag and drop
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)
Duplicates
remove duplicate rows
show duplicate values
DVAR (database function)
DVARP (database function)
Dynamic tables
- E -
EDATE (date before/after n months)
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 and object mode
Edit points (of objects)
Edit script
Edit shapes retroactively
Edit toolbar
EFFECT (effective interest rate)
Effective interest rate (EFFECT)
Effects (for objects)
Ellipses, draw
Ellipsis ("...")
E-mail a document
Empty rows, delete
En dashes, different widths
Enable OpenGL engine (Linux only)
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)
Euro (number format)
EUROCONVERT (convert EU currencies)
EVEN (round up to next even number)
EXACT (compare texts)
Excel file format
Exit (file)
EXP (power of e)
Expand the input field
EXPON.DIST (exponential distribution)
EXPONDIST (exponential distribution)
Exponential distribution
EXPON.DIST
EXPONDIST
Exponential regression
statistics (LOGEST)
values (GROWTH)
Exponentiation (operator)
Export (other file format)
Export/Import of the settings
Extended support
for Arabic text
for Asian fonts
External cell 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 path, show in title bar
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
Filter
AutoFilter
special filter
SUBTOTAL (function)
FIND (search for text in a text string)
FINV (percentiles of the F distribution)
First column (highlight)
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 (round down to a multiple of base)
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
Format URLs as hyperlinks
Formatting toolbar
Forms
Formula auditing
Formulas and functions from A to Z
FORMULATEXT (display formula contained in cell)
Fractile (see PERCENTILE)
Fraction (number format)
Freehand, draw
Freeze cells
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)
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 worksheet 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
Guides for objects
- H -
Hamburger menu
HARMEAN (harmonic mean)
Harmonic mean (HARMEAN)
Header row in tables
Headers and footers
Height of a row, change
Help content, display (F1 key)
HEX2BIN (hexadecimal to binary)
HEX2DEZ (hexadecimal to decimal)
HEX2OCT (hexadecimal to octal)
Hexadecimal to binary (HEX2BIN)
Hexadecimal to decimal (HEX2DEZ)
Hexadecimal to octal (HEX2OCT)
Hide
cell contents (protection)
formulas (protection)
objects
rows/columns
Hide cells
manually
using an outliner
Hide formula (protection)
High-low chart
HLOOKUP (look up row-wise)
HOLIDAY (dates of movable Christian holidays)
Horizontal alignment
of cell contents
of text in AutoShapes
of text in text frames
HOUR (hour)
HTML format
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
format URLs as hyperlinks
HYPERLINK function
HYPGEOM.DIST (hypergeometric distribution)
HYPGEOMDIST (hypergeometric distribution)
Hyphen
non-breaking hyphen
soft hyphen
Hyphenation
in cells
in text frames
set language
- I -
IF (if-then-else condition)
IFEMPTY (return a defined value if cell is empty)
IFERROR (return a value if error)
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)
Images
copy to document’s folder
insert
save within document
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 the 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 a complex number)
IMSUB (difference of complex numbers)
IMSUM (sum of complex numbers)
In-cell editing
Indents (for text frames)
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 field, expand
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 special characters
Installation
Android
iOS
Linux
macOS
Windows
INT (round down to nearest integer)
INTERCEPT (intercept point of a regression line)
Interest payment
CUMIPMT (cumulative)
IPMT
ISPMT
Interest rate
PCF
per period (RATE)
RRI
Internal rate of return
IRR
MIRR
XIRR
Intersection
INTERSECTION (function: intersection of two ranges)
operator
Inverse hyperbolic cosine (ACOSH)
Inverse hyperbolic cotangent (ACOTH)
Inverse hyperbolic sine (ASINH)
Inverse hyperbolic tangent (ATANH)
Inverse matrix (MINVERSE)
iOS/Android
context menu
input mode
select
share a document
unlock commands
unlock locked commands
user interface
IPMT (interest payment)
IRR (internal rate of return)
ISBLANK (is empty?)
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 cells)
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 (highlight)
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 (for text frames)
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)
Link to cell content, show in object
Links (hyperlinks)
applied to cells
for objects
format URLs as hyperlinks
HYPERLINK function
Links (OLE objects)
edit
update
Listboxes (form object)
Live preview
LN (natural logarithm)
Locking objects
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 log-normal distribution)
LOGNORM.DIST (log-normal distribution)
LOGNORM.INV (percentiles of the log-normal distribution)
Log-normal distribution
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOGNORMDIST (log-normal distribution)
LOOKUP (search cell range)
LOWER (convert text to lowercase)
Lowercase
LOWER
PROPER
- M -
Macros
Mail the document
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?
Merge cells
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)
Modulo
MOD (Excel method)
MODP (PlanMaker method)
MONTH (month of a date)
Move by ... decimals
MROUND (round to a multiple of base)
MSOLVE (solution of matrix equation Ax=B)
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 to existing formulas
assign
create from selection
edit
insert list
Names (of objects)
Names (of tables)
NEG (negative value)
Negative binomial distribution
NEGBINOM.DIST
NEGBINOMDIST
Negative value (NEG)
Net present value
NPV
XNPV
NETWORKDAYS (number of workdays)
Neumann function (BESSELY)
New (File)
New pivot table, create
New program window
New table (create tables in worksheets)
NOMINAL (nominal interest rate)
Non-breaking hyphen
Non-breaking space
Non-printable characters, remove (CLEAN)
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 filter (AutoFilter)
Number format
Number of periods (NPER)
Number of worksheets (SHEETS)
Number separators
Number series, fill automatically
Numbers, enter
NUMBERVALUE (convert text into a number)
- O -
Object
copy
cut
delete
insert
paste
select
Object (dialog box)
Object mode and edit 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
change properties
combine
distribute
duplicate
edit retroactively
group
guides for alignment
hide
resize
rotate
rotate or flip
show hidden objects
show linked cell contents
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)
Ordinal numbers, add superscript (auto correction)
Orientation
of printed pages
Other file formats
Outline pane
Outlines
automatically show outline pane
change settings
group
options
protect
remove all groups
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 (for text frames)
indents
line spacing
spacing above/below
text alignment
Pascal distribution
NEGBINOM.DIST
NEGBINOMDIST
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 sign (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 (constant value of pi)
Picture (dialog box)
Picture (ribbon tab)
Pictures
change properties
change source
compress
copy to document’s folder
export
from scanner
insert
insert from the gallery/camera (Android/iOS)
recolor
rotate or flip
save within document
select source
Pie chart
Pinned files
Pinned templates
Pivot tables
change the source data area
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: initial screen
field settings
fields: move and remove
filter
filter labels/filter values
form (field settings)
GETPIVOTDATA
group
layout (pivot table settings)
modify pivot table areas
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 or Z-A (fields in the pivot report)
sort by fill lists (fields in the pivot report)
styles for pivot tables
subtotals
tabular form
update
value settings
values area
Plain text file format
PlanMaker
basics
customize
set as default program
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 distribution
POISSON
POISSON.DIST
Polynomial coefficient
MULTINOMIAL
POLYNOMIAL
Portrait format
Position (of objects)
Position of a value in a range (MATCH)
Power (POWER function)
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
Printable (object property)
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
document protection
outline
sheet protection
workbook protection
Protection indicator
Pushbuttons (form object)
PV (present value)
Pyramid chart
- Q -
QR code, generate
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
Quotes, smart
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
XIRR
Read aloud
Recalc only before ...
Recalculate
all worksheets
current worksheet
Rectangles, draw
Redo
Redo (changes)
References, external
Reflection effect (for objects)
Refresh data for pivot table
Regression, exponential
statistics (LOGEST)
values (GROWTH)
Regression, linear
FORECAST
INTERCEPT
show trend in charts
statistics (LINEST)
values (TREND)
Relative cell references
Remove duplicate rows
Remove empty rows
Remove spaces (TRIM)
Repeat commands
Repeat search
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 complex number (IMSQRT)
square root of x*Pi (SQRTPI)
ROOTN (n-th root)
Rotate
axis labels
cell contents
drawings
objects
pictures
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 (per number format)
final result
intermediate results
precision as displayed
ROUNDUP (round up to n digits)
Row
change height
delete
insert
optimum height
select
show/hide
Row & column headers
ROW (function: row number of cells)
Row header
change row height
print
show/hide
use for selection
ROWS (function: number of rows)
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 in a text string)
HLOOKUP
LOOKUP
SEARCH (search for text in a text string)
VLOOKUP
Search (ribbon command Home | Search)
cell contents
search again
Search files (file manager)
SECOND (second)
Secondary axes (in charts)
Select
always select whole word
cells
in the Android/iOS version
objects
Select all
Select chart elements
Select whole words when selecting
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 and via Windows 10 and higher)
Sheet
change properties
copy
delete
hide sheet
insert
move
protect
rename
show sheet
visibility
SHEET (index of a worksheet)
Sheet direction
Sheet grid (gridlines), show
Sheet protection
disable
enable
Sheet register
change color
display
font size
SHEETNAME (name of a worksheet)
SHEETNUMBER (compatibility function)
SHEETS (number of worksheets)
Shortcut keys
[export/import
customize
for cell styles
for character styles
for special characters
predefined shortcuts: Mac
predefined shortcuts: Windows/Linux
view list of all shortcut keys
Show cells
Show duplicate values
Show fonts in font list
Show formulas (ribbon tab View)
Show full path in title bar
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
Smart quotes
SmartText
export/import
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 Basic
SoftMaker Equation Editor
SoftMaker support
Sort and filter
SORTM (sort function)
SORTV (sort function)
Source data for charts
Source data for pivot tables
Source for picture files
Spaces, different widths
Speak
Special filter
Spell check
as you type
edit user dictionaries
install additional dictionaries
manual
set language
Spinners (form object)
SQLite file format
SQRT (square root)
SQRTPI (square root of x*Pi)
Square of Pearson (RSQ)
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)
Styles
cell styles
character styles
table styles
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)
Superscript of ordinal numbers (auto correction)
Superscripts
Support
Surface chart
SWITCH (categorize initial value)
SYD (sum-of-years’ digits depreciation)
Syntax highlighting
when opening Excel files
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
expand automatically
first column/last column, highlight
header row
insert rows/columns
name of table
names and identifiers
select rows/columns
select table
summarize as pivot table
table name
table properties
table range
table styles
total row
Tablet mode (Android/iOS)
Tabs for documents
Tabs, close
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 for document templates
Templates
document templates
Text
copy
cut
delete
paste
TEXT (convert number into text string)
Text (number format)
Text (Object properties tab)
Text alignment horizontal (for objects)
Text alignment vertical (for objects)
Text direction
Text filter (AutoFilter)
Text frames
add/edit text
change properties
change text area
hyphenation
insert
paragraph format
Text input mode
Text rotation for text frames
Text strings
compare (EXACT)
concatenate (CONCAT)
concatenate (CONCATENATE)
concatenate (TEXTJOIN)
convert into a number (NUMBERVALUE)
convert into a number (VALUE)
cut part (LEFT)
cut part (MID)
cut part (RIGHT)
repeat n times (REPT)
Text styles
Text to columns, split
Text, enter in cell
TextArt objects
change properties
drawing
transformation
TEXTJOIN (concatenate strings with separators)
TextMaker file format
Thousands separator
change
show
Three-dimensional calculations
Threshold value (GESTEP)
Time
current (static), insert via shortcut key
enter in cell
updated, with date: NOW function
TIME (create time)
TIMEDIFF (time difference)
TIMEVALUE (convert text into time)
TINV (percentiles of the t-distribution)
Title (of charts)
Title bar
TODAY (current date)
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
Total row in tables
Touch mode
Trace to error
Transformation (of TextArt objects)
Transparency (of pictures)
Transpose
matrix (MTRANS)
swap columns and rows
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 (convert text to uppercase)
Uppercase
character format option
PROPER (function)
UPPER (function)
Use left Alt for shortcut keys
Use SHM extensions
Use system file dialogs
Use XIM
User dictionaries
edit
export/import
User info
User info, output (USERFIELD)
User interface (ribbon or menus?)
User interface on Android/iOS
User interface size
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 in AutoShapes
of text in text frames
Vertical text
View
edit mode
full screen
object mode
touch mode
windows
zoom level
View side by side (windows)
Visibility
objects
rows/columns
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)
Whole word, select
Width of a column, change
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
protect
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)
XIRR (internal rate of return)
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)
Zero values, show/hide
for number formats of cells
worksheet properties
Zoom level (view)
z-test
Z.TEST
ZTEST
