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 & Past Papers

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

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 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.
Past Paper MCQ
Which feature in MS Excel is used for organizing data in ascending or descending order?
Correct Answer: B. Data Sort
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. Columns
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. Cell Range
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. A row or column of numbers that are plotted in a chart
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. View > Window > Split
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. Microsoft Excel
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. AutoSum Button
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. Single colon (:)
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. Boolean
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. Enter
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.

Full MS Excel chapters

MS Excel (404 MCQs)

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

MS Excel MCQs & Past Papers

MS Excel MCQs with answers

Full MS Excel chapters

MS Excel MCQs — common questions

Subjects

Exams

Platform

Legal