This article will help you to get started working with spreadsheets, if the tool is enabled for a question.
In this guide:
Overview
If this tool is enabled, select the spreadsheet icon above the question stem to open the spreadsheet tool.
You can enter data, formulas, and use functions, similar to other spreadsheet programs.
Currently, Examplify allows a maximum of three sheets in a spreadsheet, and each sheet may have a maximum of 35 rows and 20 columns. These limits will be raised in a future version of Examplify.
Unsupported Excel Features
The following Microsoft Excel features are not supported.
- Excel Add-ins (e.g. Solver, Analysis ToolPak, etc.)
- Analyze Data
- Pivot Table*
- Pivot Chart
- Maps
- Hyperlinks
- Comments
- Text tools
- Equations
- Drawings
- Themes
- Database Queries
- What-If Analysis (Scenarios, Goal Seek)
- Backgrounds
- Protect Sheet/Workbook
- Excel Macros
* Pivot Table support will be added in the future.
Formula Functions
The following functions are available for use in formulas. Any functions not listed are not currently available.
Database Functions
DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP
Date and Time Functions
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
HOUR
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
Engineering Functions
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
ERF.PRECISE
ERFC.PRECISE
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
OCT2BIN
OCT2DEC
OCT2HEX
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
ERF.PRECISE
ERFC.PRECISE
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
OCT2BIN
OCT2DEC
OCT2HEX
Financial Functions
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
EURO
EUROCONVERT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
EURO
EUROCONVERT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
Information Functions
ERRORTYPE
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOMITTED
ISREF
ISTEXT
N
NA
SHEET
SHEETS
TYPE
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOMITTED
ISREF
ISTEXT
N
NA
SHEET
SHEETS
TYPE
Logical Functions
AND
BYCOL
BYROW
FALSE
IF
IFERROR
IFNA
IFS
LAMBDA
MAKEARRAY
MAP
NOT
OR
REDUCE
SCAN
SWITCH
TRUE
XOR
BYCOL
BYROW
FALSE
IF
IFERROR
IFNA
IFS
LAMBDA
MAKEARRAY
MAP
NOT
OR
REDUCE
SCAN
SWITCH
TRUE
XOR
Lookup and Reference Functions
ADDRESS
AREAS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
DROP
EXPAND
FILTER
FORMULATEXT
HLOOKUP
HSTACK
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
SORT
SORTBY
TAKE
TOCOL
TOROW
TRANSPOSE
UNIQUE
VLOOKUP
VSTACK
WRAPCOLS
WRAPROWS
XLOOKUP
XMATCH
AREAS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
DROP
EXPAND
FILTER
FORMULATEXT
HLOOKUP
HSTACK
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
SORT
SORTBY
TAKE
TOCOL
TOROW
TRANSPOSE
UNIQUE
VLOOKUP
VSTACK
WRAPCOLS
WRAPROWS
XLOOKUP
XMATCH
Math and Trigonometric Functions
ABS
ACOS
ACOSH
ACOT
ACOTH
AGGREGATE
ARABIC
ASIN
ASINH
ATAN
ATAN2
ATANH
BASE
CEILING
CEILING.MATH
CEILING.PRECISE
COMBIN
COMBINA
COS
COSH
COT
COTH
CSC
CSCH
DECIMAL
DEGREES
EVEN
EXACT
EXP
FACT
FACTDOUBLE
FLOOR
FLOOR.MATH
FLOOR.PRECISE
GCD
INT
ISO.CEILING
LCM
LET
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDARRAY
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SEQUENCE
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
ACOS
ACOSH
ACOT
ACOTH
AGGREGATE
ARABIC
ASIN
ASINH
ATAN
ATAN2
ATANH
BASE
CEILING
CEILING.MATH
CEILING.PRECISE
COMBIN
COMBINA
COS
COSH
COT
COTH
CSC
CSCH
DECIMAL
DEGREES
EVEN
EXACT
EXP
FACT
FACTDOUBLE
FLOOR
FLOOR.MATH
FLOOR.PRECISE
GCD
INT
ISO.CEILING
LCM
LET
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDARRAY
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SEQUENCE
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
Statistical Functions
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DIST
BETA.INV
BETADIST
BETAINV
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
CHIDIST
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CONFIDENCE.NORM
CONFIDENCE.T
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVARIANCE.P
COVARIANCE.S
CRITBINOM
DEVSQ
EXPONDIST
EXPON.DIST
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FTEST
FREQUENCY
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
GEOMEAN
GROWTH
HARMEAN
HYPGEOM.DIST
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOGNORMINV
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
MODE
MODE.MULT
MODE.SNGL
NEGBINOM.DIST
NEGBINOMDIST
NORM.DIST
NORM.S.DIST
NORM.S.INV
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
POISSON
POISSON.DIST
PROB
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
RSQ
SKEW
SKEW.P
SLOPE
SMALL
STANDARDIZE
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA
STEYX
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VAR.P
VAR.S
VARA
VARP
VARPA
WEIBULL
WEIBULL.DIST
ZTEST
Z.TEST
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DIST
BETA.INV
BETADIST
BETAINV
BINOM.DIST
BINOM.DIST.RANGE
BINOM.INV
BINOMDIST
CHIDIST
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHITEST
CONFIDENCE.NORM
CONFIDENCE.T
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVARIANCE.P
COVARIANCE.S
CRITBINOM
DEVSQ
EXPONDIST
EXPON.DIST
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FTEST
FREQUENCY
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
GEOMEAN
GROWTH
HARMEAN
HYPGEOM.DIST
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
LOGNORMINV
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
MODE
MODE.MULT
MODE.SNGL
NEGBINOM.DIST
NEGBINOMDIST
NORM.DIST
NORM.S.DIST
NORM.S.INV
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
POISSON
POISSON.DIST
PROB
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
RSQ
SKEW
SKEW.P
SLOPE
SMALL
STANDARDIZE
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA
STEYX
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VAR.P
VAR.S
VARA
VARP
VARPA
WEIBULL
WEIBULL.DIST
ZTEST
Z.TEST
Text Functions
ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DBCS
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LET
LOWER
MID
OBJECT
PROPER
PROPERTY
REPLACE
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTAFTER
TEXTBEFORE
TEXTJOIN
TEXTSPLIT
TRIM
UNICHAR
UNICODE
UPPER
VALUE
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DBCS
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LET
LOWER
MID
OBJECT
PROPER
PROPERTY
REPLACE
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTAFTER
TEXTBEFORE
TEXTJOIN
TEXTSPLIT
TRIM
UNICHAR
UNICODE
UPPER
VALUE
Web Functions
ENCODEURL
FILTERJSON
WEBSERVICE
FILTERJSON
WEBSERVICE
Other Functions
BYCOL
BYROW
CHOOSECOLS
CHOOSEROWS
DROP
EXPAND
EURO
EUROCONVERT
HSTACK
ISOMITTED
LAMBDA
MAKEARRAY
MAP
OBJECT
PROPERTY
REDUCE
SCAN
TOCOL
TOROW
VSTACK
WRAPCOLS
WRAPROWS
BYROW
CHOOSECOLS
CHOOSEROWS
DROP
EXPAND
EURO
EUROCONVERT
HSTACK
ISOMITTED
LAMBDA
MAKEARRAY
MAP
OBJECT
PROPERTY
REDUCE
SCAN
TOCOL
TOROW
VSTACK
WRAPCOLS
WRAPROWS