IMP: Formulas in Excel always start with = (is equal to) sign

Formula by selecting different Cells

C6 + C8 ------ For Addition of two different Cells

Explaination

B8 * B9 ------ For Multiplication of two different Cells

B9 / B10 ------ For Division of two different Cells
E10 - G10 ------ For Subtraction of two different Cells

AUTO SUM Alt+=

Different ways of Adding numbers

1. by using '+' sign D18+E18+F18

=
2. By using 'Sum' for different Cells SUM(D19,E19,F19)
3. By using 'Sum' for a range SUM(D20:F20)

Example
15 120
25 120
35 120
45
 Result for Addition
E6 + E7 i.e. (45 + 15)

Result for
Formula Usage Multiplication
E6 * E7 i.e. (45 / 15)
45 60
Result for Division
15 675 E8 / E7 i.e. (48 / 15)
48 3.2
Result for Subtraction
68 20 E9 - E8 i.e. (68 - 48)

=B23+B24+B25+B26

=SUM(B23,B24,B25,B26)

=SUM(B23:B26)
 Add the following numbers 3544 2324 Answer:

Subtract the following numbers 4344 2332 Answer:

Multiply the following numbers 1234 3432 Answer:

Divide the following numbers 1245 2354 Answer:

Total a Single Column

Bill Amount
Rent 850.00
Utilities 200.00
Car 325.00
Insurance 120.00
Total Payments

Total Rows and Columns

Bill January February March Total
Rent 850.00 850.00 850.00
Utilities 200.00 250.00 200.00
Car 325.00 325.00 325.00
Insurance 120.00 120.00 125.00
Total Payments
Enrol NoName Mark1 Mark2 Mark3 Mark4 Mark5 Total Max
186001 Allen 30 68 64 60 96
186002 Ben 50 32 60
186003 Blackstone 65 78 68 49 93
186004 Brown 39 50 43
186005 Gray 65 49 61 45 69
186006 Joel 46 75 55 61 72
186007 Johnson 45 65 59
186008 Mathews 87 60 74 43 70
186009 Peter 95 73 83 81 69
186010 Phil 83 80 64 79 63

[Link] Students:
Min
 CAR PARK INCOME
Day Price No of Users Income
Monday 3 1000 3,000
Tuesday 4 950 3,800
Wednesday 5 1000 5,000
Thursday 6 600 3,600
Friday 6 350 2,100
Saturday 5 427 2,135
Sunday 4 125 500
Overall Total 20,135

Income % = Income / Overall Total

Income %
Commission Report

Commission: 12.50%
Tax Rate: 17.50%

Sales Rep Sales Commission Base Pay Taxes

Smith, S. 49,750 10,000
Brown, N. 55,500 10,000
Wallace, F. 37,750 10,000
Adams, G. 83,750 10,000
Stephenson, J. 76,200 10,000
Norris, H. 134,000 10,000

Commission =B7*B3
Taxes =(C7+D7)*B4
Net Pay
10,000
10,000
10,000
10,000
10,000
10,000
Overdue Accounts

Today: 6-May-25

Invoice Days
Customer: Date: Overdue:
Garcia Electrical Supplies 14-Jun-16
Johnson Plumbing 1-Jul-16
Northwood Contractors 10-Jul-16
Reiffen Lumber Yard 24-Jul-16
Robins Home Improvement 3-Aug-16

* Days Overdue = Today - Invoice Date

On the "Customers" Worksheet ,enter a formula in cell N5 that uses an excel function to return the average ag

Customer ID Name Last Name First Name Middle Adress

