Computer — All MCQs

4795 questions available

Showing 2521–2540 of 4795

Q2521.Which feature in Microsoft Word allows you to create a table of contents?

Easy
A Page Layout
B Review
C References
D Home
MS Word PPSC

Correct Answer: C

The table of contents feature is located under the References tab in Microsoft Word.

Q2522.Which shortcut key is used to switch to the next worksheet tab to the right in MS Excel?

Easy
A Ctrl + Page up
B Ctrl + Home
C Ctrl + Page down
D Ctrl + End
MS Excel Shortcut Keys PPSC

Correct Answer: C

Ctrl + Page Down is the keyboard shortcut to select the next worksheet tab to the right. Ctrl + Page Up selects the worksheet tab to the left.

Q2523.An Excel workbook is a collection of __________?

Easy
A Worksheets and Charts
B Charts
C Worksheets
D Workbooks
MS Excel PPSC

Correct Answer: C

An Excel workbook is primarily a collection of worksheets. A workbook must contain at least one worksheet.

Q2524.An MS Excel worksheet consists of __________?

Easy
A Text boxes
B Rows & Columns
C Pictures & Drawings
D Rows & Text
MS Excel PPSC

Correct Answer: B

Excel worksheets consist of a grid of horizontal rows (numbered) and vertical columns (alphabetical) that intersect to form cells.

Q2525.A Pivot Table is an advanced summarization feature of which of the following software?

Easy
A Microsoft Excel
B Microsoft Word
C Microsoft PowerPoint
D None of these
MS Excel PPSC

Correct Answer: A

The PivotTable is a core data analysis feature in Microsoft Excel used to summarize, analyze, and explore large datasets.

Q2526.In MS Word, the default alignment for a newly created paragraph is _____?

Easy
A Left alignment
B Right alignment
C Centered alignment
D None of these
MS Word PPSC

Correct Answer: A

The default paragraph alignment in MS Word is Left alignment, aligning text along the left margin. Shortcut: Ctrl + L.

Q2527.Distributed Ledger Technology (DLT) is best defined as?

Easy
A A type of database controlled by a single authority
B Only used for traditional banking
C A cloud storage service
D A network where data is duplicated, shared, and synchronized across multiple locations
Computer Terminology PPSC

Correct Answer: D

DLT is a decentralized digital system that records and synchronizes transactions across multiple nodes or computers in a network without a central repository.

Q2528.Which function in Excel is used to perform addition on two or more complex numbers?

Easy
A SUM()
B IMSUM()
C COMPLEX()
D CONCAT()
MS Excel PPSC

Correct Answer: B

IMSUM() is the specific Excel engineering function used to calculate the sum of two or more complex numbers in the form 'a+bi' or 'a+bj'.

Q2529.What does VLOOKUP in Excel represent?

Easy
A Horizontal Lookup
B Vertical Lookup
C Sum Function
D Average Function
MS Excel PPSC

Correct Answer: B

VLOOKUP stands for Vertical Lookup, searching for a value in the first column of a table to pull data from a specified column in the same row.

Q2530.What is the primary reason to use a Macro in Microsoft Office applications?

Easy
A Automate Frequently used tasks
B Home page
C Both a and b
D None of these
General MCQs PPSC

Correct Answer: A

Macros in Microsoft Office are recorded or written scripts used to automate frequently used, repetitive, or multi-step tasks.

Q2531.To start the Microsoft PowerPoint application on Windows, you can _____?

Easy
A Click on Start >> Programs >> All Programs >> Microsoft PowerPoint
B Hit Ctrl + R then type ppoint.exe and Enter
C Click Start >> Run then type powerpnt then press Enter
D All of above
MS PowerPoint Shortcut Keys PPSC

Correct Answer: D

All of the listed methods are valid ways to start MS PowerPoint. Note that running 'powerpnt' (with or without .exe) is the executable command.

Q2532.In which menu of legacy PowerPoint 2003 can you find features like Slide Design and Slide Layout?

Easy
A Insert Menu
B Format Menu
C Tools Menu
D Slide Show Menu
MS PowerPoint PPSC

Correct Answer: B

In PowerPoint 2003 and older, Slide Design and Slide Layout are located under the Format menu. In newer ribbon versions, they are in the Design and Home tabs respectively.

Q2533.The IF function in Excel is used for _____?

Easy
A Performing logical comparisons
B Formatting text
C Creating charts
D None of these
MS Excel PPSC

Correct Answer: A

The IF function evaluates a condition (logical test) and returns one result if TRUE, and another if FALSE.

Q2534.Which of the following is the most suitable reason to use a Macro in MS Office?

Easy
A To record mouse move
B To record sound
C To automate repetative tasks
D None of these
General MCQs PPSC

Correct Answer: C

The core purpose of macros in MS Office is to automate repetitive, routine tasks, ensuring consistency and saving time.

Q2535.In Agile software development life cycle, what does a "Sprint" define?

Easy
A The final testing stage
B A phase of software development
C A time-boxed iteration of development
D None of these
General MCQs PPSC

Correct Answer: C

A Sprint is a core Scrum concept, representing a short, time-boxed iteration (usually 1-4 weeks) during which specific tasks must be completed.

Q2536.The agile software development model is built based on which development methodologies?

Easy
A Incremental Development
B Linear Development
C Iterative Development
D Both incremental & Iterative development
General MCQs PPSC

Correct Answer: D

Agile is inherently both iterative (developed in cycles) and incremental (delivering functional chunks at the end of each cycle).

Q2537.The classical Linear Sequential Model is also commonly known as the?

Easy
A Spiral Model
B Agile Model
C Waterfall Model
D Prototype Model
General MCQs PPSC

Correct Answer: C

The Waterfall Model represents a classic linear sequential software development life cycle where phases flow downward in order.

Q2538.The first-ever PC-compatible computer virus (Brain) was created in 1986 in which country?

Easy
A China
B Pakistan
C USA
D Israel
Computer Security PPSC

Correct Answer: B

The 'Brain' virus was created in January 1986 by two brothers from Lahore, Pakistan, making it the first IBM PC-compatible computer virus.

Q2539.Errors in computer software can be identified and removed through which process?

Easy
A Debugging
B Formating
C Flip flop
D All of these
General MCQs PPSC

Correct Answer: A

Debugging is the systematic process of finding, analyzing, and removing bugs or errors from computer software.

Q2540.An IPv6 address is expressed in which format?

Easy
A Hexadecimal form
B Octal form
C Numerical form
D Alphanumeric form
General MCQs PPSC

Correct Answer: A

IPv6 addresses are written as 8 groups of hexadecimal digits separated by colons (e.g., 2001:db8::1).