{"id":87014,"date":"2026-02-09T16:17:10","date_gmt":"2026-02-09T16:17:10","guid":{"rendered":"https:\/\/onlineexammaker.com\/kb\/?p=87014"},"modified":"2026-03-27T04:33:31","modified_gmt":"2026-03-27T04:33:31","slug":"how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr","status":"publish","type":"post","link":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/","title":{"rendered":"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<p>Adil de\u011ferlendirmeler olu\u015fturmak, sizi geceleri uyutmayan \u00f6\u011fretme zorluklar\u0131ndan biridir. M\u00fckemmel bir s\u0131nav haz\u0131rlamak i\u00e7in saatler harcars\u0131n\u0131z, yaln\u0131zca \u00f6\u011frencilerin cevaplar\u0131 payla\u015fmas\u0131ndan veya kom\u015fular\u0131n\u0131n ekran\u0131na g\u00f6z atmas\u0131ndan endi\u015fe duyars\u0131n\u0131z. \u0130\u015fin asl\u0131 \u015fu\u2014rastgelele\u015ftirme sadece kopyay\u0131 \u00f6nlemekle ilgili de\u011fildir. Ezber kal\u0131plar\u0131n\u0131 de\u011fil, anlamay\u0131 ger\u00e7ekten test eden benzersiz \u00f6\u011frenme deneyimleri yaratmakla ilgilidir.<\/p>\n<p>Excel, s\u0131nav rastgelele\u015ftirme aray\u0131\u015f\u0131n\u0131zda beklenmedik bir kahraman gibi g\u00f6r\u00fcnebilir, ancak p\u00fcf noktalar\u0131n\u0131 \u00f6\u011frendi\u011finizde \u015fa\u015f\u0131rt\u0131c\u0131 derecede g\u00fc\u00e7l\u00fcd\u00fcr. \u0130ster en son Microsoft 365 s\u00fcr\u00fcm\u00fc ile \u00e7al\u0131\u015f\u0131yor olun, ister hala Excel 2010 kullan\u0131yor olun, sizin i\u00e7in i\u015fe yarayacak bir y\u00f6ntem vard\u0131r.<\/p>\n<div class=\"article_toc\">\u0130\u00e7indekiler<\/div>\n<ul class=\"article_index\">\n<li><a href=\"#a1\">S\u0131nav Sorular\u0131n\u0131 Neden Rastgelele\u015ftirmelisiniz?<\/a><\/li>\n<li><a href=\"#a2\">Y\u00f6ntem 1: SORTBY ve RANDARRAY Kullanmak (Microsoft 365)<\/a><\/li>\n<li><a href=\"#a3\">Y\u00f6ntem 2: RAND ve SORT Kullanmak (T\u00fcm Excel S\u00fcr\u00fcmleri)<\/a><\/li>\n<li><a href=\"#a4\">Modern \u00c7\u00f6z\u00fcm: OnlineExamMaker<\/a><\/li>\n<li><a href=\"#a5\">RANDBETWEEN ve INDEX ile Soru S\u0131ras\u0131n\u0131 Rastgelele\u015ftirme<\/a><\/li>\n<li><a href=\"#a6\">Cevap Se\u00e7eneklerini Rastgelele\u015ftirme<\/a><\/li>\n<li><a href=\"#a7\">Tekrarlardan Ka\u00e7\u0131nma ve Cevap Anahtar\u0131 Y\u00f6netimi<\/a><\/li>\n<li><a href=\"#a8\">S\u0131nav\u0131n\u0131z\u0131 D\u0131\u015fa Aktarmak i\u00e7in Bi\u00e7imlendirme<\/a><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/Randomized-Questions-excel-cover.webp\" alt=\"\" width=\"900\" height=\"600\" class=\"alignnone size-full wp-image-82522\" \/><\/p>\n<h2 id=\"a1\">S\u0131nav Sorular\u0131n\u0131 Neden Rastgelele\u015ftirmelisiniz?<\/h2>\n<p>En son \u00e7oktan se\u00e7meli bir test ald\u0131\u011f\u0131n\u0131z zaman\u0131 d\u00fc\u015f\u00fcn\u00fcn. Kendinizde kal\u0131plar geli\u015ftirdi\u011finizi fark ettiniz mi? &#8220;\u015e\u00fcphede kal\u0131nd\u0131\u011f\u0131nda, C&#8217;yi se\u00e7.&#8221; Hepimiz oradayd\u0131k. \u00d6\u011frenciler statik s\u0131navlar\u0131 oynamakta dikkate de\u011fer bir \u015fekilde iyidir ve bunun nedeni kopya \u00e7ekmeye \u00e7al\u0131\u015fmalar\u0131 de\u011fil\u2014bu sadece kal\u0131plar\u0131 aramak i\u00e7in insan do\u011fas\u0131d\u0131r.<\/p>\n<p>Hem sorular\u0131 hem de cevap se\u00e7eneklerini rastgelele\u015ftirmek, ger\u00e7ek kavray\u0131\u015f\u0131 zorunlu k\u0131lar. Bir \u00f6\u011frenci, &#8220;3. sorunun cevab\u0131 her zaman B&#8217;dir&#8221; diye hat\u0131rlamaya g\u00fcvenemez, \u00e7\u00fcnk\u00fc onun versiyonunda 3. soru tamamen farkl\u0131 olabilir. Art\u0131, birden fazla s\u0131n\u0131f b\u00f6l\u00fcm\u00fc veya tekrar s\u0131navlar\u0131 y\u00f6neten e\u011fitimciler i\u00e7in, rastgelele\u015ftirilmi\u015f s\u0131navlar s\u00fcrekli olarak s\u0131f\u0131rdan yeni de\u011ferlendirmeler yazmad\u0131\u011f\u0131n\u0131z anlam\u0131na gelir.<\/p>\n<h2 id=\"a2\">Y\u00f6ntem 1: SORTBY ve RANDARRAY Kullanmak (Microsoft 365)<\/h2>\n<p>Microsoft 365 kullan\u0131yorsan\u0131z, rastgelele\u015ftirmeyi neredeyse \u00e7ok kolay hale getiren son derece zarif baz\u0131 i\u015flevlere eri\u015fiminiz var. SORTBY i\u015flevi RANDARRAY ile birle\u015fti\u011finde yeni en iyi arkada\u015f\u0131n\u0131zd\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/1-list-of-names.webp\" alt=\"\" width=\"1219\" height=\"739\" class=\"alignnone size-full wp-image-82512\" \/><\/p>\n<h3>Temel Form\u00fcl<\/h3>\n<p>Diyelim ki A2 h\u00fccresinden ba\u015flayan bir soru veya \u00f6\u011fe listeniz var. \u0130\u015fte onlar\u0131 nas\u0131l kar\u0131\u015ft\u0131raca\u011f\u0131n\u0131z:<\/p>\n<p><code>=SORTBY(A2:A15, RANDARRAY(14))<\/code><\/p>\n<p>Burada ne oluyor? SORTBY, listenizi al\u0131r ve RANDARRAY taraf\u0131ndan olu\u015fturulan rastgele say\u0131lara g\u00f6re s\u0131ralar. Basit, de\u011fil mi? RANDARRAY i\u015flevi s\u0131f\u0131r ile bir aras\u0131nda rastgele say\u0131lar olu\u015fturur ve SORTBY bunlar\u0131 s\u0131ralama kriteri olarak kullan\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/2-Demonstrating-the-SORTBY.webp\" alt=\"\" width=\"1160\" height=\"755\" class=\"alignnone size-full wp-image-82513\" \/><\/p>\n<h3>Dinamik Hale Getirme<\/h3>\n<p>&#8220;14&#8221; say\u0131s\u0131n\u0131 sabit kodlaman\u0131n sorunu, listenizin b\u00fcy\u00fcyebilmesidir. \u0130\u015fte daha ak\u0131ll\u0131 versiyonu:<\/p>\n<p><code>=SORTBY(A2:A15, RANDARRAY(ROWS(A2:A15)))<\/code><\/p>\n<p>ROWS i\u015flevi otomatik olarak ka\u00e7 \u00f6\u011feniz oldu\u011funu sayar, b\u00f6ylece soru eklemek veya \u00e7\u0131karmak form\u00fcl\u00fcn\u00fcz\u00fc bozmaz. Bu, ileride sizi ba\u015f a\u011fr\u0131lar\u0131ndan kurtaracak t\u00fcrden gelece\u011fe d\u00f6n\u00fck haz\u0131rl\u0131kt\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/3-ROWS-function.webp\" alt=\"\" width=\"1150\" height=\"761\" class=\"alignnone size-full wp-image-82514\" \/><\/p>\n<p>Bilinmeye de\u011fer bir tuhafl\u0131k: RANDARRAY &#8220;de\u011fi\u015fken&#8221; (volatile) bir i\u015flev oldu\u011fu i\u00e7in, listeniz \u00e7al\u0131\u015fma sayfan\u0131zda herhangi bir \u015fey de\u011fi\u015fti\u011finde yeniden kar\u0131\u015facakt\u0131r. Herhangi bir h\u00fccreye bir \u015fey yaz\u0131n, enter&#8217;a bas\u0131n ve bum\u2014yeni s\u0131ralama. Manuel olarak yeniden kar\u0131\u015ft\u0131rmak m\u0131 istiyorsunuz? Sadece F9&#8217;a bas\u0131n. \u0130stedi\u011finiz d\u00fczeni elde etti\u011finizde, onu yerine kilitlemek i\u00e7in kopyalay\u0131p de\u011fer olarak yap\u0131\u015ft\u0131r\u0131n.<\/p>\n<h2 id=\"a3\">Y\u00f6ntem 2: RAND ve SORT Kullanmak (T\u00fcm Excel S\u00fcr\u00fcmleri)<\/h2>\n<p>Herkesin Microsoft 365&#8217;i yoktur ve bu tamamen normaldir. Bu y\u00f6ntem hemen hemen her Excel s\u00fcr\u00fcm\u00fcnde \u00e7al\u0131\u015f\u0131r, ancak birka\u00e7 daha fazla manuel ad\u0131m gerektirir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/4-RAND-function.webp\" alt=\"\" width=\"1073\" height=\"736\" class=\"alignnone size-full wp-image-82515\" \/><\/p>\n<h3>Yard\u0131mc\u0131 S\u00fctun Yakla\u015f\u0131m\u0131<\/h3>\n<p>Listenizin yan\u0131na bir yard\u0131mc\u0131 s\u00fctun olu\u015fturun ve RAND i\u015flevini kullan\u0131n: <code>=RAND()<\/code><\/p>\n<p>Bu, her sat\u0131r i\u00e7in 0 ile 1 aras\u0131nda rastgele bir ondal\u0131k say\u0131 \u00fcretir. Form\u00fcl\u00fc t\u00fcm \u00f6\u011feleriniz i\u00e7in a\u015fa\u011f\u0131ya kopyalay\u0131n. \u015eimdi manuel k\u0131s\u0131m geliyor: rastgele say\u0131 s\u00fctununuzdaki herhangi bir h\u00fccreyi se\u00e7in, sa\u011f t\u0131klay\u0131n, S\u0131rala&#8217;y\u0131 se\u00e7in ve &#8220;En K\u00fc\u00e7\u00fckten En B\u00fcy\u00fc\u011fe&#8221; veya &#8220;En B\u00fcy\u00fckten En K\u00fc\u00e7\u00fc\u011fe&#8221; se\u00e7eneklerinden birini se\u00e7in. Hangisi oldu\u011fu fark etmez\u2014rastgelelik rastgeleliktir.<\/p>\n<p>Listeniz art\u0131k kar\u0131\u015ft\u0131r\u0131ld\u0131. Yeniden kar\u0131\u015ft\u0131rmak m\u0131 istiyorsunuz? Sadece s\u0131ralama i\u015flemini tekrarlay\u0131n. S\u0131ralamadan memnun oldu\u011funuzda, yard\u0131mc\u0131 s\u00fctunu silebilirsiniz. Bu y\u00f6ntemin g\u00fczelli\u011fi basitli\u011fidir\u2014s\u00fcsl\u00fc i\u015flevler yok, s\u00fcr\u00fcm gereksinimleri yok. Sadece temel Excel, temel Excel i\u015flerini yap\u0131yor.<\/p>\n<h2 id=\"a4\">OnlineExamMaker: AI Destekli \u00dccretsiz Rastgele Soru Olu\u015fturucu <\/h2>\n<p>Bak\u0131n, Excel g\u00fc\u00e7l\u00fcd\u00fcr ama d\u00fcr\u00fcst olal\u0131m\u2014ayn\u0131 zamanda biraz da ge\u00e7ici bir \u00e7\u00f6z\u00fcmd\u00fcr. Asl\u0131nda, tasarlanmad\u0131\u011f\u0131 bir \u015feyi yapmas\u0131 i\u00e7in bir elektronik tablo program\u0131n\u0131 zorluyorsunuz. D\u00fczenli de\u011ferlendirmeler olu\u015fturan \u00f6\u011fretmenler i\u00e7in daha iyi bir yol var.<\/p>\n<p><strong>OnlineExamMaker<\/strong>, sizi bir Excel sihirbaz\u0131 olman\u0131z\u0131 gerektirmeden <a href=\"https:\/\/onlineexammaker.com\/help\/exam-management\/exam-questions\/question-randomization\/\">s\u0131nav rastgelele\u015ftirmesini otomatik olarak<\/a> ele alan, belirli bir ama\u00e7 i\u00e7in olu\u015fturulmu\u015f bir yaz\u0131l\u0131md\u0131r. \u0130\u015fte onu e\u011fitimciler i\u00e7in cazip k\u0131lan \u015feyler:<\/p>\n<div class=\"embed_video_blog\">\n<div class=\"embed-responsive embed-responsive-16by9\" style=\"margin-bottom:16px;\">\n <iframe class=\"embed-responsive-item\" src=\"https:\/\/www.youtube.com\/embed\/bv7AAAyFOo4\"><\/iframe>\n<\/div>\n<\/div>\n<div class=\"getstarted-container\">\n<p style=\"margin-bottom: 13px;\">Bir Sonraki S\u0131nav\u0131n\u0131z\u0131\/Testinizi OnlineExamMaker&#8217;da AI Kullanarak Olu\u015fturun<\/p>\n<div class=\"blog_double_btn clearfix\">\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/sign-up.html?refer=blog_btn\">\u00dccretsiz Ba\u015flay\u0131n<\/a><\/div>\n<div class=\"p-style-b\">SAAS, sonsuza kadar \u00fccretsiz<\/div>\n<\/div>\n<div class=\"col-sm-6  col-xs-12\">\n<div class=\"p-style-a\"><a class=\"get_started_btn\" href=\"https:\/\/onlineexammaker.com\/lan.html?refer=blog_btn\">Kurumsal: \u0130ndir<\/a><\/div>\n<div class=\"p-style-b\">%100 veri m\u00fclkiyeti<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3>AI Destekli Soru Olu\u015fturma<\/h3>\n<p>Platform, \u00f6\u011fretim materyallerinizden s\u0131nav sorular\u0131 olu\u015fturman\u0131za yard\u0131mc\u0131 olmak i\u00e7in yapay zekay\u0131 kullan\u0131r. Ders i\u00e7eri\u011finizi y\u00fckleyin, AI ilgili sorular ve inand\u0131r\u0131c\u0131 yanl\u0131\u015f cevaplar \u00f6nerir. M\u00fckemmel de\u011fil\u2014hala g\u00f6zden ge\u00e7irip d\u00fczenlemeniz gerekecek\u2014ancak s\u0131f\u0131rdan her \u015feyi yazmaya k\u0131yasla \u00e7ok b\u00fcy\u00fck bir zaman tasarrufu sa\u011flar.<\/p>\n<h3>Yerle\u015fik Rastgelele\u015ftirme<\/h3>\n<p>Rastgelele\u015ftirmenin karma\u015f\u0131k form\u00fcller gerektirdi\u011fi Excel&#8217;in aksine, OnlineExamMaker bunu basit onay kutusu se\u00e7enekleriyle halleder. Soru s\u0131ras\u0131n\u0131 rastgelele\u015ftirmek mi istiyorsunuz? Bir kutuyu i\u015faretleyin. Cevap se\u00e7eneklerini kar\u0131\u015ft\u0131rmak m\u0131 istiyorsunuz? Ba\u015fka bir onay kutusu. Farkl\u0131 \u00f6\u011frencilerin daha b\u00fcy\u00fck bir havuzdan farkl\u0131 soru alt k\u00fcmelerini g\u00f6rmesini mi istiyorsunuz? Bu da yerle\u015fiktir.<\/p>\n<h3>Otomatik Puanlama ve Analitik<\/h3>\n<p>\u0130\u015fte ama\u00e7 i\u00e7in \u00f6zel s\u0131nav yaz\u0131l\u0131m\u0131n\u0131n ger\u00e7ekten parlad\u0131\u011f\u0131 yer. Her yan\u0131t otomatik olarak puanlan\u0131r ve hangi sorularda \u00f6\u011frencilerin zorland\u0131\u011f\u0131n\u0131, ortalama tamamlama s\u00fcrelerini ve bireysel performans e\u011filimlerini g\u00f6steren detayl\u0131 analitikler al\u0131rs\u0131n\u0131z. Bu t\u00fcr bir i\u00e7g\u00f6r\u00fc, \u00f6\u011fretiminizi geli\u015ftirmek i\u00e7in alt\u0131n de\u011ferindedir\u2014ve inan\u0131lmaz derecede karma\u015f\u0131k makrolar olu\u015fturmadan Excel&#8217;de bunu yeniden olu\u015fturmak esasen imkans\u0131zd\u0131r.<\/p>\n<h3>Cihaz Deste\u011fi Sunma<\/h3>\n<p>\u00d6\u011frenciler s\u0131navlar\u0131 herhangi bir cihazda\u2014bilgisayarlar, tabletler, telefonlar\u2014alabilir. Aray\u00fcz otomatik olarak ayarlan\u0131r ve Excel s\u00fcr\u00fcm uyumlulu\u011fu veya \u00f6\u011frencilerin dikkatle olu\u015fturdu\u011funuz form\u00fclleri yanl\u0131\u015fl\u0131kla bozmalar\u0131 konusunda endi\u015felenmenize gerek kalmaz. Ayr\u0131ca, zaman s\u0131n\u0131rlar\u0131 koyabilir, geri d\u00f6n\u00fc\u015f\u00fc engelleyebilir ve y\u00fcksek riskli de\u011ferlendirmeler i\u00e7in g\u00f6zetleme \u00f6zelliklerini bile etkinle\u015ftirebilirsiniz.<\/p>\n<p>Sadece ara s\u0131ra s\u0131nav olu\u015fturuyorsan\u0131z, bu a\u015f\u0131r\u0131 m\u0131d\u0131r? Belki. Ancak d\u00fczenli olarak \u00f6\u011frencileri de\u011ferlendiren \u00f6\u011fretmenler i\u00e7in, kurtar\u0131lan zaman ve azalan stres, bunu d\u00fc\u015f\u00fcnmeye de\u011fer k\u0131lar. Excel, rastgelele\u015ftirme mekani\u011fini \u00f6\u011frenmek i\u00e7in m\u00fckemmeldir, ancak belirli bir ama\u00e7 i\u00e7in olu\u015fturulmu\u015f ara\u00e7lar bir nedenle vard\u0131r.<\/p>\n<h2 id=\"a5\">RANDBETWEEN ve INDEX ile Soru S\u0131ras\u0131n\u0131 Rastgelele\u015ftirme<\/h2>\n<p>\u015eimdi ger\u00e7ek s\u0131nav olu\u015fturma alan\u0131na giriyoruz. Diyelim ki 25 \u00f6\u011felik bir soru bankan\u0131z var, ancak her seferinde sadece 5 rastgele soru sunmak istiyorsunuz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/5-Using-RANDBETWEEN.webp\" alt=\"\" width=\"955\" height=\"511\" class=\"alignnone size-full wp-image-82516\" \/><\/p>\n<h3>Rastgele Soru Se\u00e7me<\/h3>\n<p>RANDBETWEEN i\u015flevi, belirtti\u011finiz bir aral\u0131kta rastgele bir tam say\u0131 se\u00e7er:<\/p>\n<p><code>=RANDBETWEEN(1, 25)<\/code><\/p>\n<p>Bu size bankan\u0131zdan hangi soruyu \u00e7ekece\u011finizi temsil eden, 1 ile 25 aras\u0131nda rastgele bir say\u0131 verir. Ama i\u015fin zekice olan k\u0131sm\u0131 \u015fu\u2014bu soruyu ger\u00e7ekten almak i\u00e7in bunu INDEX i\u015fleviyle e\u015fle\u015ftirin:<\/p>\n<p><code>=INDEX($A$2:$A$26, RANDBETWEEN(1, 25))<\/code><\/p>\n<p>Dolar i\u015faretleri, form\u00fcl\u00fcn\u00fcz kopyaland\u0131\u011f\u0131nda kaymamas\u0131 i\u00e7in mutlak referanslar olu\u015fturur. Bu kombinasyon, sorular\u0131n\u0131z\u0131 bankan\u0131zdan manuel olarak se\u00e7meden rastgele \u00e7ekmenize izin verir.<\/p>\n<h3>Tekrarlardan Ka\u00e7\u0131nmak i\u00e7in RANK Kullanma<\/h3>\n<p>Saf rastgelele\u015ftirmenin bir problemi: ayn\u0131 soruyu iki kez alabilirsiniz. \u00c7\u00f6z\u00fcm, RAND() i\u00e7eren bir yard\u0131mc\u0131 s\u00fctun ve RANK i\u00e7eren ba\u015fka bir s\u00fctun i\u00e7erir:<\/p>\n<p><code>=RANK(B2, $B$2:$B$6)<\/code><\/p>\n<p>Bu, rastgele say\u0131lar\u0131n\u0131z\u0131 1&#8217;den istedi\u011finiz soru say\u0131s\u0131na kadar s\u0131ralar, b\u00f6ylece tekrar olmamas\u0131n\u0131 garanti eder. Ard\u0131ndan, sorular\u0131n\u0131z\u0131 benzersiz bir rastgele s\u0131rayla \u00e7ekmek i\u00e7in bu s\u0131ral\u0131 say\u0131larla INDEX&#8217;i kullan\u0131n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/6-Demonstrating-the-RANK.webp\" alt=\"\" width=\"987\" height=\"493\" class=\"alignnone size-full wp-image-82517\" \/><\/p>\n<h2 id=\"a6\">Cevap Se\u00e7eneklerini Rastgelele\u015ftirme<\/h2>\n<p>\u0130\u015fler burada ilgin\u00e7le\u015fiyor. Sorular\u0131 kar\u0131\u015ft\u0131rmak bir \u015fey, ancak her soru i\u00e7in cevap se\u00e7eneklerini rastgelele\u015ftirmek? \u0130\u015fte bu ileri seviye kurs.<\/p>\n<h3>Soru Bankan\u0131z\u0131 Kurma<\/h3>\n<p>Soru bankan\u0131z\u0131 \u015fu s\u00fctunlarla yap\u0131land\u0131r\u0131n: Soru ID, Soru Metni, Do\u011fru Cevap, Se\u00e7enek B, Se\u00e7enek C, Se\u00e7enek D. Anahtar, do\u011fru cevab\u0131 ba\u015flang\u0131\u00e7ta tutarl\u0131 bir konumda tutmakt\u0131r\u2014g\u00f6r\u00fcnt\u00fcy\u00fc daha sonra rastgelele\u015ftireceksiniz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/7-Question-bank-structure.webp\" alt=\"\" width=\"839\" height=\"567\" class=\"alignnone size-full wp-image-82518\" \/><\/p>\n<h3>Rastgelele\u015ftirme S\u00fcreci<\/h3>\n<p>Rastgele say\u0131lar i\u00e7in yard\u0131mc\u0131 s\u00fctunlar (cevap se\u00e7ene\u011fi ba\u015f\u0131na bir tane) ve onlar\u0131 s\u0131ralamak i\u00e7in ba\u015fka bir set olu\u015fturun. Her soru sat\u0131r\u0131 i\u00e7in:<\/p>\n<p>D\u00f6rt s\u00fctunda <code>=RAND()<\/code>, ard\u0131ndan onlar\u0131 1-4 aras\u0131nda s\u0131ralamak i\u00e7in <code>=RANK(L2, $L2:$O2)<\/code>.<\/p>\n<p>P\u00fcf noktas\u0131 kar\u0131\u015f\u0131k referans kullanmakt\u0131r\u2014s\u00fctun harflerini dolar i\u015faretleriyle kilitleyin ama sat\u0131r numaralar\u0131n\u0131n de\u011fi\u015fmesine izin verin. Bu, her sorunun cevaplar\u0131n\u0131n ba\u011f\u0131ms\u0131z olarak kar\u0131\u015fmas\u0131n\u0131 sa\u011flar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/8-mixed-cell-referencing.webp\" alt=\"\" width=\"1201\" height=\"468\" class=\"alignnone size-full wp-image-82519\" \/><\/p>\n<h3>Rastgelele\u015ftirilmi\u015f Se\u00e7enekleri G\u00f6r\u00fcnt\u00fcleme<\/h3>\n<p>Kar\u0131\u015ft\u0131r\u0131lm\u0131\u015f s\u0131rayla cevaplar\u0131 \u00e7ekmek i\u00e7in s\u0131ra numaralar\u0131n\u0131zla INDEX&#8217;i kullan\u0131n:<\/p>\n<p><code>=INDEX($B2:$E2, L2)<\/code><\/p>\n<p>Burada L2, A cevap konumu i\u00e7in s\u0131ran\u0131z\u0131 i\u00e7erir. Bu kurulumun g\u00fczelli\u011fi, her yeniden hesaplad\u0131\u011f\u0131n\u0131zda (F9&#8217;a bast\u0131\u011f\u0131n\u0131zda), hangi cevab\u0131n asl\u0131nda do\u011fru oldu\u011funu korurken tamamen farkl\u0131 bir cevap se\u00e7ene\u011fi d\u00fczenlemesi elde etmenizdir.<\/p>\n<h2 id=\"a7\">Tekrarlardan Ka\u00e7\u0131nma ve Cevap Anahtar\u0131 Y\u00f6netimi<\/h2>\n<p>S\u0131nav rastgelele\u015ftirmesinin en zor k\u0131sm\u0131 kar\u0131\u015ft\u0131rma de\u011fildir\u2014her \u015fey yer de\u011fi\u015ftirdikten sonra neyin do\u011fru oldu\u011funu takip etmektir.<\/p>\n<h3>INDIRECT \u0130\u015flevi Hilesi<\/h3>\n<p>Hem sorular\u0131 hem de cevaplar\u0131 rastgelele\u015ftirdi\u011finizde, do\u011fru cevaba geri e\u015flemek i\u00e7in bir yola ihtiyac\u0131n\u0131z vard\u0131r. INDIRECT i\u015flevi bunu, rastgelele\u015ftirmenize dayal\u0131 olarak h\u00fccrelere dinamik olarak referans vererek \u00e7\u00f6zer:<\/p>\n<p><code>=INDIRECT(\"QuestionBank!H\"&(A2+2))<\/code><\/p>\n<p>Bu, rastgele say\u0131n\u0131z ile cevaplar\u0131n\u0131z\u0131n asl\u0131nda nerede ba\u015flad\u0131\u011f\u0131 aras\u0131ndaki ofseti dikkate alarak, an\u0131nda bir h\u00fccre referans\u0131 olu\u015fturur. Bu, Excel&#8217;e statik bir adres yerine GPS koordinatlar\u0131 vermek gibidir.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/9-INDIRECT-function.webp\" alt=\"\" width=\"1245\" height=\"631\" class=\"alignnone size-full wp-image-82520\" \/><\/p>\n<h3>Cevap Anahtar\u0131n\u0131z\u0131 Olu\u015fturma<\/h3>\n<p>Soru bankan\u0131zda cevap anahtar\u0131 i\u00e7in ayr\u0131 bir s\u00fctun tutun. S\u0131nav g\u00f6r\u00fcnt\u00fcn\u00fcz\u00fc rastgelele\u015ftirdi\u011finizde, her soruyla birlikte do\u011fru cevap g\u00f6stergesini \u00e7ekmek i\u00e7in VLOOKUP veya INDEX\/MATCH kullan\u0131n. Bu \u015fekilde, cevaplar nas\u0131l kar\u0131\u015f\u0131rsa kar\u0131\u015fs\u0131n, hangi konumun do\u011fru olan\u0131 i\u00e7erdi\u011fini her zaman bilirsiniz.<\/p>\n<h2 id=\"a8\">S\u0131nav\u0131n\u0131z\u0131 D\u0131\u015fa Aktarmak i\u00e7in Bi\u00e7imlendirme<\/h2>\n<p>Bu g\u00fczel rastgelele\u015ftirme motorunu olu\u015fturdunuz, ama onu ger\u00e7ekten yazd\u0131r\u0131labilir bir s\u0131nava nas\u0131l d\u00f6n\u00fc\u015ft\u00fcr\u00fcrs\u00fcn\u00fcz?<\/p>\n<h3>CONCATENATE Yakla\u015f\u0131m\u0131<\/h3>\n<p>Soru numaran\u0131z\u0131, soru metninizi ve cevap se\u00e7eneklerinizi birle\u015ftirmek i\u00e7in CONCATENATE&#8217;\u0131 (veya daha basit olan ve i\u015faretini) kullan\u0131n:<\/p>\n<p><code>=A2&\". \"&B2&CHAR(10)&\"A. \"&C2&CHAR(10)&\"B. \"&D2&CHAR(10)&\"C. \"&E2&CHAR(10)&\"D. \"&F2<\/code><\/p>\n<p>CHAR(10) i\u015flevi sat\u0131r sonlar\u0131 ekler. Excel&#8217;de &#8220;Metni Kayd\u0131r&#8221;\u0131 etkinle\u015ftirin, bi\u00e7imlendirilmi\u015f halini g\u00f6r\u00fcn, ard\u0131ndan son bi\u00e7imlendirme i\u00e7in Word&#8217;e kopyalay\u0131n. Bu, yazd\u0131rma veya dijital da\u011f\u0131t\u0131m i\u00e7in haz\u0131r, d\u00fczg\u00fcn bi\u00e7imlendirilmi\u015f s\u0131nav sorular\u0131 olu\u015fturur.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/10-CONCATENATE.webp\" alt=\"\" width=\"988\" height=\"579\" class=\"alignnone size-full wp-image-82521\" \/> <\/p>\n<h3>Ne Zaman Excel&#8217;de Kalmak Gerekir<\/h3>\n<p>Bununla birlikte, Excel&#8217;in hala bir yeri var. Ka\u011f\u0131t tabanl\u0131 s\u0131navlar olu\u015fturuyorsan\u0131z, bi\u00e7imlendirme \u00fczerinde tam kontrole ihtiyac\u0131n\u0131z varsa veya rastgelele\u015ftirmenin perde arkas\u0131nda tam olarak nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak istiyorsan\u0131z, Excel daha iyi bir se\u00e7im olmaya devam ediyor. Ayr\u0131ca, zaten Office&#8217;iniz varsa \u00fccretsizdir, bu da b\u00fct\u00e7eler s\u0131k\u0131 oldu\u011funda \u00f6nemlidir.<\/p>\n<p>Ger\u00e7ek cevap, \u00e7o\u011fu \u00f6\u011fretim arac\u0131nda oldu\u011fu gibi: durumunuz i\u00e7in i\u015fe yarayan\u0131 kullan\u0131n. K\u00fc\u00e7\u00fck \u00f6l\u00e7ekli, ara s\u0131ra s\u0131navlar? Excel iyidir. Birden fazla s\u0131n\u0131f i\u00e7in d\u00fczenli dijital de\u011ferlendirmeler? Ama\u00e7 i\u00e7in \u00f6zel yaz\u0131l\u0131m, kurtar\u0131lan zamanda kendini amorti eder.<\/p>\n<p>Rastgelele\u015ftirilmi\u015f s\u0131navlar olu\u015fturmak g\u00f6z korkutucu olmak zorunda de\u011fildir. \u0130ster Excel&#8217;de form\u00fcller olu\u015fturuyor olun, ister \u00f6zel yaz\u0131l\u0131mda d\u00fc\u011fmelere t\u0131kl\u0131yor olun, ama\u00e7 ayn\u0131d\u0131r: anlamay\u0131 ger\u00e7ekten \u00f6l\u00e7en de\u011ferlendirmeler. Basit ba\u015flay\u0131n, belki sadece soru s\u0131ras\u0131n\u0131 rastgelele\u015ftirerek ve rahat olduk\u00e7a karma\u015f\u0131kl\u0131\u011f\u0131 art\u0131r\u0131n. \u00d6\u011frencileriniz ekstra \u00e7abay\u0131 takdir etmeyebilir, ancak geli\u015fen \u00f6\u011frenme \u00e7\u0131kt\u0131lar\u0131 kendileri i\u00e7in konu\u015facakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adil de\u011ferlendirmeler olu\u015fturmak, sizi geceleri uyutmayan \u00f6\u011fretme zorluklar\u0131ndan biridir. M\u00fckemmel bir s\u0131nav haz\u0131rlamak i\u00e7in saatler harcars\u0131n\u0131z, yaln\u0131zca \u00f6\u011frencilerin cevaplar\u0131 payla\u015fmas\u0131ndan veya kom\u015fular\u0131n\u0131n ekran\u0131na g\u00f6z atmas\u0131ndan endi\u015fe duyars\u0131n\u0131z. \u0130\u015fin asl\u0131 \u015fu\u2014rastgelele\u015ftirme sadece kopyay\u0131 \u00f6nlemekle ilgili de\u011fildir. Ezber kal\u0131plar\u0131n\u0131 de\u011fil, anlamay\u0131 ger\u00e7ekten test eden benzersiz \u00f6\u011frenme deneyimleri yaratmakla ilgilidir. Excel, s\u0131nav rastgelele\u015ftirme aray\u0131\u015f\u0131n\u0131zda beklenmedik bir kahraman gibi [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":82522,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5829],"tags":[],"class_list":["post-87014","post","type-post","status-publish","format-standard","hentry","category-online-quiz-tips-tr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog\" \/>\n<meta property=\"og:description\" content=\"Adil de\u011ferlendirmeler olu\u015fturmak, sizi geceleri uyutmayan \u00f6\u011fretme zorluklar\u0131ndan biridir. M\u00fckemmel bir s\u0131nav haz\u0131rlamak i\u00e7in saatler harcars\u0131n\u0131z, yaln\u0131zca \u00f6\u011frencilerin cevaplar\u0131 payla\u015fmas\u0131ndan veya kom\u015fular\u0131n\u0131n ekran\u0131na g\u00f6z atmas\u0131ndan endi\u015fe duyars\u0131n\u0131z. \u0130\u015fin asl\u0131 \u015fu\u2014rastgelele\u015ftirme sadece kopyay\u0131 \u00f6nlemekle ilgili de\u011fildir. Ezber kal\u0131plar\u0131n\u0131 de\u011fil, anlamay\u0131 ger\u00e7ekten test eden benzersiz \u00f6\u011frenme deneyimleri yaratmakla ilgilidir. Excel, s\u0131nav rastgelele\u015ftirme aray\u0131\u015f\u0131n\u0131zda beklenmedik bir kahraman gibi [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/\" \/>\n<meta property=\"og:site_name\" content=\"OnlineExamMaker Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-09T16:17:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-27T04:33:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/Randomized-Questions-excel-cover.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Willson Black\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Willson Black\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/\",\"name\":\"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog\",\"isPartOf\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\"},\"datePublished\":\"2026-02-09T16:17:10+00:00\",\"dateModified\":\"2026-03-27T04:33:31+00:00\",\"author\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineexammaker.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#website\",\"url\":\"https:\/\/onlineexammaker.com\/kb\/\",\"name\":\"OnlineExamMaker Blog\",\"description\":\"OnlineExamMaker\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b\",\"name\":\"Willson Black\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g\",\"caption\":\"Willson Black\"},\"url\":\"https:\/\/onlineexammaker.com\/kb\/author\/willblog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/","og_locale":"en_US","og_type":"article","og_title":"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog","og_description":"Adil de\u011ferlendirmeler olu\u015fturmak, sizi geceleri uyutmayan \u00f6\u011fretme zorluklar\u0131ndan biridir. M\u00fckemmel bir s\u0131nav haz\u0131rlamak i\u00e7in saatler harcars\u0131n\u0131z, yaln\u0131zca \u00f6\u011frencilerin cevaplar\u0131 payla\u015fmas\u0131ndan veya kom\u015fular\u0131n\u0131n ekran\u0131na g\u00f6z atmas\u0131ndan endi\u015fe duyars\u0131n\u0131z. \u0130\u015fin asl\u0131 \u015fu\u2014rastgelele\u015ftirme sadece kopyay\u0131 \u00f6nlemekle ilgili de\u011fildir. Ezber kal\u0131plar\u0131n\u0131 de\u011fil, anlamay\u0131 ger\u00e7ekten test eden benzersiz \u00f6\u011frenme deneyimleri yaratmakla ilgilidir. Excel, s\u0131nav rastgelele\u015ftirme aray\u0131\u015f\u0131n\u0131zda beklenmedik bir kahraman gibi [&hellip;]","og_url":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/","og_site_name":"OnlineExamMaker Blog","article_published_time":"2026-02-09T16:17:10+00:00","article_modified_time":"2026-03-27T04:33:31+00:00","og_image":[{"width":900,"height":600,"url":"https:\/\/onlineexammaker.com\/kb\/wp-content\/uploads\/2025\/12\/Randomized-Questions-excel-cover.webp","type":"image\/webp"}],"author":"Willson Black","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Willson Black","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/","url":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/","name":"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r? - OnlineExamMaker Blog","isPartOf":{"@id":"https:\/\/onlineexammaker.com\/kb\/#website"},"datePublished":"2026-02-09T16:17:10+00:00","dateModified":"2026-03-27T04:33:31+00:00","author":{"@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b"},"breadcrumb":{"@id":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineexammaker.com\/kb\/tr\/how-to-use-excel-to-make-a-quiz-with-randomized-questions-and-answers-tr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineexammaker.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Excel ile Rastgele Soru ve Cevaplara Sahip Bir S\u0131nav Nas\u0131l Yap\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/onlineexammaker.com\/kb\/#website","url":"https:\/\/onlineexammaker.com\/kb\/","name":"OnlineExamMaker Blog","description":"OnlineExamMaker","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineexammaker.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/395b2b5bfc990b8d494fc7b498db795b","name":"Willson Black","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineexammaker.com\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cdcb7df856a2cdfc9affd6f71823f077?s=96&r=g","caption":"Willson Black"},"url":"https:\/\/onlineexammaker.com\/kb\/author\/willblog\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/87014"}],"collection":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/comments?post=87014"}],"version-history":[{"count":1,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/87014\/revisions"}],"predecessor-version":[{"id":87015,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/posts\/87014\/revisions\/87015"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media\/82522"}],"wp:attachment":[{"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/media?parent=87014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/categories?post=87014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineexammaker.com\/kb\/wp-json\/wp\/v2\/tags?post=87014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}