{"id":106641,"date":"2026-06-26T16:31:20","date_gmt":"2026-06-26T11:01:20","guid":{"rendered":"https:\/\/www.oliveboard.in\/blog\/?p=106641"},"modified":"2026-06-26T16:31:24","modified_gmt":"2026-06-26T11:01:24","slug":"basics-of-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/","title":{"rendered":"Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_77 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of content<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Basics_of_MS_Excel_for_SBI_PO_Exam_FREE_PDF\" >Basics of MS Excel for SBI PO Exam, FREE PDF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Basics_of_MS_Excel_for_SBI_PO_Exam_LIVE_Quiz\" >Basics of MS Excel for SBI PO Exam, LIVE Quiz<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Sign_Up\" >Sign Up<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Login\" >Login<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Forgot_Password\" >Forgot Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#i\" >&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Sign_Up-2\" >Sign Up<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Login-2\" >Login<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#Forgot_Password-2\" >Forgot Password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#i-2\" >&nbsp;<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Basics of MS Excel is an important topic in computer awareness for competitive exams like SBI PO. Microsoft Excel is a spreadsheet program used to organize data, perform calculations, and analyze information efficiently. Understanding its basic features helps candidates solve questions related to formulas, functions, and data handling with ease. Regular practice of MS Excel basics helps improve speed, accuracy, and conceptual clarity in the computer section of banking exams.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-basics-of-ms-excel-for-sbi-po-exam-free-pdf\"><span class=\"ez-toc-section\" id=\"Basics_of_MS_Excel_for_SBI_PO_Exam_FREE_PDF\"><\/span>Basics of MS Excel for SBI PO Exam, FREE PDF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To help you prepare better, we have provided a free SBI PO Basics of MS Excel Questions PDF with practice questions and detailed explanations. By practicing from this PDF, you will:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Learn basic Excel functions and formulas<\/li>\n\n\n\n<li>Understand rows, columns, and cell referencing<\/li>\n\n\n\n<li>Improve knowledge of charts and data formatting<\/li>\n\n\n\n<li>Strengthen accuracy in Computer Awareness questions<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/complete-computer-awareness\/?ref=conttm-computer-awareness\" target=\"_blank\" rel=\"noreferrer noopener\">Download Basics of MS Excel Questions for SBI PO Exam FREE PDF<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-basics-of-ms-excel-for-sbi-po-exam-live-quiz\"><span class=\"ez-toc-section\" id=\"Basics_of_MS_Excel_for_SBI_PO_Exam_LIVE_Quiz\"><\/span>Basics of MS Excel for SBI PO Exam, LIVE Quiz<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Basics of MS Excel questions test your understanding of spreadsheet operations, formulas like SUM, AVERAGE, and basic shortcuts used in Excel. Our live quizzes help you practice in real-time, improve speed, and build confidence for the SBI PO Computer Awareness section. Regular practice will help you quickly solve Excel-based questions in the exam and strengthen your overall computer fundamentals.<\/p>\n\n\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\">\n<link rel=\"stylesheet\" href=\"https:\/\/courses.oliveboard.in\/edge\/css\/login-modal-for-blog.css\">\n\n<style>\n#quiz-1-sticky-header {\n  position: sticky;\n  top: 0;\n  z-index: 100;\n  background: #1565c0;\n  color: #fff;\n  padding: 12px 20px;\n  border-radius: 10px 10px 0 0;\n  display: flex;\n  justify-content: space-between;\n  align-items: center;\n  font-size: 16px;\n  font-weight: bold;\n  box-shadow: 0 2px 8px rgba(0,0,0,0.2);\n  margin: -20px -20px 20px -20px;\n}\n\n#quiz-1-score-badge {\n  background: rgba(255,255,255,0.2);\n  padding: 4px 12px;\n  border-radius: 20px;\n  font-size: 15px;\n  white-space: nowrap;\n}\n#quiz-1 * { box-sizing: border-box; }\n\n#quiz-1 .quiz-container {\n  max-width: 700px;\n  margin: auto;\n  padding: 20px;\n  background: #fff;\n  border-radius: 14px;\n  box-shadow: 0 6px 16px rgba(0,0,0,0.12);\n}\n\n#quiz-1 h2 {\n  text-align: center;\n}\n\n#quiz-1 .question {\n  margin-bottom: 22px;\n}\n\n#quiz-1 .question p {\n  font-weight: bold;\n}\n\n#quiz-1 button {\n  width: 100%;\n  padding: 12px;\n  margin: 6px 0;\n  border: none;\n  border-radius: 6px;\n  background: #e0e0e0;\n  color: #000;\n  font-size: 16px;\n  cursor: pointer;\n}\n\n#quiz-1 button:hover {\n  background: #d5d5d5;\n}\n\n#quiz-1 button.correct {\n  background: #4caf50;\n  color: #000;\n}\n\n#quiz-1 button.wrong {\n  background: #f44336;\n  color: #000;\n}\n\n#quiz-1 button.locked {\n  pointer-events: none;\n}\n\n\/* SUMMARY *\/\n#quiz-1 .final-summary {\n  margin-top: 40px;\n  padding: 20px;\n  border-radius: 14px;\n  background: #fafafa;\n  border: 2px solid #4caf50;\n}\n\n#quiz-1 .final-summary h3 {\n  text-align: center;\n  margin-bottom: 20px;\n}\n\n#quiz-1 .summary-row {\n  display: grid;\n  grid-template-columns: 120px 1fr 40px;\n  gap: 10px;\n  align-items: center;\n  margin-bottom: 12px;\n  font-weight: bold;\n}\n\n#quiz-1 .summary-bar {\n  height: 14px;\n  background: #ddd;\n  border-radius: 10px;\n  overflow: hidden;\n}\n\n#quiz-1 .bar-fill {\n  height: 100%;\n  width: 0%;\n}\n\n#quiz-1 .bar-attempted { background: #2196f3; }\n#quiz-1 .bar-correct { background: #4caf50; }\n#quiz-1 .bar-wrong { background: #f44336; }\n#quiz-1 .bar-unattempted { background: #9e9e9e; width: 100%; }\n\n#quiz-1 .final-score {\n  text-align: center;\n  font-size: 22px;\n  margin-top: 20px;\n}\n\n#quiz-1 .score-value {\n  font-size: 30px;\n  margin-left: 8px;\n}\n<\/style>\n<\/head>\n\n<body>\n<div id=\"quiz-1\">\n  <div class=\"quiz-container\">\n<div id=\"quiz-1-sticky-header\">\n  <span> Basics of MS Excel Quiz Questions (Part 1) <\/span>\n  <span id=\"quiz-1-score-badge\">Score: <strong id=\"quiz-1-score-value\">0.00<\/strong><\/span>\n<\/div>\n\n    <!-- QUESTIONS -->\n\n  <div class=\"question\" data-answered=\"false\">\n    <p>1. MS Excel is a type of:<\/p>\n    <button data-correct=\"false\">Word processor<\/button>\n    <button data-correct=\"true\">Spreadsheet software<\/button>\n    <button data-correct=\"false\">Web browser<\/button>\n    <button data-correct=\"false\">Antivirus software<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>2. An Excel file is called a:<\/p>\n    <button data-correct=\"false\">Document<\/button>\n    <button data-correct=\"true\">Workbook<\/button>\n    <button data-correct=\"false\">Slide<\/button>\n    <button data-correct=\"false\">Database<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>3. The intersection of a row and a column in Excel is called a:<\/p>\n    <button data-correct=\"false\">Field<\/button>\n    <button data-correct=\"false\">Range<\/button>\n    <button data-correct=\"true\">Cell<\/button>\n    <button data-correct=\"false\">Table<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>4. The default file extension for an Excel file is:<\/p>\n    <button data-correct=\"false\">.docx<\/button>\n    <button data-correct=\"false\">.pptx<\/button>\n    <button data-correct=\"true\">.xlsx<\/button>\n    <button data-correct=\"false\">.exe<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>5. Every formula in Excel must begin with:<\/p>\n    <button data-correct=\"false\">+<\/button>\n    <button data-correct=\"true\">=<\/button>\n    <button data-correct=\"false\">#<\/button>\n    <button data-correct=\"false\">@<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>6. Rows in Excel are:<\/p>\n    <button data-correct=\"false\">Vertical<\/button>\n    <button data-correct=\"true\">Horizontal<\/button>\n    <button data-correct=\"false\">Diagonal<\/button>\n    <button data-correct=\"false\">Random<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>7. Columns in Excel are:<\/p>\n    <button data-correct=\"false\">Horizontal<\/button>\n    <button data-correct=\"false\">Diagonal<\/button>\n    <button data-correct=\"true\">Vertical<\/button>\n    <button data-correct=\"false\">Random<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>8. Which of the following is a valid cell address in Excel?<\/p>\n    <button data-correct=\"false\">1A<\/button>\n    <button data-correct=\"false\">AA1<\/button>\n    <button data-correct=\"true\">A1<\/button>\n    <button data-correct=\"false\">11A<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>9. A &#8216;Range&#8217; in Excel refers to:<\/p>\n    <button data-correct=\"false\">One specific cell<\/button>\n    <button data-correct=\"true\">A group of cells<\/button>\n    <button data-correct=\"false\">A single column<\/button>\n    <button data-correct=\"false\">A single row<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>10. The SUM function is used to:<\/p>\n    <button data-correct=\"false\">Subtract values<\/button>\n    <button data-correct=\"false\">Multiply values<\/button>\n    <button data-correct=\"false\">Divide values<\/button>\n    <button data-correct=\"true\">Add values<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>11. The COUNT function counts:<\/p>\n    <button data-correct=\"false\">Text cells<\/button>\n    <button data-correct=\"false\">Blank cells<\/button>\n    <button data-correct=\"true\">Numeric values only<\/button>\n    <button data-correct=\"false\">All non-empty cells<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>12. The COUNTA function counts:<\/p>\n    <button data-correct=\"false\">Blank cells<\/button>\n    <button data-correct=\"false\">Numbers only<\/button>\n    <button data-correct=\"true\">Non-empty cells (any data type)<\/button>\n    <button data-correct=\"false\">Errors only<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>13. The AVERAGE function returns:<\/p>\n    <button data-correct=\"false\">Total sum<\/button>\n    <button data-correct=\"false\">Median value<\/button>\n    <button data-correct=\"true\">Mean (arithmetic average)<\/button>\n    <button data-correct=\"false\">Maximum value<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>14. The MAX function returns:<\/p>\n    <button data-correct=\"false\">Lowest value<\/button>\n    <button data-correct=\"false\">Total sum<\/button>\n    <button data-correct=\"false\">Mean value<\/button>\n    <button data-correct=\"true\">Highest value<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>15. The MIN function returns:<\/p>\n    <button data-correct=\"false\">Highest value<\/button>\n    <button data-correct=\"true\">Lowest value<\/button>\n    <button data-correct=\"false\">Average value<\/button>\n    <button data-correct=\"false\">Total sum<\/button>\n<\/div>\n\n    <!-- FINAL SUMMARY -->\n    <div class=\"final-summary\">\n      <h3>Quiz Summary <\/h3>\n\n      <div class=\"summary-row\">\n        <span>Attempted<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-attempted\" data-summary=\"attempted\"><\/div><\/div>\n        <span data-count=\"attempted\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Correct<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-correct\" data-summary=\"correct\"><\/div><\/div>\n        <span data-count=\"correct\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Wrong<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-wrong\" data-summary=\"wrong\"><\/div><\/div>\n        <span data-count=\"wrong\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Unattempted<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-unattempted\" data-summary=\"unattempted\"><\/div><\/div>\n        <span data-count=\"unattempted\">0<\/span>\n      <\/div>\n\n      <div class=\"final-score\">\n        Final Score: <span class=\"score-value\" data-score>0.0<\/span>\n      <\/div>\n    <\/div>\n\n  <\/div>\n<\/div>\n<div class=\"modal modal-obls\" id=\"modal-signup\">\n        <div class=\"modal-background\"><\/div>\n        <div class=\"modal-content\">\n           <div class=\"obls-group\" id=\"obls-group1\">\n               <div class=\"obls-blk\">\n                   <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/img-delivery.svg\" alt=\"\"><\/span>\n                   <h2 id=\"display-register-text\"><span class=\"ez-toc-section\" id=\"Sign_Up\"><\/span>Sign Up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                   <div class=\"loginas-group loginas-group1 loginas-group-single\">\n <div id=\"g_id_onload\" data-client_id=\"506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com\" ,=\"\" data-use_fedcm_for_prompt=\"true\" data-callback=\"handleOnetapResponse\">\n    <\/div>\n    <div class=\"g_id_signin\" data-type=\"standard\"><div class=\"S9gUrf-YoZ4jf\" style=\"position: relative;\"><div><\/div><iframe src=\"https:\/\/accounts.google.com\/gsi\/button?type=standard&amp;is_fedcm_supported=true&amp;client_id=506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com&amp;iframe_id=gsi_437394_8652&amp;cas=pwXumGxyCMNtIbjaV30qchi2A1vUar%2Faz%2FOE5HQ%2B0Zc\" class=\"L5Fo6c-PQbLGe\" allow=\"identity-credentials-get\" id=\"gsi_437394_8652\" title=\"Sign in with Google Button\" style=\"display: block; position: relative; top: 0px; left: 0px; height: 44px; width: 204px; border: 0px; margin: -2px -10px;\"><\/iframe><\/div><\/div>\n                   <\/div>\n                   <h6 class=\"signup-subheader\">Or, register with email<\/h6>\n                   <label class=\"errormsg txt-red courseUp\"><\/label>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                        <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"course-uemail\" required=\"\">\n                        <span class=\"floating-label\" style=\"top: 19px; font-size: 12px;\">Email Id<\/span>\n                   <\/div>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mobile-black.svg\" alt=\"\"><\/span>\n                        <input type=\"text\" maxlength=\"10\" name=\"monum\" class=\"formcontrol ob-inputfield\" id=\"course-uphone\" required=\"\">\n                        <span class=\"floating-label\">Mobile Number<\/span>\n                   <\/div>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-lock.svg\" alt=\"\"><\/span>\n                        <input type=\"password\" name=\"pwd\" class=\"formcontrol ob-inputfield\" id=\"course-upassword\" required=\"\">\n                        <span class=\"floating-label\">Password<\/span>\n                   <\/div>\n                   <button type=\"button\" class=\"btn btn-md btn-tblue btn-obls\" onclick=\"courseUpValidation('home','IBPS','https:\/\/u1.oliveboard.in\/exams\/?c=dashboard&amp;i=common');return false;\" id=\"courseup\">REGISTER<\/button>\n                    <p class=\"obls-footer\">Already a user?<button type=\"button\" class=\"btn btn-xs btn-switch-obls btn-show-modal-login\" id=\"btn-show-modal-login\">Login<\/button><\/p>\n               <\/div> \n            <\/div> \n        <\/div>\n        <button class=\"modal-close is-large modal-obls-close\" aria-label=\"close\"><\/button>\n    <\/div>\n\n<div class=\"modal modal-obls\" id=\"modal-login\">\n        <div class=\"modal-background\"><\/div>\n        <div class=\"modal-content\">\n           <div class=\"obls-group\" id=\"obls-group2\">\n               <div class=\"obls-blk\">\n                   <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/img-run-health.svg\" alt=\"\"><\/span>\n                   <div id=\"login-group-abc\" class=\"lfp-group-abc\"><!-- start login group -->\n                       <h2><span class=\"ez-toc-section\" id=\"Login\"><\/span>Login<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                       <label class=\"errormsg txt-red courseIn\"><\/label>\n                       <div class=\"formcontrol-group disable-loginemail\">\n                            <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                            <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"course-email\" required=\"\">\n                            <span class=\"floating-label\">Email Id<\/span>\n                       <\/div>\n                       <div class=\"loginnext-group\" id=\"loginnext-group\"><!-- pass and captcha -->\n                           <div class=\"formcontrol-group\">\n                                <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-lock.svg\" alt=\"\"><\/span>\n                                <input type=\"password\" name=\"pwd\" class=\"formcontrol ob-inputfield\" id=\"course-password\" required=\"\">\n                                <span class=\"floating-label\">Password<\/span>\n                           <\/div>\n                           <div style=\"display:none\" id=\"img-oblcaptcha\" class=\"captcha-img-blk\">\n                           <\/div>\n                           <div style=\"display:none\" class=\"formcontrol-group captcha-input-blk\">\n                                <input type=\"text\" name=\"pwd1\" value=\"1\" class=\"formcontrol ob-inputfield\" id=\"lcaptcha-code\" required=\"\">\n                                <span class=\"floating-label\">Enter text you see in the image<\/span>\n                           <\/div>\n                       <\/div><!-- pass and captcha -->\n                       \n                       <div class=\"btn-forgotpwd-group\"><button id=\"btn-forgotpwd\" class=\"btn btn-forgotpwd\">Forgot Password?<\/button><\/div>\n                       <button type=\"button\" id=\"coursein1\" class=\"btn btn-md btn-tblue btn-obls\" onclick=\"courseInValidation1()\">Next<\/button>\n                       <button type=\"button\" id=\"coursein\" class=\"btn btn-md btn-tblue btn-obls coursein\" onclick=\"courseInValidation('https:\/\/u1.oliveboard.in\/exams\/?c=dashboard&amp;i=common')\">Submit<\/button>\n                       <form method=\"post\" action=\"https:\/\/login.oliveboard.in\/login\/next.php\" id=\"snf1\">\n                        <input type=\"hidden\" name=\"email\" value=\"\" id=\"lemailnext\">\n                        <\/form>\n                   <\/div><!-- end login group -->\n                   <div id=\"forgotpwd-group-abc\" class=\"lfp-group-abc forgotpwd-group-abc\"><!-- start forgotpwd group -->\n                       <h2><span class=\"ez-toc-section\" id=\"Forgot_Password\"><\/span>Forgot Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                       <p class=\"secintro-txt\">Please enter the Email ID we will send you a Email with the link to reset the password.<\/p>\n                       <label class=\"errormsg txt-red rePassMsg\"><\/label>\n                       <div class=\"formcontrol-group formcontrol-group-fp\">\n                            <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                            <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"remail\" required=\"\">\n                            <span class=\"floating-label\">Email Id<\/span>\n                       <\/div>\n                       <div class=\"loginas-group loginas-group1\">\n                            <button type=\"button\" id=\"btn-fpwd-cancel\" class=\"btn btn-md btn-white btn-cancel btn-fpwd-cancel\">Cancel<\/button>\n                            <button type=\"button\" id=\"lreset\" class=\"btn btn-md btn-tblue btn-fpwd-submit\" onclick=\"resetPassword()\">Submit<\/button>\n                       <\/div>\n                    <\/div><!-- end forgotpwd group --> \n                   <h6 class=\"login-subheader\">Or, login with<\/h6>\n                   <div class=\"loginas-group loginas-group2 loginas-group-single\">\n\n <div id=\"g_id_onload\" data-client_id=\"506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com\" ,=\"\" data-use_fedcm_for_prompt=\"true\" data-callback=\"handleOnetapResponse\">\n    <\/div>\n    <div class=\"g_id_signin\" data-type=\"standard\"><div class=\"S9gUrf-YoZ4jf\" style=\"position: relative;\"><div><div tabindex=\"0\" role=\"button\" aria-labelledby=\"button-label\" class=\"nsm7Bb-HzV7m-LgbsSe  hJDwNd-SxQuSe i5vt6e-Ia7Qfc uaxL4e-RbRzK\"><div class=\"nsm7Bb-HzV7m-LgbsSe-MJoBVe\"><\/div><div class=\"nsm7Bb-HzV7m-LgbsSe-bN97Pc-sM5MNb \"><div class=\"nsm7Bb-HzV7m-LgbsSe-Bz112c\"><svg version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 48\" class=\"LgbsSe-Bz112c\"><g><path fill=\"#EA4335\" d=\"M24 9.5c3.54 0 6.71 1.22 9.21 3.6l6.85-6.85C35.9 2.38 30.47 0 24 0 14.62 0 6.51 5.38 2.56 13.22l7.98 6.19C12.43 13.72 17.74 9.5 24 9.5z\"><\/path><path fill=\"#4285F4\" d=\"M46.98 24.55c0-1.57-.15-3.09-.38-4.55H24v9.02h12.94c-.58 2.96-2.26 5.48-4.78 7.18l7.73 6c4.51-4.18 7.09-10.36 7.09-17.65z\"><\/path><path fill=\"#FBBC05\" d=\"M10.53 28.59c-.48-1.45-.76-2.99-.76-4.59s.27-3.14.76-4.59l-7.98-6.19C.92 16.46 0 20.12 0 24c0 3.88.92 7.54 2.56 10.78l7.97-6.19z\"><\/path><path fill=\"#34A853\" d=\"M24 48c6.48 0 11.93-2.13 15.89-5.81l-7.73-6c-2.15 1.45-4.92 2.3-8.16 2.3-6.26 0-11.57-4.22-13.47-9.91l-7.98 6.19C6.51 42.62 14.62 48 24 48z\"><\/path><path fill=\"none\" d=\"M0 0h48v48H0z\"><\/path><\/g><\/svg><\/div><span class=\"nsm7Bb-HzV7m-LgbsSe-BPrWId\">Sign in with Google<\/span><span class=\"L6cTce\" id=\"button-label\">Sign in with Google. Opens in new tab<\/span><\/div><\/div><\/div><iframe src=\"https:\/\/accounts.google.com\/gsi\/button?type=standard&amp;is_fedcm_supported=true&amp;client_id=506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com&amp;iframe_id=gsi_437400_306436&amp;cas=pwXumGxyCMNtIbjaV30qchi2A1vUar%2Faz%2FOE5HQ%2B0Zc\" class=\"L5Fo6c-PQbLGe\" allow=\"identity-credentials-get\" id=\"gsi_437400_306436\" title=\"Sign in with Google Button\" style=\"display: block; position: relative; top: 0px; left: 0px; height: 0px; width: 0px; border: 0px;\"><\/iframe><\/div><\/div>\n\n\n                   <\/div>\n                    <p class=\"obls-footer\">New to Oliveboard?<button class=\"btn btn-xs btn-switch-obls\" id=\"btn-show-modal-signup\">Register<\/button><\/p>\n               <\/div> \n            <\/div> \n            <div class=\"success-msg-group\" id=\"success-msg-group\"><!-- success msg -->\n                <div class=\"success-msg-blk\" id=\"success-msg-blk\">\n                    <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/success-ellipse.svg\" alt=\"\"><\/span>\n                    <h2 id=\"fpwd-success-msg-title\"><span class=\"ez-toc-section\" id=\"i\"><\/span>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                    <p id=\"fpwd-success-msg-text\">&nbsp;<\/p>\n                    <div class=\"login-btn\">\n                        <button type=\"button\" class=\"btn btn-md btn-tblue modal-obls-close\">Ok<\/button>\n                    <\/div>\n\n                <\/div>\n            <\/div><!-- success msg -->\n\n        <\/div>\n        <button class=\"modal-close is-large modal-obls-close\" aria-label=\"close\"><\/button>\n    <\/div>\n\n<script src=\"https:\/\/s3-ap-southeast-1.amazonaws.com\/sg2.oliveboard.in\/static\/js\/jquery.js\"><\/script>\n\n<script>\nvar boxurl = window.location.href + '?log=1';\n\nfunction getUrlParam(name, defaultValue) {\n    const params = new URLSearchParams(window.location.search);\n    return params.has(name) ? params.get(name) : defaultValue;\n}\n\nvar l_log = getUrlParam('log', 0);\n<\/script>\n<script src=\"https:\/\/www.oliveboard.in\/js\/coursecommon.js?v=12\"><\/script>\n\n\n<script>\n(() => {\n  const quizContainer = document.getElementById('quiz-1');\n  const STORAGE_KEY = 'quiz_1_state';\n  let score = 0;\n  let attempted = 0;\n  let correct = 0;\n  let wrong = 0;\n\n  const questions = quizContainer.querySelectorAll(\".question\");\n  const total = questions.length;\n\n  function loadState() {\n    try { return JSON.parse(sessionStorage.getItem(STORAGE_KEY) || '{}'); }\n    catch { return {}; }\n  }\n\n  function saveState(data) {\n    sessionStorage.setItem(STORAGE_KEY, JSON.stringify(data));\n  }\n\n  function updateUI() {\n    const unattempted = total - attempted;\n    quizContainer.querySelector('[data-count=\"attempted\"]').textContent = attempted;\n    quizContainer.querySelector('[data-count=\"correct\"]').textContent = correct;\n    quizContainer.querySelector('[data-count=\"wrong\"]').textContent = wrong;\n    quizContainer.querySelector('[data-count=\"unattempted\"]').textContent = unattempted;\n    quizContainer.querySelector('[data-summary=\"attempted\"]').style.width = (attempted \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"correct\"]').style.width = (correct \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"wrong\"]').style.width = (wrong \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"unattempted\"]').style.width = (unattempted \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-score]').textContent = score.toFixed(2);\n\n    \/\/ Live score update in sticky header\n    document.getElementById('quiz-1-score-value').textContent = score.toFixed(2);\n  }\n\n  function restoreQuestion(q, chosenIndex, wasCorrect) {\n    q.dataset.answered = \"true\";\n    const buttons = q.querySelectorAll(\"button\");\n    buttons.forEach(b => b.classList.add(\"locked\"));\n    if (wasCorrect) {\n      buttons[chosenIndex].classList.add(\"correct\");\n    } else {\n      buttons[chosenIndex].classList.add(\"wrong\");\n      q.querySelector(\"[data-correct='true']\").classList.add(\"correct\");\n    }\n  }\n\n  \/\/ Restore saved answers on page load\n  const savedAnswers = loadState();\nquestions.forEach((q, qIndex) => {\n    const saved = savedAnswers[qIndex];\n    if (saved !== undefined) {\n      attempted++;\n      if (saved.correct) { correct++; }\n      else { wrong++; }\n      restoreQuestion(q, saved.chosenIndex, saved.correct);\n    }\n  });\n  score = parseFloat((correct * 1 - wrong * 0.25).toFixed(2));\n  updateUI();\n\n  \/\/ Attach click handlers\n  questions.forEach((q, qIndex) => {\n    q.querySelectorAll(\"button\").forEach((btn, btnIndex) => {\n      btn.addEventListener(\"click\", () => {\n        if (q.dataset.answered === \"true\") return;\n        q.dataset.answered = \"true\";\n        attempted++;\n\n        if (attempted > 7 && l_log == 0) {\n          $('#modal-signup').addClass('is-active');\n        }\n\n        q.querySelectorAll(\"button\").forEach(b => b.classList.add(\"locked\"));\n        const isCorrect = btn.dataset.correct === \"true\";\n\n if (isCorrect) {\n          btn.classList.add(\"correct\");\n          correct++;\n        } else {\n          btn.classList.add(\"wrong\");\n          wrong++;\n          q.querySelector(\"[data-correct='true']\").classList.add(\"correct\");\n        }\n        score = parseFloat((correct * 1 - wrong * 0.25).toFixed(2));\n\n        savedAnswers[qIndex] = { chosenIndex: btnIndex, correct: isCorrect };\n        saveState(savedAnswers);\n        updateUI();\n      });\n    });\n  });\n\n  updateUI();\n})();\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/blog\/sbi-po-practice-questions\/?ref=conttm-computer-awareness\" target=\"_blank\" rel=\"noreferrer noopener\">download free SBI PO Practice paper<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\">\n<link rel=\"stylesheet\" href=\"https:\/\/courses.oliveboard.in\/edge\/css\/login-modal-for-blog.css\">\n\n<style>\n#quiz-2-sticky-header {\n  position: sticky;\n  top: 0;\n  z-index: 100;\n  background: #1565c0;\n  color: #fff;\n  padding: 12px 20px;\n  border-radius: 10px 10px 0 0;\n  display: flex;\n  justify-content: space-between;\n  align-items: center;\n  font-size: 16px;\n  font-weight: bold;\n  box-shadow: 0 2px 8px rgba(0,0,0,0.2);\n  margin: -20px -20px 20px -20px;\n}\n\n#quiz-2-score-badge {\n  background: rgba(255,255,255,0.2);\n  padding: 4px 12px;\n  border-radius: 20px;\n  font-size: 15px;\n  white-space: nowrap;\n}\n#quiz-2 * { box-sizing: border-box; }\n\n#quiz-2 .quiz-container {\n  max-width: 700px;\n  margin: auto;\n  padding: 20px;\n  background: #fff;\n  border-radius: 14px;\n  box-shadow: 0 6px 16px rgba(0,0,0,0.12);\n}\n\n#quiz-2 h2 {\n  text-align: center;\n}\n\n#quiz-2 .question {\n  margin-bottom: 22px;\n}\n\n#quiz-2 .question p {\n  font-weight: bold;\n}\n\n#quiz-2 button {\n  width: 100%;\n  padding: 12px;\n  margin: 6px 0;\n  border: none;\n  border-radius: 6px;\n  background: #e0e0e0;\n  color: #000;\n  font-size: 16px;\n  cursor: pointer;\n}\n\n#quiz-2 button:hover {\n  background: #d5d5d5;\n}\n\n#quiz-2 button.correct {\n  background: #4caf50;\n  color: #000;\n}\n\n#quiz-2 button.wrong {\n  background: #f44336;\n  color: #000;\n}\n\n#quiz-2 button.locked {\n  pointer-events: none;\n}\n\n\/* SUMMARY *\/\n#quiz-2 .final-summary {\n  margin-top: 40px;\n  padding: 20px;\n  border-radius: 14px;\n  background: #fafafa;\n  border: 2px solid #4caf50;\n}\n\n#quiz-2 .final-summary h3 {\n  text-align: center;\n  margin-bottom: 20px;\n}\n\n#quiz-2 .summary-row {\n  display: grid;\n  grid-template-columns: 120px 1fr 40px;\n  gap: 10px;\n  align-items: center;\n  margin-bottom: 12px;\n  font-weight: bold;\n}\n\n#quiz-2 .summary-bar {\n  height: 14px;\n  background: #ddd;\n  border-radius: 10px;\n  overflow: hidden;\n}\n\n#quiz-2 .bar-fill {\n  height: 100%;\n  width: 0%;\n}\n\n#quiz-2 .bar-attempted { background: #2196f3; }\n#quiz-2 .bar-correct { background: #4caf50; }\n#quiz-2 .bar-wrong { background: #f44336; }\n#quiz-2 .bar-unattempted { background: #9e9e9e; width: 100%; }\n\n#quiz-2 .final-score {\n  text-align: center;\n  font-size: 22px;\n  margin-top: 20px;\n}\n\n#quiz-2 .score-value {\n  font-size: 30px;\n  margin-left: 8px;\n}\n<\/style>\n<\/head>\n\n<body>\n<div id=\"quiz-2\">\n  <div class=\"quiz-container\">\n<div id=\"quiz-2-sticky-header\">\n  <span> Basics of MS Excel Quiz Questions (Part 2) <\/span>\n  <span id=\"quiz-2-score-badge\">Score: <strong id=\"quiz-2-score-value\">0.00<\/strong><\/span>\n<\/div>\n\n    <!-- QUESTIONS -->\n\n    <div class=\"question\" data-answered=\"false\">\n    <p>16. The keyboard shortcut to Save a file in Excel is:<\/p>\n    <button data-correct=\"false\">Ctrl + C<\/button>\n    <button data-correct=\"false\">Ctrl + V<\/button>\n    <button data-correct=\"true\">Ctrl + S<\/button>\n    <button data-correct=\"false\">Ctrl + Z<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>17. The keyboard shortcut for Undo in Excel is:<\/p>\n    <button data-correct=\"false\">Ctrl + Y<\/button>\n    <button data-correct=\"false\">Ctrl + U<\/button>\n    <button data-correct=\"false\">Ctrl + D<\/button>\n    <button data-correct=\"true\">Ctrl + Z<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>18. The keyboard shortcut for Redo in Excel is:<\/p>\n    <button data-correct=\"false\">Ctrl + Z<\/button>\n    <button data-correct=\"false\">Ctrl + R<\/button>\n    <button data-correct=\"false\">Ctrl + P<\/button>\n    <button data-correct=\"true\">Ctrl + Y<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>19. Which function key is used to edit (enter edit mode for) the active cell?<\/p>\n    <button data-correct=\"false\">F1<\/button>\n    <button data-correct=\"false\">F5<\/button>\n    <button data-correct=\"true\">F2<\/button>\n    <button data-correct=\"false\">F12<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>20. The keyboard shortcut for AutoSum is:<\/p>\n    <button data-correct=\"false\">Ctrl + =<\/button>\n    <button data-correct=\"false\">Shift + =<\/button>\n    <button data-correct=\"false\">Alt + S<\/button>\n    <button data-correct=\"true\">Alt + =<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>21. Ctrl + P in Excel is used for:<\/p>\n    <button data-correct=\"false\">Paste<\/button>\n    <button data-correct=\"false\">Pause<\/button>\n    <button data-correct=\"true\">Print<\/button>\n    <button data-correct=\"false\">Play<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>22. Ctrl + F in Excel is used for:<\/p>\n    <button data-correct=\"false\">Fill<\/button>\n    <button data-correct=\"false\">Format<\/button>\n    <button data-correct=\"false\">Filter<\/button>\n    <button data-correct=\"true\">Find<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>23. Ctrl + H in Excel is used for:<\/p>\n    <button data-correct=\"false\">Help<\/button>\n    <button data-correct=\"false\">Hide<\/button>\n    <button data-correct=\"false\">Home<\/button>\n    <button data-correct=\"true\">Replace (Find &#038; Replace)<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>24. A Workbook in Excel contains:<\/p>\n    <button data-correct=\"false\">Slides<\/button>\n    <button data-correct=\"false\">Pages<\/button>\n    <button data-correct=\"false\">Files<\/button>\n    <button data-correct=\"true\">Worksheets<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>25. A Worksheet in Excel contains:<\/p>\n    <button data-correct=\"false\">Slides<\/button>\n    <button data-correct=\"false\">Files<\/button>\n    <button data-correct=\"false\">Folders<\/button>\n    <button data-correct=\"true\">Rows and columns (cells)<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>26. The Formula Bar in Excel displays:<\/p>\n    <button data-correct=\"false\">File name<\/button>\n    <button data-correct=\"false\">Sheet name<\/button>\n    <button data-correct=\"false\">Active cell address<\/button>\n    <button data-correct=\"true\">Content\/formula of the active cell<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>27. The Name Box in Excel displays:<\/p>\n    <button data-correct=\"false\">Formula<\/button>\n    <button data-correct=\"false\">File name<\/button>\n    <button data-correct=\"false\">Sheet count<\/button>\n    <button data-correct=\"true\">Address of the active cell<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>28. The Ribbon in Excel contains:<\/p>\n    <button data-correct=\"false\">Cells<\/button>\n    <button data-correct=\"false\">Rows<\/button>\n    <button data-correct=\"false\">Columns<\/button>\n    <button data-correct=\"true\">Tabs (Home, Insert, Formulas, Data, etc.)<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>29. The IF function in Excel is used for:<\/p>\n    <button data-correct=\"false\">Adding numbers<\/button>\n    <button data-correct=\"false\">Sorting data<\/button>\n    <button data-correct=\"false\">Counting cells<\/button>\n    <button data-correct=\"true\">Conditional (logical) testing<\/button>\n<\/div>\n\n<div class=\"question\" data-answered=\"false\">\n    <p>30. The AND function returns TRUE when:<\/p>\n    <button data-correct=\"false\">Any one condition is true<\/button>\n    <button data-correct=\"false\">No conditions are true<\/button>\n    <button data-correct=\"true\">All specified conditions are true<\/button>\n    <button data-correct=\"false\">At least two conditions are true<\/button>\n<\/div>\n\n    <!-- FINAL SUMMARY -->\n    <div class=\"final-summary\">\n      <h3>Quiz Summary <\/h3>\n\n      <div class=\"summary-row\">\n        <span>Attempted<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-attempted\" data-summary=\"attempted\"><\/div><\/div>\n        <span data-count=\"attempted\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Correct<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-correct\" data-summary=\"correct\"><\/div><\/div>\n        <span data-count=\"correct\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Wrong<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-wrong\" data-summary=\"wrong\"><\/div><\/div>\n        <span data-count=\"wrong\">0<\/span>\n      <\/div>\n\n      <div class=\"summary-row\">\n        <span>Unattempted<\/span>\n        <div class=\"summary-bar\"><div class=\"bar-fill bar-unattempted\" data-summary=\"unattempted\"><\/div><\/div>\n        <span data-count=\"unattempted\">0<\/span>\n      <\/div>\n\n      <div class=\"final-score\">\n        Final Score: <span class=\"score-value\" data-score>0.0<\/span>\n      <\/div>\n    <\/div>\n\n  <\/div>\n<\/div>\n<div class=\"modal modal-obls\" id=\"modal-signup\">\n        <div class=\"modal-background\"><\/div>\n        <div class=\"modal-content\">\n           <div class=\"obls-group\" id=\"obls-group1\">\n               <div class=\"obls-blk\">\n                   <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/img-delivery.svg\" alt=\"\"><\/span>\n                   <h2 id=\"display-register-text\"><span class=\"ez-toc-section\" id=\"Sign_Up-2\"><\/span>Sign Up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                   <div class=\"loginas-group loginas-group1 loginas-group-single\">\n <div id=\"g_id_onload\" data-client_id=\"506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com\" ,=\"\" data-use_fedcm_for_prompt=\"true\" data-callback=\"handleOnetapResponse\">\n    <\/div>\n    <div class=\"g_id_signin\" data-type=\"standard\"><div class=\"S9gUrf-YoZ4jf\" style=\"position: relative;\"><div><\/div><iframe src=\"https:\/\/accounts.google.com\/gsi\/button?type=standard&amp;is_fedcm_supported=true&amp;client_id=506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com&amp;iframe_id=gsi_437394_8652&amp;cas=pwXumGxyCMNtIbjaV30qchi2A1vUar%2Faz%2FOE5HQ%2B0Zc\" class=\"L5Fo6c-PQbLGe\" allow=\"identity-credentials-get\" id=\"gsi_437394_8652\" title=\"Sign in with Google Button\" style=\"display: block; position: relative; top: 0px; left: 0px; height: 44px; width: 204px; border: 0px; margin: -2px -10px;\"><\/iframe><\/div><\/div>\n                   <\/div>\n                   <h6 class=\"signup-subheader\">Or, register with email<\/h6>\n                   <label class=\"errormsg txt-red courseUp\"><\/label>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                        <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"course-uemail\" required=\"\">\n                        <span class=\"floating-label\" style=\"top: 19px; font-size: 12px;\">Email Id<\/span>\n                   <\/div>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mobile-black.svg\" alt=\"\"><\/span>\n                        <input type=\"text\" maxlength=\"10\" name=\"monum\" class=\"formcontrol ob-inputfield\" id=\"course-uphone\" required=\"\">\n                        <span class=\"floating-label\">Mobile Number<\/span>\n                   <\/div>\n                   <div class=\"formcontrol-group\">\n                        <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-lock.svg\" alt=\"\"><\/span>\n                        <input type=\"password\" name=\"pwd\" class=\"formcontrol ob-inputfield\" id=\"course-upassword\" required=\"\">\n                        <span class=\"floating-label\">Password<\/span>\n                   <\/div>\n                   <button type=\"button\" class=\"btn btn-md btn-tblue btn-obls\" onclick=\"courseUpValidation('home','IBPS','https:\/\/u1.oliveboard.in\/exams\/?c=dashboard&amp;i=common');return false;\" id=\"courseup\">REGISTER<\/button>\n                    <p class=\"obls-footer\">Already a user?<button type=\"button\" class=\"btn btn-xs btn-switch-obls btn-show-modal-login\" id=\"btn-show-modal-login\">Login<\/button><\/p>\n               <\/div> \n            <\/div> \n        <\/div>\n        <button class=\"modal-close is-large modal-obls-close\" aria-label=\"close\"><\/button>\n    <\/div>\n\n<div class=\"modal modal-obls\" id=\"modal-login\">\n        <div class=\"modal-background\"><\/div>\n        <div class=\"modal-content\">\n           <div class=\"obls-group\" id=\"obls-group2\">\n               <div class=\"obls-blk\">\n                   <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/img-run-health.svg\" alt=\"\"><\/span>\n                   <div id=\"login-group-abc\" class=\"lfp-group-abc\"><!-- start login group -->\n                       <h2><span class=\"ez-toc-section\" id=\"Login-2\"><\/span>Login<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                       <label class=\"errormsg txt-red courseIn\"><\/label>\n                       <div class=\"formcontrol-group disable-loginemail\">\n                            <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                            <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"course-email\" required=\"\">\n                            <span class=\"floating-label\">Email Id<\/span>\n                       <\/div>\n                       <div class=\"loginnext-group\" id=\"loginnext-group\"><!-- pass and captcha -->\n                           <div class=\"formcontrol-group\">\n                                <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-lock.svg\" alt=\"\"><\/span>\n                                <input type=\"password\" name=\"pwd\" class=\"formcontrol ob-inputfield\" id=\"course-password\" required=\"\">\n                                <span class=\"floating-label\">Password<\/span>\n                           <\/div>\n                           <div style=\"display:none\" id=\"img-oblcaptcha\" class=\"captcha-img-blk\">\n                           <\/div>\n                           <div style=\"display:none\" class=\"formcontrol-group captcha-input-blk\">\n                                <input type=\"text\" name=\"pwd1\" value=\"1\" class=\"formcontrol ob-inputfield\" id=\"lcaptcha-code\" required=\"\">\n                                <span class=\"floating-label\">Enter text you see in the image<\/span>\n                           <\/div>\n                       <\/div><!-- pass and captcha -->\n                       \n                       <div class=\"btn-forgotpwd-group\"><button id=\"btn-forgotpwd\" class=\"btn btn-forgotpwd\">Forgot Password?<\/button><\/div>\n                       <button type=\"button\" id=\"coursein1\" class=\"btn btn-md btn-tblue btn-obls\" onclick=\"courseInValidation1()\">Next<\/button>\n                       <button type=\"button\" id=\"coursein\" class=\"btn btn-md btn-tblue btn-obls coursein\" onclick=\"courseInValidation('https:\/\/u1.oliveboard.in\/exams\/?c=dashboard&amp;i=common')\">Submit<\/button>\n                       <form method=\"post\" action=\"https:\/\/login.oliveboard.in\/login\/next.php\" id=\"snf1\">\n                        <input type=\"hidden\" name=\"email\" value=\"\" id=\"lemailnext\">\n                        <\/form>\n                   <\/div><!-- end login group -->\n                   <div id=\"forgotpwd-group-abc\" class=\"lfp-group-abc forgotpwd-group-abc\"><!-- start forgotpwd group -->\n                       <h2><span class=\"ez-toc-section\" id=\"Forgot_Password-2\"><\/span>Forgot Password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                       <p class=\"secintro-txt\">Please enter the Email ID we will send you a Email with the link to reset the password.<\/p>\n                       <label class=\"errormsg txt-red rePassMsg\"><\/label>\n                       <div class=\"formcontrol-group formcontrol-group-fp\">\n                            <span class=\"icon\"><img decoding=\"async\" src=\"\/img\/ic-mail.svg\" alt=\"\"><\/span>\n                            <input type=\"email\" name=\"email\" class=\"formcontrol ob-inputfield\" id=\"remail\" required=\"\">\n                            <span class=\"floating-label\">Email Id<\/span>\n                       <\/div>\n                       <div class=\"loginas-group loginas-group1\">\n                            <button type=\"button\" id=\"btn-fpwd-cancel\" class=\"btn btn-md btn-white btn-cancel btn-fpwd-cancel\">Cancel<\/button>\n                            <button type=\"button\" id=\"lreset\" class=\"btn btn-md btn-tblue btn-fpwd-submit\" onclick=\"resetPassword()\">Submit<\/button>\n                       <\/div>\n                    <\/div><!-- end forgotpwd group --> \n                   <h6 class=\"login-subheader\">Or, login with<\/h6>\n                   <div class=\"loginas-group loginas-group2 loginas-group-single\">\n\n <div id=\"g_id_onload\" data-client_id=\"506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com\" ,=\"\" data-use_fedcm_for_prompt=\"true\" data-callback=\"handleOnetapResponse\">\n    <\/div>\n    <div class=\"g_id_signin\" data-type=\"standard\"><div class=\"S9gUrf-YoZ4jf\" style=\"position: relative;\"><div><div tabindex=\"0\" role=\"button\" aria-labelledby=\"button-label\" class=\"nsm7Bb-HzV7m-LgbsSe  hJDwNd-SxQuSe i5vt6e-Ia7Qfc uaxL4e-RbRzK\"><div class=\"nsm7Bb-HzV7m-LgbsSe-MJoBVe\"><\/div><div class=\"nsm7Bb-HzV7m-LgbsSe-bN97Pc-sM5MNb \"><div class=\"nsm7Bb-HzV7m-LgbsSe-Bz112c\"><svg version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 48\" class=\"LgbsSe-Bz112c\"><g><path fill=\"#EA4335\" d=\"M24 9.5c3.54 0 6.71 1.22 9.21 3.6l6.85-6.85C35.9 2.38 30.47 0 24 0 14.62 0 6.51 5.38 2.56 13.22l7.98 6.19C12.43 13.72 17.74 9.5 24 9.5z\"><\/path><path fill=\"#4285F4\" d=\"M46.98 24.55c0-1.57-.15-3.09-.38-4.55H24v9.02h12.94c-.58 2.96-2.26 5.48-4.78 7.18l7.73 6c4.51-4.18 7.09-10.36 7.09-17.65z\"><\/path><path fill=\"#FBBC05\" d=\"M10.53 28.59c-.48-1.45-.76-2.99-.76-4.59s.27-3.14.76-4.59l-7.98-6.19C.92 16.46 0 20.12 0 24c0 3.88.92 7.54 2.56 10.78l7.97-6.19z\"><\/path><path fill=\"#34A853\" d=\"M24 48c6.48 0 11.93-2.13 15.89-5.81l-7.73-6c-2.15 1.45-4.92 2.3-8.16 2.3-6.26 0-11.57-4.22-13.47-9.91l-7.98 6.19C6.51 42.62 14.62 48 24 48z\"><\/path><path fill=\"none\" d=\"M0 0h48v48H0z\"><\/path><\/g><\/svg><\/div><span class=\"nsm7Bb-HzV7m-LgbsSe-BPrWId\">Sign in with Google<\/span><span class=\"L6cTce\" id=\"button-label\">Sign in with Google. Opens in new tab<\/span><\/div><\/div><\/div><iframe src=\"https:\/\/accounts.google.com\/gsi\/button?type=standard&amp;is_fedcm_supported=true&amp;client_id=506321490093-i3j96ah9gn1sv3khntnd1rnv5jebt5j4.apps.googleusercontent.com&amp;iframe_id=gsi_437400_306436&amp;cas=pwXumGxyCMNtIbjaV30qchi2A1vUar%2Faz%2FOE5HQ%2B0Zc\" class=\"L5Fo6c-PQbLGe\" allow=\"identity-credentials-get\" id=\"gsi_437400_306436\" title=\"Sign in with Google Button\" style=\"display: block; position: relative; top: 0px; left: 0px; height: 0px; width: 0px; border: 0px;\"><\/iframe><\/div><\/div>\n\n\n                   <\/div>\n                    <p class=\"obls-footer\">New to Oliveboard?<button class=\"btn btn-xs btn-switch-obls\" id=\"btn-show-modal-signup\">Register<\/button><\/p>\n               <\/div> \n            <\/div> \n            <div class=\"success-msg-group\" id=\"success-msg-group\"><!-- success msg -->\n                <div class=\"success-msg-blk\" id=\"success-msg-blk\">\n                    <span class=\"img-box\"><img decoding=\"async\" src=\"\/img\/success-ellipse.svg\" alt=\"\"><\/span>\n                    <h2 id=\"fpwd-success-msg-title\"><span class=\"ez-toc-section\" id=\"i-2\"><\/span>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n                    <p id=\"fpwd-success-msg-text\">&nbsp;<\/p>\n                    <div class=\"login-btn\">\n                        <button type=\"button\" class=\"btn btn-md btn-tblue modal-obls-close\">Ok<\/button>\n                    <\/div>\n\n                <\/div>\n            <\/div><!-- success msg -->\n\n        <\/div>\n        <button class=\"modal-close is-large modal-obls-close\" aria-label=\"close\"><\/button>\n    <\/div>\n\n<script src=\"https:\/\/s3-ap-southeast-1.amazonaws.com\/sg2.oliveboard.in\/static\/js\/jquery.js\"><\/script>\n\n<script>\nvar boxurl = window.location.href + '?log=1';\n\nfunction getUrlParam(name, defaultValue) {\n    const params = new URLSearchParams(window.location.search);\n    return params.has(name) ? params.get(name) : defaultValue;\n}\n\nvar l_log = getUrlParam('log', 0);\n<\/script>\n<script src=\"https:\/\/www.oliveboard.in\/js\/coursecommon.js?v=12\"><\/script>\n\n\n<script>\n(() => {\n  const quizContainer = document.getElementById('quiz-2');\n  const STORAGE_KEY = 'quiz_2_state';\n  let score = 0;\n  let attempted = 0;\n  let correct = 0;\n  let wrong = 0;\n\n  const questions = quizContainer.querySelectorAll(\".question\");\n  const total = questions.length;\n\n  function loadState() {\n    try { return JSON.parse(sessionStorage.getItem(STORAGE_KEY) || '{}'); }\n    catch { return {}; }\n  }\n\n  function saveState(data) {\n    sessionStorage.setItem(STORAGE_KEY, JSON.stringify(data));\n  }\n\n  function updateUI() {\n    const unattempted = total - attempted;\n    quizContainer.querySelector('[data-count=\"attempted\"]').textContent = attempted;\n    quizContainer.querySelector('[data-count=\"correct\"]').textContent = correct;\n    quizContainer.querySelector('[data-count=\"wrong\"]').textContent = wrong;\n    quizContainer.querySelector('[data-count=\"unattempted\"]').textContent = unattempted;\n    quizContainer.querySelector('[data-summary=\"attempted\"]').style.width = (attempted \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"correct\"]').style.width = (correct \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"wrong\"]').style.width = (wrong \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-summary=\"unattempted\"]').style.width = (unattempted \/ total) * 100 + \"%\";\n    quizContainer.querySelector('[data-score]').textContent = score.toFixed(2);\n\n    \/\/ Live score update in sticky header\n    document.getElementById('quiz-2-score-value').textContent = score.toFixed(2);\n  }\n\n  function restoreQuestion(q, chosenIndex, wasCorrect) {\n    q.dataset.answered = \"true\";\n    const buttons = q.querySelectorAll(\"button\");\n    buttons.forEach(b => b.classList.add(\"locked\"));\n    if (wasCorrect) {\n      buttons[chosenIndex].classList.add(\"correct\");\n    } else {\n      buttons[chosenIndex].classList.add(\"wrong\");\n      q.querySelector(\"[data-correct='true']\").classList.add(\"correct\");\n    }\n  }\n\n  \/\/ Restore saved answers on page load\n  const savedAnswers = loadState();\nquestions.forEach((q, qIndex) => {\n    const saved = savedAnswers[qIndex];\n    if (saved !== undefined) {\n      attempted++;\n      if (saved.correct) { correct++; }\n      else { wrong++; }\n      restoreQuestion(q, saved.chosenIndex, saved.correct);\n    }\n  });\n  score = parseFloat((correct * 1 - wrong * 0.25).toFixed(2));\n  updateUI();\n\n  \/\/ Attach click handlers\n  questions.forEach((q, qIndex) => {\n    q.querySelectorAll(\"button\").forEach((btn, btnIndex) => {\n      btn.addEventListener(\"click\", () => {\n        if (q.dataset.answered === \"true\") return;\n        q.dataset.answered = \"true\";\n        attempted++;\n\n        if (attempted > 7 && l_log == 0) {\n          $('#modal-signup').addClass('is-active');\n        }\n\n        q.querySelectorAll(\"button\").forEach(b => b.classList.add(\"locked\"));\n        const isCorrect = btn.dataset.correct === \"true\";\n\n if (isCorrect) {\n          btn.classList.add(\"correct\");\n          correct++;\n        } else {\n          btn.classList.add(\"wrong\");\n          wrong++;\n          q.querySelector(\"[data-correct='true']\").classList.add(\"correct\");\n        }\n        score = parseFloat((correct * 1 - wrong * 0.25).toFixed(2));\n\n        savedAnswers[qIndex] = { chosenIndex: btnIndex, correct: isCorrect };\n        saveState(savedAnswers);\n        updateUI();\n      });\n    });\n  });\n\n  updateUI();\n})();\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.oliveboard.in\/blog\/computer-awareness-quiz\/?ref=conttm-computer-awareness\" target=\"_blank\" rel=\"noreferrer noopener\">download 500 computer awareness questions PDF<\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<ul class=\"wp-block-latest-posts__list is-grid columns-3 wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/sbi-po-scorecard\/\">SBI PO Scorecard 2026 Out, Download Prelims Scorecard, Check Marks<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/sbi-clerk-vs-sbi-po-exams-major-differences\/\">SBI Clerk vs SBI PO: Which Exam is Better?<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/phrase-replacement-questions-for-sbi-po\/\">Phrase Replacement Questions for SBI PO Mains, FREE PDF &amp; Live Quiz<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/data-interpretation-questions-for-sbi-po\/\">Data Interpretation Questions for SBI PO Mains, FREE PDF &amp; Live Quiz<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/order-and-ranking-questions-for-sbi-po\/\">Order and Ranking Questions for SBI PO Mains, FREE PDF &amp; Live Quiz<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/www.oliveboard.in\/blog\/alphanumeric-series-questions-for-sbi-po\/\">Alphanumeric Series Questions for SBI PO Mains, FREE PDF &amp; Quiz<\/a><\/li>\n<\/ul>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Basics of MS Excel is an important topic in computer awareness for competitive exams like SBI PO. Microsoft Excel is<\/p>\n","protected":false},"author":60,"featured_media":246384,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,31,10224,33],"tags":[18578,111],"class_list":["post-106641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-bank-exams","category-sbi","category-sbi-po","tag-basics-of-ms-excel-for-sbi-po","tag-sbi-po","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.6 (Yoast SEO v26.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz<\/title>\n<meta name=\"description\" content=\"Download Basics of MS Excel PDF for SBI PO Exam. Learn formulas, functions, rows, columns and improve speed with live quizzes and practice sets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz\" \/>\n<meta property=\"og:description\" content=\"Basics of MS Excel is an important topic in computer awareness for competitive exams like SBI PO. Microsoft Excel is a spreadsheet program used to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Oliveboard\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Oliveboard\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-26T11:01:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-26T11:01:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"730\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Tripti Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Oliveboard\" \/>\n<meta name=\"twitter:site\" content=\"@Oliveboard\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tripti Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"NewsArticle\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\"},\"author\":{\"name\":\"Tripti Mishra\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/d85e63b0781e1a55771b9894184814a5\"},\"headline\":\"Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz\",\"datePublished\":\"2026-06-26T11:01:20+00:00\",\"dateModified\":\"2026-06-26T11:01:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\"},\"wordCount\":844,\"publisher\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp\",\"keywords\":[\"Basics of MS Excel for SBI PO\",\"SBI PO\"],\"articleSection\":[\"Articles\",\"Bank Exams\",\"SBI\",\"SBI PO\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\",\"name\":\"Basics of MS Excel for SBI PO Exam, PDF & Live Quiz\",\"isPartOf\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp\",\"datePublished\":\"2026-06-26T11:01:20+00:00\",\"dateModified\":\"2026-06-26T11:01:24+00:00\",\"description\":\"Download Basics of MS Excel PDF for SBI PO Exam. Learn formulas, functions, rows, columns and improve speed with live quizzes and practice sets.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp\",\"contentUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp\",\"width\":730,\"height\":480,\"caption\":\"Basics of MS Excel for SBI PO Exam\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bank Exams\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SBI\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/sbi\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"SBI PO\",\"item\":\"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/sbi\/sbi-po\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Basics of Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#website\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/\",\"name\":\"Oliveboard\",\"description\":\"Free Govt. Exam Alerts &amp; Resources\",\"publisher\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.oliveboard.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#organization\",\"name\":\"Oliveboard\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png\",\"contentUrl\":\"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png\",\"width\":150,\"height\":40,\"caption\":\"Oliveboard\"},\"image\":{\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Oliveboard\",\"https:\/\/x.com\/Oliveboard\",\"https:\/\/www.instagram.com\/oliveboard.in\/\",\"https:\/\/www.youtube.com\/channel\/UCRvrHAyNdOMI_JBkE2pjZtw?sub_confirmation=1\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/d85e63b0781e1a55771b9894184814a5\",\"name\":\"Tripti Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e9ff3153b7365669b619433e04937baec4da53cdb38c345d8283a33479dba3b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e9ff3153b7365669b619433e04937baec4da53cdb38c345d8283a33479dba3b6?s=96&d=mm&r=g\",\"caption\":\"Tripti Mishra\"},\"description\":\"Hi, I'm Tripti, a senior content writer at Oliveboard, where I manage blog content along with community engagement across platforms like Telegram and WhatsApp. With 3+ years of experience in content and SEO optimization related to banking exams, I have led content for popular exams like SSC, banking, railway, and state exams.\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Basics of MS Excel for SBI PO Exam, PDF & Live Quiz","description":"Download Basics of MS Excel PDF for SBI PO Exam. Learn formulas, functions, rows, columns and improve speed with live quizzes and practice sets.","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:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz","og_description":"Basics of MS Excel is an important topic in computer awareness for competitive exams like SBI PO. Microsoft Excel is a spreadsheet program used to","og_url":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/","og_site_name":"Oliveboard","article_publisher":"https:\/\/www.facebook.com\/Oliveboard","article_published_time":"2026-06-26T11:01:20+00:00","article_modified_time":"2026-06-26T11:01:24+00:00","og_image":[{"width":730,"height":480,"url":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp","type":"image\/webp"}],"author":"Tripti Mishra","twitter_card":"summary_large_image","twitter_creator":"@Oliveboard","twitter_site":"@Oliveboard","twitter_misc":{"Written by":"Tripti Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/"},"author":{"name":"Tripti Mishra","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/d85e63b0781e1a55771b9894184814a5"},"headline":"Basics of MS Excel for SBI PO Exam, PDF &amp; Live Quiz","datePublished":"2026-06-26T11:01:20+00:00","dateModified":"2026-06-26T11:01:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/"},"wordCount":844,"publisher":{"@id":"https:\/\/www.oliveboard.in\/blog\/#organization"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp","keywords":["Basics of MS Excel for SBI PO","SBI PO"],"articleSection":["Articles","Bank Exams","SBI","SBI PO"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/","url":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/","name":"Basics of MS Excel for SBI PO Exam, PDF & Live Quiz","isPartOf":{"@id":"https:\/\/www.oliveboard.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp","datePublished":"2026-06-26T11:01:20+00:00","dateModified":"2026-06-26T11:01:24+00:00","description":"Download Basics of MS Excel PDF for SBI PO Exam. Learn formulas, functions, rows, columns and improve speed with live quizzes and practice sets.","breadcrumb":{"@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#primaryimage","url":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp","contentUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2022\/11\/Basics-of-MS-Excel-for-SBI-PO-Exam.webp","width":730,"height":480,"caption":"Basics of MS Excel for SBI PO Exam"},{"@type":"BreadcrumbList","@id":"https:\/\/www.oliveboard.in\/blog\/basics-of-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oliveboard.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Bank Exams","item":"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/"},{"@type":"ListItem","position":3,"name":"SBI","item":"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/sbi\/"},{"@type":"ListItem","position":4,"name":"SBI PO","item":"https:\/\/www.oliveboard.in\/blog\/category\/bank-exams\/sbi\/sbi-po\/"},{"@type":"ListItem","position":5,"name":"Basics of Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.oliveboard.in\/blog\/#website","url":"https:\/\/www.oliveboard.in\/blog\/","name":"Oliveboard","description":"Free Govt. Exam Alerts &amp; Resources","publisher":{"@id":"https:\/\/www.oliveboard.in\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oliveboard.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.oliveboard.in\/blog\/#organization","name":"Oliveboard","url":"https:\/\/www.oliveboard.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png","contentUrl":"https:\/\/www.oliveboard.in\/blog\/wp-content\/uploads\/2021\/11\/logo.png","width":150,"height":40,"caption":"Oliveboard"},"image":{"@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Oliveboard","https:\/\/x.com\/Oliveboard","https:\/\/www.instagram.com\/oliveboard.in\/","https:\/\/www.youtube.com\/channel\/UCRvrHAyNdOMI_JBkE2pjZtw?sub_confirmation=1"]},{"@type":"Person","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/d85e63b0781e1a55771b9894184814a5","name":"Tripti Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.oliveboard.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e9ff3153b7365669b619433e04937baec4da53cdb38c345d8283a33479dba3b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9ff3153b7365669b619433e04937baec4da53cdb38c345d8283a33479dba3b6?s=96&d=mm&r=g","caption":"Tripti Mishra"},"description":"Hi, I'm Tripti, a senior content writer at Oliveboard, where I manage blog content along with community engagement across platforms like Telegram and WhatsApp. With 3+ years of experience in content and SEO optimization related to banking exams, I have led content for popular exams like SSC, banking, railway, and state exams."}]}},"_links":{"self":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/106641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/users\/60"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/comments?post=106641"}],"version-history":[{"count":11,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/106641\/revisions"}],"predecessor-version":[{"id":246385,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/posts\/106641\/revisions\/246385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/media\/246384"}],"wp:attachment":[{"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/media?parent=106641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/categories?post=106641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oliveboard.in\/blog\/wp-json\/wp\/v2\/tags?post=106641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}