Which of the following is not a valid version of Microsoft Office? A. Office 2003 B. Office 2007 C. Office 2016 D. Office Vista Correct answer is: D. Office Vista π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
How many rows are there in a Microsoft Excel worksheet? A. 65,536 B. 1,048,576 C. 104,857 D. 16,384 Correct answer is: B. 1,048,576 π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
In Microsoft Excel, sorting data from A to Z is called: A. Descending Order B. Filtering C. Custom Sorting D. Ascending Order Correct answer is: D. Ascending Order π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which keyboard shortcut is used to minimize the Excel window? A. Ctrl + F8 B. Ctrl + F9 C. Ctrl + F10 D. Ctrl + F11 Correct answer is: B. Ctrl + F9 π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
MS Word offers different views of a document: A. Two B. Three C. Four D. Five Correct answer is: D. Five π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which keyboard shortcut is used to extend the selection down in a Microsoft Excel worksheet? A. Shift + Down Arrow B. Ctrl + Shift + Right Arrow C. Alt + Down Arrow D. Ctrl + Down Arrow Correct answer is: A. Shift + Down Arrow π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
The file extension .ppt is used for files created by: A. MS Word B. MS Excel C. MS PowerPoint D. MS Access Correct answer is: C. MS PowerPoint π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Ctrl + Q is used to: A. Remove Paragraph formatting (Line Space and Paragraph Space) B. Close Word Application without saving C. Print Whole Document without confirmation D. Does nothing Correct answer is: A. Remove Paragraph formatting (Line Space and Paragraph Space) π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
A. Remove Paragraph formatting (Line Space and Paragraph Space) B. Close Word Application without saving C. Print Whole Document without confirmation D. Does nothing
The ____ feature of MS Excel quickly completes a series of data. A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting Correct answer is: B. Auto Fill π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which keyboard shortcut is used to switch between open applications in Windows 10? A. Ctrl + Tab B. Alt + F4 C. Alt + Tab D. Shift + Esc Correct answer is: C. Alt + Tab π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
The Protect Document option can be found in the ____ tab of the Ribbon. A. Review B. Home C. References D. Edit Correct answer is: A. Review π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which keyboard shortcut is used to create a formula that sums all the cells above the active cell in Excel? A. Alt + S B. Ctrl + = C. Alt + = D. Shift + = Correct answer is: C. Alt + = π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which of the following functions in MS Excel counts the number of cells within a range that meet the given condition? A. COUNTIFB B. COUNTA C. COUNT D. COUNTIF Correct answer is: D. COUNTIF π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
MS Word is a type of: A. System Software B. Programming Software C. Utility Software D. Application Software Correct answer is: D. Application Software π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
The process of arranging data in a logical sequence is called: A. Filtering B. Grouping C. Sorting D. Formatting Correct answer is: C. Sorting π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
The feature of Word that automatically adjusts the amount of space between certain combinations of characters so that an entire word looks more evenly spaced is called: A. Spacing B. Kerning C. Positioning D. Scaling Correct answer is: B. Kerning π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
What is a range in Microsoft Excel? A. A1 B. #REF! C. B1:B2 D. 100 Correct answer is: C. B1:B2 π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which keyboard shortcut is used to change the case of selected text in Microsoft Word? A. Ctrl + Shift + A B. Shift + F3 C. Ctrl + F3 D. Alt + F3 Correct answer is: B. Shift + F3 π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
In a LAN (Local Area Network) system, the operation mainly depends on the: A. Node B. Hub C. Server D. Ring Correct answer is: C. Server π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
What is the primary function of the Windows Task Manager? A. File management B. System configuration C. Process and resource management D. Disk cleanup Correct answer is: C. Process and resource management π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
Which category of computer data typically consumes the most memory? A. Text B. Numbers C. Graphics D. Symbols Correct answer is: C. Graphics π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
The World Wide Web (WWW) is used for: A. Sending e-mails B. File printing C. Accessing and sharing information over the internet D. Operating system functions Correct answer is: C. Accessing and sharing information over the internet π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
A. Sending e-mails B. File printing C. Accessing and sharing information over the internet D. Operating system functions
If you want to apply the formatting of one page to another without copying the text, which tool should you use? A. Copy-Paste B. Format Painter C. Format Text Box D. Page Setup Correct answer is: B. Format Painter π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
What are cookies in a web browser used for? A. Cleaning the browser cache B. Displaying advertisements C. Storing user data and preferences D. Blocking pop-ups Correct answer is: C. Storing user data and preferences π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar
A. Cleaning the browser cache B. Displaying advertisements C. Storing user data and preferences D. Blocking pop-ups
The functions of Copy and Paste reside in which group on the Home tab in MS Word? A. Home B. Paragraph C. Style D. Clipboard Correct answer is: D. Clipboard π Read Detailed Explanation β Computer MCQs for Competitive Exams Computer Science MCQS PPSC Past Papers & Solved MCQs PPSC Punjab Police Data Entry Operator Previous Papers Leave a Comment | Umar