Elaborate the 5 types of view available in a spreadsheet
Answers
Answer:
preadsheets play a central role in the daily administrative tasks within many businesses both small and large. With spreadsheet software such as Microsoft Excel, business managers and administrators can capture, manipulate, analyze and present valuable data related to particular areas of their operation. The types of data spreadsheets are used to manage typically fall into one of a few common categories. As well as recording business data, spreadsheets can be used to manage it in a variety of ways.
Explanation:
Financial
Many businesses use spreadsheets to manage accounting data. This includes budget management such as tracking income and expenses. Spreadsheets include automated formatting options for currency as well as the option to display negative numbers in red, providing a clear representation of the financial situation. Some organizations also use spreadsheets to manage specific aspects of income and expenses in detail, for example with a dedicated worksheet for payroll expenses. Most spreadsheet programs allow multiple worksheets to work in conjunction with one another. Using this model, you could, for example, create one sheet for income and another for expenses with a balance sheet referencing the totals from the income and expense sheets.
Statistical
Spreadsheets are primarily used to capture data, but they also provide the means to analyze and manipulate data sets. Spreadsheet applications such as Excel include a range of pre-defined functions for applying statistical and arithmetic calculations on data sets. Spreadsheet users can also create their own formulas to arrive at the analysis to suit their business needs. Users can sort and filter data to achieve a tailored perspective. Common functions include averages, distribution calculations and sampling. Basic spreadsheet use often involves more straightforward arithmetic options such as addition, multiplication, division and subtraction, but users can build these elements to produce complex statistical overviews of business operations.
Presentation
Once a spreadsheet has been populated with one or more data sets, users can exploit features within the spreadsheet application to present these data sets graphically. Spreadsheet software includes utilities for transforming sets of data into charts and graphs of various types. These visual representations can then be included in presentations both within the organization and for marketing purposes, for example at corporate events, to communicate with potential clients.
Future Planning
Spreadsheet data sets can be used to inform the process of making future plans for a business. As well as including graphs or tables representing historical business data within business plans, spreadsheets can be created specifically for the purposes of projection. For example, with existing data set for the past performance of your business, you can make estimations within a projection spreadsheet to calculate the impact of potential changes in your activities. This can allow you to theoretically test any ideas you have for future development with the benefit of accurate historical data.
Project Tracking
Spreadsheets can play a role in project management tasks within certain organizations. With a project-tracking spreadsheet you can record and track tasks or activities associated with particular projects. This type of spreadsheet can comprise a collaborative record of the progress of a project, whether it is a one-time project or an ongoing concern. Such spreadsheets can also include the personnel involved in a project and what their responsibilities are.
Explanation:
following types of view available in a spreadsheet:-
1) workbook views
2) show
3) zoom
4) window
5) Macros
I hope,
this helpful answer
plz.. .. guys follow me