presentation of computer
DESCRIPTION
computer presentation fileTRANSCRIPT
![Page 1: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/1.jpg)
![Page 2: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/2.jpg)
PRESENTED BY;
Purwa Iftikhar
Hafsah Masood
Shahbaz Anwar
![Page 3: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/3.jpg)
Spreadsheet in excel
![Page 4: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/4.jpg)
What is a spread sheet?
A spreadsheet is an interactive computer application program for
organization and analysis of data in tabular form.
![Page 5: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/5.jpg)
SPREADSHEETS CAN:
Do all sorts of calculations, both simple and complex using
formulae.
Recalculate things quickly when the numbers change.
Use functions to help you set up complex formulae.
Act as simple databases so that you can sort of search your data.
Plot charts and graphs.
Change the appearance of fonts, cell, background and borders.
Control how many decimal places are shown.
![Page 6: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/6.jpg)
Main Users Of Spreadsheets
Spreadsheets are similar to database which is why they are used in business
world by small companies and specific people.
Accountants – use spreadsheets to store customer information on income
and expenditure.
Teachers – use spreadsheets to store information such as students grades
etc.
Engineers – use spreadsheets for calculations when designing and
developing structures for projects.
Sales People – they use spreadsheets to keep track of sales that there
company might have.
![Page 7: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/7.jpg)
Main Users of Spreadsheets cont…
• Scientists – they need to keep track of their results from their
experiments that they have done.
• Supermarkets head offices – supermarkets have spreadsheets to
record how their company is doing, i.e. income and outcomes, busiest
time of day/month/year so the company know how many staff they will
need that day/month/year.
• Project Manager – project managers and their clients use spreadsheets
to meet their deadlines.
• Event organizations – events can be planned easily through
spreadsheets.
![Page 8: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/8.jpg)
WHAT IS DIFFERENT HERE
Freedom to design
Freedom to define the scope
Fruitful interaction with different departments
Maintain students grad
Manage inventory
Prepare financial statements
![Page 9: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/9.jpg)
PROJECT
![Page 10: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/10.jpg)
A spreadsheet which contain the record of daily spending, income statement, balance sheet and worksheet.
![Page 11: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/11.jpg)
THE MAIN PURPOSE
Calculate the total revenue
Calculate the total expenses
Find out the net income
Shows the total assets
Shows the total liabilities
Daily spending
![Page 12: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/12.jpg)
What is different here?
Daily spending – to calculate the daily spending.
Work sheet – contain the overall record of trial balance,
adjusted trial balance, income statement and balance
sheet.
![Page 13: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/13.jpg)
Who can utilize this spreadsheet.
Accountant
Sales people
Retailer
Wholesalers
Budget maker
![Page 14: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/14.jpg)
![Page 15: Presentation of Computer](https://reader036.vdocuments.us/reader036/viewer/2022062421/563dbb3a550346aa9aab559f/html5/thumbnails/15.jpg)