Uncategorized
Computation
Utilizando el archivo WK3 – Excel Excercise como guía, modifique la hoja de cálculos
Week 3 Excel Data.xlsx
incluida en esta tarea. El resultado a obtener es una hoja de dato lo mas parecida a la guía en PDF (WK3 – Excel Excercise ).
Como ayuda para crear la grafica le incluyo un corto video.
Week 3 Excel Data.xlsx
Inserting Chart to Excel Sheet.mp4
WK 3 – Excel Excercise
Sheet1
Walk and Rock Music | ||||||
First Quarter Rock-It MP3 Sales | ||||||
Northeast | South | Midwest | West | |||
Videos | 66145.15 | 79677.1 | 34657.66 | 52517.2 | 99455.49 | |
Mini | 31,375.24 | 82,937.72 | 66,137.50 | 30,681.82 | 43,595.24 | |
Micro | 27,596.37 | 92,716.32 | 88,294.78 | 87,984.79 | 83,380.72 | |
Flash | 27,885.59 | 98,800.57 | 24,111.33 | 69,737.51 | 51,003.09 | |
Accessories | 9,715.12 | 31,284.20 | 66,527.37 | 40,374.83 | 46,321.88 | |
162717.47 | 385415.91 | 279728.64 | 281296.15 | 323756.42 | ||
Global Sales Tax | 7% | |||||
Total Tax Paid | ||||||
Total Plus Tax |
Style = Title
Size 18
Heading 3
Style: Heading 1
Merge & Center
Size 15
Signo “$”
Negrillas
Style: Total
Chart Style : Style 1
Quick Layout: Layout 10
Crear formula: celda
G9 por D24
Crear formula: celda
G9 mas D25Negrillas
Change This First!! Theme = Office Them | Color = Office 2007-2010