computer applications and business systems - Calculation and Advanced Features Practice
feoeigw2g3
module_05_assignment_data_1.xlsxFormulas and Charts
| My Practice Data | |||||
| Module 05 | |||||
| Location | January | February | March | Total Sales | Percent of Total |
| North | 100 | 75 | 250 | ||
| South | 200 | 80 | 245 | ||
| East | 300 | 70 | 145 | ||
| West | 200 | 55 | 90 | ||
| Grand Total | |||||
| Create formulas for Total Sales, Grand Total, and Percent of Total (F5/E9) - remember absolute cell addressing | |||||
| Create a bar chart for the data | |||||
| Move the chart to its own sheet |
Functions
| My House Payment | ||
| Mortgage | 350,000 | |
| Interest rate | 6% | |
| # of payments | 240 | |
| My monthly payment will be: |
Goal Seek
| My Savings Plan | ||
| Number of months | 12 | |
| Amount saved | $232 | |
| Grand Total | $2,784 |
Sort
| Topic | Subtopic |
| Criminal Justice | Deviance |
| Marriage and Family | Marriage and Marriage and Family |
| Race/Class/Gender | Race/Ethnicity |
| Race/Class/Gender | Human Sexuality |
| Criminal Justice | Juvenile Delinquency |
| Research/Statistics | Data Analysis |
| Research/Statistics | Social Statistics |
| Race/Class/Gender | Race/Ethnicity |
| Race/Class/Gender | Race/Ethnicity |
| Aging and Death | Sociology of Aging |
| Introduction | Conflict Approach |
| Introduction | Conflict Approach |
| Introduction | General |
| Introduction | General |
| Research/Statistics | Data Analysis |
| Aging and Death | Death and Dying |
| Criminal Justice | Deviance |
| Criminal Justice | Deviance |
| Marriage and Family | Marriage and Marriage and Family |
| Introduction | Macrosociology Approach |
| Research/Statistics | Research Methods |
| Research/Statistics | Social Statistics |
| Race/Class/Gender | Gender Issues |
| Race/Class/Gender | Gender Issues |
| Aging and Death | Sociology of Aging |
| Aging and Death | Sociology of Aging |
| Race/Class/Gender | Human Sexuality |
| Aging and Death | Death and Dying |
| Aging and Death | Death and Dying |
| Race/Class/Gender | Gender Issues |
| Introduction | Social Sciences |
| Research/Statistics | Social Statistics |
| Criminal Justice | Juvenile Delinquency |
| Criminal Justice | Juvenile Delinquency |
| Introduction | Macrosociology Approach |
| Marriage and Family | Marriage and Family Interaction |
| Marriage and Family | Marriage and Family Interaction |
| Marriage and Family | Marriage and Marriage and Family |
| Introduction | Social Sciences |
| Introduction | Social Sciences |
| Race/Class/Gender | Human Sexuality |
| Research/Statistics | Research Methods |
| Aging and Death | Sociology of Aging |
| Research/Statistics | Research Methods |
| Marriage and Family | Marriage and Marriage and Family |
| Research/Statistics | Research Methods |
| Race/Class/Gender | Human Sexuality |
| Race/Class/Gender | Gender Issues |
| Race/Class/Gender | Gender Issues |
| Introduction | General |
| Aging and Death | Sociology of Aging |
| Research/Statistics | Social Statistics |
| Introduction | General |
| Research/Statistics | Data Analysis |
| Research/Statistics | Social Statistics |
| Research/Statistics | Social Statistics |
Filter
| Topic | Subtopic |
| Criminal Justice | Deviance |
| Marriage and Family | Marriage and Marriage and Family |
| Race/Class/Gender | Race/Ethnicity |
| Race/Class/Gender | Human Sexuality |
| Criminal Justice | Juvenile Delinquency |
| Research/Statistics | Data Analysis |
| Research/Statistics | Social Statistics |
| Race/Class/Gender | Race/Ethnicity |
| Race/Class/Gender | Race/Ethnicity |
| Aging and Death | Sociology of Aging |
| Introduction | Conflict Approach |
| Introduction | Conflict Approach |
| Introduction | General |
| Introduction | General |
| Research/Statistics | Data Analysis |
| Aging and Death | Death and Dying |
| Criminal Justice | Deviance |
| Criminal Justice | Deviance |
| Marriage and Family | Marriage and Marriage and Family |
| Introduction | Macrosociology Approach |
| Research/Statistics | Research Methods |
| Research/Statistics | Social Statistics |
| Race/Class/Gender | Gender Issues |
| Race/Class/Gender | Gender Issues |
| Aging and Death | Sociology of Aging |
| Aging and Death | Sociology of Aging |
| Race/Class/Gender | Human Sexuality |
| Aging and Death | Death and Dying |
| Aging and Death | Death and Dying |
| Race/Class/Gender | Gender Issues |
| Introduction | Social Sciences |
| Research/Statistics | Social Statistics |
| Criminal Justice | Juvenile Delinquency |
| Criminal Justice | Juvenile Delinquency |
| Introduction | Macrosociology Approach |
| Marriage and Family | Marriage and Family Interaction |
| Marriage and Family | Marriage and Family Interaction |
| Marriage and Family | Marriage and Marriage and Family |
| Introduction | Social Sciences |
| Introduction | Social Sciences |
| Race/Class/Gender | Human Sexuality |
| Research/Statistics | Research Methods |
| Aging and Death | Sociology of Aging |
| Research/Statistics | Research Methods |
| Marriage and Family | Marriage and Marriage and Family |
| Research/Statistics | Research Methods |
| Race/Class/Gender | Human Sexuality |
| Race/Class/Gender | Gender Issues |
| Race/Class/Gender | Gender Issues |
| Introduction | General |
| Aging and Death | Sociology of Aging |
| Research/Statistics | Social Statistics |
| Introduction | General |
| Research/Statistics | Data Analysis |
| Research/Statistics | Social Statistics |
| Research/Statistics | Social Statistics |
Pivot Table
| Artist | Name | Value | Location | Category |
| Jeremy Winters | Spring in the Mountains | $ 73,482 | Courthouse | Painting |
| Jeremy Winters | Mountains in the Spring | $ 48,293 | Convention Center | Sculpture |
| Jeremy Winters | Blue Mountains | $ 47,180 | Courthouse | Painting |
| Marlene Smith | Green Mountains | $ 44,448 | Courthouse | Painting |
| Jeremy Winters | Mountains in the Summer | $ 58,571 | County Center | Painting |
| kenneth Springer | Boulder Park Geese | $ 63,687 | County Center | Sculpture |
| kenneth Springer | Boulder Park Ducks | $ 37,794 | County Center | Painting |
| Jeremy Winters | Mountains in the Winter | $ 40,377 | Courthouse | Sculpture |
| Jeremy Winters | White Mountains | $ 24,631 | Courthouse | Painting |
| Elenor Pollack | Lake Michigan at Sunset | $ 58,387 | Convention Center | Painting |
| Elenor Pollack | Lake Michigan | $ 70,663 | Convention Center | Sculpture |
| Marlene Smith | Red Mountains | $ 56,417 | Convention Center | Sculpture |
| kenneth Springer | Boulder Park Lake | $ 68,582 | Convention Center | Painting |
| Elenor Pollack | Lake Michigan at Dawn | $ 72,443 | County Center | Painting |
| Elenor Pollack | Lake Michigan at Night | $ 29,051 | County Center | Painting |
| Marlene Smith | Gold Mountains | $ 54,117 | Convention Center | Painting |
| kenneth Springer | Children at Play | $ 36,531 | Courthouse | Painting |
| Elenor Pollack | Lake Michigan at Noon | $ 71,194 | Courthouse | Painting |
| kenneth Springer | Boulder Park Water | $ 43,249 | County Center | Painting |
| Marlene Smith | Yellow Mountains | $ 72,035 | Courthouse | Painting |
