MAJHNI KORAKI. PRAVE VEŠČINE.
Vaša naslednja koristna veščina.
Opišite nalogo. Preglejte predlog. Preverite rezultat v Excelu.
Tri brezplačne lekcije · eno koristno poglavje
Prejšnje preverjanje znanja je ohranjeno. Vaše shranjeno delo je nespremenjeno; nove naloge uporabljajo poziv, pregled, uporabo in preverjanje.
Vaš vodnik po Excelu
Učite se z delom, v svojem tempuVaš prvi poziv v Excelu
Sledite demonstraciji, nato vadite.
| 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 |
Navodila 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 |
Navodila 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 |
Navodila 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 |
Navodila 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 |
Navodila 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 |
Navodila 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.
- Napiši poziv
- Pregled
- Uporabi
- Preveri
Vaša poslovna navodila
Primer Primer poziva mentorja
Preglej dejanja iz mentorjevega primera
Pregled pred uporabo
Predlagane spremembe celic, formul in grafikonov
Vaš prvi poziv deluje. Želite ohraniti ta napredek?
Trenutno pripada tej seji brskalnika. Prijavite se z računom AI Coalition Network, da ga obdržite.
Shrani moj napredek →Zdaj lahko poslovna navodila spremenite v preverjeno preglednico.
Izdelali ste evidenco prodaje, povezan proračun stroškov in regijski grafikon. Nato se naučite čiščenja, finančnih modelov, zanesljivih iskanj, izvirnih vrtilnih tabel in nadzornih plošč.
Predogled poznejšega tečaja →Poglavji 1–2 sta brezplačni. Poln dostop do tečaja stane 19 $ USD enkratno, vključno s trenutnimi vajami, preverjanji znanja in poukom ob lekcijah. Brez obvezne naročnine. Oglejte si praznično uvodno ponudbo in razpoložljivost blagajne →
Vprašajte o tej lekciji
Stalni demonstracijski mentor
Sledite označenim celicam.
Uporabite ta delovni zvezek v Excelu
Zmožnosti delovnega zvezka in shranjena različica
Različica 0
Te pripravljene lekcije podpirajo aritmetiko, oklepaje in SUM znotraj številskih podatkovnih vrstic 2–4. Druge funkcije, zunanje povezave in poljubna koda so zavrnjene. Nepodprte operacije povzročijo vidno napako.