1001 Jack Dwyer 21 N. Navesink River Dr.
1002 Sara Brown 1005 First Ave.
1003 Rose Hamlin 7 Church St.
1004 Grant Thomas 159 Branch Ave., Apt. 15B
1005 Timothy Marino 90 E. Royal Dr.
1006 Lon Chaplin 91 Monmouth Ave.
1007 Maria Trent 525 E. Palm Dr.
1008 Frank Liston 302 Ash St.
1009 Cathy Nichols 75 Brooklea Dr.
1010 Anna Brett 23 Suffolk Ln.
1011 Jeff Phelps 2343 W. Audrey Ln.
1012 Lon Chaplin 91 Monmouth Ave.
1013 Kurt Brown 124 Main St.
1014 Chad Pennington 23 Mill Ave.
1015 Timothy Marino 90 E. Royal Dr.
1016 Andrew Beinbrink 45 Burr Rd.
1017 Scott Briggs 45 E. Camelback Rd.
1018 William Bloomquist 43 Kings Rd.
1019 Dwyer Jack 22 N. Navesink River Dr.
1020 Brown Sara 1006 First Ave.
1021 Hamlin Rose 8 Church St.
1022 Thomas Grant 160 Branch Ave., Apt. 15B
1023 Marino Timothy 91 E. Royal Dr.
1024 Chaplin Lon 92 Monmouth Ave.
1025 Trent Maria 526 E. Palm Dr.
1026 Liston Frank 303 Ash St.
1027 Nichols Cathy 76 Brooklea Dr.
1028 Brett Anna 24 Suffolk Ln.
1029 Phelps Jeff 2344 W. Audrey Ln.
1030 Chaplin Lon 92 Monmouth Ave.
1031 Brown Kurt 125 Main St.
1032 Pennington Chad 24 Mill Ave.
1033 Marino Timothy 91 E. Royal Dr.
1034 Beinbrink Andrew 46 Burr Rd.
1035 Briggs Scott 46 E. Camelback Rd.
1036 Bloomquist William 44 Kings Rd.
1037 Jack Dwyer 23 N. Navesink River Dr.
1038 Sara Brown 1007 First Ave.
1039 Rose Hamlin 9 Church St.
1040 Grant Thomas 161 Branch Ave., Apt. 15B
1041 Timothy Marino 92 E. Royal Dr.
1042 Lon Chaplin 93 Monmouth Ave.
1043 Maria Trent 527 E. Palm Dr.
1044 Frank Liston 304 Ash St.
1045 Cathy Nichols 77 Brooklea Dr.
1046 Anna Brett 25 Suffolk Ln.
1047 Jeff Phelps 2345 W. Audrey Ln.
1048 Lon Chaplin 93 Monmouth Ave.
1049 Kurt Brown 126 Main St.
1050 Chad Pennington 25 Mill Ave.
1051 Timothy Marino 92 E. Royal Dr.
1052 Andrew Beinbrink 47 Burr Rd.
1053 Scott Briggs 47 E. Camelback Rd.
1054 William Bloomquist 45 Kings Rd.
1055 Dwyer Jack 24 N. Navesink River Dr.
1056 Brown Sara 1008 First Ave.
1057 Hamlin Rose 10 Church St.
1058 Thomas Grant 162 Branch Ave., Apt. 15B
1059 Marino Timothy 93 E. Royal Dr.
1060 Chaplin Lon 94 Monmouth Ave.
1061 Trent Maria 528 E. Palm Dr.
1062 Liston Frank 305 Ash St.
1063 Nichols Cathy 78 Brooklea Dr.
1064 Brett Anna 26 Suffolk Ln.
1065 Phelps Jeff 2346 W. Audrey Ln.
1066 Chaplin Lon 94 Monmouth Ave.
1067 Brown Kurt 127 Main St.
1068 Pennington Chad 26 Mill Ave.
1069 Marino Timothy 93 E. Royal Dr.
1070 Beinbrink Andrew 48 Burr Rd.
1071 Briggs Scott 48 E. Camelback Rd.
1072 Bloomquist William 46 Kings Rd.
tion to return the average age of the customers based on the values in the "Current Age" column.

City State Postal Code CountryOr Region Birth Date Current Age
DW 27013 Canada 27613 41
BR 47647 Canada 29728 35
HA 25929 United States 17885 68
., Apt. 15B TH 34755 United States 31052 31
MA 69575 Canada 31012 32
CH 17425 Canada 28942 37
TR 17426 United States 32190 28
LI 17427 United States 27415 41
NI 24587 Canada 30175 34
BR 45678 Canada 30823 32
PH 14569 United States 18152 67
CH 47589 United States 28942 37
BR 47458 Canada 20254 61
PE 47647 Canada 22355 55
MA 25929 Canada 31012 32
BE 34755 Canada 21378 58
BR 69575 United States 32703 27
BL 17425 United States 24282 50
JA 17426 Canada 27613 41
SA 17427 Canada 29728 35
RO 24587 United States 17885 68
., Apt. 15B GR 45678 United States 31052 31
AS 14569 Canada 31012 32
NO 47589 Canada 28942 37
IN 34755 United States 32190 28
NT 69575 United States 27415 41
ON 17425 Canada 30175 34
LS 17426 Canada 30823 32
TT 17427 Canada 18152 67
PS 24587 Canada 28942 37
IN 45678 United States 20254 61
WN 14569 United States 22355 55
ON 47589 Canada 31012 32
NO 47458 Canada 21378 58
NK 50734 United States 32703 27
GS 55748 United States 24282 50
ST 60762 Canada 27613 41
CK 65777 Canada 29728 35
RA 70791 United States 17885 68
., Apt. 15B SE 75806 United States 31052 31
NT 80820 Canada 31012 32
HY 17426 Canada 28942 37
 ON 17427 Canada 32190 28
IA 24587 Canada 27415 41
NK 45678 United States 30175 34
HY 14569 United States 30823 32
NA 47589 Canada 18152 67
FF 47458 Canada 28942 37
ON 65777 United States 20254 61
RT 70791 United States 22355 55
AD 75806 Canada 31012 32
HY 80820 Canada 21378 58
EW 17426 United States 32703 27
TT 17427 United States 24282 50
AM 25929 Canada 27613 41
ER 34755 Canada 29728 35
WN 69575 Canada 17885 68
., Apt. 15B IN 17425 Canada 31052 31
AS 17426 United States 31012 32
NO 17427 United States 28942 37
IN 24587 Canada 32190 28
NT 45678 Canada 27415 41
ON 14569 United States 30175 34
LS 47589 United States 30823 32
TT 25929 Canada 18152 67
PS 34755 Canada 28942 37
IN 69575 United States 20254 61
WN 17425 United States 22355 55
ON 17426 Canada 31012 32
NO 17427 Canada 21378 58
NK 24587 Canada 32703 27
GS 45678 Canada 24282 50
Customer Information
Average Age: