Cargando ejercicio…
Cargando ejercicio…
Los ejercicios están pensados para usar con teclado. Lee la tarea aquí y luego abre esta página en una computadora para resolverla.
Marcus Hill quiere la clasificación de clientes de diciembre: cada cliente con al menos un pedido completado, el que más gastó primero, que se rearme sola a medida que llegan pedidos.
En I2, desborda cada cliente (columna C) que tenga al menos un pedido completado, una vez cada uno, ordenados por su Value completado total (columna G) de mayor a menor. En J2, desborda el total completado de cada cliente listado, apuntando a I2#. Sin redondear.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Order date | Customer | Region | Channel | Status | Value | Customer | Completed value | |
| 2 | 51006 | 2025-12-01 | Pioneer Consulting | North | Sales Rep | completed | $371.80 | |||
| 3 | 51007 | 2025-12-01 | Willow Studios | North | Sales Rep | completed | $157.50 | |||
| 4 | 51008 | 2025-12-01 | Harbor Labs | East | Online | completed | $320.45 | |||
| 5 | 51009 | 2025-12-01 | Falcon Consulting | North | Sales Rep | completed | $42.00 | |||
| 6 | 51010 | 2025-12-02 | Beacon Hotels | East | Partner | completed | $275.60 | |||
| 7 | 51011 | 2025-12-02 | Willow Law Group | East | Online | completed | $224.00 | |||
| 8 | 51012 | 2025-12-02 | Copper Media | South | Online | completed | $251.55 | |||
| 9 | 51013 | 2025-12-03 | Willow Studios | North | Sales Rep | completed | $29.70 | |||
| 10 | 51014 | 2025-12-03 | River Print Co | West | Online | completed | $182.50 | |||
| 11 | 51015 | 2025-12-03 | Maple Academy | East | Sales Rep | completed | $841.60 | |||
| 12 | 51016 | 2025-12-03 | Willow Academy | North | Online | completed | $181.00 | |||
| 13 | 51017 | 2025-12-04 | Orchard Media | West | Online | completed | $74.00 | |||
| 14 | 51018 | 2025-12-04 | Willow Hotels | West | Sales Rep | completed | $86.40 | |||
| 15 | 51019 | 2025-12-04 | Copper Media | South | Online | completed | $148.50 | |||
| 16 | 51020 | 2025-12-04 | Bright Hotels | East | Sales Rep | completed | $118.50 | |||
| 17 | 51021 | 2025-12-05 | Harbor Fitness | South | Sales Rep | completed | $152.40 | |||
| 18 | 51022 | 2025-12-05 | Copper Media | South | Online | completed | $175.00 | |||
| 19 | 51023 | 2025-12-05 | Orchard Clinic | South | Online | cancelled | $823.00 | |||
| 20 | 51024 | 2025-12-05 | Copper Fitness | South | Sales Rep | completed | $223.00 | |||
| 21 | 51025 | 2025-12-06 | Pioneer Realty | West | Sales Rep | completed | $195.70 | |||
| 22 | 51026 | 2025-12-08 | Blue Accounting | North | Online | completed | $92.40 | |||
| 23 | 51027 | 2025-12-08 | Willow Hotels | West | Sales Rep | completed | $248.47 | |||
| 24 | 51028 | 2025-12-08 | Beacon Architects | North | Online | completed | $219.60 | |||
| 25 | 51029 | 2025-12-09 | Orchard Academy | South | Online | completed | $402.55 | |||
| 26 | 51030 | 2025-12-09 | Copper Media | South | Online | completed | $169.50 | |||
| 27 | 51031 | 2025-12-09 | Harbor Consulting | North | Online | completed | $747.83 | |||
| 28 | 51032 | 2025-12-10 | North Architects | South | Partner | completed | $19.80 | |||
| 29 | 51033 | 2025-12-10 | Cedar Realty | North | Sales Rep | completed | $122.50 | |||
| 30 | 51034 | 2025-12-10 | Harbor Hotels | West | Partner | completed | $182.00 | |||
| 31 | 51035 | 2025-12-10 | Harbor Studios | East | Online | refunded | $504.00 | |||
| 32 | 51036 | 2025-12-10 | Pioneer Realty | West | Online | completed | $105.00 | |||
| 33 | ||||||||||
| 34 | ||||||||||
| 35 | ||||||||||
| 36 | ||||||||||
| 37 | ||||||||||
| 38 | ||||||||||
| 39 | ||||||||||
| 40 | ||||||||||
| 41 | ||||||||||
| 42 | ||||||||||
| 43 |
=SI(B2>=1,5;SUMA(C2:C9);0)Idioma
Plan completo
Excel ✓ · SQL y Power BI también incluidos
Cancela cuando quieras · Reembolso total en 14 días · Pago seguro con Stripe