Spreadsheets

The Smartboard is an interactive, computer-connected whiteboard designed for teaching and learning. The Smartboard system usually consists of computer software with touch-sensitive screen and a...

Microsoft Excel 2007 is a powerful spreadsheet package that can help you create professional graphs and charts from your data. One type of chart that Excel can create is a relative frequency...

Microsoft Excel 2007 is a powerful spreadsheet program that can sort and classify huge amounts of data. While Microsoft Excel 2007 comes with many built in functions, it doesn't have a built in...

A break even point represents the number of units you must sell to begin making a profit, given your fixed costs, cost per unit, and revenue per unit. For example, you might want to know the break...

Microsoft Excel 2007 can produce a variety of graphs and charts, including scatter plots, line graphs and pie charts. To create a curved graph, you must provide the raw data for the curve, such as...

Waterfall charts represent a set of data that impacts a single derived number. It's a visual aid to show how numbers relate to each other. That's according to Databison, who state that a good...

Microsoft Excel can be used to track work hours. Time-card templates are available on the Microsoft Office website. The templates contain formulas that are necessary to calculate the time worked...

The idea that a small sample of subjects can be used to draw conclusions about a much larger population seems hard to believe. Nevertheless, sampling is done all the time---in public opinion...

A popular maxim is that the data speak for themselves. Statisticians, however, know that the data rarely speak for themselves; you have to ask them the right questions. That's what statistical...

A VLookup is used in a spreadsheet to find records within a data spreadsheet. A VLookup is extremely useful when a large amount of data needs to be searched to find a particular piece of information.

The complex spreadsheet software applications of today offer users many useful features that were not available in previous versions. Since workbooks can tend to become cluttered with mounds of...

Microsoft has built a wealth of powerful functions into its Excel spreadsheet to help users. The FORECAST function is a useful addition that forms forecasted values for use in estimates and...

Within the wide range of functions Microsoft has built into its Excel spreadsheet, the FLOOR function is a useful addition. The FLOOR function in Excel returns a rounded off number for use in...

Microsoft includes a lot of very useful functions in its Excel Spreadsheet software. One of them which is continually being improved for accuracy is the Intercept function. What Intercept does is...

The Microsoft spreadsheet Excel is popular in a lot of US offices. One great feature of Excel is the range of functions that the program includes. Excel's Indirect function is a high-performing...

The Microsoft people gave users a whole lot of functions to use within their Excel spreadsheet. Some of these functions are easily identified with words like SUM or INDEX, but users might scratch...

If you create Excel spreadsheets that contain massive amounts of data, use the ISREF function to check whether certain cells reference one another. To use Excel's ISREF function, you need only...

Before Microsoft Excel came along making calculations with complicated functions could be an arduous process. However, if a person understands how to use and interpret particular functions, such...

You can use Microsoft Excel to compile, compute and interpret copious amounts of data. While Excel does have some complicated functions, the ISBLANK function is straightforward and easy to use...

Many businesses use Excel to track their data and expenses. However, you can run into problems when files grow too big. Try reducing the size of your Excel files in different ways to eliminate...

Excel's DCOUNT function is short for "database count." It considers all of the cells in a column of a database that match the specified criteria. DCOUNT then returns a count of all cells that...

Excel's DSTDEVP function is short for "database standard deviation for a population." It calculates a population's standard deviation for values in the column of a database that match the...

The PPMT function in Excel calculates the amount of a loan payment that is applied to the principal based on the interest rate, period of the payment, number of payments and the value of the loan....

Excel's TRIM function removes all spaces from the specified text except a single space between words. It is frequently used on text that has irregular spacing. TRIM deletes the ASCII space, which...

Excel's UPPER function converts the specified text to uppercase. It returns the specified text with all lowercase letters replaced by their uppercase equivalent. Characters that already are...

Excel's VDB function stands for variable declining balance. It returns an asset's depreciation set over the specified period. It includes partial periods and the balance declines at the specified...

Excel's VARPA function stands for variance population arguments. It calculates the variance based on the entire population. The argument list is considered to be the entire population, so the...

Excel's VARA function estimates the variance of a population based on a sample and returns the compound variance of that sample. This function is identical to VAR except that VARA accepts errors,...

Excel's ZTEST function returns the one-tailed probability of a z-test. This is the probability that the sample mean will be greater than the observed mean. The ZTEST function is used for...

Excel's WEIBULL function calculates the Weibull distribution, named after Waloddi Weibull, its creator, and is used in reliability analysis. Weibull analysis can make predictions about the life...

Microsoft Office 2007 introduced a number of significant changes to Office applications. One of the most significant changes is the "Ribbon," a new way to control some Office applications,...