www.dropbox.com
Open in
urlscan Pro
2620:100:6022:18::a27d:4212
Public Scan
Submitted URL: https://tctoolkit.com/
Effective URL: https://www.dropbox.com/scl/fi/zhmlu3ejjd9fce749hxnn/BONUS-The-Confidence-Toolkit.pdf?rlkey=2z165jjh66o3qyrskmdwbo4z3&dl=0
Submission: On July 05 via api from US — Scanned from DE
Effective URL: https://www.dropbox.com/scl/fi/zhmlu3ejjd9fce749hxnn/BONUS-The-Confidence-Toolkit.pdf?rlkey=2z165jjh66o3qyrskmdwbo4z3&dl=0
Submission: On July 05 via api from US — Scanned from DE
Form analysis 1 forms found in the DOM
POST
<form method="POST" novalidate="">
<div class="_susi-auth-field_4srl7_4">
<div class="_field-input-wrapper_4srl7_50"><label class="_field-input-label_4srl7_100" for="susi_email03006841929678239">Email</label><input id="susi_email03006841929678239" type="email" class="_field-input_4srl7_50" name="susi_email"
autocomplete="username" aria-describedby="susi_email03006841929678239__input-error" aria-invalid="false" inputmode="text" value=""><input class="_hide-password_vs4tt_4" type="password" id="credential-autofill-hint" name="autofill-password">
</div>
<div id="susi_email03006841929678239__input-error" aria-live="polite" aria-atomic="true" class="text-input-error-wrapper"></div>
</div>
<div class="_submit-container_vs4tt_12">
<div class="_email-check-button_vs4tt_8"><button
class="email-submit-button dwg-button2 dwg-button2--button-style-primary dwg-button2--button-size-standard dwg-box dwg-display--inline-block dwg-width--full dwg-pt--2 dwg-pr--3 dwg-pb--2 dwg-pl--3 dwg-bg-color--core-accent disabled:dwg-bg-color--disabled dwg-border-color--core-accent disabled:dwg-border-color--disabled dwg-border-style--solid dwg-color--inverse-standard disabled:dwg-color--inverse-faint"
rel="" type="submit">
<div
class="dwg-stack dwg-stack--v2 dwg-stack--grid-flow-column dwg-column-gap--3 dwg-box dwg-display--inline-grid dwg-position--relative dwg-width--full dwg-height--full dwg-align-items--center dwg-justify-content--center dwg-p--0 dwg-m--0 dwg-text-decoration--none">
<span
class="dwg-text dwg-font-family--atlas-grotesk dwg-font-size--16 dwg-font-weight--medium dwg-font-style--normal dwg-line-height--120% dwg-text-align--center dwg-button2__text dwg-box dwg-p--0 dwg-m--0 dwg-bg-color--transparent dwg-color--inherit">Continue</span>
</div>
</button></div>
</div>
</form>Text Content
BONUS - The Confidence Toolkitpdf
BONUS - The Confidence Toolkitpdf
File
Edit
View
Help
Share
Log inSign up
Page 1 of 150
Edit PDFDrawHighlightAdd text
Comment
175%
1.
Sexy Excel Keyboard Shortcuts!1.Arrow keysMoves left, right, up, or down
one cell2.HomeMoves to the beginning of the row3.Home* Moves to the
upper-left cell displayed in the window4.End*Moves to the lower-left cell
displayed in the window5.Arrow keys*Scrolls left, right, up, or down one
cell6.PgUpMoves up one screen7.PgDnMoves down one screen8.CTRL+PgUpMoves to
the previous sheet9.CTRL+PgDnMoves to the next sheet10.Alt+PgUpMoves one
screen to the left11.Alt+PgDnMoves one screen to the right12.CTRL+HomeMoves
to the first cell in the worksheet (A1)13.CTRL+EndMoves to the last active
cell of the worksheet14.CTRL+arrow keyMoves to the edge of a data block; if
the cell is blank, moves to the first nonblank cell15.CTRL+BackspaceScrolls
to display the active cell16.End, HomeMoves to the last nonempty cell on
the worksheet17.F5Prompts for a cell address to go to18.F6Moves to the next
pane of a window that has been split19.SHIFT+F6Moves to the previous pane
of a window that has been split20.CTRL+TabMoves to the next
window21.CTRL+SHIFT+TabMoves to the previous window22.SHIFT+F8Adds other
nonadjacent cells or ranges to the selection; pressing SHIFT+F8 again ends
Add mode23.SHIFT+arrow keyExpands the selection in the direction
indicated24.SHIFT+HomeExpands the selection to the beginning of the current
row25.F8Extends the selection as you use navigation keys. Press F8 again to
return to normal selection mode.26.F5Prompts for a range or range name to
select27.CTRL+GPrompts for a range or range name to
select28.SHIFT+BackspaceSelects the active cell in a range
selection29.CTRL+*Selects the block of data surrounding the active cell;
Selects the entire Pivot Table30.CTRL+spacebarSelects the entire column(s)
in the selected range31.SHIFT+spacebarSelects the entire row(s) in the
selected range32.CTRL+SHIFT+ spacebarSelects the entire
worksheet33.CTRL+ASelects the entire worksheet34.CTRL+SHIFT arrow
keysSelects to the end of the data range35.ALT+;Selects visible
cells36.EnterMoves the cell pointer. The direction depends on the setting
in the Edit tab of the Options dialog box.37.SHIFT+EnterMoves the cell
pointer up to the preceding cell in the selection38.TabMoves the cell
pointer right to the next cell in the selection39.SHIFT+TabMoves the cell
pointer left to the preceding cell in the selection40.CTRL+period (.)Moves
the cell pointer to the next corner of the current cell
range41.SHIFT+BackspaceCollapses the cell selection to just the active
cell42.F2Begins editing the active cell43.F3Pastes a name into a
formula44.Arrow keysMoves the cursor one character in the direction of the
arrow45.HomeMoves the cursor to the beginning of the line46.EscCancels the
editing47.EndMoves the cursor to the end of the line48.CTRL+rightarrow
Moves the cursor one word to the right49.CTRL+leftarrow Moves the cursor
one word to the left50.DelDeletes the character to the right of the
cursor51.CTRL+DelDeletes all characters from the cursor to the end of the
line52.BackspaceDeletes the character to the left of the
cursor53.CTRL+1Format➪[Selected Object]54.CTRL+BSets or removes
boldface55.CTRL+ISets or removes italic56.CTRL+USets or removes
underlining57.CTRL+5Sets or removes strikethrough58.CTRL+SHIFT+^Applies the
Exponential number format with two decimal places.59.CTRL+SHIFT+~Applies
the general number format60.CTRL+SHIFT+!Applies the comma format with two
decimal places61.CTRL+SHIFT+#Applies the date format (day, month,
year)62.CTRL+SHIFT+@Applies the time format (hour, minute,
a.m./p.m.)63.CTRL+SHIFT+$Applies the currency format with two decimal
places64.CTRL+SHIFT+%Applies the percent format with no decimal
places65.CTRL+SHIFT+&Applies border to outline66.CTRL+SHIFT+_Removes all
borders67.Alt+’Equivalent to Format➪Style68.CTRL+`Toggles from viewing the
Value or Formula in a cell69.CTRL+'Copies a formula from the cell above the
active cell into the cell or the Formula Bar.70.CTRL+"Copies the value from
the cell above the active cell into the cell or the Formula
Bar.71.CTRL++Displays the Insert dialog box to insert blank
cells72.CTRL+-Displays the Delete dialog box to delete the selected
cells.73.Alt+=Inserts the AutoSum formula74.Alt+BackspaceEquivalent to
Edit➪Undo75.Alt+EnterStarts a new line in the current cell76.CTRL+;Enters
the current date77.CTRL+:Enters the current time78.CTRL+0 (zero)Hides
columnsWorksheet Navigation* With Scroll Lock onSelectionsGetting
AroundFormula Bar EditingFormatting KeysOther Shortcut KeysCAC:
1489Copyright © 2023 ~ Mr. Lifestyle Enterprises, LLC ~ All Rights
ReservedCAC: 1489
2.
Sexy Excel Keyboard Shortcuts!79.CTRL+1Displays the Format Cells dialog
box80.CTRL+2Applies or removes bold formatting.81.CTRL+3Applies or removes
italic formatting.82.CTRL+4Applies or removes underlining.83.CTRL+5Applies
or removes strikethrough.84.CTRL+6Cycles among various ways of displaying
objects85.CTRL+7Toggles the display of the standard toolbar86.CTRL+8Toggles
the display of outline symbols87.CTRL+9Hides rows88.CTRL+A After typing a
function name in a formula, displays the Formula Palette89.CTRL+CEquivalent
to Edit➪Copy90.CTRL+DEquivalent to Edit➪Fill Down91.CTRL+EFlash
Fill92.CTRL+FEquivalent to Edit➪Find93.CTRL+HEquivalent to
Edit➪Replace94.CTRL+InsertEquivalent to Edit➪Copy95.CTRL+KEquivalent to
Insert➪Hyperlink96.CTRL+LEquivalent to Data➪Create List97.CTRL+NEquivalent
to File➪New98.CTRL+OEquivalent to File➪Open99.CTRL+PEquivalent to
File➪Print100.CTRL+REquivalent to Edit➪Fill Right101.CTRL+SEquivalent to
File➪Save102.CTRL+SHIFT+(Unhides rows103.CTRL+SHIFT+)Unhides
columns104.CTRL+SHIFT+:Enters the current time105.CTRL+SHIFT+AAfter typing
a valid function name in a formula, inserts the 'working model' for the
function106.CTRL+VEquivalent to Edit➪Paste107.CTRL+WEquivalent to
File➪Close108.CTRL+XEquivalent to Edit➪Cut109.CTRL+YRepeats the last
command or action110.CTRL+ZEquivalent to Edit➪Undo111.DeleteEquivalent to
Edit➪Clear➪Contents112.SHIFT+InsertEquivalent to
Edit➪Paste113.CTRL+ALT+VEquivalent to Edit➪Paste Special114.F1Displays Help
or the Office Assistant115.SHIFT+F1Displays the What’s This
cursor116.Alt+F1Inserts a chart sheet117.Alt+SHIFT+ F1Inserts a new
worksheet118.F2Edits the active cell119.SHIFT+F2Edits a cell
comment120.Alt+F2Issues Save As command121.Alt+SHIFT+F2Issues Save
command122.F3Pastes a name into a formula123.SHIFT+F3Pastes a function into
a formula124.CTRL+F3Defines a name125.CTRL+SHIFT+F3Displays the Creates
Names dialog box, to create names using row and column labels126.F4Repeats
the last action/ Adds absolute reference to a formula127.SHIFT+F4Repeats
the last Find (Find Next)128.CTRL+F4Closes the window129.Alt+F4Exits the
program130.F5Displays the Go To dialog box131.SHIFT+F5Displays the Find
dialog box132.CTRL+F5Restores the window size133.ALT+F5Refreshes data in a
Pivot Table134.F6Moves to the next pane135.SHIFT+F6Moves to the previous
pane136.CTRL+F6Moves to the next window137.CTRL+SHIFT+F6Moves to the
previous workbook window138.F7Issues Spelling command139.CTRL+F7Moves the
window140.F8Extends a selection (toggle)141.SHIFT+F8Adds to the selection
(toggle)142.CTRL+F8Resizes the window143.Alt+F8Displays the Macro dialog
box144.F9Calculates all sheets in all open workbooks145.SHIFT+F9Calculates
the active worksheet146.CTRL+Alt+F9Global calculation147.CTRL+F9Minimizes
the workbook148.F10Makes the menu bar active149.SHIFT+F10Displays a
shortcut menu150.CTRL+F10Maximizes or restores the workbook
window151.F11Creates a chart152.SHIFT+F11Inserts a new
worksheet153.CTRL+F11Inserts an Excel 4.0 macro sheet154.Alt+F11Displays
Visual Basic Editor155.F12Issues Save As command156.SHIFT+F12Issues Save
command157.CTRL+F12Issues Open command158.CTRL+SHIFT+F12Issues Print
commandFunction KeysOther Shortcut Keys (Continued...)CAC: 1489Copyright ©
2023 ~ Mr. Lifestyle Enterprises, LLC ~ All Rights ReservedCAC: 1489
3.
No.CategoryShortcut KeysDescription1.DocumentCommand-Control-DTo show/ hide
the definition of the selected word.2.DocumentCommand-Shift-Colon
(:)Display the Spelling and Grammar window.3.DocumentCommand-Semicolon
(;)To find misspelled words in the document.4.DocumentOption-DeleteDelete
the word to the left5.DocumentControl-HDelete the character to the
left6.DocumentControl-DDelete the character to the
right7.DocumentControl-KDelete the character to the between8.DocumentFn-Up
ArrowTo scroll up one page. 9.DocumentFn-Down ArrowTo scroll down one page.
10.DocumentFn-Left ArrowTo scroll to the beginning11.DocumentFn-Right
ArrowTo Scroll to the end to the begining.12.DocumentCommand-Up ArrowTo
Move the beginning of the document.13.DocumentCommand-Down ArrowTo Move the
End of the document.14.DocumentCommand-Left ArrowTo Move the beginning of
current line.15.DocumentCommand-Right ArrowTo Move the end of current line
of the document.16.DocumentOption-Left ArrowTo move the beginning of the
previous word.17.DocumentOption-Right ArrowTo move the end of the next
word.18.DocumentCommand-Shift-Up ArrowTo select the text between the
beginning.19.DocumentCommand-Shift-Down ArrowTo select the text between the
end.20.DocumentCommand-Shift-Left ArrowTo select the text between the
beginning.21.DocumentCommand-Shift-Right ArrowTo select the text between
the end in Current line22.DocumentShift-Up ArrowExtend text selection the
horizontal in line above.23.DocumentShift-Down ArrowExtend text selection
the horizontal in line below.24.DocumentShift-Left ArrowTo extend text
selection one character to the left.25.DocumentShift-Right ArrowTo extend
text selection one character to the right26.DocumentControl-ATo move the
beginning of the line or paragraph.27.DocumentControl-ETo move the end of
the line or paragraph.28.DocumentControl-FMove one character
forward.29.DocumentControl-BMove one character
backward.30.DocumentControl-LTo center the cursor in the visible
area.31.DocumentControl-PTo move up one line.32.DocumentControl-NTo move
down one line.33.DocumentControl-OTo insert a new
line.34.DocumentControl-TTo swap character behind the selection of
character35.DocumentCommand-Left Curly Bracket ({)For left
align.36.DocumentCommand-Right Curly Bracket (})For right
align.37.DocumentCommand-Shift-Vertical bar (|)For center
align.38.DocumentCommand-Option-FGo to the search field.
39.DocumentCommand-Option-TTo show/hide a toolbar in the
app.40.DocumentCommand-Option-CTo copy the formatting of selected
items41.DocumentCommand-Option-VTo apply the copied formatting
42.DocumentCommand-Option-ITo show/hide the inspector
window.43.DocumentCommand-Shift-PTo display a window for selecting document
setting44.DocumentCommand-Shift-STo display the Save As
dialog45.DocumentCommand-Shift-Minus sign (-) Use to decrease the size of
the selected item.46.DocumentCommand-Shift-Plus sign (+)Use to increase the
size of the selected item.47.DocumentCommand-Shift-Question mark (?)Open
the Help menu.48.GeneralCommand-CTo Copy the text49.GeneralCommand-VTo
Paste the copied text50.GeneralCommand-BTo bold the selected
text51.GeneralCommand-ITo change the font as italic52.GeneralCommand-Uto
underline the text53.GeneralCommand-FTo find the item54.GeneralCommand-GTo
find the next item55.GeneralCommand-NTo open new file56.GeneralCommand-OTo
open the selected item57.GeneralCommand-PTo print the
file58.GeneralCommand-STo save the file59.GeneralSpace barUse to quick
preview of selected item60.GeneralCommand-Shift-3To take the screenshot of
entire screen61.Generalcommand-control-VTo Displays The "Paste Special"
Dialog BoxExcel For Mac Keyboard Shortcuts!CAC:1489Copyright © 2023 ~ Mr.
Lifestyle Enterprises, LLC ~ All Rights ReservedCAC: 1489
4.
No.CategoryShortcut KeysDescriptionExcel For Mac Keyboard
Shortcuts!62.GeneralEscCancel The Selection63.Generalfn-F11To Create The
Chart64.Generalcommand-F4To Find Next65.Generalcommand-Shift-F4To Find
Previous66.Generaloption-F1To Insert Chart67.Generalcommand-/To Open Help
Section68.Generalcontrol - deleteShow Active Cell69.NavigateCommand-XTo
Cut/Remove the text70.NavigateDown ArrowGo To Left71.NavigateUp ArrowGo To
Right72.NavigateLeft ArrowGo To Up73.NavigateRight ArrowGo To
Down74.Navigateoption-Down arrowTo Display Auto Complete List75.Navigatefn
- left arrowMove To Beginning Of Line76.Navigatefn - right arrowMove To End
Of Line77.Navigatefn-control-left arrowTop Of
Module78.Navigatefn-control-right arrowEnd Of
Module79.Navigatefn-option-down ArrowMove One Word To
Left80.Navigatefn-option-up ArrowMove One Word To Right81.NavigateControl -
Down ArrowMove To Right Cell82.NavigateControl - Up ArrowMove To Left
Cell83.NavigateControl - Left ArrowMove To Upper Cell84.NavigateControl -
Right ArrowMove To Down Cell85.Navigatecontrol - option - Left arrowMove
Right Non Adjacent86.Navigatecontrol - option - Right arrowMove Left Non
Adjacent87.SelectionCommand-ZFor Undo88.SelectionCommand-ATo select all
items89.Selectionfn-Shift-F8To Add Selection90.SelectionShift-SpacebarTo
Select The Entire Row91.SelectionSHIFT- deleteTo Select Only Active
Cell92.Selectioncontrol-SpacebarSelect The Complete
Column93.Selectioncontrol - ATo Select The Entire
Worksheet94.Selectionoption - tabSame Selection In Next
Column95.Selectionoption - shift - tabSame Selection In Previous
Column96.Selectioncontrol - .Move Active Cell Clockwise In
Selection97.SelectionReturnMove Active Cell Down In
Selection98.Selectionshift - returnMove Active Cell Up99.SelectiontabMove
Active In Right Direction100.Selectionshift - tabMove Active In Left
Direction101.WindowCommand-Control-Power buttonTo restart the
Mac102.WindowCommand-Option-Power buttonTo put the Mac on sleep mode
103.WindowShift-Control-Power buttonPut your displays to
sleep.104.WindowCommand-HTo Hide the windows of the front
app105.WindowCommand-MTo minimize the front window to the
Doc106.WindowCommand-WTo close the window107.WindowCommand-QTo quit the
app108.WindowCommand-Option-EscTo force quit the app109.WindowCommand-TTo
show /hide the Fonts window.110.WindowCommand-DTo select the Desktop
folder.CAC:1489Copyright © 2023 ~ Mr. Lifestyle Enterprises, LLC ~ All
Rights ReservedCAC: 1489
5.
The Excel Functions!No.Function nameCategoryDescription1.ABS functionMath &
TrigReturns the absolute value of a number2.ACCRINT
functionFinancialReturns the accrued interest for a security that pays
periodic interest3.ACCRINTM functionFinancialReturns the accrued interest
for a security that pays interest at maturity4.ACOS functionMath &
TrigReturns the arccosine of a number5.ACOSH functionMath & TrigReturns the
inverse hyperbolic cosine of a number6.ACOT function (2013)Math &
TrigReturns the arccotangent of a number7.ACOTH function (2013)Math &
TrigReturns the hyperbolic arccotangent of a number8.AGGREGATE functionMath
& TrigReturns an aggregate in a list or database9.ADDRESS functionLookup &
ReferenceReturns a reference as text to a single cell in a
worksheet10.AMORDEGRC functionFinancialReturns the depreciation for each
accounting period by using a depreciation coefficient11.AMORLINC
functionFinancialReturns the depreciation for each accounting period12.AND
functionLogicalReturns TRUE if all of its arguments are TRUE13.ARABIC
function (2013)Math & TrigConverts a Roman number to Arabic, as a
number14.AREAS functionLookup & ReferenceReturns the number of areas in a
reference15.ASC functionTextChanges full-width (double-byte) English
letters or katakana within a character string to half-width (single-byte)
characters16.ASIN functionMath & TrigReturns the arcsine of a
number17.ASINH functionMath & TrigReturns the inverse hyperbolic sine of a
number18.ATAN functionMath & TrigReturns the arctangent of a number19.ATAN2
functionMath & TrigReturns the arctangent from x- and y-coordinates20.ATANH
functionMath & TrigReturns the inverse hyperbolic tangent of a
number21.AVEDEV functionStatisticalReturns the average of the absolute
deviations of data points from their mean22.AVERAGE
functionStatisticalReturns the average of its arguments23.AVERAGEA
functionStatisticalReturns the average of its arguments, including numbers,
text, and logical values24.AVERAGEIF functionStatisticalReturns the average
(arithmetic mean) of all the cells in a range that meet a given
criteria25.AVERAGEIFS function (2019)StatisticalReturns the average
(arithmetic mean) of all cells that meet multiple criteria.26.BAHTTEXT
functionTextConverts a number to text, using the ß (baht) currency
format27.BASE functionMath & TrigConverts a number into a text
representation with the given radix (base)28.BESSELI
functionEngineeringReturns the modified Bessel function In(x)29.BESSELJ
functionEngineeringReturns the Bessel function Jn(x)30.BESSELK
functionEngineeringReturns the modified Bessel function Kn(x)31.BESSELY
functionEngineeringReturns the Bessel function Yn(x)32.BETADIST function
(2007)CompatibilityReturns the beta cumulative distribution
function33.BETA.DIST function (2010)StatisticalReturns the beta cumulative
distribution function34.BETAINV function (2007)CompatibilityReturns the
inverse of the cumulative distribution function for a specified beta
distribution35.BETA.INV function (2010)StatisticalReturns the inverse of
the cumulative distribution function for a specified beta
distribution36.BIN2DEC functionEngineeringConverts a binary number to
decimal37.BIN2HEX functionEngineeringConverts a binary number to
hexadecimal38.BIN2OCT functionEngineeringConverts a binary number to
octal39.BINOMDIST function (2007)CompatibilityReturns the individual term
binomial distribution probability40.BINOM.DIST function
(2010)StatisticalReturns the individual term binomial distribution
probability41.BINOM.DIST.RANGE function (2013)StatisticalReturns the
probability of a trial result using a binomial distribution42.BINOM.INV
function (2010)StatisticalReturns the smallest value for which the
cumulative binomial distribution is less than or equal to a criterion
value43.BITAND function (2013)EngineeringReturns a 'Bitwise And' of two
numbers44.BITLSHIFT function (2013)EngineeringReturns a value number
shifted left by shift_amount bits45.BITOR function (2013)EngineeringReturns
a bitwise OR of 2 numbers46.BITRSHIFT function (2013)EngineeringReturns a
value number shifted right by shift_amount bits47.BITXOR function
(2013)EngineeringReturns a bitwise 'Exclusive Or' of two numbers48.CALL
functionAdd-in and AutomationCalls a procedure in a dynamic link library or
code resourceNote: Version markers indicate the version of Excel a function
was introduced. These functions are not available in earlier versions.CAC:
1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~ All Rights Reserved(Page
1 of 11)CAC: 1489
6.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.49.CEILING functionMath &
TrigRounds a number to the nearest integer or to the nearest multiple of
significance50.CEILING.MATH function (2013)Math & TrigRounds a number up,
to the nearest integer or to the nearest multiple of
significance51.CEILING.PRECISE functionMath & TrigRounds a number the
nearest integer or to the nearest multiple of significance. Regardless of
the sign of the number, the number is rounded up.52.CELL
functionInformationReturns information about the formatting, location, or
contents of a cell53.CHAR functionTextReturns the character specified by
the code number54.CHIDIST function (2007)CompatibilityReturns the
one-tailed probability of the chi-squared distribution55.CHIINV function
(2007)CompatibilityReturns the inverse of the one-tailed probability of the
chi-squared distribution56.CHITEST function (2007)CompatibilityReturns the
test for independence57.CHISQ.DIST function (2010)StatisticalReturns the
cumulative beta probability density function58.CHISQ.DIST.RT function
(2010)StatisticalReturns the one-tailed probability of the chi-squared
distribution59.CHISQ.INV function (2010)StatisticalReturns the cumulative
beta probability density function60.CHISQ.INV.RT function
(2010)StatisticalReturns the inverse of the one-tailed probability of the
chi-squared distribution61.CHISQ.TEST function (2010)StatisticalReturns the
test for independence62.CHOOSE functionLookup & ReferenceChooses a value
from a list of values63.CLEAN functionTextRemoves all nonprintable
characters from text64.CODE functionTextReturns a numeric code for the
first character in a text string65.COLUMN functionLookup & ReferenceReturns
the column number of a reference66.COLUMNS functionLookup &
ReferenceReturns the number of columns in a reference67.COMBIN functionMath
& TrigReturns the number of combinations for a given number of
objects68.COMBINA function (2013)Math & Trig69.COMPLEX
functionEngineeringConverts real and imaginary coefficients into a complex
number70.CONCAT function (2019)TextCombines the text from multiple ranges
and/or strings, but it doesn't provide the delimiter or IgnoreEmpty
arguments.71.CONCATENATE functionTextJoins several text items into one text
item72.CONFIDENCE function (2007)CompatibilityReturns the confidence
interval for a population mean73.CONFIDENCE.NORM function
(2010)StatisticalReturns the confidence interval for a population
mean74.CONFIDENCE.T function (2010)StatisticalReturns the confidence
interval for a population mean, using a Student's t distribution75.CONVERT
functionEngineeringConverts a number from one measurement system to
another76.CORREL functionStatisticalReturns the correlation coefficient
between two data sets77.COS functionMath & TrigReturns the cosine of a
number78.COSH functionMath & TrigReturns the hyperbolic cosine of a
number79.COT function (2013)Math & TrigReturns the hyperbolic cosine of a
number80.COTH function (2013)Math & TrigReturns the cotangent of an
angle81.COUNT functionStatisticalCounts how many numbers are in the list of
arguments82.COUNTA functionStatisticalCounts how many values are in the
list of arguments83.COUNTBLANK functionStatisticalCounts the number of
blank cells within a range84.COUNTIF functionStatisticalCounts the number
of cells within a range that meet the given criteria85.COUNTIFS function
(2019)StatisticalCounts the number of cells within a range that meet
multiple criteria86.COUPDAYBS functionFinancialReturns the number of days
from the beginning of the coupon period to the settlement date87.COUPDAYS
functionFinancialReturns the number of days in the coupon period that
contains the settlement date88.COUPDAYSNC functionFinancialReturns the
number of days from the settlement date to the next coupon date89.COUPNCD
functionFinancialReturns the next coupon date after the settlement
date90.COUPNUM functionFinancialReturns the number of coupons payable
between the settlement date and maturity date91.COUPPCD
functionFinancialReturns the previous coupon date before the settlement
date92.COVAR function (2007)CompatibilityReturns covariance, the average of
the products of paired deviations93.COVARIANCE.P function
(2010)StatisticalReturns covariance, the average of the products of paired
deviationsCAC: 1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~ All
Rights Reserved(Page 2 of 11)CAC: 1489
7.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.94.COVARIANCE.S function
(2010)StatisticalReturns the sample covariance, the average of the products
deviations for each data point pair in two data sets95.CRITBINOM function
(2007)CompatibilityReturns the smallest value for which the cumulative
binomial distribution is less than or equal to a criterion value96.CSC
function (2013)Math & TrigReturns the cosecant of an angle97.CSCH function
(2013)Math & TrigReturns the hyperbolic cosecant of an
angle98.CUBEKPIMEMBER functionCubeReturns a key performance indicator (KPI)
name, property, and measure, and displays the name and property in the
cell. A KPI is a quantifiable measurement, such as monthly gross profit or
quarterly employee turnover, used to monitor an organization's
performance.99.CUBEMEMBER functionCubeReturns a member or tuple in a cube
hierarchy. Use to validate that the member or tuple exists in the
cube.100.CUBEMEMBERPROPERTY functionCubeReturns the value of a member
property in the cube. Use to validate that a member name exists within the
cube and to return the specified property for this
member.101.CUBERANKEDMEMBER functionCubeReturns the nth, or ranked, member
in a set. Use to return one or more elements in a set, such as the top
sales performer or top 10 students.102.CUBESET functionCubeDefines a
calculated set of members or tuples by sending a set expression to the cube
on the server, which creates the set, and then returns that set to
Microsoft Office Excel.103.CUBESETCOUNT functionCubeReturns the number of
items in a set.104.CUBEVALUE functionCubeReturns an aggregated value from a
cube.105.CUMIPMT functionFinancialReturns the cumulative interest paid
between two periods106.CUMPRINC functionFinancialReturns the cumulative
principal paid on a loan between two periods107.DATE functionDate &
TimeReturns the serial number of a particular date108.DATEDIF functionDate
& TimeCalculates the number of days, months, or years between two dates.
This function is useful in formulas where you need to calculate an
age.109.DATEVALUE functionDate & TimeConverts a date in the form of text to
a serial number110.DAVERAGE functionDatabaseReturns the average of selected
database entries111.DAY functionDate & TimeConverts a serial number to a
day of the month112.DAYS function (2013)Date & TimeReturns the number of
days between two dates113.DAYS360 functionDate & TimeCalculates the number
of days between two dates based on a 360-day year114.DB
functionFinancialReturns the depreciation of an asset for a specified
period by using the fixed-declining balance method115.DBCS function
(2013)TextChanges half-width (single-byte) English letters or katakana
within a character string to full-width (double-byte) characters116.DCOUNT
functionDatabaseCounts the cells that contain numbers in a
database117.DCOUNTA functionDatabaseCounts nonblank cells in a
database118.DDB functionFinancialReturns the depreciation of an asset for a
specified period by using the double-declining balance method or some other
method that you specify119.DEC2BIN functionEngineeringConverts a decimal
number to binary120.DEC2HEX functionEngineeringConverts a decimal number to
hexadecimal121.DEC2OCT functionEngineeringConverts a decimal number to
octal122.DECIMAL functionMath & TrigConverts a text representation of a
number in a given base into a decimal number123.DEGREES functionMath &
TrigConverts radians to degrees124.DELTA functionEngineeringTests whether
two values are equal125.DEVSQ functionStatisticalReturns the sum of squares
of deviations126.DGET functionDatabaseExtracts from a database a single
record that matches the specified criteria127.DISC functionFinancialReturns
the discount rate for a security128.DMAX functionDatabaseReturns the
maximum value from selected database entries129.DMIN
functionDatabaseReturns the minimum value from selected database
entries130.DOLLAR functionTextConverts a number to text, using the $
(dollar) currency formatCAC: 1489Copyright © 2023 ~ Mr. Lifestyle
Enterprises ~ All Rights Reserved(Page 3 of 11)CAC: 1489
8.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.131.DOLLARDE
functionFinancialConverts a dollar price, expressed as a fraction, into a
dollar price, expressed as a decimal number132.DOLLARFR
functionFinancialConverts a dollar price, expressed as a decimal number,
into a dollar price, expressed as a fraction133.DPRODUCT
functionDatabaseMultiplies the values in a particular field of records that
match the criteria in a database134.DSTDEV functionDatabaseEstimates the
standard deviation based on a sample of selected database
entries135.DSTDEVP functionDatabaseCalculates the standard deviation based
on the entire population of selected database entries136.DSUM
functionDatabaseAdds the numbers in the field column of records in the
database that match the criteria137.DURATION functionFinancialReturns the
annual duration of a security with periodic interest payments138.DVAR
functionDatabaseEstimates variance based on a sample from selected database
entries139.DVARP functionDatabaseCalculates variance based on the entire
population of selected database entries140.EDATE functionDate & TimeReturns
the serial number of the date that is the indicated number of months before
or after the start date141.EFFECT functionFinancialReturns the effective
annual interest rate142.ENCODEURL function (2013)WebReturns a URL-encoded
string143.EOMONTH functionDate & TimeReturns the serial number of the last
day of the month before or after a specified number of months144.ERF
functionEngineeringReturns the error function145.ERF.PRECISE function
(2010)EngineeringReturns the error function146.ERFC
functionEngineeringReturns the complementary error function147.ERFC.PRECISE
function (2010)EngineeringReturns the complementary ERF function integrated
between x and infinity148.ERROR.TYPE functionInformationReturns a number
corresponding to an error type149.EUROCONVERT functionAdd-in and
AutomationConverts a number to euros, converts a number from euros to a
euro member currency, or converts a number from one euro member currency to
another by using the euro as an intermediary (triangulation).150.EVEN
functionMath & TrigRounds a number up to the nearest even integer151.EXACT
functionTextChecks to see if two text values are identical152.EXP
functionMath & TrigReturns e raised to the power of a given
number153.EXPON.DIST function (2010)StatisticalReturns the exponential
distribution154.EXPONDIST function (2007)CompatibilityReturns the
exponential distribution155.FACT functionMath & TrigReturns the factorial
of a number156.FACTDOUBLE functionMath & TrigReturns the double factorial
of a number157.FALSE functionLogicalReturns the logical value
FALSE158.F.DIST function (2010)StatisticalReturns the F probability
distribution159.FDIST function (2007)CompatibilityReturns the F probability
distribution160.F.DIST.RT function (2010)StatisticalReturns the F
probability distribution161.FILTER function (Office 365)Lookup &
ReferenceFilters a range of data based on criteria you define162.FILTERXML
function (2013)WebReturns specific data from the XML content by using the
specified XPath163.FIND, FINDB functionsTextFinds one text value within
another (case-sensitive)164.F.INV function (2010)StatisticalReturns the
inverse of the F probability distribution165.F.INV.RT function
(2010)StatisticalReturns the inverse of the F probability
distribution166.FINV functionStatisticalReturns the inverse of the F
probability distribution167.FISHER functionStatisticalReturns the Fisher
transformation168.FISHERINV functionStatisticalReturns the inverse of the
Fisher transformation169.FIXED functionTextFormats a number as text with a
fixed number of decimals170.FLOOR functionCompatibilityRounds a number
down, toward zero171.FLOOR.MATH function (2013)Math & TrigRounds a number
down, to the nearest integer or to the nearest multiple of significanceCAC:
1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~ All Rights Reserved(Page
4 of 11)CAC: 1489
9.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.172.FLOOR.PRECISE
functionMath & TrigRounds a number the nearest integer or to the nearest
multiple of significance. Regardless of the sign of the number, the number
is rounded up.173.FORECAST functionStatisticalReturns a value along a
linear trend (Replaced by FORECAST.LINEAR in 2016)174.FORECAST.ETS function
(2016)StatisticalReturns a future value based on existing (historical)
values by using the AAA version of the Exponential Smoothing (ETS)
algorithm175.FORECAST.ETS.CONFINT function (2016)StatisticalReturns a
confidence interval for the forecast value at the specified target
date176.FORECAST.ETS.SEASONALITY function (2016)StatisticalReturns the
length of the repetitive pattern Excel detects for the specified time
series177.FORECAST.ETS.STAT function (2016)StatisticalReturns a statistical
value as a result of time series forecasting178.FORECAST.LINEAR function
(2016)StatisticalReturns a future value based on existing
values179.FORMULATEXT function (2013)Lookup & ReferenceReturns the formula
at the given reference as text180.FREQUENCY functionStatisticalReturns a
frequency distribution as a vertical array181.F.TEST function
(2010)StatisticalReturns the result of an F-test182.FTEST function
(2007)CompatibilityReturns the result of an F-test183.FV
functionFinancialReturns the future value of an investment184.FVSCHEDULE
functionFinancialReturns the future value of an initial principal after
applying a series of compound interest rates185.GAMMA function
(2013)StatisticalReturns the Gamma function value186.GAMMA.DIST function
(2010)StatisticalReturns the gamma distribution187.GAMMADIST
functionCompatibilityReturns the gamma distribution188.GAMMA.INV function
(2010)StatisticalReturns the inverse of the gamma cumulative
distribution189.GAMMAINV functionCompatibilityReturns the inverse of the
gamma cumulative distribution190.GAMMALN functionStatisticalReturns the
natural logarithm of the gamma function, Γ(x)191.GAMMALN.PRECISE function
(2010)StatisticalReturns the natural logarithm of the gamma function,
Γ(x)192.GAUSS function (2013)StatisticalReturns 0.5 less than the standard
normal cumulative distribution193.GCD functionMath & TrigReturns the
greatest common divisor194.GEOMEAN functionStatisticalReturns the geometric
mean195.GESTEP functionEngineeringTests whether a number is greater than a
threshold value196.GETPIVOTDATA functionLookup & ReferenceReturns data
stored in a PivotTable report197.GROWTH functionStatisticalReturns values
along an exponential trend198.HARMEAN functionStatisticalReturns the
harmonic mean199.HEX2BIN functionEngineeringConverts a hexadecimal number
to binary200.HEX2DEC functionEngineeringConverts a hexadecimal number to
decimal201.HEX2OCT functionEngineeringConverts a hexadecimal number to
octal202.HLOOKUP functionLookup & ReferenceLooks in the top row of an array
and returns the value of the indicated cell203.HOUR functionDate &
TimeConverts a serial number to an hour204.HYPERLINK functionLookup &
ReferenceCreates a shortcut or jump that opens a document stored on a
network server, an intranet, or the Internet205.HYPGEOM.DIST
functionStatisticalReturns the hypergeometric distribution206.HYPGEOMDIST
functionCompatibilityReturns the hypergeometric distribution207.IF
functionLogicalSpecifies a logical test to perform208.IFERROR
functionLogicalReturns a value you specify if a formula evaluates to an
error; otherwise, returns the result of the formula209.IFNA function
(2013)LogicalReturns the value you specify if the expression resolves to
#N/A, otherwise returns the result of the expression210.IFS function
(2019)LogicalChecks whether one or more conditions are met and returns a
value that corresponds to the first TRUE condition.211.IMABS
functionEngineeringReturns the absolute value (modulus) of a complex
number212.IMAGINARY functionEngineeringReturns the imaginary coefficient of
a complex number213.IMARGUMENT functionEngineeringReturns the argument
theta, an angle expressed in radians214.IMCONJUGATE
functionEngineeringReturns the complex conjugate of a complex
number215.IMCOS functionEngineeringReturns the cosine of a complex
number216.IMCOSH function (2013)EngineeringReturns the hyperbolic cosine of
a complex number217.IMCOT function (2013)EngineeringReturns the cotangent
of a complex number218.IMCSC function (2013)EngineeringReturns the cosecant
of a complex number219.IMCSCH function (2013)EngineeringReturns the
hyperbolic cosecant of a complex numberCAC: 1489Copyright © 2023 ~ Mr.
Lifestyle Enterprises ~ All Rights Reserved(Page 5 of 11)CAC: 1489
10.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.220.IMDIV
functionEngineeringReturns the quotient of two complex numbers221.IMEXP
functionEngineeringReturns the exponential of a complex number222.IMLN
functionEngineeringReturns the natural logarithm of a complex
number223.IMLOG10 functionEngineeringReturns the base-10 logarithm of a
complex number224.IMLOG2 functionEngineeringReturns the base-2 logarithm of
a complex number225.IMPOWER functionEngineeringReturns a complex number
raised to an integer power226.IMPRODUCT functionEngineeringReturns the
product of complex numbers227.IMREAL functionEngineeringReturns the real
coefficient of a complex number228.IMSEC function (2013)EngineeringReturns
the secant of a complex number229.IMSECH function (2013)EngineeringReturns
the hyperbolic secant of a complex number230.IMSIN
functionEngineeringReturns the sine of a complex number231.IMSINH function
(2013)EngineeringReturns the hyperbolic sine of a complex number232.IMSQRT
functionEngineeringReturns the square root of a complex number233.IMSUB
functionEngineeringReturns the difference between two complex
numbers234.IMSUM functionEngineeringReturns the sum of complex
numbers235.IMTAN function (2013)EngineeringReturns the tangent of a complex
number236.INDEX functionLookup & ReferenceUses an index to choose a value
from a reference or array237.INDIRECT functionLookup & ReferenceReturns a
reference indicated by a text value238.INFO functionInformationReturns
information about the current operating environment239.INT functionMath &
TrigRounds a number down to the nearest integer240.INTERCEPT
functionStatisticalReturns the intercept of the linear regression
line241.INTRATE functionFinancialReturns the interest rate for a fully
invested security242.IPMT functionFinancialReturns the interest payment for
an investment for a given period243.IRR functionFinancialReturns the
internal rate of return for a series of cash flows244.ISBLANK
functionInformationReturns TRUE if the value is blank245.ISERR
functionInformationReturns TRUE if the value is any error value except
#N/A246.ISERROR functionInformationReturns TRUE if the value is any error
value247.ISEVEN functionInformationReturns TRUE if the number is
even248.ISFORMULA function (2013)InformationReturns TRUE if there is a
reference to a cell that contains a formula249.ISLOGICAL
functionInformationReturns TRUE if the value is a logical value250.ISNA
functionInformationReturns TRUE if the value is the #N/A error
value251.ISNONTEXT functionInformationReturns TRUE if the value is not
text252.ISNUMBER functionInformationReturns TRUE if the value is a
number253.ISODD functionInformationReturns TRUE if the number is
odd254.ISREF functionInformationReturns TRUE if the value is a
reference255.ISTEXT functionInformationReturns TRUE if the value is
text256.ISO.CEILING function (2013)Math & TrigReturns a number that is
rounded up to the nearest integer or to the nearest multiple of
significance257.ISOWEEKNUM function (2013)Date & TimeReturns the number of
the ISO week number of the year for a given date258.ISPMT
functionFinancialCalculates the interest paid during a specific period of
an investment259.JIS functionTextChanges half-width (single-byte)
characters within a string to full-width (double-byte) characters260.KURT
functionStatisticalReturns the kurtosis of a data set261.LARGE
functionStatisticalReturns the k-th largest value in a data set262.LCM
functionMath & TrigReturns the least common multiple263.LEFT, LEFTB
functionsTextReturns the leftmost characters from a text value264.LEN, LENB
functionsTextReturns the number of characters in a text string265.LINEST
functionStatisticalReturns the parameters of a linear trend266.LN
functionMath & TrigReturns the natural logarithm of a number267.LOG
functionMath & TrigReturns the logarithm of a number to a specified
base268.LOG10 functionMath & TrigReturns the base-10 logarithm of a
number269.LOGEST functionStatisticalReturns the parameters of an
exponential trend270.LOGINV functionCompatibilityReturns the inverse of the
lognormal cumulative distribution271.LOGNORM.DIST function
(2010)StatisticalReturns the cumulative lognormal
distribution272.LOGNORMDIST functionCompatibilityReturns the cumulative
lognormal distribution273.LOGNORM.INV function (2010)StatisticalReturns the
inverse of the lognormal cumulative distribution274.LOOKUP functionLookup &
ReferenceLooks up values in a vector or array275.LOWER functionTextConverts
text to lowercase276.MATCH functionLookup & ReferenceLooks up values in a
reference or arrayCAC: 1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~
All Rights Reserved(Page 6 of 11)CAC: 1489
11.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.277.MAX
functionStatisticalReturns the maximum value in a list of arguments278.MAXA
functionStatisticalReturns the maximum value in a list of arguments,
including numbers, text, and logical values279.MAXIFS function
(2019)StatisticalReturns the maximum value among cells specified by a given
set of conditions or criteria280.MDETERM functionMath & TrigReturns the
matrix determinant of an array281.MDURATION functionFinancialReturns the
Macauley modified duration for a security with an assumed par value of
$100282.MEDIAN functionStatisticalReturns the median of the given
numbers283.MID, MIDB functionsTextReturns a specific number of characters
from a text string starting at the position you specify284.MIN
functionStatisticalReturns the minimum value in a list of
arguments285.MINIFS function (2019)StatisticalReturns the minimum value
among cells specified by a given set of conditions or criteria.286.MINA
functionStatisticalReturns the smallest value in a list of arguments,
including numbers, text, and logical values287.MINUTE functionDate &
TimeConverts a serial number to a minute288.MINVERSE functionMath &
TrigReturns the matrix inverse of an array289.MIRR functionFinancialReturns
the internal rate of return where positive and negative cash flows are
financed at different rates290.MMULT functionMath & TrigReturns the matrix
product of two arrays291.MOD functionMath & TrigReturns the remainder from
division292.MODE functionCompatibilityReturns the most common value in a
data set293.MODE.MULT function (2010)StatisticalReturns a vertical array of
the most frequently occurring, or repetitive values in an array or range of
data294.MODE.SNGL function (2010)StatisticalReturns the most common value
in a data set295.MONTH functionDate & TimeConverts a serial number to a
month296.MROUND functionMath & TrigReturns a number rounded to the desired
multiple297.MULTINOMIAL functionMath & TrigReturns the multinomial of a set
of numbers298.MUNIT function (2013)Math & TrigReturns the unit matrix or
the specified dimension299.N functionInformationReturns a value converted
to a number300.NA functionInformationReturns the error value
#N/A301.NEGBINOM.DIST function (2010)StatisticalReturns the negative
binomial distribution302.NEGBINOMDIST functionCompatibilityReturns the
negative binomial distribution303.NETWORKDAYS functionDate & TimeReturns
the number of whole workdays between two dates304.NETWORKDAYS.INTL function
(2010)Date & TimeReturns the number of whole workdays between two dates
using parameters to indicate which and how many days are weekend
days305.NOMINAL functionFinancialReturns the annual nominal interest
rate306.NORM.DIST function (2010)StatisticalReturns the normal cumulative
distribution307.NORMDIST functionCompatibilityReturns the normal cumulative
distribution308.NORMINV functionStatisticalReturns the inverse of the
normal cumulative distribution309.NORM.INV function
(2010)CompatibilityReturns the inverse of the normal cumulative
distribution310.NORM.S.DIST function (2010)StatisticalReturns the standard
normal cumulative distribution311.NORMSDIST functionCompatibilityReturns
the standard normal cumulative distribution312.NORM.S.INV function
(2010)StatisticalReturns the inverse of the standard normal cumulative
distribution313.NORMSINV functionCompatibilityReturns the inverse of the
standard normal cumulative distribution314.NOT functionLogicalReverses the
logic of its argument315.NOW functionDate & TimeReturns the serial number
of the current Date & Time316.NPER functionFinancialReturns the number of
periods for an investment317.NPV functionFinancialReturns the net present
value of an investment based on a series of periodic cash flows and a
discount rate318.NUMBERVALUE function (2013)TextConverts text to number in
a locale-independent manner319.OCT2BIN functionEngineeringConverts an octal
number to binary320.OCT2DEC functionEngineeringConverts an octal number to
decimal321.OCT2HEX functionEngineeringConverts an octal number to
hexadecimal322.ODD functionMath & TrigRounds a number up to the nearest odd
integer323.ODDFPRICE functionFinancialReturns the price per $100 face value
of a security with an odd first period324.ODDFYIELD
functionFinancialReturns the yield of a security with an odd first
periodCAC: 1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~ All Rights
Reserved(Page 7 of 11)CAC: 1489
12.
The Excel Functions!No.Function nameCategoryDescriptionNote: Version
markers indicate the version of Excel a function was introduced. These
functions are not available in earlier versions.325.ODDLPRICE
functionFinancialReturns the price per $100 face value of a security with
an odd last period326.ODDLYIELD functionFinancialReturns the yield of a
security with an odd last period327.OFFSET functionLookup &
ReferenceReturns a reference offset from a given reference328.OR
functionLogicalReturns TRUE if any argument is TRUE329.PDURATION function
(2013)FinancialReturns the number of periods required by an investment to
reach a specified value330.PEARSON functionStatisticalReturns the Pearson
product moment correlation coefficient331.PERCENTILE.EXC function
(2010)StatisticalReturns the k-th percentile of values in a range, where k
is in the range 0..1, exclusive332.PERCENTILE.INC function
(2010)StatisticalReturns the k-th percentile of values in a
range333.PERCENTILE functionCompatibilityReturns the k-th percentile of
values in a range334.PERCENTRANK.EXC function (2010)StatisticalReturns the
rank of a value in a data set as a percentage (0..1, exclusive) of the data
set335.PERCENTRANK.INC function (2010)StatisticalReturns the percentage
rank of a value in a data set336.PERCENTRANK functionCompatibilityReturns
the percentage rank of a value in a data set337.PERMUT
functionStatisticalReturns the number of permutations for a given number of
objects338.PERMUTATIONA function (2013)StatisticalReturns the number of
permutations for a given number of objects (with repetitions) that can be
selected from the total objects339.PHI function (2013)StatisticalReturns
the value of the density function for a standard normal
distribution340.PHONETIC functionTextExtracts the phonetic (furigana)
characters from a text string341.PI functionMath & TrigReturns the value of
pi342.PMT functionFinancialReturns the periodic payment for an
annuity343.POISSON.DIST function (2010)StatisticalReturns the Poisson
distribution344.POISSON functionCompatibilityReturns the Poisson
distribution345.POWER functionMath & TrigReturns the result of a number
raised to a power346.PPMT functionFinancialReturns the payment on the
principal for an investment for a given period347.PRICE
functionFinancialReturns the price per $100 face value of a security that
pays periodic interest348.PRICEDISC functionFinancialReturns the price per
$100 face value of a discounted security349.PRICEMAT
functionFinancialReturns the price per $100 face value of a security that
pays interest at maturity350.PROB functionStatisticalReturns the
probability that values in a range are between two limits351.PRODUCT
functionMath & TrigMultiplies its arguments352.PROPER
functionTextCapitalizes the first letter in each word of a text value353.PV
functionFinancialReturns the present value of an investment354.QUARTILE
functionCompatibilityReturns the quartile of a data set355.QUARTILE.EXC
function (2010)StatisticalReturns the quartile of the data set, based on
percentile values from 0..1, exclusive356.QUARTILE.INC function
(2010)StatisticalReturns the quartile of a data set357.QUOTIENT
functionMath & TrigReturns the integer portion of a division358.RADIANS
functionMath & TrigConverts degrees to radians359.RAND functionMath &
TrigReturns a random number between 0 and 1360.RANDARRAY function (Office
365)Math & TrigReturns an array of random numbers between 0 and 1. However,
you can specify the number of rows and columns to fill, minimum and maximum
values, and whether to return whole numbers or decimal
values.361.RANDBETWEEN functionMath & TrigReturns a random number between
the numbers you specify362.RANK.AVG function (2010)StatisticalReturns the
rank of a number in a list of numbers363.RANK.EQ function
(2010)StatisticalReturns the rank of a number in a list of numbers364.RANK
functionCompatibilityReturns the rank of a number in a list of
numbers365.RATE functionFinancialReturns the interest rate per period of an
annuity366.RECEIVED functionFinancialReturns the amount received at
maturity for a fully invested security367.REGISTER.ID functionAdd-in and
AutomationReturns the register ID of the specified dynamic link library
(DLL) or code resource that has been previously registered368.REPLACE,
REPLACEB functionsTextReplaces characters within text369.REPT
functionTextRepeats text a given number of times370.RIGHT, RIGHTB
functionsTextReturns the rightmost characters from a text valueCAC:
1489Copyright © 2023 ~ Mr. Lifestyle Enterprises ~ All Rights Reserved(Page
8 of 11)CAC: 1489
Save it for later in Dropbox
LOG IN OR SIGN UP
Continue with Apple
or
Email
Continue
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word word word word word word word word word
word word word word word word word word
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
mmMwWLliI0fiflO&1
SOMEONE SHARED A FILE WITH YOU
Here’s what you can do to keep work flowing in Dropbox.
SkipShow me