EXAMEN NIVEL AVANZADO- CCE
Resolución problema 2
Sale ID Venta Categoria Nombre Producto
3 8/20/2023 Tablets Amazon Fire HD
50 1/21/2024 Headphones Apple AirPods Pro
20 1/31/2024 Headphones Apple AirPods Pro
8 1/25/2024 Smartwatches Apple Watch Series 7
23 5/23/2024 Smartwatches Apple Watch Series 7
21 7/5/2023 Laptops Asus ZenBook
24 10/16/2023 Laptops Asus ZenBook
9 2/6/2024 Laptops Asus ZenBook
49 9/22/2023 Headphones Beats Solo3
40 6/23/2023 Headphones Bose QuietComfort 35
32 7/26/2023 Headphones Bose QuietComfort 35
44 9/21/2023 Headphones Bose QuietComfort 35
34 3/26/2024 Headphones Bose QuietComfort 35
19 4/29/2024 Headphones Bose QuietComfort 35
41 5/20/2024 Headphones Bose QuietComfort 35
43 5/22/2024 Headphones Bose QuietComfort 35
28 7/29/2023 Laptops Dell XPS 13
47 11/11/2023 Laptops Dell XPS 13
29 6/2/2024 Laptops Dell XPS 13
12 4/16/2024 Smartwatches Fitbit Sense
17 7/3/2023 Smartwatches Garmin Venu
15 9/10/2023 Smartwatches Garmin Venu
33 6/19/2023 Smartphones Google Pixel 6
18 10/6/2023 Smartphones Google Pixel 6
30 7/20/2023 Laptops HP Spectre x360
45 8/2/2023 Laptops HP Spectre x360
7 12/24/2023 Laptops HP Spectre x360
27 8/20/2023 Smartwatches Huawei Watch GT 3
5 9/5/2023 Smartwatches Huawei Watch GT 3
11 5/12/2024 Tablets iPad Pro
Instrucciones:
1. Obtenga el precio del Nombre Producto de la hoja de calculo Precios
2. Determine el valor de Ventas
3. Crea un infome de Ventas por Categoria
4. Crea un informe de las Ventas por Nombre Producto
!Exitos!
