"MadLib" Neeg Hlau Siv Excel: 9 Kauj Ruam

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:30

Nco ntsoov madlibbing nrog koj cov phooj ywg? Ib tus neeg yuav muab cov npe thiab lus qhia, thiab lwm tus neeg yuav muab kab lus nrog qhov khoob los sau nrog lawv. Qhov kev lom zem tau pom qhov kev sib txuas tsis tau npaj tseg.

Cov lus qhia no yuav qhia koj yuav siv Microsoft Excel li cas los tsim ntau kab lus tsis raug, siv cov lus uas koj muab. Nov yog kab lus uas kuv daim ntawv nthuav tawm tsuas yog tsim rau kuv: "Tus menyuam roj hmab tu siab npau taws rau ntawm tus tub squishy." thiab kuv ceeb heev kom kawm txog nws. Koj daim ntawv teev npe yuav qhia dab tsi rau koj?

Kauj Ruam 1: Muab Cov Lus Qhia Yooj Yim

Pib los ntawm kev qhib daim ntawv dawb hauv Microsoft Excel. Kuv siv Excel 2007, tab sis koj tuaj yeem ua qhov no hauv cov ntawv dhau los ib yam nkaus. Txhua yam zoo ib yam.

Koj tsuas yog yuav tsum txhawj xeeb txog peb thaj chaw ntawm daim ntawv nthuav tawm. 1) Lub cell nquag yuav yog qhov uas feem ntau ntawm kev ntaus ntawv yuav tshwm sim. 2) Koj tuaj yeem pom cov mis los ntawm cov cell nquag hauv cov mis bar. Koj tuaj yeem nyiam ntaus yam nyob ntawd, yog tias koj daim ntawv nthuav dav dhau los. 3) Peb yuav siv ob nplooj ntawv hauv phau ntawv ua haujlwm. Koj tuaj yeem hloov ntawm lawv, los ntawm kev nyem rau ntawm cov tab no. … Pib nrog daim ntawv ua haujlwm Sheet1, ua cov lus ntawm cov lus, raws li qhia. Txhawm rau pib nrog, peb tsuas yog siv cov npe, lus qhia thiab adjectives. Thiab tsuas yog plaub ntawm txhua tus. Tom qab ntawd kuv yuav qhia koj li cas ntxiv.

Kauj Ruam 2: Npaj Chaw Ua Haujlwm rau Xeem

Muaj ob peb tus qauv uas peb yuav tau sau, yog li mus rau nplooj ntawv 2 los ntawm nyem rau ntawm nplooj ntawv 2 nyob rau hauv qab ntawm lub qhov rais. 1) Kab B tau sau npe tias Adjective, Column C yog Noun thiab Kab D yog Verb.2) Kab 2 yuav raug suav. Sau nws '#'. 3) Kab 2 thiab 3 yuav yog cov lus tsis raug. Sau lawv tam sim no ib yam nkaus.… Peb thawj tus lej yuav rov qab cov lej ntawm kab lus tshwj xeeb. 1) Hauv xov tooj B3 (kab B, kab 3), ntaus cov mis no kom raug (luam-thiab-muab los ntawm nplooj ntawv no, yog tias ua tau) = COUNTA (Sheet1! A: A) -1 Qhov no qhia rau Excel, "mus rau 'sheet1' thiab suav tag nrho cov xov tooj uas tsis nyob hauv kab A. Tshem tawm ib qho los ntawm qhov ntawd" (rau daim ntawv lo hauv thawj kab.) 2) Luam cov mis no thiab muab tso rau hauv C3. Hloov A: Ib feem rau B: B3) Luam rau D3 thiab hloov A: A rau C: C.

Kauj Ruam 3: Xaiv Lo Lus Random Los Ntawm Cov Npe

