In Excel, what is a data series?

B. A row or column of numbers that are plotted in a chart

A. A collection of worksheets in a workbook

B. A row or column of numbers that are plotted in a chart

C. A set of formatting rules applied to cells

D. A formula that performs calculations across multiple sheets

In MS Excel 2016, which option is used to split the window into two panes?

C. View > Window > Freeze Panes

Computer · page 1 of 3

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

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

Practice MS Excel in the app All Computer MCQs by topic

MS Excel MCQs with answers

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.
Past Paper MCQ
Which feature in MS Excel is used for organizing data in ascending or descending order?
Correct Answer: B
One-liner
The feature used for organizing data in ascending or descending order in MS Excel is Data Sort.
2.
Past Paper MCQ
In Microsoft Excel, what do the letters at the top of the spreadsheet represent?
Correct Answer: B
One-liner
In Microsoft Excel, the letters at the top of the spreadsheet represent columns.
3.
Past Paper MCQ
What is a group of cells called in Microsoft Excel?
Correct Answer: A
One-liner
A group of cells in Microsoft Excel is called a Cell Range.
4.
Past Paper MCQ
In Excel, what is a data series?
Correct Answer: B
One-liner
In Excel, a data series is a row or column of numbers that are plotted in a chart.
5.
Past Paper MCQ
In MS Excel 2016, which option is used to split the window into two panes?
Correct Answer: A
One-liner
In MS Excel 2016, the View > Window > Split option is used to divide the worksheet window into two or four independently scrollable panes.
6.
Past Paper MCQ
Which program in Microsoft Office is used for creating spreadsheets?
Correct Answer: B
One-liner
Microsoft Excel is the program in Microsoft Office used for creating spreadsheets.
7.
Past Paper MCQ
Which button in MS Excel is used to quickly sum a series of numbers?
Correct Answer: A
One-liner
The AutoSum Button in MS Excel is used to quickly sum a series of numbers.
8.
Past Paper MCQ
What symbol is used in Excel to include all cells between two cell references?
Correct Answer: A
One-liner
In Excel, the single colon (:) is used as the range operator to include all cells between two cell references.
9.
Past Paper MCQ
Which data type is considered valid in MS Excel?
Correct Answer: A
One-liner
Boolean is a valid data type in MS Excel, used to represent TRUE/FALSE logical values.
10.
Past Paper MCQ
When you press which key does the cell in MS Excel accept your typing as its contents?
Correct Answer: B
One-liner
Pressing the Enter key in MS Excel accepts your typing as the cell's contents and moves the cursor to the cell below.

Previous: MS Word MCQs Next: MS PowerPoint MCQs

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.

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

MS Excel MCQs with answers

MS Excel MCQs — common questions

Subjects

Exams

Platform

Legal