Widget Company

Balance Sheet
On 12/31/2016 & 12/31/2017

2016 2017
Assets
Current Assets
Cash 115,000.00 125,000.00
Marketable Securities 55,000.00 47,321.00
Certificate Deposit 70,000.00 110,000.00
Accounts Receitable 105,555.00 99,177.00
Inventory 329,221.00 317,875.00
Prepaid Expenses 7,800.00 3,000.00
Other 5,900.00 221.00

Total Current Assets 688,476.00 702,594.00

Property & Equipment

Land & Buildings 135,670.00 135,670.00
Furniture Equipment 47,900.00 53,600.00
Machinery 55,900.00 55,920.00
Leasehold Improvements 0.00 21,200.00

Total Property & Equipment 239,470.00 266,390.00

Accumulated Depreciation & Amortization 67,500.00 92,870.00

Net Property & Equipment 450.00 300.00

Other Assets

Total Assets 927,946.00 968,984.00

 Company
nce Sheet
16 & 12/31/2017

2016 2017
Liabilities
Current Liabilities
Notes Payable 121,450 124,870
Current Obligations Under Capital Leases 0 15,647 C
Taxes Payable 9,055 12,366 800,000.00
Accounts Payable 197,870 203,965 700,000.00
600,000.00
Accrued Salaries and Wages 57,643 61,322 500,000.00
Other Accrued Expenses 29,900 24,540 400,000.00
300,000.00
Other Current Liabilities 700 0 200,000.00
100,000.00
0.00
Total Current Liabilities 416,618 442,710 t e
es o si bl
i ti ep ta
cur D c ei
S e e Re
Long-Term Debt 245,822 235,790 e cat s
bl rti
fi nt
ta ou
rke Ce c
a Ac
M
Other Liabilities 7,000 2,500 Col u

Total Liabilities 252,822 238,290

Stockholders Equity
Common Stock 75,000 75,000
Retained Earnings 116,466 120,584
Total Stockholders' Equity 191,466 195,584

Total Liabilities and Equity 860,906 876,584

 Chart Title
800,000.00
700,000.00
600,000.00
500,000.00
400,000.00
300,000.00
200,000.00
100,000.00
0.00
t y r
es si bl
e
or es he et
s
i ti o ta nt en
s
Ot s
ur ep ei ve p As
e c D c In Ex nt
S at
e Re id rre
e c s u
bl rti
fi nt a
lC
ta ou ep
rke Ce c Pr To
ta
a Ac
M

Col umn C Col umn D

Number to use: operationsformulas: answers:
1 Addition(+ 3 3
2 Subtraction -1 -1
Multiplicat 2 2
Division(/) 0.5 0.5
Power(^) 1 1
fruit amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
SUM> 170 SUM> 140

Item Amount Item Amount

Bread 50 Bread 50
Donuts 100 Donuts
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
SUM> 260 SUM> 160
fruit amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
AVERAGE> 42.5 AVERAGE> 35

Item Amount Item Amount

Bread 50 Bread 50
Donuts 100 Donuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
AVERAGE> 0 AVERAGE> 50
fruit amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
MIN> 20 MAX> 50

Item Amount Item Amount

Bread 50 Bread 50
Donuts 100 Donuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
MAX> 100 MIN> 20
 Date functions
Today's date: 3/13/2019
Your Birthday: 2/9/2001
Days until your birthday: 6606

Grace period days: 12/15/2018

Bill due on: 4/9/2239
First Name Last Name Last Name, First Name Full Name
Nancy Smith Smith, Nancy Nancy Smith
Andy North North, Andy Andy North
Jan Kolas Kolas, Jan Jan Kolas
Mariya Jones Jones, Mariya Mariya Jones
Steven Thorpe Thorpe, Steven Steven Thorpe
Michael Neipper Neipper, Michael Michael Neipper
Robert Zare Zare, Robert Robert Zare
Yvonne Mckay Mckay, Yvonne Yvonne Mckay

Smith, Nancy
North, Andy
Kolas, Jan
Jones, Mariya
Thorpe, Steven
Neipper, Michael
Zare, Robert
Mckay, Yvonne
CAPSLOCK SMALL CAPS Default Case
NANCY SMITH nancy smith Nancy Smith
ANDY NORTH andy north Andy North
JAN KOLAS jan kolas Jan Kolas
MARIYA JONES mariya jones Mariya Jones
STEVEN THORPE steven thorpe Steven Thorpe
MICHAEL NEIPPER michael neipper Michael Neipper
ROBERT ZARE robert zare Robert Zare
YVONNE MCKAY yvonne mckay Yvonne Mckay
 If Statements
Apple 1
Orange 0

50 Less than 100

fruit amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50

Apples 50 Pork 10
fruit amount fruit Type Amount
Apples 50 Apples Fuji 50
Oranges 20 Oranges Florida 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Rough 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Lady Finger 60
Lemons 40 Lemons Eureka 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Eureka 40

Fruit SUMIF Fruit Type SUMIFS

Apples 150 Oranges Florida 60
fruit amount
Apples 50
Oranges 20
Bananas 60
Lemons 40

Apples 50
Favorite Treats Number of Votes
Candy 18
Chips 40
Cookies 80
Pizza 12

Favorite Treats
90
80
80
70
60
50
40

X
40
30
20 18
12
10
0
Candy Chi ps Cooki es Pizza
Y
vorite Treats

80

Number of Votes

12

Cooki es Pizza
Favorite L Boys Girls
Burgers 60 40
Hot Dogs 70 20
Pizza 60 60
Spaghet 20 60
Tacos 35 5

Fa
80
70
60
50
40
30
20
10
0
Burgers Hot Dogs
 Favorite Lunch
80
70
60
50
40
30
20
10
0
Burgers Hot Dogs Pizza Spa ghet Tacos
Boys Gi rl s