PEQUEÑOS PASOS. HABILIDADES REALES.
Su próxima habilidad útil.
Describa la tarea. Revise la propuesta. Verifique el resultado en Excel.
Tres lecciones gratuitas · un capítulo útil
Se conserva la evaluación anterior. Su trabajo guardado no cambia; las nuevas tareas usan instrucción, revisión, aplicación y verificación.
Su guía de Excel
Aprenda haciendo, a su ritmoSu primera instrucción en Excel
Siga la demostración y después practique.
| A | B | C | |
|---|---|---|---|
| 1 | Product | January | February |
| 2 | Notebooks | 120 | 150 |
| 3 | Pens | 80 | 90 |
| 4 | Folders | 60 | 75 |
| 5 | Total |
| A | B | C | |
|---|---|---|---|
| 1 | Product | January | February |
| 2 | Notebooks | 120 | 150 |
| 3 | Pens | 80 | 90 |
| 4 | Folders | 60 | 75 |
| 5 | Total | 260 |
El enunciado Goal: total February sales from the current sheet. February is C2:C4 (150, 90, 75). Request a connected formula in C5. Preserve all source data and January. Check that the total is 315 and responds to each February value.
Add all February sales in C2:C4 and put a formula total in C5. Preserve the source data.
- B5 → =SUM(B2:B4)
- ✓Headings describe the data. Each product gets one row, with January and February in separate columns.
- ✓=SUM(B2:B4) adds 120 + 80 + 60 to get 260. The colon includes every cell between the endpoints.
- ✓=SUM(C2:C4) or =C2+C3+C4 adds all three February values to get 315. Enter calculates; Check grades separately.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | |
| 3 | Pens | 5 | 2 | |
| 4 | Folders | 4 | 3 | |
| 5 | Total |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | 36 |
| 3 | Pens | 5 | 2 | |
| 4 | Folders | 4 | 3 | |
| 5 | Total |
El enunciado Goal: calculate revenue per product and a grand total from the supplied quantities and prices. Request connected formulas in D2:D4 and D5. Then refine your prompt to set Notebooks units to 4 and Pens units to 7, preserving prices and Folders. Verify that revenue and the grand total recalculate to 48, 14, 12 and 74.
Calculate revenue for each product from quantity times price, and a grand total. Set Notebooks units to 4 and Pens units to 7. Keep the prices and Folders unchanged.
- D2 → =B2*C2
- ✓Revenue = quantity × unit price. =B2*C2 and =C2*B2 both work. A fixed 36 would not recalculate.
- ✓Multiply each row’s quantity by its price, then use =SUM(D2:D4) or =D2+D3+D4 for the total. Initially it is 58.
- ✓Changing notebook quantity from 3 to 4 updates its revenue from 36 to 48. Changing pen quantity from 5 to 7 updates pen revenue to 14 and total revenue to 74.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Notebooks | 48 |
| 3 | Pens | 14 |
| 4 | Folders | 12 |
| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Notebooks | 48 |
| 3 | Pens | 14 |
| 4 | Folders | 12 |
El enunciado Goal: compare the supplied product revenues: Notebooks 48, Pens 14, Folders 12. Request a column chart using A1:B4 or A2:B4, a descriptive revenue title, and the highest-revenue product and value. Preserve the source table.
Create a column chart from A1:B4 titled "Product sales revenue" and identify the highest-revenue product and its value. Keep the data unchanged.
- Column chart from A1:B4 titled “Revenue by product”
- ✓Choose both product labels and all three revenue values. A1:B4 includes headings; A2:B4 is also valid for this chart.
- ✓A column chart uses height to compare values. Descriptive titles such as “Product sales revenue” tell the reader what the values mean.
- ✓Notebooks has the tallest column and the most revenue: 48, compared with 14 for Pens and 12 for Folders.
- ✓Refine weak prompts by adding source, expected output and what must remain unchanged. This is an authored constrained planner; review actual proposed formulas and verify changed inputs.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit price | Revenue |
| 2 | Notebooks | 3 | 12 | 36 |
| 3 | Pens | 5 | 2 | 10 |
| 4 | Folders | 4 | 3 | 12 |
| 5 | Total | 58 |
El enunciado Business goal: track shop sales. Supplied data: Notebooks — 3 units at 12 each; Pens — 5 units at 2 each; Folders — 4 units at 3 each. Desired result: a table with revenue per product and a calculated grand total.
Create a sales tracker for my shop. Data: Notebooks 3 units at 12 each; Pens 5 units at 2 each; Folders 4 units at 3 each. Calculate revenue for each product and a grand total.
- 10 cells of supplied data: A2, B2, C2, A3, B3, C3…
- D2 → =B2*C2
- D3 → =B3*C3
- D4 → =B4*C4
- D5 → =SUM(D2:D4)
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Create a sales tracker for my shop. Data: Notebooks 3 units at 12 each; Pens 5 units at 2 each; Folders 4 units at 3 each. Calculate revenue for each product and a grand total.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Category | Expense | Metric | Value |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Category | Expense | Metric | Value |
| 2 | Rent | 800 | Budget limit | 1000 |
| 3 | Utilities | 120 | Total expenses | 1000 |
| 4 | Supplies | 80 | Remaining | 0 |
El enunciado Business goal: plan monthly spending. Budget limit: 1000. Supplied expenses: Rent 800; Utilities 120; Supplies 80. Desired result: an expense table, total expenses and the remaining budget, all connected by formulas.
Build a monthly expense budget. Budget limit: 1000. Data: Rent 800; Utilities 120; Supplies 80. Calculate total expenses and the remaining budget.
- 10 cells of supplied data: A2, B2, A3, B3, A4, B4…
- D3 → =SUM(B2:B4)
- D4 → =D2-D3
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Build a monthly expense budget. Budget limit: 1000. Data: Rent 800; Utilities 120; Supplies 80. Calculate total expenses and the remaining budget.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | North | 1200 |
| 3 | South | 900 |
| 4 | West | 1500 |
El enunciado Business goal: compare regional sales for a business review. Supplied data: North 1200; South 900; West 1500. Desired result: a product-style column comparison of all three regions, a descriptive sales title, and a statement identifying the highest-sales region and its value.
Summarise regional sales for a business review. Data: North 1200; South 900; West 1500. Create a column chart titled "Sales by region" and identify the highest sales region with its value.
- 6 cells of supplied data: A2, B2, A3, B3, A4, B4
- Column chart from A1:B4 titled “Sales by region”
- ✓Goal + supplied data + desired result gives the assistant a concrete job. Example: Summarise regional sales for a business review. Data: North 1200; South 900; West 1500. Create a column chart titled "Sales by region" and identify the highest sales region with its value.
- ✓A prompt generates an inspectable plan, not executable code. Review the cells, formulas and any chart before applying. Applying validates ranges and formulas and calculates on the server.
- ✓Check the resulting data, calculations and chart. If something is missing, refine the prompt and review a new proposal. Existing changed cells need explicit replacement approval. Replay never applies the proposal again.
- Escribir la instrucción
- Revisar
- Aplicar
- Comprobar
Su planteamiento empresarial
Ejemplo Instrucción de ejemplo del tutor
Inspeccionar las acciones del ejemplo del tutor
Revisar antes de aplicar
Cambios propuestos en celdas, fórmulas y gráficos
Su primera instrucción funciona. ¿Desea conservar este progreso?
Ahora mismo pertenece a esta sesión del navegador. Inicie sesión con su cuenta de AI Coalition Network para conservarlo.
Guardar mi progreso →Ya puede convertir un planteamiento empresarial en una hoja de cálculo comprobada.
Ha creado un registro de ventas, un presupuesto de gastos conectado y un gráfico regional. A continuación, aprenda limpieza, modelos financieros, búsquedas fiables, tablas dinámicas nativas y paneles.
Vista previa del resto del curso →Los capítulos 1–2 son gratuitos. El acceso completo al curso cuesta $19 USD, un solo pago, e incluye los ejercicios, las evaluaciones y la tutoría de lecciones actuales. Sin suscripción obligatoria. Ver la oferta de lanzamiento festiva y la disponibilidad del pago →
Preguntar sobre esta lección
Tutor de demostración fijo
Siga las celdas resaltadas.
Usar este libro de trabajo en Excel
Capacidades del libro de trabajo y versión guardada
Versión 0
Estas lecciones redactadas por nosotros admiten aritmética, paréntesis y SUM dentro de sus filas de datos numéricos 2–4. Se rechazan otras funciones, vínculos externos y código arbitrario. Las operaciones no admitidas producen un error visible.