Skip to content

Computer · page 3 of 3

MS Excel MCQs with Answers for FPSC, PPSC, NTS and all One Paper Exams — page 3

MS Excel MCQs test formulas, cell references, charts and shortcuts such as F2 and Alt+=. One-paper papers stay at spreadsheet literacy, not modelling.

MS Excel MCQs (21–30)

10 questions on this page, with a one-liner under each answer. Hide answers to attempt; questions you already answered stay revealed. This is a sample of 30 MS Excel MCQs — the full Computer bank is in the study app.

Answers and one-liners are hidden. Tap an option to check that question, or show all. Questions from previously asked papers carry a Past Paper MCQ badge.

  1. 21.

    Past Paper MCQ

    What should be added before a fraction in Excel to prevent it from being interpreted as a date?

  2. 22.

    Past Paper MCQ

    Which of the following wildcard characters are used in MS Excel for pattern matching?

  3. 23.

    Past Paper MCQ

    How can you display the current date and time in MS Excel?

  4. 24.

    Past Paper MCQ

    What is the purpose of the IF function in MS Excel?

  5. 25.

    Past Paper MCQ

    In MS Excel, where is the address of the current active cell displayed?

  6. 26.

    Past Paper MCQ

    What is the outcome of the Excel formula (7-3)×(4+3)/4?

  7. 27.

    Past Paper MCQ

    The basic unit of a spreadsheet where you enter text and numbers is called a _____?

  8. 28.

    Past Paper MCQ

    Which of the following formulas is NOT correctly entered in Excel?

  9. 29.

    Past Paper MCQ

    In a spreadsheet, what do letters represent?

  10. 30.

    Past Paper MCQ

    An Excel workbook is a collection of what components?

MS Excel MCQs — common questions

Are these MS Excel MCQs with answers?
Yes. Each question on this page can be attempted here. The correct option and a one-liner are in the HTML. This is a sample set of 30 MS Excel MCQs across 3 pages. The full Computer bank is in the study app.
Are MS Excel MCQs asked in FPSC, PPSC, NTS and all One Paper Exams?
Yes. MS Excel is part of the Computer portion of most Pakistani one-paper job tests. Weighting still depends on the advertisement — use the official syllabus for your post.
Are these past paper MS Excel MCQs?
Where a question came from a previously asked paper, it carries a Past Paper MCQ badge. The rest are general practice from the same topic. The study app lets you drill past papers on their own.
How should I practise MS Excel MCQs?
Hide answers and attempt the samples on this page first. Then open Computer in the study app and drill this area until your correction rate rises. Mix a full paper only after the topic is stable.
Start studying free