How Can Spreadsheets Be Used? Solve Complex Problems?

* Charts and Pictograms - Charts and pictures can present observation data in colourful ways to make your portfolio appear more interesting.

Spread sheet Software: Microsoft Excel can be used to produce spread sheet for keeping financial records.

Explain how you would use the integration features of MS Office to incorporate the Excel information into other presentation media.

I would use a bar graph because it would be easy to follow and understand the information presented.

| |Page Number |Inserts a page number into your document (useful in the header). |

I do various presentations throughout the organization and within my department, so PowerPoint comes in handy. I use excel for planning purposes, to store data, uncover trends, etc.

There are a lot of differences between spreadsheets and a database system. One of the differences many users noticed is the way the data is organised. For example, if the data is flat, then a spreadsheet is perfect in a way. Another example is if a business wants to keep in touch/tracking their monthly earning over the year, spreadsheet will be the more ideal and perfect way because it was meant to handle lots of data and map the progress of a tiny amount of key points, for example if you are using Microsoft excel you can use CTRL + F to locate a specific name or data information. On the other hand, database systems use a relational data structure. An example would be if a company wants to track down their monthly earnings and compare to their competitors business for the past 3 years, there will be a relationships between data points.

Before spreadsheet was invented, people used to do and solve calculations on a piece of paper or by calculators (they still use calculators even today). Spreadsheet was invented by Dan Bricklin and Bob Frankston in 1979. Visual calculator was in fact the first commercial spreadsheet program. After it was invented, it made peoples’ life much easier in terms of doing calculations automatically, speeding up the calculations, lots of calculations are done simultaneously and also saving up peoples’ time. Spreadsheets are so important today because many companies and organisations use a lot of spreadsheet models to manipulate complex data/ problems as it contains accurate data. Manipulation of data can be applied to non-numeric data. It is a

The challenge in this situation is that the user wants to use a program that is new to him. I will have to explain to the user the basic functions of Excel to see if those functions match what the user wants to do.

In many instances it is a good idea to use graphical representations to support the text in reports or business documents. Conduct research and find graphics or illustrations that might be used in documents providing information about the following:

Microsoft Excel can be used to store and retrieve information in the form of tables and charts and filters can be inserted

Q7: Create a bar graph or pie chart of the data you have collected. For example, you could create a bar graph that shows the employee turnover rate in organizations that do offer flexible work arrangement compared to organizations that do not. Alternately, you could create a pie chart that shows which types of flexible work arrangement workers want the most.

Information systems changed forever the way accounting tasks are processed. The days of green paper pads are gone, and instead businesses have a centralized place where all accounting transactions are entered and saved. No more looking for paper

Accountants must have a good deal of experience working with computers. They develop computer applications to assist the analysis and presentation of their findings. Due to the e-commerce explosion, a majority of financial records are now web-related.

There are various tasks that can be completed by using spread sheets, especially when it comes to solving complex problems. Moreover, the difficulty in using the application is of a low level, thus making it easy to use for an individual, who may not have as much experience someone who is an expert in IT.