Free MS Excel MCQs for one-paper tests in Pakistan: formulas and functions, cell referencing, charts, formatting, sorting and filtering, and keyboard shortcuts — essential preparation for Data Entry Operator, Computer Operator, accounts and all FPSC, PPSC and NTS tests.
20 of 500 MS Excel questions, shown with their correct answers — open an answer to check yourself, then practice the full set free.
What does pressing Ctrl+Home do in a worksheet?easy
Correct answer: Moves the active cell to A1 (when panes are not frozen)
What does the Consolidate command do?medium
A live look at what's newest across TestGenius
What is the decimal value of the binary number 1101?
Practice thisThe dyer is dyeing the yarn.
Practice thisBrezhnev, the name borne from 1982 to 1988 in honour of the Soviet leader by a city on the Kama River in Tatarstan, is the present-day Russian city of:
Practice 500 MS Excel multiple-choice questions from General Knowledge, covering easy, medium and hard level questions (200 easy, 200 medium, 100 hard). Attempt a batch, check each answer instantly and repeat as often as you like — free, with no signup. Explore more subjects in General Knowledge.
MS Excel sits in General Knowledge and currently has 500 practice questions: 40% easy, 40% medium, 20% hard. This set leans towards easier questions, which makes it a comfortable starting point before moving on to harder material.
With 500 questions, doing about 25 a day would take roughly 20 days to complete once, so splitting it into weekly targets works best.
Examples of questions in this subject:
There are 500 MS Excel MCQs on TestGenius (200 easy, 200 medium, 100 hard), as part of General Knowledge. You can practise all of them free on this page.
Yes. MS Excel practice on TestGenius is completely free and guest practice needs no signup. Creating a free account unlocks unlimited questions, timed quizzes and certificates.
Yes. A sample of MS Excel questions with their correct answers is shown on this page, and in the practice session every answer is checked instantly as you attempt it.
Work through the MS Excel questions in batches, review each correct answer after you attempt it, and repeat the questions you got wrong until you can answer them confidently. Then take a timed quiz to check yourself under exam pressure.
Correct answer: Combines values from several ranges or sheets into one summary, for example adding monthly sheets into a yearly total
Why is IFERROR often placed around a division formula?hard
Correct answer: So a divide-by-zero or other error shows a chosen value instead of an error code
Three students score 60, 75 and 90 marks. What is their average?medium
Correct answer: 75
TRUNC(-3.5) differs from INT(-3.5) because TRUNC:easy
Correct answer: Simply removes the fractional part, giving -3
What does Ctrl+D do when cells below a filled cell are selected?easy
Correct answer: Copies the contents of the top cell down through the selection (Fill Down)
From Monday 9 November 2026 to Friday 13 November 2026, what does NETWORKDAYS return with no holidays?hard
Correct answer: 5
What does the MINUTE function return for the time 1:30 PM?medium
Correct answer: 30
What is the default font in a new Excel workbook?easy
Correct answer: Calibri, size 11
What is the result of the formula =5*2+3?hard
Correct answer: 13
A manager wants to count orders that are both from the North region and worth more than Rs 1,000. Which function counts cells meeting both conditions at once?easy
Correct answer: COUNTIFS
Where can the full contents of the active cell be seen and edited?easy
Correct answer: In the formula bar
A price list has the product code in column B and the price in column A. Which function can find the price by looking up the code?medium
Correct answer: XLOOKUP
The last column of a worksheet is labelled with which letters?hard
Correct answer: XFD
How is data sorted first by department and then by salary within each department?medium
Correct answer: By adding a second level in the Sort dialog
What does a waterfall chart show?easy
Correct answer: How a starting value increases and decreases through intermediate values to reach an ending value
Which shortcut hides the selected columns?easy
Correct answer: Ctrl+0
What does the COUNT function count within a range?medium
Correct answer: Cells that contain numbers
Which statement about text returned by LEFT, RIGHT and MID is correct?hard
Correct answer: Numbers extracted with these functions are stored as text and may not calculate until converted
What does Wrap Text do in a cell containing a long entry?medium
Correct answer: Displays the entry on several lines within the cell by widening its row display
MS Excel sits in General Knowledge and currently has 500 practice questions: 40% easy, 40% medium, 20% hard. This set leans towards easier questions, which makes it a comfortable starting point before moving on to harder material.
Yes — signed-in users can take a timed quiz in any subject and earn a certificate by passing it. Practice mode itself is untimed and does not issue certificates.