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.
El director de ventas quiere un resumen por canal de diciembre que se arme solo: los canales, los ingresos completados y el número de pedidos completados, sin ninguna fila escrita a mano.
En I2, desborda cada canal (columna E) una vez, de la A a la Z. En J2, desborda los ingresos completados (Value, columna G, Status "completed") de cada canal, y en K2 el número de pedidos completados. J2 y K2 deben apuntar al rango desbordado de I2 con I2#. Sin redondear.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Order date | Customer | Region | Channel | Status | Value | Channel | Completed revenue | Completed orders | |
| 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 |
=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