Got a tricky question? Receive an answer from students like you! Try us!

Information Systems - Essay Example

Only on StudentShare
Pages 10 (2510 words)


The Report is created using Microsoft Excel that is now the World's leading spreadsheet program and is written and distributed by Microsoft Corporation. It features an intuitive interface and capable calculation and graphing tools, so it can be used even by a person without strong computer background…

Extract of sample
Information Systems

There are various ways of adding and counting data (Microsoft Corporation 2006), the most appropriate are simple addition and addition with one or more criteria.
Subtotals by quarter for all persons are shown in the Sales Summary for 2005 in(000's) in Table 1. For example, Subtotal 815 means that all salespersons together have sold office furniture on 815,000 in the first quarter in Commercial sector. Then, Sector subtotals (sales volumes by sector) are added. For example, Sector subtotal 3429 means that all salespersons together have sold office furniture on 3,429,000 in Commercial sector in the 2005. Then, 6,555,000 is annual sales result in 2005.
Then formatting should be applied to the report to make it easy to read and understand. There are many basic formatting options available at the cell and worksheet level. Most are available on the Format Menu located on the Standard Excel toolbar. (Sandhills Publishing Company 2005)
Pie charts and bar charts are very useful for analysis and easy to interpret. Peltier (2006) concludes that pie charts are good when you are showing the relative proportion of numbers that add up to a total, for a single series of data and when there are not too many wedges, particularly too many small ones. They show a good qualitative view of the data. ...
Download paper
Not exactly what you need?

Related Essays

Information Systems and Technology
In 2005 it recorded sales of $79.9 billion and employed 168,847 people. In December 2002, the financial services company J.P. Morgan Chase announced a seven-year, $5 billion deal to outsource much of its data processing to the technology giant IBM, both companies bragged that the contract the largest of its kind for IBM would reduce costs, create value and propel innovation at J.P. Morgan. According to JP Morgan Chase management, this agreement would create "significant value" for clients, shareholders, and employees by creating capacity for "efficient growth" while reducing costs and…
8 pages (2008 words)