Start practising

Topic / 65 questions

MS Excel MCQs

MS Excel MCQs are multiple-choice questions about Microsoft Excel, the spreadsheet program, covering cells, workbooks, formulas, functions, toolbars and keyboard shortcuts. They help candidates preparing for computer sections of NTS, PPSC, FPSC, SSC CGL and IBPS tests. Each question displays its correct answer instantly, so you can revise practical spreadsheet knowledge efficiently.

Advertisement
Advertisement
Advertisement

About MS Excel MCQs

This category tests the everyday features of Excel. Questions ask where the active cell address is shown, which function counts numeric entries, what the title bar displays, which key opens help and which symbol every formula must start with. Others check basic workbook tasks, such as opening an existing file from a toolbar, and how a cell accepts typed content when you press a key.

Some questions apply arithmetic inside a spreadsheet, for example evaluating a formula with brackets using the correct order of operations, or identifying examples of spreadsheet software. Computer awareness sections of clerical, assistant and bank recruitment tests regularly include Excel because it is used in almost every office. Practising these questions helps you answer quickly and also improves your real-world skills.

Key facts to remember

  • Every formula in Excel begins with an equals sign (=).
  • The Name Box displays the address of the currently selected cell.
  • The COUNT function counts cells containing numbers in a given range.
  • Pressing the F1 key opens the Help window in Microsoft Excel.
  • An Excel file is called a workbook and contains one or more worksheets.

Exams that include MS Excel MCQs

Pakistan

  • NTS
  • PPSC
  • FPSC
  • SPSC
  • KPPSC
  • Banking job tests

India

  • SSC CGL
  • SSC CHSL
  • IBPS PO
  • IBPS Clerk
  • SBI PO
  • RRB NTPC

Bangladesh

  • Bank job exams
  • Bangladesh Bank recruitment
  • BCS
  • Government job tests

How to prepare for MS Excel MCQs

  1. Open Excel while practising and try each function or shortcut yourself, which makes the answers far easier to remember.
  2. Learn the difference between COUNT, COUNTA and COUNTIF, since examiners often place them together as options.
  3. Memorise common shortcuts such as F1 for help, F2 to edit a cell and Ctrl+S to save.
  4. Apply BODMAS carefully when evaluating formulas, because Excel follows the standard order of operations.

Frequently asked questions

What topics are covered in MS Excel MCQs?

MS Excel MCQs cover the Excel interface, cells, rows and columns, workbooks and worksheets, formulas and operators, common functions such as SUM, AVERAGE and COUNT, charts, formatting, toolbars and keyboard shortcuts. Questions are usually practical and focus on how everyday tasks are done.

How many MS Excel MCQs are on MCQs360?

There are 68 MS Excel MCQs on MCQs360, each with an instant answer. You can practise free with no sign-up and pair them with MS Word and other MS Office categories to prepare fully for computer awareness sections.

Which exams ask MS Excel MCQs?

Excel questions appear in computer sections of NTS, PPSC, FPSC, SPSC and KPPSC tests for clerical and assistant posts, and in banking job tests in Pakistan. In India they are part of computer awareness in SSC, IBPS, SBI and RRB exams. In Bangladesh they appear in bank job exams and government recruitment.

What is the difference between COUNT and COUNTA in Excel?

COUNT counts only cells that contain numbers within a range. COUNTA counts all non-empty cells, including those with text, numbers, dates or error values. So if a range contains names and numbers, COUNT returns only the number of numeric cells, while COUNTA counts every filled cell.

Last reviewed October 2026