MALÉ KROKY. SKUTEČNÉ DOVEDNOSTI.
Vaše další užitečná dovednost.
Popište úkol. Zkontrolujte návrh. Ověřte výsledek v Excelu.
Tři bezplatné lekce · jedna užitečná kapitola
Dřívější hodnocení je zachováno. Vaše uložená práce se nemění; nové úkoly používají postup zadat, zkontrolovat, použít a ověřit.
Váš průvodce Excelem
Učte se praxí, svým tempemVáš první prompt pro Excel
Sledujte ukázku a poté si procvičte.
| 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 |
Zadání 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 |
Zadání 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 |
Zadání 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 |
Zadání 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 |
Zadání 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 |
Zadání 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.
- Napsat prompt
- Kontrola
- Použijte
- Ověřte
Vaše obchodní zadání
Příklad Ukázkový prompt tutora
Zobrazit akce ukázky tutora
Zkontrolujte před použitím
Navržené změny buněk, vzorců a grafů
Váš první prompt funguje. Chcete tento postup zachovat?
Zatím patří této relaci prohlížeče. Přihlaste se svým účtem AI Coalition Network, aby vás provázel dál.
Uložit můj postup →Nyní umíte proměnit obchodní zadání v zkontrolovanou tabulku.
Vytvořili jste evidenci prodeje, propojený rozpočet výdajů a regionální graf. Dále se naučíte čištění dat, finanční modely, spolehlivé vyhledávání, nativní kontingenční tabulky a přehledy.
Náhled pozdějšího kurzu →Kapitoly 1–2 jsou zdarma. Plný přístup ke kurzu stojí jednorázově $19 USD a zahrnuje aktuální cvičení, hodnocení a doučování k lekcím. Žádné povinné předplatné. Zobrazit prázdninovou startovací nabídku a dostupnost placení →
Zeptat se na tuto lekci
Pevně daný ukázkový tutor
Sledujte zvýrazněné buňky.
Použít tento sešit v Excelu
Stáhnout pro Excel · Procvičte si práci se souborem Excelu →
Možnosti sešitu a uložená verze
Verze 0
Tyto připravené lekce podporují aritmetiku, závorky a SUM v číselných řádcích dat 2–4. Jiné funkce, externí odkazy a libovolný kód jsou odmítnuty. Nepodporované operace zobrazí viditelnou chybu.