# New Objects in 2010

AboveAverage | |

FormatRow (Property) | (Removed in 2010) |

AddIn | |

IsOpen (Property) | Returns True if the add-in is currently open. Boolean Read-only |

AddIns2 (new) | A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. |

Application | |

SaveISO8601Dates (Property) | This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications. |

FileValidation (Property) | Returns or sets how Excel will validate files before opening them. Read/write |

ProtectedViewWindows (Property) | Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only |

FileExportConverters (Property) | Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only. |

HinstancePtr (Property) | Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Read-only Variant. |

FileValidationPivot (Property) | Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write |

SmartArtLayouts (Property) | Returns the set of SmartArt layouts that are currently loaded in the application. Read-only |

AddIns2 (Property) | Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only |

HighQualityModeForGraphics (Property) | Returns or sets whether Excel uses high quality mode to print graphics. Read/write |

ActiveProtectedViewWindow (Property) | Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Read-only. Returns Nothing if there are no Protected View windows open. Read-only |

PrintCommunication (Property) | Specifies whether communication with the printer is turned on. Boolean Read/write |

SmartArtColors (Property) | Returns the set of color styles that are currently loaded in the application. Read-only |

IsSandboxed (Property) | Returns True if the specified workbook is open in a Protected View window. Read-only |

SmartArtQuickStyles (Property) | Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only |

UseClusterConnector (Property) | Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write |

ClusterConnector (Property) | Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins. Read/write |

AnswerWizard (Property) | (Hidden in 2010) |

Assistant (Property) | (Hidden in 2010) |

SmartTagRecognizers (Property) | (Hidden in 2010) |

MacroOptions (Method) | (Changes in 2010) |

AxisTitle | |

