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 asistente de IA contó los pedidos online del Q3 de clientes Mid-Market y Enterprise por región y mes. Al total general de la cuadrícula le faltan unos cuantos pedidos respecto a la lista.
Asistente de IA: “Aquí está el conteo región × mes. Cada celda cuenta los pedidos desde el primer día del mes hasta el fin de mes que da FIN.MES, así que los meses no se pueden superponer.”
Revisa las fórmulas de la IA en H2:J5 y corrígelas para que cada celda cuente los pedidos de A2:A41 de la región en la columna G y del mes completo que empieza en la fecha de la fila 1, con el primer y el último día incluidos.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Region | Value | Region | 2025-07-01 | 2025-08-01 | 2025-09-01 | Q3 | |
| 2 | 50555 | 2025-07-03 | Copper Bakery | North | 1,724.00 | North | 4AI | 2AI | 8AI | 14 | |
| 3 | 50578 | 2025-07-11 | Harbor Bakery | East | 460.80 | South | 5AI | 4AI | 2AI | 11 | |
| 4 | 50580 | 2025-07-11 | Willow Studios | North | 1,284.30 | East | 2AI | 3AI | 2AI | 7 | |
| 5 | 50583 | 2025-07-13 | Bright Pharmacy | North | 943.90 | West | 0AI | 4AI | 1AI | 5 | |
| 6 | 50595 | 2025-07-16 | Pioneer Studios | North | 85.50 | Total | 11 | 13 | 13 | 37 | |
| 7 | 50598 | 2025-07-17 | Oak Bakery | East | 570.50 | Orders in list | 40 | ||||
| 8 | 50599 | 2025-07-18 | Orchard Clinic | South | 1,044.40 | ||||||
| 9 | 50610 | 2025-07-22 | Orchard Clinic | South | 3,239.40 | ||||||
| 10 | 50623 | 2025-07-25 | Copper Media | South | 409.45 | ||||||
| 11 | 50627 | 2025-07-28 | Copper Fitness | South | 198.00 | ||||||
| 12 | 50633 | 2025-07-29 | River Bakery | South | 81.68 | ||||||
| 13 | 50638 | 2025-07-31 | Copper Media | South | 307.80 | ||||||
| 14 | 50639 | 2025-07-31 | Cedar Studios | South | 347.20 | ||||||
| 15 | 50645 | 2025-08-04 | Copper Fitness | South | 389.28 | ||||||
| 16 | 50648 | 2025-08-05 | Harbor Realty | West | 355.50 | ||||||
| 17 | 50650 | 2025-08-05 | Orchard Clinic | South | 206.00 | ||||||
| 18 | 50655 | 2025-08-06 | Oak Academy | East | 574.40 | ||||||
| 19 | 50666 | 2025-08-08 | Atlas Bakery | South | 115.01 | ||||||
| 20 | 50668 | 2025-08-11 | Harbor Labs | East | 66.00 | ||||||
| 21 | 50670 | 2025-08-12 | Falcon Dental | East | 430.60 | ||||||
| 22 | 50676 | 2025-08-13 | Summit Motors | West | 314.78 | ||||||
| 23 | 50688 | 2025-08-16 | Harbor Consulting | North | 258.70 | ||||||
| 24 | 50691 | 2025-08-18 | Orchard Bakery | West | 223.56 | ||||||
| 25 | 50702 | 2025-08-21 | Willow Logistics | West | 256.75 | ||||||
| 26 | 50723 | 2025-08-28 | Orchard Print Co | North | 837.00 | ||||||
| 27 | 50728 | 2025-08-29 | River Bakery | South | 794.30 | ||||||
| 28 | 50733 | 2025-09-01 | Harbor Bakery | East | 59.40 | ||||||
| 29 | 50735 | 2025-09-01 | Copper Bakery | North | 468.00 | ||||||
| 30 | 50740 | 2025-09-02 | Beacon Accounting | West | 513.37 | ||||||
| 31 | 50741 | 2025-09-03 | Copper Fitness | South | 203.77 | ||||||
| 32 | 50743 | 2025-09-03 | Willow Studios | North | 1,319.70 | ||||||
| 33 | 50748 | 2025-09-04 | Oak Academy | East | 643.10 | ||||||
| 34 | 50751 | 2025-09-05 | Copper Bakery | North | 628.08 | ||||||
| 35 | 50753 | 2025-09-07 | Willow Studios | North | 135.00 | ||||||
| 36 | 50766 | 2025-09-11 | Lakeside Pharmacy | North | 678.50 | ||||||
| 37 | 50768 | 2025-09-11 | Oak Fitness | North | 859.00 | ||||||
| 38 | 50782 | 2025-09-16 | Pioneer Studios | North | 38.50 | ||||||
| 39 | 50787 | 2025-09-18 | Orchard Realty | South | 707.70 | ||||||
| 40 | 50800 | 2025-09-23 | Oak Fitness | North | 681.20 | ||||||
| 41 | 50821 | 2025-09-30 | Willow Logistics | West | 358.00 | ||||||
| 42 | |||||||||||
| 43 | |||||||||||
| 44 |
=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