{"id":4957,"date":"2026-01-05T10:15:38","date_gmt":"2026-01-05T10:15:38","guid":{"rendered":"https:\/\/murreeroad.org\/?p=4957"},"modified":"2026-01-05T10:15:38","modified_gmt":"2026-01-05T10:15:38","slug":"microsoft-excel-mcqs-with-answers-100-multiple-choice-questions","status":"publish","type":"post","link":"https:\/\/learn-nest.murreeroad.org\/blog\/microsoft-excel-mcqs-with-answers-100-multiple-choice-questions\/","title":{"rendered":"Microsoft Excel MCQs with Answers | 100 Multiple Choice Questions"},"content":{"rendered":"<p data-start=\"283\" data-end=\"465\">Practice <strong data-start=\"292\" data-end=\"333\">100 Microsoft Excel MCQs with answers<\/strong> covering formulas, functions, charts, cell references, shortcuts, and data analysis tools. Ideal for students and exam preparation.<\/p>\n<p data-start=\"283\" data-end=\"465\"><strong data-start=\"0\" data-end=\"19\" data-is-only-node=\"\">Microsoft Excel<\/strong> is one of the most powerful and widely used spreadsheet applications for organizing, calculating, and analyzing data. This carefully designed set of <strong data-start=\"169\" data-end=\"210\">100 Microsoft Excel <a href=\"https:\/\/studentnotes.murreeroad.org\/\" target=\"_blank\" rel=\"noopener\">MCQs<\/a> with answers<\/strong> covers essential topics such as Excel basics, formulas and functions, cell references, charts, data sorting and filtering, pivot tables, and shortcut keys. Created for <strong data-start=\"379\" data-end=\"456\">students, beginners, office professionals, and competitive exam aspirants<\/strong>, these multiple choice questions are ideal for <strong data-start=\"504\" data-end=\"562\"><a href=\"https:\/\/studentnotes.murreeroad.org\/\">exam preparation, skill<\/a> assessment, and quick revision<\/strong>, helping learners strengthen their practical knowledge and confidence in using Microsoft Excel effectively.<\/p>\n<p data-start=\"0\" data-end=\"210\">Here are <strong data-start=\"9\" data-end=\"40\">100 MCQs on Microsoft Excel<\/strong>, written in <strong data-start=\"53\" data-end=\"70\">clear <a href=\"https:\/\/studentnotes.murreeroad.org\/english\/\" target=\"_blank\" rel=\"noopener\">English<\/a><\/strong>, suitable for <strong data-start=\"85\" data-end=\"145\">students, beginners, office users, and competitive exams<\/strong>. Each question includes <strong data-start=\"170\" data-end=\"209\">four options and the correct answer<\/strong>.<\/p>\n<hr data-start=\"212\" data-end=\"215\" \/>\n<h2 data-start=\"217\" data-end=\"263\"><strong data-start=\"220\" data-end=\"263\">Microsoft Excel \u2013 100 MCQs with Answers<\/strong><\/h2>\n<h3 data-start=\"265\" data-end=\"305\"><strong data-start=\"269\" data-end=\"305\">Basics of Microsoft Excel (1\u201320)<\/strong><\/h3>\n<ol data-start=\"307\" data-end=\"2529\">\n<li data-start=\"307\" data-end=\"451\">\n<p data-start=\"310\" data-end=\"451\">Microsoft Excel is a:<br \/>\nA. Word processing software<br data-start=\"359\" data-end=\"362\" \/>B. Spreadsheet software<br data-start=\"385\" data-end=\"388\" \/>C. Presentation software<br data-start=\"412\" data-end=\"415\" \/>D. Database software<br data-start=\"435\" data-end=\"438\" \/><strong data-start=\"438\" data-end=\"449\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"453\" data-end=\"549\">\n<p data-start=\"456\" data-end=\"549\">Microsoft Excel is developed by:<br \/>\nA. Apple<br data-start=\"497\" data-end=\"500\" \/>B. Google<br data-start=\"509\" data-end=\"512\" \/>C. Microsoft<br data-start=\"524\" data-end=\"527\" \/>D. IBM<br data-start=\"533\" data-end=\"536\" \/><strong data-start=\"536\" data-end=\"547\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"551\" data-end=\"664\">\n<p data-start=\"554\" data-end=\"664\">The default file extension of Excel 2016 and later is:<br \/>\nA. .xls<br data-start=\"616\" data-end=\"619\" \/>B. .xlsx<br data-start=\"627\" data-end=\"630\" \/>C. .csv<br data-start=\"637\" data-end=\"640\" \/>D. .docx<br data-start=\"648\" data-end=\"651\" \/><strong data-start=\"651\" data-end=\"662\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"666\" data-end=\"800\">\n<p data-start=\"669\" data-end=\"800\">Excel is mainly used for:<br \/>\nA. Drawing<br data-start=\"705\" data-end=\"708\" \/>B. Calculations and data analysis<br data-start=\"741\" data-end=\"744\" \/>C. Typing letters<br data-start=\"761\" data-end=\"764\" \/>D. Designing posters<br data-start=\"784\" data-end=\"787\" \/><strong data-start=\"787\" data-end=\"798\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"802\" data-end=\"904\">\n<p data-start=\"805\" data-end=\"904\">A spreadsheet is made up of:<br \/>\nA. Slides<br data-start=\"843\" data-end=\"846\" \/>B. Pages<br data-start=\"854\" data-end=\"857\" \/>C. Rows and columns<br data-start=\"876\" data-end=\"879\" \/>D. Charts<br data-start=\"888\" data-end=\"891\" \/><strong data-start=\"891\" data-end=\"902\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"906\" data-end=\"1013\">\n<p data-start=\"909\" data-end=\"1013\">The intersection of a row and column is called a:<br \/>\nA. Box<br data-start=\"965\" data-end=\"968\" \/>B. Field<br data-start=\"976\" data-end=\"979\" \/>C. Cell<br data-start=\"986\" data-end=\"989\" \/>D. Table<br data-start=\"997\" data-end=\"1000\" \/><strong data-start=\"1000\" data-end=\"1011\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"1015\" data-end=\"1115\">\n<p data-start=\"1018\" data-end=\"1115\">Each cell in Excel has a unique:<br \/>\nA. Number<br data-start=\"1060\" data-end=\"1063\" \/>B. Name<br data-start=\"1070\" data-end=\"1073\" \/>C. Cell address<br data-start=\"1088\" data-end=\"1091\" \/>D. Value<br data-start=\"1099\" data-end=\"1102\" \/><strong data-start=\"1102\" data-end=\"1113\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"1117\" data-end=\"1213\">\n<p data-start=\"1120\" data-end=\"1213\">Which of the following is a valid cell address?<br \/>\nA. 1A<br data-start=\"1173\" data-end=\"1176\" \/>B. AA<br data-start=\"1181\" data-end=\"1184\" \/>C. A1<br data-start=\"1189\" data-end=\"1192\" \/>D. 11<br data-start=\"1197\" data-end=\"1200\" \/><strong data-start=\"1200\" data-end=\"1211\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"1215\" data-end=\"1315\">\n<p data-start=\"1218\" data-end=\"1315\">Rows in Excel are identified by:<br \/>\nA. Letters<br data-start=\"1261\" data-end=\"1264\" \/>B. Numbers<br data-start=\"1274\" data-end=\"1277\" \/>C. Symbols<br data-start=\"1287\" data-end=\"1290\" \/>D. Colors<br data-start=\"1299\" data-end=\"1302\" \/><strong data-start=\"1302\" data-end=\"1313\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"1317\" data-end=\"1421\">\n<p data-start=\"1321\" data-end=\"1421\">Columns in Excel are identified by:<br \/>\nA. Numbers<br data-start=\"1367\" data-end=\"1370\" \/>B. Symbols<br data-start=\"1380\" data-end=\"1383\" \/>C. Letters<br data-start=\"1393\" data-end=\"1396\" \/>D. Colors<br data-start=\"1405\" data-end=\"1408\" \/><strong data-start=\"1408\" data-end=\"1419\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"1423\" data-end=\"1537\">\n<p data-start=\"1427\" data-end=\"1537\">A worksheet is:<br \/>\nA. A complete Excel file<br data-start=\"1467\" data-end=\"1470\" \/>B. A single spreadsheet<br data-start=\"1493\" data-end=\"1496\" \/>C. A chart<br data-start=\"1506\" data-end=\"1509\" \/>D. A formula<br data-start=\"1521\" data-end=\"1524\" \/><strong data-start=\"1524\" data-end=\"1535\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"1539\" data-end=\"1645\">\n<p data-start=\"1543\" data-end=\"1645\">A workbook is:<br \/>\nA. One worksheet<br data-start=\"1574\" data-end=\"1577\" \/>B. Collection of worksheets<br data-start=\"1604\" data-end=\"1607\" \/>C. A chart<br data-start=\"1617\" data-end=\"1620\" \/>D. A cell<br data-start=\"1629\" data-end=\"1632\" \/><strong data-start=\"1632\" data-end=\"1643\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"1647\" data-end=\"1783\">\n<p data-start=\"1651\" data-end=\"1783\">By default, a new workbook contains:<br \/>\nA. One worksheet<br data-start=\"1704\" data-end=\"1707\" \/>B. Two worksheets<br data-start=\"1724\" data-end=\"1727\" \/>C. Three worksheets<br data-start=\"1746\" data-end=\"1749\" \/>D. Four worksheets<br data-start=\"1767\" data-end=\"1770\" \/><strong data-start=\"1770\" data-end=\"1781\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"1785\" data-end=\"1869\">\n<p data-start=\"1789\" data-end=\"1869\">Which key is used to edit a cell?<br \/>\nA. F1<br data-start=\"1828\" data-end=\"1831\" \/>B. F2<br data-start=\"1836\" data-end=\"1839\" \/>C. F5<br data-start=\"1844\" data-end=\"1847\" \/>D. F10<br data-start=\"1853\" data-end=\"1856\" \/><strong data-start=\"1856\" data-end=\"1867\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"1871\" data-end=\"1987\">\n<p data-start=\"1875\" data-end=\"1987\">Which shortcut key creates a new workbook?<br \/>\nA. Ctrl + S<br data-start=\"1929\" data-end=\"1932\" \/>B. Ctrl + O<br data-start=\"1943\" data-end=\"1946\" \/>C. Ctrl + N<br data-start=\"1957\" data-end=\"1960\" \/>D. Ctrl + P<br data-start=\"1971\" data-end=\"1974\" \/><strong data-start=\"1974\" data-end=\"1985\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"1989\" data-end=\"2099\">\n<p data-start=\"1993\" data-end=\"2099\">Which shortcut key saves a workbook?<br \/>\nA. Ctrl + A<br data-start=\"2041\" data-end=\"2044\" \/>B. Ctrl + S<br data-start=\"2055\" data-end=\"2058\" \/>C. Ctrl + C<br data-start=\"2069\" data-end=\"2072\" \/>D. Ctrl + V<br data-start=\"2083\" data-end=\"2086\" \/><strong data-start=\"2086\" data-end=\"2097\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"2101\" data-end=\"2187\">\n<p data-start=\"2105\" data-end=\"2187\">Which symbol is used to start a formula?<br \/>\nA. +<br data-start=\"2150\" data-end=\"2153\" \/>B. =<br data-start=\"2157\" data-end=\"2160\" \/>C. *<br data-start=\"2164\" data-end=\"2167\" \/>D. %<br data-start=\"2171\" data-end=\"2174\" \/><strong data-start=\"2174\" data-end=\"2185\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"2189\" data-end=\"2309\">\n<p data-start=\"2193\" data-end=\"2309\">Which option is used to open an existing file?<br \/>\nA. Ctrl + N<br data-start=\"2251\" data-end=\"2254\" \/>B. Ctrl + O<br data-start=\"2265\" data-end=\"2268\" \/>C. Ctrl + P<br data-start=\"2279\" data-end=\"2282\" \/>D. Ctrl + F<br data-start=\"2293\" data-end=\"2296\" \/><strong data-start=\"2296\" data-end=\"2307\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"2311\" data-end=\"2412\">\n<p data-start=\"2315\" data-end=\"2412\">Excel files are also called:<br \/>\nA. Documents<br data-start=\"2356\" data-end=\"2359\" \/>B. Workbooks<br data-start=\"2371\" data-end=\"2374\" \/>C. Slides<br data-start=\"2383\" data-end=\"2386\" \/>D. Records<br data-start=\"2396\" data-end=\"2399\" \/><strong data-start=\"2399\" data-end=\"2410\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"2414\" data-end=\"2529\">\n<p data-start=\"2418\" data-end=\"2529\">Which key deletes the contents of a selected cell?<br \/>\nA. Backspace<br data-start=\"2481\" data-end=\"2484\" \/>B. Delete<br data-start=\"2493\" data-end=\"2496\" \/>C. Esc<br data-start=\"2502\" data-end=\"2505\" \/>D. Enter<br data-start=\"2513\" data-end=\"2516\" \/><strong data-start=\"2516\" data-end=\"2527\">Answer:<\/strong> B<\/p>\n<\/li>\n<\/ol>\n<hr data-start=\"2531\" data-end=\"2534\" \/>\n<h3 data-start=\"2536\" data-end=\"2572\"><strong data-start=\"2540\" data-end=\"2572\">Formulas &amp; Functions (21\u201350)<\/strong><\/h3>\n<ol start=\"21\" data-start=\"2574\" data-end=\"4764\">\n<li data-start=\"2574\" data-end=\"2658\">\n<p data-start=\"2578\" data-end=\"2658\">A formula in Excel always begins with:<br \/>\nA. +<br data-start=\"2621\" data-end=\"2624\" \/>B. #<br data-start=\"2628\" data-end=\"2631\" \/>C. =<br data-start=\"2635\" data-end=\"2638\" \/>D. @<br data-start=\"2642\" data-end=\"2645\" \/><strong data-start=\"2645\" data-end=\"2656\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"2660\" data-end=\"2762\">\n<p data-start=\"2664\" data-end=\"2762\">Which function is used to add values?<br \/>\nA. ADD()<br data-start=\"2710\" data-end=\"2713\" \/>B. SUM()<br data-start=\"2721\" data-end=\"2724\" \/>C. TOTAL()<br data-start=\"2734\" data-end=\"2737\" \/>D. PLUS()<br data-start=\"2746\" data-end=\"2749\" \/><strong data-start=\"2749\" data-end=\"2760\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"2764\" data-end=\"2865\">\n<p data-start=\"2768\" data-end=\"2865\">Which function calculates average?<br \/>\nA. MEAN()<br data-start=\"2812\" data-end=\"2815\" \/>B. AVG()<br data-start=\"2823\" data-end=\"2826\" \/>C. AVERAGE()<br data-start=\"2838\" data-end=\"2841\" \/>D. MID()<br data-start=\"2849\" data-end=\"2852\" \/><strong data-start=\"2852\" data-end=\"2863\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"2867\" data-end=\"2977\">\n<p data-start=\"2871\" data-end=\"2977\">Which function counts numeric values?<br \/>\nA. COUNT()<br data-start=\"2919\" data-end=\"2922\" \/>B. COUNTA()<br data-start=\"2933\" data-end=\"2936\" \/>C. COUNTIF()<br data-start=\"2948\" data-end=\"2951\" \/>D. TOTAL()<br data-start=\"2961\" data-end=\"2964\" \/><strong data-start=\"2964\" data-end=\"2975\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"2979\" data-end=\"3098\">\n<p data-start=\"2983\" data-end=\"3098\">COUNTA() is used to count:<br \/>\nA. Numbers only<br data-start=\"3025\" data-end=\"3028\" \/>B. Empty cells<br data-start=\"3042\" data-end=\"3045\" \/>C. Non-empty cells<br data-start=\"3063\" data-end=\"3066\" \/>D. Formulas only<br data-start=\"3082\" data-end=\"3085\" \/><strong data-start=\"3085\" data-end=\"3096\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"3100\" data-end=\"3203\">\n<p data-start=\"3104\" data-end=\"3203\">Which function finds the largest value?<br \/>\nA. LARGE()<br data-start=\"3154\" data-end=\"3157\" \/>B. MAX()<br data-start=\"3165\" data-end=\"3168\" \/>C. BIG()<br data-start=\"3176\" data-end=\"3179\" \/>D. TOP()<br data-start=\"3187\" data-end=\"3190\" \/><strong data-start=\"3190\" data-end=\"3201\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"3205\" data-end=\"3310\">\n<p data-start=\"3209\" data-end=\"3310\">Which function finds the smallest value?<br \/>\nA. SMALL()<br data-start=\"3260\" data-end=\"3263\" \/>B. MIN()<br data-start=\"3271\" data-end=\"3274\" \/>C. LOW()<br data-start=\"3282\" data-end=\"3285\" \/>D. LESS()<br data-start=\"3294\" data-end=\"3297\" \/><strong data-start=\"3297\" data-end=\"3308\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"3312\" data-end=\"3409\">\n<p data-start=\"3316\" data-end=\"3409\">Which function rounds a number?<br \/>\nA. ROUND()<br data-start=\"3358\" data-end=\"3361\" \/>B. FIX()<br data-start=\"3369\" data-end=\"3372\" \/>C. INT()<br data-start=\"3380\" data-end=\"3383\" \/>D. VALUE()<br data-start=\"3393\" data-end=\"3396\" \/><strong data-start=\"3396\" data-end=\"3407\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"3411\" data-end=\"3513\">\n<p data-start=\"3415\" data-end=\"3513\">Which function returns current date?<br \/>\nA. DATE()<br data-start=\"3461\" data-end=\"3464\" \/>B. NOW()<br data-start=\"3472\" data-end=\"3475\" \/>C. TODAY()<br data-start=\"3485\" data-end=\"3488\" \/>D. TIME()<br data-start=\"3497\" data-end=\"3500\" \/><strong data-start=\"3500\" data-end=\"3511\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"3515\" data-end=\"3627\">\n<p data-start=\"3519\" data-end=\"3627\">Which function returns current date and time?<br \/>\nA. TODAY()<br data-start=\"3575\" data-end=\"3578\" \/>B. DATE()<br data-start=\"3587\" data-end=\"3590\" \/>C. NOW()<br data-start=\"3598\" data-end=\"3601\" \/>D. CLOCK()<br data-start=\"3611\" data-end=\"3614\" \/><strong data-start=\"3614\" data-end=\"3625\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"3629\" data-end=\"3741\">\n<p data-start=\"3633\" data-end=\"3741\">Which function is used to combine text?<br \/>\nA. JOIN()<br data-start=\"3682\" data-end=\"3685\" \/>B. CONCAT()<br data-start=\"3696\" data-end=\"3699\" \/>C. MERGE()<br data-start=\"3709\" data-end=\"3712\" \/>D. TEXTJOIN()<br data-start=\"3725\" data-end=\"3728\" \/><strong data-start=\"3728\" data-end=\"3739\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"3743\" data-end=\"3854\">\n<p data-start=\"3747\" data-end=\"3854\">IF function is used for:<br \/>\nA. Calculations<br data-start=\"3787\" data-end=\"3790\" \/>B. Logical testing<br data-start=\"3808\" data-end=\"3811\" \/>C. Formatting<br data-start=\"3824\" data-end=\"3827\" \/>D. Printing<br data-start=\"3838\" data-end=\"3841\" \/><strong data-start=\"3841\" data-end=\"3852\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"3856\" data-end=\"3968\">\n<p data-start=\"3860\" data-end=\"3968\">Which function counts based on condition?<br \/>\nA. COUNT()<br data-start=\"3912\" data-end=\"3915\" \/>B. COUNTA()<br data-start=\"3926\" data-end=\"3929\" \/>C. COUNTIF()<br data-start=\"3941\" data-end=\"3944\" \/>D. SUM()<br data-start=\"3952\" data-end=\"3955\" \/><strong data-start=\"3955\" data-end=\"3966\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"3970\" data-end=\"4089\">\n<p data-start=\"3974\" data-end=\"4089\">SUMIF() is used to:<br \/>\nA. Count values<br data-start=\"4009\" data-end=\"4012\" \/>B. Add values with condition<br data-start=\"4040\" data-end=\"4043\" \/>C. Find average<br data-start=\"4058\" data-end=\"4061\" \/>D. Sort data<br data-start=\"4073\" data-end=\"4076\" \/><strong data-start=\"4076\" data-end=\"4087\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"4091\" data-end=\"4181\">\n<p data-start=\"4095\" data-end=\"4181\">Which symbol is used for absolute reference?<br \/>\nA. &amp;<br data-start=\"4144\" data-end=\"4147\" \/>B. #<br data-start=\"4151\" data-end=\"4154\" \/>C. $<br data-start=\"4158\" data-end=\"4161\" \/>D. %<br data-start=\"4165\" data-end=\"4168\" \/><strong data-start=\"4168\" data-end=\"4179\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"4183\" data-end=\"4302\">\n<p data-start=\"4187\" data-end=\"4302\">$A$1 represents:<br \/>\nA. Relative reference<br data-start=\"4225\" data-end=\"4228\" \/>B. Mixed reference<br data-start=\"4246\" data-end=\"4249\" \/>C. Absolute reference<br data-start=\"4270\" data-end=\"4273\" \/>D. Cell value<br data-start=\"4286\" data-end=\"4289\" \/><strong data-start=\"4289\" data-end=\"4300\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"4304\" data-end=\"4434\">\n<p data-start=\"4308\" data-end=\"4434\">A1 is an example of:<br \/>\nA. Absolute reference<br data-start=\"4350\" data-end=\"4353\" \/>B. Relative reference<br data-start=\"4374\" data-end=\"4377\" \/>C. Mixed reference<br data-start=\"4395\" data-end=\"4398\" \/>D. Invalid reference<br data-start=\"4418\" data-end=\"4421\" \/><strong data-start=\"4421\" data-end=\"4432\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"4436\" data-end=\"4544\">\n<p data-start=\"4440\" data-end=\"4544\">Which error occurs when dividing by zero?<br \/>\nA. #VALUE!<br data-start=\"4492\" data-end=\"4495\" \/>B. #REF!<br data-start=\"4503\" data-end=\"4506\" \/>C. #DIV\/0!<br data-start=\"4516\" data-end=\"4519\" \/>D. #NAME?<br data-start=\"4528\" data-end=\"4531\" \/><strong data-start=\"4531\" data-end=\"4542\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"4546\" data-end=\"4650\">\n<p data-start=\"4550\" data-end=\"4650\">Which function returns length of text?<br \/>\nA. SIZE()<br data-start=\"4598\" data-end=\"4601\" \/>B. LEN()<br data-start=\"4609\" data-end=\"4612\" \/>C. COUNT()<br data-start=\"4622\" data-end=\"4625\" \/>D. TEXT()<br data-start=\"4634\" data-end=\"4637\" \/><strong data-start=\"4637\" data-end=\"4648\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"4652\" data-end=\"4764\">\n<p data-start=\"4656\" data-end=\"4764\">Which function converts text to uppercase?<br \/>\nA. CAPITAL()<br data-start=\"4711\" data-end=\"4714\" \/>B. UPPER()<br data-start=\"4724\" data-end=\"4727\" \/>C. BIG()<br data-start=\"4735\" data-end=\"4738\" \/>D. LARGE()<br data-start=\"4748\" data-end=\"4751\" \/><strong data-start=\"4751\" data-end=\"4762\">Answer:<\/strong> B<\/p>\n<\/li>\n<\/ol>\n<hr data-start=\"4766\" data-end=\"4769\" \/>\n<p><a href=\"https:\/\/murreeroad.org\/microsoft-word-mcqs-with-answers-100-multiple-choice-questions\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-4955\" src=\"https:\/\/murreeroad.org\/wp-content\/uploads\/2026\/01\/Microsoft-Word-MCQs-with-Answers-100-Multiple-Choice-Questions-1024x683.png\" alt=\"Microsoft Word MCQs with Answers | 100 Multiple Choice Questions\" width=\"640\" height=\"427\" srcset=\"https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Word-MCQs-with-Answers-100-Multiple-Choice-Questions-1024x683.png 1024w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Word-MCQs-with-Answers-100-Multiple-Choice-Questions-300x200.png 300w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Word-MCQs-with-Answers-100-Multiple-Choice-Questions-768x512.png 768w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Word-MCQs-with-Answers-100-Multiple-Choice-Questions.png 1536w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<hr data-start=\"4766\" data-end=\"4769\" \/>\n<h3 data-start=\"4771\" data-end=\"4818\"><strong data-start=\"4775\" data-end=\"4818\">Formatting, Charts &amp; Data Tools (41\u201370)<\/strong><\/h3>\n<ol start=\"41\" data-start=\"4820\" data-end=\"7018\">\n<li data-start=\"4820\" data-end=\"4921\">\n<p data-start=\"4824\" data-end=\"4921\">Which tab is used for formatting cells?<br \/>\nA. Insert<br data-start=\"4873\" data-end=\"4876\" \/>B. Home<br data-start=\"4883\" data-end=\"4886\" \/>C. Data<br data-start=\"4893\" data-end=\"4896\" \/>D. Review<br data-start=\"4905\" data-end=\"4908\" \/><strong data-start=\"4908\" data-end=\"4919\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"4923\" data-end=\"5049\">\n<p data-start=\"4927\" data-end=\"5049\">Which option changes cell background color?<br \/>\nA. Font Color<br data-start=\"4984\" data-end=\"4987\" \/>B. Fill Color<br data-start=\"5000\" data-end=\"5003\" \/>C. Cell Border<br data-start=\"5017\" data-end=\"5020\" \/>D. Text Color<br data-start=\"5033\" data-end=\"5036\" \/><strong data-start=\"5036\" data-end=\"5047\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"5051\" data-end=\"5157\">\n<p data-start=\"5055\" data-end=\"5157\">Which alignment places text in the center?<br \/>\nA. Left<br data-start=\"5105\" data-end=\"5108\" \/>B. Right<br data-start=\"5116\" data-end=\"5119\" \/>C. Center<br data-start=\"5128\" data-end=\"5131\" \/>D. Justify<br data-start=\"5141\" data-end=\"5144\" \/><strong data-start=\"5144\" data-end=\"5155\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"5159\" data-end=\"5279\">\n<p data-start=\"5163\" data-end=\"5279\">Which feature automatically fills data?<br \/>\nA. Flash Fill<br data-start=\"5216\" data-end=\"5219\" \/>B. Auto Fill<br data-start=\"5231\" data-end=\"5234\" \/>C. Smart Fill<br data-start=\"5247\" data-end=\"5250\" \/>D. Quick Fill<br data-start=\"5263\" data-end=\"5266\" \/><strong data-start=\"5266\" data-end=\"5277\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"5281\" data-end=\"5405\">\n<p data-start=\"5285\" data-end=\"5405\">Which option merges multiple cells?<br \/>\nA. Merge &amp; Center<br data-start=\"5338\" data-end=\"5341\" \/>B. Wrap Text<br data-start=\"5353\" data-end=\"5356\" \/>C. Align Center<br data-start=\"5371\" data-end=\"5374\" \/>D. Format Cells<br data-start=\"5389\" data-end=\"5392\" \/><strong data-start=\"5392\" data-end=\"5403\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"5407\" data-end=\"5525\">\n<p data-start=\"5411\" data-end=\"5525\">Which chart is best for comparison?<br \/>\nA. Pie chart<br data-start=\"5459\" data-end=\"5462\" \/>B. Line chart<br data-start=\"5475\" data-end=\"5478\" \/>C. Column chart<br data-start=\"5493\" data-end=\"5496\" \/>D. Area chart<br data-start=\"5509\" data-end=\"5512\" \/><strong data-start=\"5512\" data-end=\"5523\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"5527\" data-end=\"5622\">\n<p data-start=\"5531\" data-end=\"5622\">Which chart shows trends over time?<br \/>\nA. Pie<br data-start=\"5573\" data-end=\"5576\" \/>B. Line<br data-start=\"5583\" data-end=\"5586\" \/>C. Bar<br data-start=\"5592\" data-end=\"5595\" \/>D. Doughnut<br data-start=\"5606\" data-end=\"5609\" \/><strong data-start=\"5609\" data-end=\"5620\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"5624\" data-end=\"5724\">\n<p data-start=\"5628\" data-end=\"5724\">Which chart shows percentage distribution?<br \/>\nA. Column<br data-start=\"5680\" data-end=\"5683\" \/>B. Bar<br data-start=\"5689\" data-end=\"5692\" \/>C. Pie<br data-start=\"5698\" data-end=\"5701\" \/>D. Line<br data-start=\"5708\" data-end=\"5711\" \/><strong data-start=\"5711\" data-end=\"5722\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"5726\" data-end=\"5823\">\n<p data-start=\"5730\" data-end=\"5823\">Which tab is used to insert charts?<br \/>\nA. Home<br data-start=\"5773\" data-end=\"5776\" \/>B. Insert<br data-start=\"5785\" data-end=\"5788\" \/>C. Data<br data-start=\"5795\" data-end=\"5798\" \/>D. Review<br data-start=\"5807\" data-end=\"5810\" \/><strong data-start=\"5810\" data-end=\"5821\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"5825\" data-end=\"5912\">\n<p data-start=\"5829\" data-end=\"5912\">Which option sorts data?<br \/>\nA. Filter<br data-start=\"5863\" data-end=\"5866\" \/>B. Sort<br data-start=\"5873\" data-end=\"5876\" \/>C. Group<br data-start=\"5884\" data-end=\"5887\" \/>D. Format<br data-start=\"5896\" data-end=\"5899\" \/><strong data-start=\"5899\" data-end=\"5910\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"5914\" data-end=\"6011\">\n<p data-start=\"5918\" data-end=\"6011\">Which option hides unwanted data?<br \/>\nA. Sort<br data-start=\"5959\" data-end=\"5962\" \/>B. Filter<br data-start=\"5971\" data-end=\"5974\" \/>C. Freeze<br data-start=\"5983\" data-end=\"5986\" \/>D. Format<br data-start=\"5995\" data-end=\"5998\" \/><strong data-start=\"5998\" data-end=\"6009\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"6013\" data-end=\"6129\">\n<p data-start=\"6017\" data-end=\"6129\">Which feature keeps headings visible?<br \/>\nA. Freeze Panes<br data-start=\"6070\" data-end=\"6073\" \/>B. Split Cells<br data-start=\"6087\" data-end=\"6090\" \/>C. Wrap Text<br data-start=\"6102\" data-end=\"6105\" \/>D. Group<br data-start=\"6113\" data-end=\"6116\" \/><strong data-start=\"6116\" data-end=\"6127\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"6131\" data-end=\"6244\">\n<p data-start=\"6135\" data-end=\"6244\">Which tool removes duplicate data?<br \/>\nA. Sort<br data-start=\"6177\" data-end=\"6180\" \/>B. Filter<br data-start=\"6189\" data-end=\"6192\" \/>C. Remove Duplicates<br data-start=\"6212\" data-end=\"6215\" \/>D. Clean Data<br data-start=\"6228\" data-end=\"6231\" \/><strong data-start=\"6231\" data-end=\"6242\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"6246\" data-end=\"6338\">\n<p data-start=\"6250\" data-end=\"6338\">Which tab contains PivotTable?<br \/>\nA. Home<br data-start=\"6288\" data-end=\"6291\" \/>B. Insert<br data-start=\"6300\" data-end=\"6303\" \/>C. Data<br data-start=\"6310\" data-end=\"6313\" \/>D. Review<br data-start=\"6322\" data-end=\"6325\" \/><strong data-start=\"6325\" data-end=\"6336\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"6340\" data-end=\"6448\">\n<p data-start=\"6344\" data-end=\"6448\">PivotTable is used for:<br \/>\nA. Formatting<br data-start=\"6381\" data-end=\"6384\" \/>B. Data summarization<br data-start=\"6405\" data-end=\"6408\" \/>C. Printing<br data-start=\"6419\" data-end=\"6422\" \/>D. Drawing<br data-start=\"6432\" data-end=\"6435\" \/><strong data-start=\"6435\" data-end=\"6446\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"6450\" data-end=\"6587\">\n<p data-start=\"6454\" data-end=\"6587\">Conditional Formatting is used to:<br \/>\nA. Print data<br data-start=\"6502\" data-end=\"6505\" \/>B. Highlight cells based on rules<br data-start=\"6538\" data-end=\"6541\" \/>C. Protect data<br data-start=\"6556\" data-end=\"6559\" \/>D. Sort data<br data-start=\"6571\" data-end=\"6574\" \/><strong data-start=\"6574\" data-end=\"6585\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"6589\" data-end=\"6693\">\n<p data-start=\"6593\" data-end=\"6693\">Which feature adds borders to cells?<br \/>\nA. Font<br data-start=\"6637\" data-end=\"6640\" \/>B. Alignment<br data-start=\"6652\" data-end=\"6655\" \/>C. Borders<br data-start=\"6665\" data-end=\"6668\" \/>D. Styles<br data-start=\"6677\" data-end=\"6680\" \/><strong data-start=\"6680\" data-end=\"6691\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"6695\" data-end=\"6821\">\n<p data-start=\"6699\" data-end=\"6821\">Which option formats numbers?<br \/>\nA. Home \u2192 Number<br data-start=\"6745\" data-end=\"6748\" \/>B. Insert \u2192 Chart<br data-start=\"6765\" data-end=\"6768\" \/>C. Data \u2192 Sort<br data-start=\"6782\" data-end=\"6785\" \/>D. Review \u2192 Proofing<br data-start=\"6805\" data-end=\"6808\" \/><strong data-start=\"6808\" data-end=\"6819\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"6823\" data-end=\"6918\">\n<p data-start=\"6827\" data-end=\"6918\">Which format shows currency?<br \/>\nA. General<br data-start=\"6866\" data-end=\"6869\" \/>B. Number<br data-start=\"6878\" data-end=\"6881\" \/>C. Currency<br data-start=\"6892\" data-end=\"6895\" \/>D. Text<br data-start=\"6902\" data-end=\"6905\" \/><strong data-start=\"6905\" data-end=\"6916\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"6920\" data-end=\"7018\">\n<p data-start=\"6924\" data-end=\"7018\">Which feature rotates text?<br \/>\nA. Orientation<br data-start=\"6966\" data-end=\"6969\" \/>B. Alignment<br data-start=\"6981\" data-end=\"6984\" \/>C. Merge<br data-start=\"6992\" data-end=\"6995\" \/>D. Wrap<br data-start=\"7002\" data-end=\"7005\" \/><strong data-start=\"7005\" data-end=\"7016\">Answer:<\/strong> A<\/p>\n<\/li>\n<\/ol>\n<hr data-start=\"7020\" data-end=\"7023\" \/>\n<h3 data-start=\"7025\" data-end=\"7071\"><strong data-start=\"7029\" data-end=\"7071\">Advanced Features &amp; Shortcuts (71\u2013100)<\/strong><\/h3>\n<ol start=\"71\" data-start=\"7073\" data-end=\"10436\">\n<li data-start=\"7073\" data-end=\"7180\">\n<p data-start=\"7077\" data-end=\"7180\">Which shortcut selects all cells?<br \/>\nA. Ctrl + S<br data-start=\"7122\" data-end=\"7125\" \/>B. Ctrl + A<br data-start=\"7136\" data-end=\"7139\" \/>C. Ctrl + C<br data-start=\"7150\" data-end=\"7153\" \/>D. Ctrl + V<br data-start=\"7164\" data-end=\"7167\" \/><strong data-start=\"7167\" data-end=\"7178\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"7182\" data-end=\"7283\">\n<p data-start=\"7186\" data-end=\"7283\">Which shortcut copies data?<br \/>\nA. Ctrl + X<br data-start=\"7225\" data-end=\"7228\" \/>B. Ctrl + C<br data-start=\"7239\" data-end=\"7242\" \/>C. Ctrl + V<br data-start=\"7253\" data-end=\"7256\" \/>D. Ctrl + Z<br data-start=\"7267\" data-end=\"7270\" \/><strong data-start=\"7270\" data-end=\"7281\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"7285\" data-end=\"7386\">\n<p data-start=\"7289\" data-end=\"7386\">Which shortcut pastes data?<br \/>\nA. Ctrl + C<br data-start=\"7328\" data-end=\"7331\" \/>B. Ctrl + V<br data-start=\"7342\" data-end=\"7345\" \/>C. Ctrl + X<br data-start=\"7356\" data-end=\"7359\" \/>D. Ctrl + P<br data-start=\"7370\" data-end=\"7373\" \/><strong data-start=\"7373\" data-end=\"7384\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"7388\" data-end=\"7487\">\n<p data-start=\"7392\" data-end=\"7487\">Which shortcut cuts data?<br \/>\nA. Ctrl + X<br data-start=\"7429\" data-end=\"7432\" \/>B. Ctrl + C<br data-start=\"7443\" data-end=\"7446\" \/>C. Ctrl + V<br data-start=\"7457\" data-end=\"7460\" \/>D. Ctrl + A<br data-start=\"7471\" data-end=\"7474\" \/><strong data-start=\"7474\" data-end=\"7485\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"7489\" data-end=\"7589\">\n<p data-start=\"7493\" data-end=\"7589\">Which shortcut opens Find?<br \/>\nA. Ctrl + H<br data-start=\"7531\" data-end=\"7534\" \/>B. Ctrl + G<br data-start=\"7545\" data-end=\"7548\" \/>C. Ctrl + F<br data-start=\"7559\" data-end=\"7562\" \/>D. Ctrl + R<br data-start=\"7573\" data-end=\"7576\" \/><strong data-start=\"7576\" data-end=\"7587\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"7591\" data-end=\"7694\">\n<p data-start=\"7595\" data-end=\"7694\">Which shortcut opens Replace?<br \/>\nA. Ctrl + F<br data-start=\"7636\" data-end=\"7639\" \/>B. Ctrl + H<br data-start=\"7650\" data-end=\"7653\" \/>C. Ctrl + G<br data-start=\"7664\" data-end=\"7667\" \/>D. Ctrl + R<br data-start=\"7678\" data-end=\"7681\" \/><strong data-start=\"7681\" data-end=\"7692\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"7696\" data-end=\"7812\">\n<p data-start=\"7700\" data-end=\"7812\">Which shortcut inserts a new worksheet?<br \/>\nA. Shift + F11<br data-start=\"7754\" data-end=\"7757\" \/>B. Ctrl + N<br data-start=\"7768\" data-end=\"7771\" \/>C. Alt + F4<br data-start=\"7782\" data-end=\"7785\" \/>D. Ctrl + T<br data-start=\"7796\" data-end=\"7799\" \/><strong data-start=\"7799\" data-end=\"7810\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"7814\" data-end=\"7902\">\n<p data-start=\"7818\" data-end=\"7902\">Which shortcut edits the active cell?<br \/>\nA. F1<br data-start=\"7861\" data-end=\"7864\" \/>B. F2<br data-start=\"7869\" data-end=\"7872\" \/>C. F5<br data-start=\"7877\" data-end=\"7880\" \/>D. F12<br data-start=\"7886\" data-end=\"7889\" \/><strong data-start=\"7889\" data-end=\"7900\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"7904\" data-end=\"8019\">\n<p data-start=\"7908\" data-end=\"8019\">Which function is used to lookup data vertically?<br \/>\nA. HLOOKUP<br data-start=\"7968\" data-end=\"7971\" \/>B. LOOKUP<br data-start=\"7980\" data-end=\"7983\" \/>C. VLOOKUP<br data-start=\"7993\" data-end=\"7996\" \/>D. FIND<br data-start=\"8003\" data-end=\"8006\" \/><strong data-start=\"8006\" data-end=\"8017\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"8021\" data-end=\"8126\">\n<p data-start=\"8025\" data-end=\"8126\">Which function searches horizontally?<br \/>\nA. VLOOKUP<br data-start=\"8073\" data-end=\"8076\" \/>B. HLOOKUP<br data-start=\"8086\" data-end=\"8089\" \/>C. XLOOKUP<br data-start=\"8099\" data-end=\"8102\" \/>D. MATCH<br data-start=\"8110\" data-end=\"8113\" \/><strong data-start=\"8113\" data-end=\"8124\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"8128\" data-end=\"8242\">\n<p data-start=\"8132\" data-end=\"8242\">Which function replaces both VLOOKUP and HLOOKUP?<br \/>\nA. LOOKUP<br data-start=\"8191\" data-end=\"8194\" \/>B. FIND<br data-start=\"8201\" data-end=\"8204\" \/>C. XLOOKUP<br data-start=\"8214\" data-end=\"8217\" \/>D. SEARCH<br data-start=\"8226\" data-end=\"8229\" \/><strong data-start=\"8229\" data-end=\"8240\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"8244\" data-end=\"8336\">\n<p data-start=\"8248\" data-end=\"8336\">Which tab protects worksheets?<br \/>\nA. Home<br data-start=\"8286\" data-end=\"8289\" \/>B. Insert<br data-start=\"8298\" data-end=\"8301\" \/>C. Review<br data-start=\"8310\" data-end=\"8313\" \/>D. Data<br data-start=\"8320\" data-end=\"8323\" \/><strong data-start=\"8323\" data-end=\"8334\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"8338\" data-end=\"8467\">\n<p data-start=\"8342\" data-end=\"8467\">Which feature restricts data entry?<br \/>\nA. Filter<br data-start=\"8387\" data-end=\"8390\" \/>B. Data Validation<br data-start=\"8408\" data-end=\"8411\" \/>C. Conditional Format<br data-start=\"8432\" data-end=\"8435\" \/>D. Protect Sheet<br data-start=\"8451\" data-end=\"8454\" \/><strong data-start=\"8454\" data-end=\"8465\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"8469\" data-end=\"8564\">\n<p data-start=\"8473\" data-end=\"8564\">Which format stores plain text data?<br \/>\nA. .xlsx<br data-start=\"8518\" data-end=\"8521\" \/>B. .xls<br data-start=\"8528\" data-end=\"8531\" \/>C. .csv<br data-start=\"8538\" data-end=\"8541\" \/>D. .pdf<br data-start=\"8548\" data-end=\"8551\" \/><strong data-start=\"8551\" data-end=\"8562\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"8566\" data-end=\"8677\">\n<p data-start=\"8570\" data-end=\"8677\">Which feature automatically saves changes?<br \/>\nA. AutoSave<br data-start=\"8624\" data-end=\"8627\" \/>B. Save As<br data-start=\"8637\" data-end=\"8640\" \/>C. Backup<br data-start=\"8649\" data-end=\"8652\" \/>D. Export<br data-start=\"8661\" data-end=\"8664\" \/><strong data-start=\"8664\" data-end=\"8675\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"8679\" data-end=\"8796\">\n<p data-start=\"8683\" data-end=\"8796\">Which view shows page layout?<br \/>\nA. Normal<br data-start=\"8722\" data-end=\"8725\" \/>B. Page Break Preview<br data-start=\"8746\" data-end=\"8749\" \/>C. Page Layout<br data-start=\"8763\" data-end=\"8766\" \/>D. Custom View<br data-start=\"8780\" data-end=\"8783\" \/><strong data-start=\"8783\" data-end=\"8794\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"8798\" data-end=\"8903\">\n<p data-start=\"8802\" data-end=\"8903\">Which feature inserts comments?<br \/>\nA. Notes<br data-start=\"8842\" data-end=\"8845\" \/>B. Comments<br data-start=\"8856\" data-end=\"8859\" \/>C. Review<br data-start=\"8868\" data-end=\"8871\" \/>D. Track Changes<br data-start=\"8887\" data-end=\"8890\" \/><strong data-start=\"8890\" data-end=\"8901\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"8905\" data-end=\"9008\">\n<p data-start=\"8909\" data-end=\"9008\">Which function removes extra spaces?<br \/>\nA. CLEAN()<br data-start=\"8956\" data-end=\"8959\" \/>B. TRIM()<br data-start=\"8968\" data-end=\"8971\" \/>C. SPACE()<br data-start=\"8981\" data-end=\"8984\" \/>D. LEN()<br data-start=\"8992\" data-end=\"8995\" \/><strong data-start=\"8995\" data-end=\"9006\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"9010\" data-end=\"9119\">\n<p data-start=\"9014\" data-end=\"9119\">Which function converts text to lowercase?<br \/>\nA. LOWER()<br data-start=\"9067\" data-end=\"9070\" \/>B. SMALL()<br data-start=\"9080\" data-end=\"9083\" \/>C. MIN()<br data-start=\"9091\" data-end=\"9094\" \/>D. TEXT()<br data-start=\"9103\" data-end=\"9106\" \/><strong data-start=\"9106\" data-end=\"9117\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"9121\" data-end=\"9235\">\n<p data-start=\"9125\" data-end=\"9235\">Which function joins text with delimiter?<br \/>\nA. CONCAT()<br data-start=\"9178\" data-end=\"9181\" \/>B. JOIN()<br data-start=\"9190\" data-end=\"9193\" \/>C. TEXTJOIN()<br data-start=\"9206\" data-end=\"9209\" \/>D. MERGE()<br data-start=\"9219\" data-end=\"9222\" \/><strong data-start=\"9222\" data-end=\"9233\">Answer:<\/strong> C<\/p>\n<\/li>\n<li data-start=\"9237\" data-end=\"9328\">\n<p data-start=\"9241\" data-end=\"9328\">Which option inserts a table?<br \/>\nA. Home<br data-start=\"9278\" data-end=\"9281\" \/>B. Insert<br data-start=\"9290\" data-end=\"9293\" \/>C. Data<br data-start=\"9300\" data-end=\"9303\" \/>D. Review<br data-start=\"9312\" data-end=\"9315\" \/><strong data-start=\"9315\" data-end=\"9326\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"9330\" data-end=\"9458\">\n<p data-start=\"9334\" data-end=\"9458\">Which option converts range to table?<br \/>\nA. Insert Table<br data-start=\"9387\" data-end=\"9390\" \/>B. Format as Table<br data-start=\"9408\" data-end=\"9411\" \/>C. Create Table<br data-start=\"9426\" data-end=\"9429\" \/>D. Make Table<br data-start=\"9442\" data-end=\"9445\" \/><strong data-start=\"9445\" data-end=\"9456\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"9460\" data-end=\"9588\">\n<p data-start=\"9464\" data-end=\"9588\">Which feature tracks changes in Excel?<br \/>\nA. Track Changes<br data-start=\"9519\" data-end=\"9522\" \/>B. Share Workbook<br data-start=\"9539\" data-end=\"9542\" \/>C. Comments<br data-start=\"9553\" data-end=\"9556\" \/>D. Protect Sheet<br data-start=\"9572\" data-end=\"9575\" \/><strong data-start=\"9575\" data-end=\"9586\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"9590\" data-end=\"9715\">\n<p data-start=\"9594\" data-end=\"9715\">Which tool analyzes data quickly?<br \/>\nA. Solver<br data-start=\"9637\" data-end=\"9640\" \/>B. What-If Analysis<br data-start=\"9659\" data-end=\"9662\" \/>C. Scenario Manager<br data-start=\"9681\" data-end=\"9684\" \/>D. All of these<br data-start=\"9699\" data-end=\"9702\" \/><strong data-start=\"9702\" data-end=\"9713\">Answer:<\/strong> D<\/p>\n<\/li>\n<li data-start=\"9717\" data-end=\"9852\">\n<p data-start=\"9721\" data-end=\"9852\">Which option inserts sparklines?<br \/>\nA. Insert \u2192 Charts<br data-start=\"9772\" data-end=\"9775\" \/>B. Insert \u2192 Sparklines<br data-start=\"9797\" data-end=\"9800\" \/>C. Data \u2192 Charts<br data-start=\"9816\" data-end=\"9819\" \/>D. Review \u2192 Graph<br data-start=\"9836\" data-end=\"9839\" \/><strong data-start=\"9839\" data-end=\"9850\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"9854\" data-end=\"9961\">\n<p data-start=\"9858\" data-end=\"9961\">Which function checks logical condition?<br \/>\nA. IF()<br data-start=\"9906\" data-end=\"9909\" \/>B. AND()<br data-start=\"9917\" data-end=\"9920\" \/>C. OR()<br data-start=\"9927\" data-end=\"9930\" \/>D. All of these<br data-start=\"9945\" data-end=\"9948\" \/><strong data-start=\"9948\" data-end=\"9959\">Answer:<\/strong> D<\/p>\n<\/li>\n<li data-start=\"9963\" data-end=\"10054\">\n<p data-start=\"9967\" data-end=\"10054\">Which key exits Excel?<br \/>\nA. Ctrl + Q<br data-start=\"10001\" data-end=\"10004\" \/>B. Alt + F4<br data-start=\"10015\" data-end=\"10018\" \/>C. Ctrl + W<br data-start=\"10029\" data-end=\"10032\" \/>D. Esc<br data-start=\"10038\" data-end=\"10041\" \/><strong data-start=\"10041\" data-end=\"10052\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"10056\" data-end=\"10167\">\n<p data-start=\"10060\" data-end=\"10167\">Which feature recovers unsaved files?<br \/>\nA. AutoSave<br data-start=\"10109\" data-end=\"10112\" \/>B. AutoRecover<br data-start=\"10126\" data-end=\"10129\" \/>C. Backup<br data-start=\"10138\" data-end=\"10141\" \/>D. Save As<br data-start=\"10151\" data-end=\"10154\" \/><strong data-start=\"10154\" data-end=\"10165\">Answer:<\/strong> B<\/p>\n<\/li>\n<li data-start=\"10169\" data-end=\"10276\">\n<p data-start=\"10173\" data-end=\"10276\">Which function returns text from a cell?<br \/>\nA. TEXT()<br data-start=\"10223\" data-end=\"10226\" \/>B. VALUE()<br data-start=\"10236\" data-end=\"10239\" \/>C. CHAR()<br data-start=\"10248\" data-end=\"10251\" \/>D. CODE()<br data-start=\"10260\" data-end=\"10263\" \/><strong data-start=\"10263\" data-end=\"10274\">Answer:<\/strong> A<\/p>\n<\/li>\n<li data-start=\"10278\" data-end=\"10436\">\n<p data-start=\"10283\" data-end=\"10436\">Microsoft Excel is mainly used for:<br \/>\nA. Writing documents<br data-start=\"10339\" data-end=\"10342\" \/>B. Making presentations<br data-start=\"10365\" data-end=\"10368\" \/>C. Data calculation and analysis<br data-start=\"10400\" data-end=\"10403\" \/>D. Drawing images<br data-start=\"10420\" data-end=\"10423\" \/><strong data-start=\"10423\" data-end=\"10434\">Answer:<\/strong> C<\/p>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/rgsoftwares.com\/school-management-software\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4896\" src=\"https:\/\/murreeroad.org\/wp-content\/uploads\/2025\/12\/School-Management-software-1.png\" alt=\"School Management software\" width=\"1500\" height=\"98\" srcset=\"https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2025\/12\/School-Management-software-1.png 1500w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2025\/12\/School-Management-software-1-300x20.png 300w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2025\/12\/School-Management-software-1-1024x67.png 1024w, https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2025\/12\/School-Management-software-1-768x50.png 768w\" sizes=\"auto, (max-width: 1500px) 100vw, 1500px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Practice 100 Microsoft Excel MCQs with answers covering formulas, functions, charts, cell references, shortcuts, and data analysis tools. Ideal for students and exam preparation. Microsoft Excel is one of the most powerful and widely used spreadsheet applications for organizing, calculating, and analyzing data. This carefully designed set of 100 Microsoft Excel MCQs with answers covers &#8230; <a title=\"Microsoft Excel MCQs with Answers | 100 Multiple Choice Questions\" class=\"read-more\" href=\"https:\/\/learn-nest.murreeroad.org\/blog\/microsoft-excel-mcqs-with-answers-100-multiple-choice-questions\/\" aria-label=\"Read more about Microsoft Excel MCQs with Answers | 100 Multiple Choice Questions\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":4958,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowprK_DA:productID":"","om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2106],"tags":[2978,2973,2976,2669,2952,2971,2967,2968,2965,2970,2975,2966,2963,2974,2964,2972,2953,2977,2969,186],"class_list":["post-4957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mcqs","tag-100-mcqs-on-microsoft-excel","tag-beginner-excel-quiz","tag-beginners","tag-competitive-exams","tag-computer-application-mcqs","tag-data-analysis-mcqs","tag-excel-formulas-mcqs","tag-excel-functions-questions","tag-excel-mcqs-with-answers","tag-excel-shortcut-keys-mcqs","tag-microsoft-excel","tag-microsoft-excel-basics-questions","tag-microsoft-excel-mcqs","tag-microsoft-excel-mcqs-with-answers","tag-ms-excel-multiple-choice-questions","tag-ms-excel-objective-questions","tag-office-automation-mcqs","tag-office-users","tag-spreadsheet-mcqs","tag-students"],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers.png",1536,1024,false],"thumbnail":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers-150x150.png",150,150,true],"medium":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers-300x200.png",300,200,true],"medium_large":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers-768x512.png",768,512,true],"large":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers-1024x683.png",1024,683,true],"1536x1536":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers.png",1536,1024,false],"2048x2048":["https:\/\/learn-nest.murreeroad.org\/blog\/wp-content\/uploads\/2026\/01\/Microsoft-Excel-MCQs-with-Answers.png",1536,1024,false]},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/learn-nest.murreeroad.org\/blog\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Practice 100 Microsoft Excel MCQs with answers covering formulas, functions, charts, cell references, shortcuts, and data analysis tools. Ideal for students and exam preparation. Microsoft Excel is one of the most powerful and widely used spreadsheet applications for organizing, calculating, and analyzing data. This carefully designed set of 100 Microsoft Excel MCQs with answers covers&hellip;","_links":{"self":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/4957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/comments?post=4957"}],"version-history":[{"count":1,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/4957\/revisions"}],"predecessor-version":[{"id":4959,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/posts\/4957\/revisions\/4959"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/media\/4958"}],"wp:attachment":[{"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/media?parent=4957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/categories?post=4957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learn-nest.murreeroad.org\/blog\/wp-json\/wp\/v2\/tags?post=4957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}