Nws yog lub sijhawm los xaiv peb thawj lo lus tsis sib xws. 1) Hauv cell B3, nkag mus rau tus lej no EXACTLY = NTXIV (ADDRESS (INT (RAND ()*Sheet2! $ B $ 2) +2, 1, 1, TRUE, "sheet1")) 2) Muab cov mis no tso rau hauv B4, raws li zoo … Yog tias koj txaus siab (thiab nws tsis tsim nyog koj yog), muaj plaub txoj haujlwm hu hauv kab no. Lawv tau ua zes ua ke kom sab hauv ua tiav thawj zaug. 1) RAND () tsim tus lej tsis sib xws ntawm 0 thiab 1. Tus lej ntawd tau sib npaug ntau zaus cov lus hauv cov npe. Piv txwv, yog tus lej tsis yog.314159 thiab tus lej ntawm lo lus yog 10, tom qab ntawv tus lej yuav rov qab 3.14159.2) INT txiav tawm ib feem ntawm ib feem. Hauv qhov no, 3.14159 yuav dhau los yooj yim 3.3) ADDRESS tsim cov xov tooj ntawm tes. Thawj qhov ntsuas yog kab thiab qhov ntsuas thib ob yog kab. Ntawm no, kab yuav yog 3 (los ntawm tus lej tsis raug), thiab kab ntawv yuav yog thawj kab: kab A. Peb kuj thov kom qhov no yog qhov chaw nyob hauv 'sheet1'.4. kauj ruam 3 thiab pom lo lus nyob ntawd. Yog, nws yog qhov nyuaj. Kuv tsis yog zaum ib hnub thiab hlua txhua cov qauv no ua ke. Kuv kawm txhua tus ntawm lawv ib leeg nyob ntev, los daws teeb meem sib txawv heev. Nws yog ib pliag ua ntej kuv paub tias kuv tuaj yeem siv lawv ua ke hauv txoj kev lom zem. Vim tias kuv muaj lub paj hlwb txawv. Cia peb txav mus ntxiv.

Kauj Ruam 4: Rov Ua Dua Lwm Yam Lus

Tam sim no peb tau ua tiav kev tsim cov npe tsis raug, peb tuaj yeem ua tib tus qauv rau Nouns thiab Verbs

1) Luam cov mis los ntawm B3 rau C3 2) Hloov $ B $ 2 rau $ C $ 2 3) Hloov 1 mus rau 2 4) Luam C3 rau C4… 1) Luam cov mis los ntawm C3 rau D3 2) Hloov $ C $ 2 rau $ D $ 2 3) Hloov 2 txog 3 4) Luam D3 rau D4 Tam sim no koj yuav tsum muaj lub rooj nrog cov pawg ntawm cov lus tsis raug ntawm nws. (Koj puas tau pom tias cov lus hloov pauv txhua lub sijhawm koj hloov pauv lwm yam ntawm daim ntawv nthuav qhia? Qhov ntawd yog qhov txias ntawm RAND ua haujlwm. Nws hloov tshiab thaum twg los xij hauv daim ntawv teev npe raug hloov pauv.:-)

Kauj Ruam 5: Tsim Kab Lus

Tam sim no peb xav sau cov lus no ua ke hauv kab lus. Ntaus cov mis no kom raug, hauv cell A7: = "The" & B3 & "" & C3 & "" & D3 & "the" & B4 & "" & C4Thaum koj ntaus rov qab koj yuav pom koj thawj kab lus random! Xav tau lwm tus? Ntaus 'CTRL+='. (Qhov ntawd yog CTRL qhov tseem ceeb, ntxiv rau '=', tib lub sijhawm.) Mus txuas ntxiv! Qhov kev sib tw yeej tsis tso tseg. Nws ua haujlwm li cas? Excel sib xyaw ua ke txhua yam hauv kab ntawd. Lo lus "Tus" raug tsoo rau lo lus tsis sib xws hauv cell B3, uas tau tsoo rau hauv qhov chaw ("") thiab nyob rau hauv cell C3, thiab lwm yam.

Kauj Ruam 6: Zoo Tshaj Plaws

Thaum koj qhia qhov no rau koj cov phooj ywg, tej zaum koj yuav xav zais txhua qhov kev suav thiab cov qauv.

