Skip to content

Computer · page 2 of 3

MS Excel MCQs & Past Papers – Sample 2

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

Timed quizzes, instant results, track your progress — free

Practice these MCQs in the app

MS Excel MCQs (11–20)

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 on the chapter pages, 10 questions at a time.

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. 11.

    Past Paper MCQ

    Which function in Excel is used to return the remainder after a number is divided by a divisor?

  2. 12.

    Past Paper MCQ

    How can comments be added to cells in MS Excel?

  3. 13.

    Past Paper MCQ

    What is the term used for obtaining data from a cell in a different sheet in MS Excel?

  4. 14.

    Past Paper MCQ

    What is the correct formula to calculate the sum of cells A1 and A2 in MS Excel?

  5. 15.

    Past Paper MCQ

    In Excel, what is the process of transferring data to the next worksheet called?

  6. 16.

    Past Paper MCQ

    What is the graphical representation of data commonly called?

  7. 17.

    Past Paper MCQ

    To automatically adjust the width of a column in MS Excel, which action should you perform?

  8. 18.

    Past Paper MCQ

    What is the name of the topmost bar in an Excel window when you first open it?

  9. 19.

    Past Paper MCQ

    How can you display or hide the gridlines in an Excel worksheet?

  10. 20.

    Past Paper MCQ

    In MS Excel, how is the cell entry 'July 16, 2016' categorized?

Full MS Excel chapters

MS Excel MCQs — common questions

Are these MS Excel MCQs with answers?
Yes. Each question on this page can be attempted here, with the correct option and a one-liner. This URL is a sample of 30 MS Excel MCQs across 3 pages. The rest of the Computer questions are on the chapter pages, 10 MCQs per page.
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