Formula (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write. |

FormulaR1C1Local (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write. |

FormulaLocal (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write. |

Height (Property) | Returns the height, in points, of the object. Read-only. |

FormulaR1C1 (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write. |

Width (Property) | Returns the width, in points, of the object. Read-only. |

CalculatedMember | |

Dynamic (Property) | Returns whether the specified named set is recalculated with every update. Read-only |

FlattenHierarchies (Property) | Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write |

HierarchizeDistinct (Property) | Returns or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube. Read/write |

DisplayFolder (Property) | Returns the display folder name for a named set. Read-only |

CalculatedMembers | |

Add (Method) | (Changed in 2010) |

Chart | |

PrintedCommentPages (Property) | Returns the number of comment pages that will be printed for the current chart. Read-only |

ShowLegendFieldButtons (Property) | Returns or sets whether to display legend field buttons on a PivotChart. Read/write |

ShowValueFieldButtons (Property) | Returns or sets whether to display the value field buttons on a PivotChart. Read/write |

ShowReportFilterFieldButtons (Property) | Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write |

ShowAllFieldButtons (Property) | Returns or sets whether to display all field buttons on a PivotChart. Read/write |

ShowAxisFieldButtons (Property) | Returns or sets whether to display axis field buttons on a PivotChart. Read/write |

ChartArea | |

RoundedCorners (Property) | True if the chart area of the chart has rounded corners. Read/write Boolean. |

ChartTitle | |

Formula (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write. |

FormulaLocal (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write. |

FormulaR1C1Local (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write. |

FormulaR1C1 (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write. |

Height (Property) | Returns the height, in points, of the object. Read-only. |

Width (Property) | Returns the width, in points, of the object. Read-only. |

ColorFormat | |

Brightness (Property) | Returns or sets the luminosity of the specified object. Read/write |

ColorScale | |

FormatRow (Property) | (Removed in 2010) |

CubeField | |

HierarchizeDistinct (Property) | Returns or sets whether to order and remove duplicates when displaying the specified hierarchy field in a PivotTable report based on an OLAP cube. Read/write |

FlattenHierarchies (Property) | Returns or sets whether items from all levels of the specified hierarchy field are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write |

Databar | |

BarFillType (Property) | Returns or sets how a data bar is filled with color. Read/write |

AxisPosition (Property) | Returns or sets the position of the axis of the data bars specified by a conditional formatting rule. Read/write |

AxisColor (Property) | Returns the color of the axis for cells with conditional formatting as data bars. Read-only |

Direction (Property) | Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write. |

NegativeBarFormat (Property) | Returns the NegativeBarFormat object associated with a data bar conditional formatting rule. Read-only |

BarBorder (Property) | Returns an object that specifies the border of a data bar. Read-only |

DataBarBorder (new) | Represents the border of the data bars specified by a conditional formatting rule. |

DataLabel | |

FormulaR1C1 (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write. |

FormulaLocal (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write. |

Height (Property) | Returns the height, in points, of the object. Read-only. |

FormulaR1C1Local (Property) | Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write. |

Width (Property) | Returns the width, in points, of the object. Read-only. |

Formula (Property) | Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write. |

DisplayFormat (new) | Represents the display settings for an associated Range object. Read only. |

DisplayUnitLabel | |

Formula (Property) | |

FormulaR1C1 (Property) | |

FormulaLocal (Property) | |

Height (Property) | Returns the height, in points, of the object. Read-only. |

FormulaR1C1Local (Property) | |

Width (Property) | Returns the width, in points, of the object. Read-only. |

FileExportConverter (new) | Represents a file converter that is used to save files. |

FileExportConverters (new) | A collection of FileExportConverter objects that represent all the file converters available for saving files. |

FillFormat | |

PictureEffects (Property) | Returns an object that represents the picture or texture fill for the specified fill format. Read-only |

GradientAngle (Property) | Returns or sets the angle of the gradient fill for the specified fill format. Read/write |

FormatCondition | |

FormatRow (Property) | (Removed in 2010) |

IconCriterion | |

Icon (Property) | Returns or specifies the icon for a criterion in an icon set conditional formatting rule. Read/write |

IconSetCondition | |

FormatRow (Property) | (Removed in 2010) |

LineFormat | |

InsetPen (Property) | Returns or sets whether lines are drawn inside the specified shape's boundaries. Read/write |

ListObject | |

AlternativeText (Property) | Returns or sets the descriptive (alternative) text string for the specified table. Read/write |

Summary (Property) | Returns or sets the description associated with the alternative text string for the specified table. Read/write |

NegativeBarFormat (new) | Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule. |

OLEDBConnection | |

LocaleID (Property) | Returns or sets the locale identifier for the specified connection. Read/write |

CalculatedMembers (Property) | Returns the CalculatedMembers collection for the specified connection. Read-only |

Reconnect (Method) | Drops and then reconnects the specified connection. |

PictureFormat | |

Crop (Property) | Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Read-only |

PivotCell | |

MDX (Property) | Returns a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source. Read-only |

CellChanged (Property) | Returns whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. Read-only |

DataSourceValue (Property) | Returns the value last retrieved from the data source for edited cells in a PivotTable report. Read-only |

DiscardChange (Method) | Discards changes to the specified cell in a PivotTable report. |

AllocateChange (Property) | Performs a writeback operation on the specified cell in a PivotTable report based on an OLAP data source. |

PivotField | |

RepeatLabels (Property) | Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write |

PivotTable | |

ShowValuesRow (Property) | Returns or sets whether the values row is displayed. Read/write |

AllocationMethod (Property) | Returns or sets what method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write |

EnableWriteback (Property) | Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write. |

AlternativeText (Property) | Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write |

Slicers (Property) | Returns the Slicers collection for the specified PivotTable. Read-only |

VisualTotalsForSets (Property) | Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write |

AllocationValue (Property) | Returns or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write |

ChangeList (Property) | Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Read-only |

AllocationWeightExpression (Property) | Returns or sets the MDX weight expression to use when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write |

Summary (Property) | Returns or sets the description associated with the alternative text string for the specified table. Read/write |

Allocation (Property) | Returns or sets whether to run an UPDATE CUBE statement for each cell is edited, or only when the user chooses to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. Read/write |

CalculatedMembersInFilters (Property) | Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write |

CommitChanges (Method) | Performs a commit operation on the data source of a PivotTable report based on an OLAP data source. |

RepeatAllLabels (Method) | Specifies whether to repeat item labels for all PivotFields in the specified PivotTable. |

RefreshDataSourceValues (Method) | Retrieves the current values from the data source for all edited cells in a PivotTable report that is in writeback mode. |

DiscardChanges (Method) | Discards all changes in the edited cells of a PivotTable report. |

AllocateChanges (Method) | Performs a writeback operation for all edited cells in a PivotTable report based on an OLAP data source. |

PivotTableChangeList (new) | Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source. |

Point | |

Width (Property) | Returns the width, in points, of the object. Read-only. |

Name (Property) | Returns the object name. Read-only. |

Top (Property) | Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Read-only. |

Height (Property) | Returns the height, in points, of the object. Read-only. |

Left (Property) | Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only. |

PieSliceLocation (Property) | Returns the vertical or horizontal position of a point on a chart item, in points, from the top or left edge of the object to the top or left edge of the chart area. |

ProtectedViewWindow (new) | Represents a Protected View window. |

ProtectedViewWindows (new) | A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application. |

Range | |

SparklineGroups (Property) | Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Read-only |

DisplayFormat (Property) | Returns a DisplayFormat object that represents the display settings for the specified range. Read-only |

SmartTags (Property) | (Hidden in 2010) |

BorderAround (Method) | (Changed in 2010) |

DiscardChanges (Method) | Discards all changes in the edited cells of the range. |

ClearHyperlinks (Method) | Removes all hyperlinks from the specified range. |

AllocateChanges (Method) | Performs a writeback operation for all edited cells in a range based on an OLAP data source. |

Series | |

InvertColorIndex (Property) | Returns or sets the fill color for negative data points in a series. Read/write |

InvertColor (Property) | Returns or sets the fill color for negative data points in a series. Read/write |

PlotColorIndex (Property) | Returns an index value that is used internally to associate series formatting with chart elements. Read-only |

SeriesCollection | |

Add (Method) | (Changed in 2010) |

Paste (Method) | (Changed in 2010) |

Shape | |

SmartArt (Property) | Returns an object that represents the SmartArt associated with the shape. Read-only |

Title (Property) | Returns or sets the title of the alternative text associated with the specified shape. Read/write |

HasSmartArt (Property) | Returns whether there is a SmartArt diagram present on the specified shape. Read-only |

ShapeRange | |

Title (Property) | Returns or sets the title of the alternative text associated with the specified shape range. Read/write |

Shapes | |

AddSmartArt (Method) | Creates a new SmartArt graphic with the specified layout. |

Slicer (new) | Represents a slicer in a workbook. |

SlicerCache (new) | Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to. |

SlicerCacheLevel (new) | Represents a level of a hierarchy in an OLAP data source being filtered by a slicer. |

SlicerCacheLevels (new) | Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer. |

SlicerCaches (new) | Represents the collection of slicer caches associated with the specified workbook. |

SlicerItem (new) | Represents an item in a slicer. |

SlicerItems (new) | Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object. |

SlicerPivotTables (new) | Represents information about the collection of PivotTables associated with the specified SlicerCache. object |

Slicers (new) | A collection of Slicer objects. |

SmartTag | |

Application (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

DownloadURL (Property) | (Hidden in 2010) |

Name (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

Properties (Property) | (Hidden in 2010) |

Range (Property) | (Hidden in 2010) |

SmartTagActions (Property) | (Hidden in 2010) |

XML (Property) | (Hidden in 2010) |

Delete (Property) | (Hidden in 2010) |

SmartTagAction | |

ActiveXControl (Property) | (Hidden in 2010) |

Application (Property) | (Hidden in 2010) |

CheckboxState (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

ExpandHelp (Property) | (Hidden in 2010) |

ListSelection (Property) | (Hidden in 2010) |

Name (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

PresentInPane (Property) | (Hidden in 2010) |

RadioGroupSelection (Property) | (Hidden in 2010) |

TextboxText (Property) | (Hidden in 2010) |

Type (Property) | (Hidden in 2010) |

Execute (Method) | (Hidden in 2010) |

SmartTagActions | |

Application (Property) | (Hidden in 2010) |

Count (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

Item (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

SmartTagOptions | |

Application (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

DisplaySmartTags (Property) | (Hidden in 2010) |

EmbedSmartTags (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

SmartTagRecognizer | |

Application (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

Enabled (Property) | (Hidden in 2010) |

FullName (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

progID (Property) | (Hidden in 2010) |

SmartTagRecognizers | |

Application (Property) | (Hidden in 2010) |

Count (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

Item (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

Recognize (Property) | (Hidden in 2010) |

SmartTags | |

Application (Property) | (Hidden in 2010) |

Count (Property) | (Hidden in 2010) |

Creator (Property) | (Hidden in 2010) |

Parent (Property) | (Hidden in 2010) |

Add (Method) | (Hidden in 2010) |

SparkAxes (new) | Represents the settings for the horizontal and vertical axes of a group of sparklines. |

SparkColor (new) | Represents the color of the markers for points in a sparkline. |

SparkHorizontalAxis (new) | Represents the settings for the horizontal axes of a group of sparklines. |

Sparkline (new) | Represents a single sparkline. |

SparklineGroup (new) | Represents a group of sparklines. |

SparklineGroups (new) | Represents a collection of sparkline groups. |

SparkPoints (new) | Represents the settings of the markers for points of data on a sparkline. |

SparkVerticalAxis (new) | Represents the settings for the vertical axes of a group of sparklines. |

SpellingOptions | |

ArabicStrictAlefHamza (Property) | Returns or sets whether the spelling checker uses rules regarding Arabic words beginning with an alef hamza. Read/write |

ArabicStrictTaaMarboota (Property) | Returns or sets whether the spelling checker uses rules to flag Arabic words ending with haa instead of taa marboota. Read/write |

BrazilReform (Property) | Returns or sets the mode for checking the spelling of Brazilian Portuguese. Read/write |

ArabicStrictFinalYaa (Property) | Returns or sets whether the spelling checker uses rules regarding Arabic words ending with the letter yaa. Read/write |

RussianStrictE (Property) | Returns or sets whether the spelling checker uses rules regarding Russian words containing special characters. Read/write |

PortugalReform (Property) | Returns or sets the mode for checking the spelling of European Portuguese. Read/write |

SpanishModes (Property) | Returns or sets the mode for checking the spelling of Spanish. Read/write |

TableStyle | |

ShowAsAvailableSlicerStyle (Property) | Returns or sets if the specified table style is shown as available in the slicer styles gallery. Read/write |

TextFrame | |

HorizontalOverflow (Property) | Returns or sets the horizontal overflow setting for the specified object. Read/write |

VerticalOverflow (Property) | Returns or sets the vertical overflow setting for the specified object. Read/write |

TextFrame2 | |

NoTextRotation (Property) | Returns or sets whether text remains flat when the specified object is rotated. Read/write |

Top10 | |

FormatRow (Property) | (Removed in 2010) |

UniqueValues | |

FormatRow (Property) | (Removed in 2010) |

ValueChange (new) | Represents a value that has been changed in a PivotTable report that is based on an OLAP data source. |

Workbook | |

ActiveSlicer (Property) | Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. Read-only. |

SlicerCaches (Property) | Returns the SlicerCaches object associated with the workbook. Read-only. |

AccuracyVersion (Property) | Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. Read/write |

DefaultSlicerStyle (Property) | Specifies the style from the TableStyles object that is used as the default style for slicers. Read/write. |

SmartTagOptions (Property) | (Hidden in 2010) |

CheckIn (Method) | (Changed in 2010) |

RecheckSmartTags (Method) | (Hidden in 2010) |

CheckInWithVersion (Method) | Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally. |

Worksheet | |

PrintedCommentPages (Property) | Returns the number of comment pages that will be printed for the current worksheet. Read-only |

SmartTags (Property) | (Hidden in 2010) |

WorksheetFunction | |

Aggregate (Method) | Returns an aggregate in a list or database. |

Beta_Dist (Method) | Returns the beta cumulative distribution function. |

Beta_Inv (Method) | Returns the inverse of the cumulative distribution function for a specified beta distribution. That is, if probability = Beta_Dist(x,...), then Beta_Inv(probability,...) = x. |

Binom_Dist (Method) | Returns the individual term binomial distribution probability. |

Binom_Inv (Method) | Returns the inverse of the individual term binomial distribution probability. |

Ceiling_Precise (Method) | Returns the specified number rounded to the nearest multiple of significance. |

ChiSq_Dist (Method) | Returns the chi-squared distribution. |

ChiSq_Dist_RT (Method) | Returns the right-tailed probability of the chi-squared distribution. |

ChiSq_Inv (Method) | Returns the inverse of the left-tailed probability of the chi-squared distribution. |

ChiSq_Inv_RT (Method) | Returns the inverse of the right-tailed probability of the chi-squared distribution. |

ChiSq_Test (Method) | Returns the test for independence. |

Confidence_Norm (Method) | Returns a value that you can use to construct a confidence interval for a population mean. |

Confidence_T (Method) | Returns the confidence interval for a population mean, using a Student's t distribution. |

Covariance_P (Method) | Returns population covariance, the average of the products of deviations for each data point pair. |

Covariance_S (Method) | Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets. |

Erf_Precise (Method) | Returns the error function integrated between zero and lower_limit. |

ErfC_Precise (Method) | Returns the complementary error function integrated between the specified value and infinity. |

Expon_Dist (Method) | Returns the exponential distribution. Use EXPON_DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON_DIST to determine the probability that the process takes at most 1 minute. |

F_Dist (Method) | Returns the F probability distribution. |

F_Dist_RT (Method) | Returns the right-tailed F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school and determine if the variability in the females is different from that found in the males. |

F_Inv (Method) | Returns the inverse of the F probability distribution. |

F_Inv_RT (Method) | Returns the inverse of the right-tailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x. |

F_Test (Method) | Returns the result of an F-test. An F-test returns the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public and private schools, you can test whether these schools have different levels of test score diversity. |

Floor_Precise (Method) | Rounds the specified number to the nearest multiple of significance. |

Gamma_Dist (Method) | Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis. |

Gamma_Inv (Method) | Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x. |

GammaLn_Precise (Method) | Returns the natural logarithm of the gamma function, G(x). |

HypGeom_Dist (Method) | Returns the hypergeometric distribution. HYPGEOM_DIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOM_DIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood. |

ISO_Ceiling (Method) | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. |

LogNorm_Dist (Method) | Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed. |

LogNorm_Inv (Method) | Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data. |

Mode_Mult (Method) | Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data. |

Mode_Sngl (Method) | Returns the most frequently occurring, or repetitive, value in an array or range of data. |

NegBinom_Dist (Method) | Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent. |

NetworkDays_Intl (Method) | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays. |

Norm_Dist (Method) | Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing. |

Norm_Inv (Method) | Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. |

Norm_S_Dist (Method) | Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas. |

Norm_S_Inv (Method) | Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one. |

Percentile_Exc (Method) | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |

Percentile_Inc (Method) | Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile. |

PercentRank_Exc (Method) | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |

PercentRank_Inc (Method) | Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK_INC to evaluate the standing of an aptitude test score among all scores for the test. |

Poisson_Dist (Method) | Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in one minute. |

Quartile_Exc (Method) | Returns the quartile of the data set, based on percentile values from 0..1, exclusive. |

Quartile_Inc (Method) | Returns the quartile of a data set based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE_INC to find the top 25 percent of incomes in a population. |

Rank_Avg (Method) | Returns the rank of a number in a list of numbers; that is its size relative to other values in the list. If more than one value has the same rank, the average rank is returned. |

Rank_Eq (Method) | Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) |

StDev_P (Method) | Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). |

StDev_S (Method) | Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). |

T_Dist (Method) | Returns a Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed. |

T_Dist_2T (Method) | Returns the two-tailed Student t-distribution. |

T_Dist_RT (Method) | Returns the right-tailed Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. |

T_Inv (Method) | Returns the left-tailed inverse of the Student t-distribution. |

T_Inv_2T (Method) | Returns the t-value of the Student t-distribution as a function of the probability and the degrees of freedom. |

T_Test (Method) | Returns the probability associated with a Student t-Test. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. |

Var_P (Method) | Calculates variance based on the entire population. |

Var_S (Method) | Estimates variance based on a sample. |

Weibull_Dist (Method) | Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device. |

WorkDay_Intl (Method) | Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays. |

Z_Test (Method) | Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, Z_TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) that is, the observed sample mean. |

### Events

To see a list of all the events, please refer to the __Events__ page.

ProtectedViewWindowActivate | Application | Occurs when a Protected View window is activated. |

SheetPivotTableBeforeCommitChanges | Application | Occurs before changes are committed against the OLAP data source for a pivot table. |

ProtectedViewWindowBeforeClose | Application | Occurs immediately before a Protected View window or a workbook in a Protected View window closes. |

SheetPivotTableBeforeDiscardChanges | Application | Occurs before changes to a pivot table are discarded. |

SheetPivotTableAfterValueChange | Application | Occurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas). |

SheetPivotTableBeforeAllocateChanges | Application | Occurs before changes are applied to a pivot table. |

WorkbookNewChart | Application | Occurs when a new chart is created in any open workbook. |

ProtectedViewWindowOpen | Application | Occurs when a workbook is opened in a Protected View window. |

ProtectedViewWindowBeforeEdit | Application | Occurs immediately before editing is enabled on the workbook in the specified Protected View window. |

ProtectedViewWindowResize | Application | Occurs when any Protected View window is resized. |

ProtectedViewWindowDeactivate | Application | Occurs when a Protected View window is deactivated. |

WorkbookAfterSave | Application | Occurs after the workbook is saved. |

NewChart | Workbook | Occurs when a new chart is created in the workbook. |

SheetPivotTableChangeSync | Workbook | Occurs after changes to a pivot table. |

SheetPivotTableAfterValueChange | Workbook | Occurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas). |

SheetPivotTableBeforeDiscardChanges | Workbook | Occurs before changes to a pivot table are discarded. |

SheetPivotTableBeforeAllocateChanges | Workbook | Occurs before changes are applied to a pivot table. |

SheetPivotTableBeforeCommitChanges | Workbook | Occurs before changes are committed against the OLAP data source for a pivot table. |

AfterSave | Workbook | Occurs after the workbook is saved. |

PivotTableChangeSync | Worksheet | Occurs after changes to a pivot table. |

PivotTableBeforeAllocateChanges | Worksheet | Occurs before changes are applied to a pivot table. |

PivotTableBeforeDiscardChanges | Worksheet | Occurs before changes to a pivot table are discarded. |

PivotTableBeforeCommitChanges | Worksheet | Occurs before changes are committed against the OLAP data source for a pivot table. |

PivotTableAfterValueChange | Worksheet | Occurs after a cell or range of cells inside a pivot table are edited or recalculated (for cells that contain formulas). |

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext