際際滷

際際滷Share a Scribd company logo
Calculating Percents Spreadsheet Type the title,  Sport Teams Records  in cell C1 Type  your name  in cell A2 Type the column headings in row 3 as follows: Cell A3   Teams Cell B3   Won Cell C3   Lost Cell D3   Total Cell E3   Percent Won
Team Names Enter the team names in Column A Lakers Suns Blazers Bulls Magic Sonics
Format Headings Format all the HEADINGS and TEAM NAMES Select cell A1 and holding the left mouse button go over and down to E9 Then click the Bold button  the B in the tool bar
Enter Wins Enter the wins for each team in Column B Lakers  45 Suns  30 Blazers  32 Bulls  48 Magic  38 Sonics  47
Enter Loses Enter the losses for each team in Column  C Lakers  30 Suns  45 Blazers 43 Bulls  27 Magic  38 Sonics  29
Totals Compute the total number of games for each team in Column D Select D4 In the formula bar at the top enter this: = B4 + C4  (no spaces) Press ENTER The total number should  appear in cell D4
Totals Click on D4 and drag your mouse down to D9 With the text still highlighted, click Edit then Fill, then Down This adds all your scores without making you add each team.
Percent of Wins The formula for percent is Wins divided by Total Games times 100.  This is a 2 step process. Click on cell E4 Enter this formula into the formula line =B4/D4*100  Now, click on E4 and highlight to E9 Click Edit, Fill, Down
Changing decimal points Highlight Column E Go to Format  Cells  Number You can change the number of decimal places by using the up arrow Click OK
Congratulations You have now completed your first spreadsheet

More Related Content

What's hot (20)

Ch. 5 2 Triangles
Ch. 5 2 TrianglesCh. 5 2 Triangles
Ch. 5 2 Triangles
Kathy Favazza
Converting repeating , non terminating decimals
Converting repeating , non terminating decimalsConverting repeating , non terminating decimals
Converting repeating , non terminating decimals
MartinGeraldine
Ch. 5 2 Rectangles
Ch. 5 2 RectanglesCh. 5 2 Rectangles
Ch. 5 2 Rectangles
Kathy Favazza
Washers 2019
Washers 2019Washers 2019
Washers 2019
nucampusrec
Worksheet about racket sports
Worksheet about racket sportsWorksheet about racket sports
Worksheet about racket sports
sebassevilla9PE
Fractions & decimals
Fractions & decimalsFractions & decimals
Fractions & decimals
Rebekah Manson
Lesson 6 The Basics Of Overcalling Opponents And The Introduction To Doubles
Lesson 6   The Basics Of Overcalling Opponents And The Introduction To DoublesLesson 6   The Basics Of Overcalling Opponents And The Introduction To Doubles
Lesson 6 The Basics Of Overcalling Opponents And The Introduction To Doubles
Bridge Spades
Constants variables and data types
Constants variables and data typesConstants variables and data types
Constants variables and data types
SV.CO
Ladder golf 2019
Ladder golf 2019Ladder golf 2019
Ladder golf 2019
nucampusrec
Tennis
Tennis Tennis
Tennis
ebrahimalhosani
DIVISION: TWO-DIGIT DIVISOR
DIVISION: TWO-DIGIT DIVISORDIVISION: TWO-DIGIT DIVISOR
DIVISION: TWO-DIGIT DIVISOR
Johdener14
Chapter2.1
Chapter2.1Chapter2.1
Chapter2.1
nglaze10
A2 numer ix
A2 numer ixA2 numer ix
A2 numer ix
Rosa Cantoro
TEst
TEstTEst
TEst
conferencely
Division of mixed decimals
Division of mixed decimalsDivision of mixed decimals
Division of mixed decimals
JohnTitoLerios
Maths for psychology 1
Maths for psychology 1Maths for psychology 1
Maths for psychology 1
Mike Magras
Power point
Power pointPower point
Power point
AndreGoins
Fractions
FractionsFractions
Fractions
Joumana Nabil
CPM Geometry Inequalities
CPM Geometry InequalitiesCPM Geometry Inequalities
CPM Geometry Inequalities
scnbmitchell
Fractions Xv
Fractions XvFractions Xv
Fractions Xv
hiratufail
Ch. 5 2 Triangles
Ch. 5 2 TrianglesCh. 5 2 Triangles
Ch. 5 2 Triangles
Kathy Favazza
Converting repeating , non terminating decimals
Converting repeating , non terminating decimalsConverting repeating , non terminating decimals
Converting repeating , non terminating decimals
MartinGeraldine
Ch. 5 2 Rectangles
Ch. 5 2 RectanglesCh. 5 2 Rectangles
Ch. 5 2 Rectangles
Kathy Favazza
Worksheet about racket sports
Worksheet about racket sportsWorksheet about racket sports
Worksheet about racket sports
sebassevilla9PE
Fractions & decimals
Fractions & decimalsFractions & decimals
Fractions & decimals
Rebekah Manson
Lesson 6 The Basics Of Overcalling Opponents And The Introduction To Doubles
Lesson 6   The Basics Of Overcalling Opponents And The Introduction To DoublesLesson 6   The Basics Of Overcalling Opponents And The Introduction To Doubles
Lesson 6 The Basics Of Overcalling Opponents And The Introduction To Doubles
Bridge Spades
Constants variables and data types
Constants variables and data typesConstants variables and data types
Constants variables and data types
SV.CO
Ladder golf 2019
Ladder golf 2019Ladder golf 2019
Ladder golf 2019
nucampusrec
DIVISION: TWO-DIGIT DIVISOR
DIVISION: TWO-DIGIT DIVISORDIVISION: TWO-DIGIT DIVISOR
DIVISION: TWO-DIGIT DIVISOR
Johdener14
Chapter2.1
Chapter2.1Chapter2.1
Chapter2.1
nglaze10
Division of mixed decimals
Division of mixed decimalsDivision of mixed decimals
Division of mixed decimals
JohnTitoLerios
Maths for psychology 1
Maths for psychology 1Maths for psychology 1
Maths for psychology 1
Mike Magras
Power point
Power pointPower point
Power point
AndreGoins
CPM Geometry Inequalities
CPM Geometry InequalitiesCPM Geometry Inequalities
CPM Geometry Inequalities
scnbmitchell
Fractions Xv
Fractions XvFractions Xv
Fractions Xv
hiratufail

More from drussell (6)

NCTIES 2012
NCTIES 2012NCTIES 2012
NCTIES 2012
drussell
NCSTA 2012
NCSTA 2012NCSTA 2012
NCSTA 2012
drussell
NCAGT - Celebrating 40 years with 40 web 2.0 sites
NCAGT - Celebrating 40 years with 40 web 2.0 sitesNCAGT - Celebrating 40 years with 40 web 2.0 sites
NCAGT - Celebrating 40 years with 40 web 2.0 sites
drussell
Database
DatabaseDatabase
Database
drussell
Spreadsheets made easy
Spreadsheets made easySpreadsheets made easy
Spreadsheets made easy
drussell
Movie Maker
Movie MakerMovie Maker
Movie Maker
drussell
NCTIES 2012
NCTIES 2012NCTIES 2012
NCTIES 2012
drussell
NCSTA 2012
NCSTA 2012NCSTA 2012
NCSTA 2012
drussell
NCAGT - Celebrating 40 years with 40 web 2.0 sites
NCAGT - Celebrating 40 years with 40 web 2.0 sitesNCAGT - Celebrating 40 years with 40 web 2.0 sites
NCAGT - Celebrating 40 years with 40 web 2.0 sites
drussell
Database
DatabaseDatabase
Database
drussell
Spreadsheets made easy
Spreadsheets made easySpreadsheets made easy
Spreadsheets made easy
drussell
Movie Maker
Movie MakerMovie Maker
Movie Maker
drussell

Recently uploaded (20)

The Economic History of the United States 15
The Economic History of the United States 15The Economic History of the United States 15
The Economic History of the United States 15
Gale Pooley
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERTDIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
joannoreau77
0070_B_Sevenyoken.pdfAntwerp Acceleration Day
0070_B_Sevenyoken.pdfAntwerp Acceleration Day0070_B_Sevenyoken.pdfAntwerp Acceleration Day
0070_B_Sevenyoken.pdfAntwerp Acceleration Day
FinTech Belgium
Twitter-Acquisition-by-Tesla-A-Case-Study.pptx
Twitter-Acquisition-by-Tesla-A-Case-Study.pptxTwitter-Acquisition-by-Tesla-A-Case-Study.pptx
Twitter-Acquisition-by-Tesla-A-Case-Study.pptx
hrishabhsrivastava20
The Economic History of the United States 13
The Economic History of the United States 13The Economic History of the United States 13
The Economic History of the United States 13
Gale Pooley
The Economic History of the United States 11
The Economic History of the United States 11The Economic History of the United States 11
The Economic History of the United States 11
Gale Pooley
0030_A_Ixor (1).pptxAntwerp Acceleration Day
0030_A_Ixor (1).pptxAntwerp Acceleration Day0030_A_Ixor (1).pptxAntwerp Acceleration Day
0030_A_Ixor (1).pptxAntwerp Acceleration Day
FinTech Belgium
Sailpeak - Agentic AI -Antonio G (2).pptx
Sailpeak - Agentic AI -Antonio G (2).pptxSailpeak - Agentic AI -Antonio G (2).pptx
Sailpeak - Agentic AI -Antonio G (2).pptx
FinTech Belgium
Time Value of Money .
Time Value of Money                      .Time Value of Money                      .
Time Value of Money .
Supriyo Dana
FESE Capital Markets Fact Sheet 2024 Q4.pdf
FESE Capital Markets Fact Sheet 2024 Q4.pdfFESE Capital Markets Fact Sheet 2024 Q4.pdf
FESE Capital Markets Fact Sheet 2024 Q4.pdf
secretariat4
CH_03 ppt ACOUNTING INFORMATION SYSTEM .
CH_03 ppt ACOUNTING INFORMATION SYSTEM .CH_03 ppt ACOUNTING INFORMATION SYSTEM .
CH_03 ppt ACOUNTING INFORMATION SYSTEM .
ghadasamy11
Certainties that are changing.Feb25.AM.ENG.docx.pdf
Certainties that are changing.Feb25.AM.ENG.docx.pdfCertainties that are changing.Feb25.AM.ENG.docx.pdf
Certainties that are changing.Feb25.AM.ENG.docx.pdf
Andrea Mennillo
The Economic History of the United States 8
The Economic History of the United States 8The Economic History of the United States 8
The Economic History of the United States 8
Gale Pooley
Tristar Corporate Presentation Investors page
Tristar Corporate Presentation Investors pageTristar Corporate Presentation Investors page
Tristar Corporate Presentation Investors page
Adnet Communications
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. MaliniINDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
MaliniHariraj
Playpen talk on trustee duties 25 Feb 2025.pptx
Playpen talk on trustee duties 25 Feb 2025.pptxPlaypen talk on trustee duties 25 Feb 2025.pptx
Playpen talk on trustee duties 25 Feb 2025.pptx
Henry Tapper
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn ProfileEaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
Easemoney
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdfYanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
MatiasMendoza46
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HostJane.com
The Economic History of the United States 15
The Economic History of the United States 15The Economic History of the United States 15
The Economic History of the United States 15
Gale Pooley
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERTDIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
DIGITAL TECH GUARD RECOVERY - MOST EFFICIENT BITCOIN RECOVERY EXPERT
joannoreau77
0070_B_Sevenyoken.pdfAntwerp Acceleration Day
0070_B_Sevenyoken.pdfAntwerp Acceleration Day0070_B_Sevenyoken.pdfAntwerp Acceleration Day
0070_B_Sevenyoken.pdfAntwerp Acceleration Day
FinTech Belgium
Twitter-Acquisition-by-Tesla-A-Case-Study.pptx
Twitter-Acquisition-by-Tesla-A-Case-Study.pptxTwitter-Acquisition-by-Tesla-A-Case-Study.pptx
Twitter-Acquisition-by-Tesla-A-Case-Study.pptx
hrishabhsrivastava20
The Economic History of the United States 13
The Economic History of the United States 13The Economic History of the United States 13
The Economic History of the United States 13
Gale Pooley
The Economic History of the United States 11
The Economic History of the United States 11The Economic History of the United States 11
The Economic History of the United States 11
Gale Pooley
0030_A_Ixor (1).pptxAntwerp Acceleration Day
0030_A_Ixor (1).pptxAntwerp Acceleration Day0030_A_Ixor (1).pptxAntwerp Acceleration Day
0030_A_Ixor (1).pptxAntwerp Acceleration Day
FinTech Belgium
Sailpeak - Agentic AI -Antonio G (2).pptx
Sailpeak - Agentic AI -Antonio G (2).pptxSailpeak - Agentic AI -Antonio G (2).pptx
Sailpeak - Agentic AI -Antonio G (2).pptx
FinTech Belgium
Time Value of Money .
Time Value of Money                      .Time Value of Money                      .
Time Value of Money .
Supriyo Dana
FESE Capital Markets Fact Sheet 2024 Q4.pdf
FESE Capital Markets Fact Sheet 2024 Q4.pdfFESE Capital Markets Fact Sheet 2024 Q4.pdf
FESE Capital Markets Fact Sheet 2024 Q4.pdf
secretariat4
CH_03 ppt ACOUNTING INFORMATION SYSTEM .
CH_03 ppt ACOUNTING INFORMATION SYSTEM .CH_03 ppt ACOUNTING INFORMATION SYSTEM .
CH_03 ppt ACOUNTING INFORMATION SYSTEM .
ghadasamy11
Certainties that are changing.Feb25.AM.ENG.docx.pdf
Certainties that are changing.Feb25.AM.ENG.docx.pdfCertainties that are changing.Feb25.AM.ENG.docx.pdf
Certainties that are changing.Feb25.AM.ENG.docx.pdf
Andrea Mennillo
The Economic History of the United States 8
The Economic History of the United States 8The Economic History of the United States 8
The Economic History of the United States 8
Gale Pooley
Tristar Corporate Presentation Investors page
Tristar Corporate Presentation Investors pageTristar Corporate Presentation Investors page
Tristar Corporate Presentation Investors page
Adnet Communications
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. MaliniINDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
INDUSTRIAL ESTATES IN TAMIL NADU by Dr. S. Malini
MaliniHariraj
Playpen talk on trustee duties 25 Feb 2025.pptx
Playpen talk on trustee duties 25 Feb 2025.pptxPlaypen talk on trustee duties 25 Feb 2025.pptx
Playpen talk on trustee duties 25 Feb 2025.pptx
Henry Tapper
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn ProfileEaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
EaseMoney - A Leading Finance & Banking Platform in India | Tracxn Profile
Easemoney
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdfYanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
Yanis Varoufakis - Technofeudalism_ What Killed Capitalism - libgen.li.pdf
MatiasMendoza46
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HBS Study examines which freelance groups ChatGPT and AI is replacing on onli...
HostJane.com

Calculating Percents

  • 1. Calculating Percents Spreadsheet Type the title, Sport Teams Records in cell C1 Type your name in cell A2 Type the column headings in row 3 as follows: Cell A3 Teams Cell B3 Won Cell C3 Lost Cell D3 Total Cell E3 Percent Won
  • 2. Team Names Enter the team names in Column A Lakers Suns Blazers Bulls Magic Sonics
  • 3. Format Headings Format all the HEADINGS and TEAM NAMES Select cell A1 and holding the left mouse button go over and down to E9 Then click the Bold button the B in the tool bar
  • 4. Enter Wins Enter the wins for each team in Column B Lakers 45 Suns 30 Blazers 32 Bulls 48 Magic 38 Sonics 47
  • 5. Enter Loses Enter the losses for each team in Column C Lakers 30 Suns 45 Blazers 43 Bulls 27 Magic 38 Sonics 29
  • 6. Totals Compute the total number of games for each team in Column D Select D4 In the formula bar at the top enter this: = B4 + C4 (no spaces) Press ENTER The total number should appear in cell D4
  • 7. Totals Click on D4 and drag your mouse down to D9 With the text still highlighted, click Edit then Fill, then Down This adds all your scores without making you add each team.
  • 8. Percent of Wins The formula for percent is Wins divided by Total Games times 100. This is a 2 step process. Click on cell E4 Enter this formula into the formula line =B4/D4*100 Now, click on E4 and highlight to E9 Click Edit, Fill, Down
  • 9. Changing decimal points Highlight Column E Go to Format Cells Number You can change the number of decimal places by using the up arrow Click OK
  • 10. Congratulations You have now completed your first spreadsheet