Koj tuaj yeem nkaum cov kab ntawd, los ntawm 1) nyem kab ntawv kab thiab rub kom xaiv ob peb kab 2) right-click ntawm kab kom tau txais cov ntawv qhia zaub mov 3) xaiv Nkaum los ntawm cov ntawv qhia zaub mov … Tsev toolbar. Kuv tau poob ntau teev ntawm kuv lub neej, nqes los ntawm cov npe tsis muaj qhov kawg ntawm cov ntawv uas tuaj nrog Microsoft Office. Hauv qhov piv txwv no, kuv xaiv 'Jokerman'. Koj kuj tseem xav ntxiv qee cov lus qhia, kom koj cov phooj ywg paub yuav ua dab tsi.

Kauj Ruam 7: Ntau Ntxiv, Ntau Ntxiv

Ntau qhov kev tshwm sim tshwm sim los ntawm cov npe cov lus ntev dua.

Ntxiv ntau lo lus raws li koj tuaj yeem xav txog. Nug koj cov phooj ywg rau cov lus. Ntxiv lawv rau cov npe hauv daim ntawv 1. …

Kauj Ruam 8: Cov Lus Zoo Tshaj Plaws

Cov neeg sau ntawv zoo paub tias, thaum cov kab lus luv tau txais koj mloog, kab lus ntev nrog ntau tus neeg hloov kho, tsim kev xav. Koj tuaj yeem ntxiv ntau hom lus thiab hloov cov qauv kom tau txais cov kab lus piav qhia ntau ntxiv thiab ua phem ua ntej. Hauv qhov ua piv txwv no, Kuv yuav ntxiv qee qhov adverbs rau kuv kab lus. … SECOND, tseem ntxiv lwm kab ntawv rau daim ntawv 2 (koj yuav tsum tau 'zais' cov kab no, yog tias koj nkaum lawv hauv cov kauj ruam dhau los. Txoj cai Nyem qhov twg kab yuav tsum tau txais cov ntawv qhia zaub mov popup. Xaiv Unhide.) Luam cov qauv los ntawm cov kab yav dhau los, thiab kho raws li ua ntej. Yog li, E3 yuav tsum yog: = COUNTA (Sheet1! D: D) -1E4 thiab E5 yuav tsum yog: = NTSEEG (ADDRESS (INT (RAND ()*Sheet2! $ E $ 2)) +2, 4, 1, TRUE, "sheet1")) … Thaum kawg, ntxiv lo lus tshiab rau koj kab lus. Kuv muab kuv cov lus Adverb tshiab tso rau ntawm Verb, raws li qhov tsim nyog. = "The" & B3 & "" & C3 & "" & E3 & "" & D3 & "the" & B4 & "" & C4Ceev faj koom nrog txhua yam nrog ampersands (&). Kuj xyuas kom tseeb tias muaj qhov chaw ("") ntawm cov lus.

Kauj ruam 9: Cheat

Nov yog qee cov tswv yim ntxiv. Vim li cas ho tsis hloov daim ntawv nthuav tawm los tsim:

• tabloid cov ntawv xov xwm, zoo li 'Jennifer Aniston thiab Bigfoot Tshaj Tawm Cov phiaj xwm yuav poj niam!'
• TV TV tshiab, zoo li 'bionic aub lub sijhawm-taug kev mus rau cov kob paub tsis meej ntawm supermodels'
• kev zam txim, zoo li 'Kuv tus dev mus sij hawm bionic tau noj kuv cov ntawv ua tom tsev.'
• paj huam zoo nkauj, zoo li 'Kuv hlub koj ntau dua li cov kob paub tsis meej ntawm supermodels'

:-) Qhov kawg Thiab tam sim no, raws li khoom plig rau koj qhov kev saib xyuas txuas ntxiv, thov nrhiav kuv daim ntawv kawg madlib txuas nrog. Tag nrho cov qauv yog TYPED IN, tab sis nws yuav tsum tau npaj ua ntej. Please ntxiv cov lus yog tias koj tsis meej pem txog ib qib twg. Kuv yuav piav qhia nws lossis kho cov kauj ruam.