spreadsheet applications 1. common spreadsheet applications budgets, business and personal ** ...
TRANSCRIPT
![Page 1: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/1.jpg)
SPREADSHEET APPLICATIONS
1
![Page 2: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/2.jpg)
COMMON SPREADSHEET APPLICATIONS
Budgets, business and personal **
Payroll **
Inventory
Invoices **
Balance sheets
Profit-loss statements
Income tax preparation
Currency conversion
Basically any use that requires calculations or charts
** - Illustrated in this lesson2
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 3: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/3.jpg)
Budget Illustration
3
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 4: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/4.jpg)
Payroll illustration
4
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 5: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/5.jpg)
INVOICE ILLUSTRATION
5
![Page 6: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/6.jpg)
Common formulas
All mathematical operations: sum (+), difference (-), multiply (*), divide (/)
Average
Max - highest
Min - lowest
Count – number of
6
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 7: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/7.jpg)
SPREADSHEET ENHANCEMENTS
Number styles, for example, accounting style
Borders
Cell formatting such as dates and percentages
Highlighting using conditional formatting
Charts and graphs
Font formatting including size, color, and alignment
7
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 8: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/8.jpg)
Commonly-used chart types
Column – usually compares >1 item vertically
Line – can compare >1 item or items over time
Pie – compares parts related to a whole, can ‘explode’ a slice for emphasis
Bar - usually compares >1 item horizontally
Area – similar to column but can show parts of a whole over time
8
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 9: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/9.jpg)
Illustrations of different chart types
The charts on the next few slides are based upon the Projected Expenses from the Budget Illustration Slide 3.
9
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 10: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/10.jpg)
Sample column chart
10
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 11: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/11.jpg)
Sample line chart
11
Right-click in the chart area and you
can change the chart type from
column to line etc.
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 12: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/12.jpg)
Sample pie chart
12
Pie charts should include data labels
of percentages.
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 13: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/13.jpg)
Sample bar chart
13
Copyright © Texas Education Agency, 2013. All rights reserved.
![Page 14: SPREADSHEET APPLICATIONS 1. COMMON SPREADSHEET APPLICATIONS Budgets, business and personal ** Payroll ** Inventory Invoices ** Balance sheets](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f1d5503460f94c349d6/html5/thumbnails/14.jpg)
Sample area chart
14
Area charts are most effective with >1 set
of data, but this provides an example of what it looks like.
Copyright © Texas Education Agency, 2013. All rights reserved.