Question

In: Accounting

Define a spreadsheet program

Define a spreadsheet program

Solutions

Expert Solution

A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form.Spreadsheets are developed as computerized simulations of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.

Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets, and can display data either as text and numerals, or in graphical form.

Besides performing basic arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial and statistical operations. Such calculations as net present value or standard deviation can be applied to tabular data with a pre-programmed function in a formula. Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text.

Spreadsheets have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.

spreadsheet programs have all the spreadsheet functions you'd expect as well as some excellent features such as Excel file compatibility, clean interfaces, automatic spell check, macro creation, and auto-saving.

Types of spreadsheet program:

1. Kingsoft Spreadsheets

2.OpenOffice Calc.
3.Gnumeric
4.Spread325

.Accel Spreadsheet


Related Solutions

To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be...
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. At Goodman Shipping, the load master wants to determine the mix of cargo to be carried on the next trip. The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to...
This assignment is designed to illustrate how a spreadsheet program such as Microsoft Excel supplemented by...
This assignment is designed to illustrate how a spreadsheet program such as Microsoft Excel supplemented by PHStat can enable you to easily accomplish hypothesis tests and confidence intervals that compare two population parameters. All work should be accomplished using PHStat. You should provide all the appropriate printouts of the tests you do and the confidence intervals you create along with explanations of the meaning of your answers and business implications for each problem. The assignment should be submitted to the...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, “10.5%” should be input as “.1050” 1. Jacinda Herschel wants to buy a car and determines she can afford to pay $295.02 a month for a...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, 10.5% should be input as .1050. An investment with quarterly compounding has a nominal rate of 0.0917. The effective rate is:
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9. Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,175. The bonds may be called in 5 years at...
Discuss what options of internal controls and audit trails are available in this spreadsheet program, EXCEL...
Discuss what options of internal controls and audit trails are available in this spreadsheet program, EXCEL and how these work in terms of data accuracy, security and integrity. List at least two examples for each of the internal control procedure and the audit trail feature.
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use interim rounding, state your answers as positive values, to two decimal places for dollar or period values and four places for percentages stated as decimals; do not label answers with symbols such as $ or %. For example, "10.5%" should be input as ".1050" 1. An investment compounding twice a month has an effective rate of 0.1688. The nominal rate is: 2.Brian Burkhardt is...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9. Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,185. The bonds may be called in 5 years at...
Write a rudimentary spreadsheet program using C++. Display a grid of cells with columns A through...
Write a rudimentary spreadsheet program using C++. Display a grid of cells with columns A through H and rows 1 through 20. Accept input in the first row of the screen. The commands are of the form column row entry, where entry is a number, a cell address preceded by a plus (e.g., +A5), a string, or a function preceded by an at sign, @. The functions are: max, min, avg, and sum. During execution of your program, build and...
In an event-driven program, you design the screens, define the objects, and define how the screens...
In an event-driven program, you design the screens, define the objects, and define how the screens will connect. Within an event-driven program, a component from which an event is generated is the source of the event. Other than changes to the planning stage, how is the development of an event-driven program different from that of a procedural program? How would a programmer create a plan for an animation?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT