Sarkari Jobs Pakistan
Download App

MS Excel MCQs 2026

45 questions with detailed answers · 15 from past papers · 5 quiz batches available

📚 Computer Mcqs 📄 15 Past-Paper Qs ✓ Free · No Login Needed
🎯 Mock Test

Read each question, think about the answer, then click Show Answer to reveal the correct option and explanation. Load 10 at a time so it stays manageable — perfect for one-topic study sessions on the bus or during a break.

Page 1 of 1 Questions 1–10 of 45
  1. Q1 medium

    Which of these is a valid Excel formula

    1. A SUM(A1,A2)
    2. B =A1+A2+
    3. C =A1+A2
    4. D A1+A2
    💡 Explanation:

    =A1+A2 is a valid formula; formulas must start with = and be complete.

  2. Q2 medium

    A cell reference that changes when copied to another cell is a

    1. A Relative reference
    2. B Absolute reference
    3. C Fixed reference
    4. D Locked reference
    💡 Explanation:

    A relative reference adjusts automatically when the formula is copied.

  3. Q3 easy

    The cell that is currently selected and ready for input is the

    1. A Range
    2. B Merged cell
    3. C Named cell
    4. D Active cell
    💡 Explanation:

    The active cell is the currently selected cell ready to receive input.

  4. Q4 Past Paper · PPSC/FPSC/NTS easy

    MS Excel was developed by

    1. A Apple
    2. B Microsoft
    3. C Google
    4. D Oracle
    💡 Explanation:

    MS Excel is developed by Microsoft as part of MS Office.

  5. Q5 easy

    Showing only rows that meet a condition is called

    1. A Sorting
    2. B Merging
    3. C Filtering
    4. D Freezing
    💡 Explanation:

    Filtering displays only the rows that meet specified criteria.

  6. Q6 easy

    Arranging data in ascending or descending order is called

    1. A Sorting
    2. B Filtering
    3. C Merging
    4. D Wrapping
    💡 Explanation:

    Sorting arranges data in ascending or descending order.

  7. Q7 easy

    Combining several cells into one is called

    1. A Wrapping
    2. B Splitting
    3. C Filtering
    4. D Merging
    💡 Explanation:

    Merging combines two or more cells into a single larger cell.

  8. Q8 easy

    The AutoSum button quickly inserts which function

    1. A AVERAGE
    2. B COUNT
    3. C SUM
    4. D IF
    💡 Explanation:

    AutoSum inserts the SUM function for the adjacent range.

  9. Q9 easy

    Which feature automatically continues a series such as Jan, Feb, Mar

    1. A AutoFill
    2. B AutoSum
    3. C AutoCorrect
    4. D AutoSave
    💡 Explanation:

    AutoFill automatically completes a series based on a pattern.

  10. Q10 medium

    To keep the top row visible while scrolling, you use

    1. A Merge cells
    2. B Freeze Panes
    3. C Wrap Text
    4. D Auto Fit
    💡 Explanation:

    Freeze Panes keeps chosen rows or columns visible while scrolling.

  11. Q11 Past Paper · PPSC/FPSC/NTS medium

    A cell range from A1 to C3 is written as

    1. A A1-C3
    2. B A1;C3
    3. C A1,C3
    4. D A1:C3
    💡 Explanation:

    A range is written with a colon, e.g. A1:C3.

  12. Q12 easy

    Which of the following is NOT an Excel function

    1. A SUM
    2. B PARAGRAPH
    3. C AVERAGE
    4. D COUNT
    💡 Explanation:

    PARAGRAPH is not an Excel function; SUM, AVERAGE and COUNT are.

  13. Q13 easy

    To move to the next cell on the right, you press

    1. A Enter
    2. B Shift
    3. C Tab
    4. D Esc
    💡 Explanation:

    Pressing Tab moves the active cell one column to the right.

  14. Q14 medium

    The shortcut Ctrl+; (semicolon) inserts the current

    1. A Date
    2. B Time
    3. C Formula
    4. D Page number
    💡 Explanation:

    Ctrl+; inserts the current date into the active cell.

  15. Q15 medium

    The IF function in Excel is a/an

    1. A Math function
    2. B Text function
    3. C Date function
    4. D Logical function
    💡 Explanation:

    IF is a logical function that returns different results based on a condition.

  16. Q16 Past Paper · PPSC/FPSC/NTS medium

    Which function joins text from different cells

    1. A SUM
    2. B IF
    3. C COUNT
    4. D CONCATENATE
    💡 Explanation:

    CONCATENATE (or CONCAT) joins text from several cells into one.

  17. Q17 easy

    The tabs at the bottom of the Excel window represent

    1. A Rows
    2. B Worksheets
    3. C Columns
    4. D Cells
    💡 Explanation:

    The tabs at the bottom represent the worksheets in the workbook.

  18. Q18 medium

    The formula =SUM(A1:A5) will

    1. A Add A1 and A5 only
    2. B Multiply the range
    3. C Add all values from A1 to A5
    4. D Count the cells
    💡 Explanation:

    =SUM(A1:A5) adds every value in the range A1 through A5.

  19. Q19 easy

    MS Excel is mainly used for

    1. A Word processing
    2. B Presentations
    3. C Painting
    4. D Spreadsheets and calculations
    💡 Explanation:

    Excel is a spreadsheet program used for calculations, data analysis and charts.

  20. Q20 Past Paper · PPSC/FPSC/NTS easy

    A file created in MS Excel is called a

    1. A Document
    2. B Workbook
    3. C Slide
    4. D Database
    💡 Explanation:

    An Excel file is called a workbook, containing one or more worksheets.

  21. Q21 easy

    Each page within an Excel workbook is called a

    1. A Worksheet
    2. B Slide
    3. C Paragraph
    4. D Record
    💡 Explanation:

    A single page of cells in a workbook is called a worksheet.

  22. Q22 Past Paper · PPSC/FPSC/NTS easy

    The intersection of a row and a column in Excel is called a

    1. A Range
    2. B Table
    3. C Cell
    4. D Field
    💡 Explanation:

    A cell is formed at the intersection of a row and a column.

  23. Q23 Past Paper · PPSC/FPSC/NTS easy

    The default file extension of an Excel 2007 or later file is

    1. A .docx
    2. B .xlsx
    3. C .pptx
    4. D .accdb
    💡 Explanation:

    Excel 2007+ files use the .xlsx extension.

  24. Q24 Past Paper · PPSC/FPSC/NTS easy

    Every formula in Excel must begin with

    1. A A number
    2. B A letter
    3. C A space
    4. D An equal sign (=)
    💡 Explanation:

    All Excel formulas start with an equal sign (=).

  25. Q25 easy

    A cell reference is written as

    1. A Column letter followed by row number
    2. B Row number followed by column letter
    3. C Two numbers
    4. D Two letters
    💡 Explanation:

    A cell reference combines the column letter and row number, e.g. A1.

  26. Q26 Past Paper · PPSC/FPSC/NTS easy

    Which function adds a range of numbers

    1. A AVERAGE
    2. B COUNT
    3. C SUM
    4. D MAX
    💡 Explanation:

    The SUM function adds all the numbers in a range.

  27. Q27 Past Paper · PPSC/FPSC/NTS easy

    Which function returns the average of a range

    1. A SUM
    2. B AVERAGE
    3. C MAX
    4. D MIN
    💡 Explanation:

    The AVERAGE function returns the arithmetic mean of a range.

  28. Q28 easy

    Which function returns the largest value in a range

    1. A MIN
    2. B SUM
    3. C COUNT
    4. D MAX
    💡 Explanation:

    The MAX function returns the largest value in a range.

  29. Q29 easy

    Which function returns the smallest value in a range

    1. A MIN
    2. B MAX
    3. C SUM
    4. D AVERAGE
    💡 Explanation:

    The MIN function returns the smallest value in a range.

  30. Q30 Past Paper · PPSC/FPSC/NTS medium

    In Excel, $A$1 is an example of a/an

    1. A Relative reference
    2. B Mixed reference
    3. C Function
    4. D Absolute reference
    💡 Explanation:

    $A$1 is an absolute reference that does not change when copied.

  31. Q31 medium

    The symbol used to make a cell reference absolute is

    1. A &
    2. B $
    3. C #
    4. D @
    💡 Explanation:

    The dollar sign ($) locks a cell reference, making it absolute.

  32. Q32 medium

    The box that displays the reference of the active cell is the

    1. A Name Box
    2. B Formula bar
    3. C Status bar
    4. D Title bar
    💡 Explanation:

    The Name Box, left of the formula bar, shows the active cell reference.

  33. Q33 medium

    The bar that displays the contents of the active cell is the

    1. A Name Box
    2. B Status bar
    3. C Formula bar
    4. D Title bar
    💡 Explanation:

    The formula bar displays and lets you edit the contents of the active cell.

  34. Q34 easy

    By default, text entered in a cell is aligned to the

    1. A Center
    2. B Right
    3. C Top
    4. D Left
    💡 Explanation:

    Text is aligned to the left of a cell by default.

  35. Q35 easy

    By default, numbers entered in a cell are aligned to the

    1. A Left
    2. B Right
    3. C Center
    4. D Top
    💡 Explanation:

    Numbers are aligned to the right of a cell by default.

  36. Q36 easy

    A group of selected cells is called a

    1. A Range
    2. B Sheet
    3. C Book
    4. D Record
    💡 Explanation:

    A group of adjacent selected cells is called a range.

  37. Q37 easy

    The columns in Excel are labeled with

    1. A Numbers
    2. B Symbols
    3. C Letters
    4. D Roman numerals
    💡 Explanation:

    Excel columns are labeled with letters (A, B, C ...).

  38. Q38 easy

    The rows in Excel are labeled with

    1. A Letters
    2. B Symbols
    3. C Alphabets
    4. D Numbers
    💡 Explanation:

    Excel rows are labeled with numbers (1, 2, 3 ...).

  39. Q39 Past Paper · PPSC/FPSC/NTS hard

    The last column in Excel 2007 and later is

    1. A IV
    2. B XFD
    3. C ZZ
    4. D AAA
    💡 Explanation:

    In Excel 2007+, the last column is XFD (column number 16,384).

  40. Q40 Past Paper · PPSC/FPSC/NTS hard

    The number of rows in an Excel 2007+ worksheet is

    1. A 1,048,576
    2. B 65,536
    3. C 256
    4. D 1,000,000
    💡 Explanation:

    Excel 2007+ worksheets have 1,048,576 rows.

  41. Q41 medium

    Which function counts only cells that contain numbers

    1. A COUNTA
    2. B SUM
    3. C COUNT
    4. D IF
    💡 Explanation:

    The COUNT function counts only the cells containing numeric values.

  42. Q42 Past Paper · PPSC/FPSC/NTS medium

    The VLOOKUP function is used to

    1. A Add numbers
    2. B Count cells
    3. C Sort data
    4. D Look up a value in a vertical column
    💡 Explanation:

    VLOOKUP searches for a value in the first column and returns a value from the same row.

  43. Q43 Past Paper · PPSC/FPSC/NTS medium

    Which feature summarizes large data using drag-and-drop fields

    1. A Chart
    2. B Pivot Table
    3. C Filter
    4. D Formula bar
    💡 Explanation:

    A Pivot Table summarizes and analyzes large datasets interactively.

  44. Q44 easy

    A graphical representation of data in Excel is called a

    1. A Chart
    2. B Table
    3. C Query
    4. D Macro
    💡 Explanation:

    A chart is a graphical representation of worksheet data.

  45. Q45 Past Paper · PPSC/FPSC/NTS medium

    The ##### symbol displayed in a cell means

    1. A Formula error
    2. B Wrong data type
    3. C The column is too narrow
    4. D The file is corrupt
    💡 Explanation:

    ##### appears when a column is too narrow to display the number.

More Computer Mcqs Topics

📖
Computer Fundamentals & Introduction 45 MCQs
→ 📖
Generations & History of Computers 45 MCQs
→ 📖
Input & Output Devices 45 MCQs
→ 📖
CPU, Memory & Storage 45 MCQs
→ 📖
Operating Systems 45 MCQs
→ 📖
MS Word 45 MCQs
→

See all Computer Mcqs topics →

Get instant alerts & apply faster — install the free app Install App