HP Computer Practice Set 13 | Interactive MCQ Mock Test

1. A dataset includes sales records across different regions and months. An analyst applies filters for "Region = East" and "Sales > 5000" at the same time. What will be the result of applying these filters?

Computer 📄 JOA IT (2026)

A. Records matching either condition are shown B. All records are sorted in order automatically C. All records are deleted from the dataset completely D. Records matching both conditions are shown

2. Which of the following is NOT an advantage of charts in Microsoft Excel (2019 or later)?

Computer 📄 JOA IT (2026)

A. Easier identification of trends and patterns B. Quick visual interpretation of data C. Better presentation of comparisons D. Protection of data in the worksheet

3. A data analyst imports customer information into Microsoft Excel 2021 from a text file. The imported data contains full names separated by commas within a single column. Which Excel feature should be used to divide the data into separate columns automatically?

Computer 📄 JOA IT (2026)

A. Remove Duplicates B. Text to Columns C. Flash Fill D. Conditional Formatting

4. What will be the result of the formula =LEFT("INFORMATION", 5) in Microsoft Excel (2019 or later)?

Computer 📄 JOA IT (2026)

A. INFOR B. MATIO C. INFO D. ROFNI

5. If you want to add a slide with both a title and two content sections, which layout should you use?

Computer 📄 JOA IT (2026)

A. Title Slide B. Title and Content layout C. Blank layout D. Comparison layout

6. Which feature in MS PowerPoint allows you to apply a consistent set of colors, fonts, and effects across all slides in a presentation?

Computer 📄 JOA IT (2026)

A. Animations B. Design themes C. Transitions D. Slide layouts

7. Which approach best utilizes animations to enhance understanding in a classroom PowerPoint presentation?

Computer 📄 JOA IT (2026)

A. Using complex animations for every element B. Avoiding animations entirely for every slide C. Using simple animations to introduce each concept step by step D. Animating all items on the slide at once

8. Which option in Microsoft PowerPoint (2019 or later) allows multiple slides to be printed on a single page?

Computer 📄 JOA IT (2026)

A. Reading View B. Slide Sorter C. Notes Pages D. Handouts

9. You are tasked with creating an interactive quiz in MS PowerPoint where feedback appears only after a specific answer is selected. Which animation technique should you use to achieve this conditional display of feedback?

Computer 📄 JOA IT (2026)

A. Set all feedback to 'Start On Click' B. Use a single animation effect for all answer choices C. Add feedback animations with timed delays D. Apply animation triggers linked to the correct answer object

10. In computer networking, different types of networks are classified based on their coverage, cost, and communication methods. Which of the following is not a characteristic of a WAN (Wide Area Network)?

Computer 📄 JOA IT (2026)

A. Covers large geographical regions across cities or countries B. Requires relatively high setup and maintenance cost C. Operates within a limited local area like a building or campus D. Uses public communication infrastructure for data transmission

11. Consider the following statements regarding modems used in computer network: S1: Modulation is a process of converting digital data into analog form, S2: Modems are required when communication medium carries analog signals, S3: Demodulation converts analog data into digital form, S4: Modems assign MAC addresses to network interface cards. Which statements are TRUE?

Computer 📄 JOA IT (2026)

A. Only S2 and S4 B. Only S1, S2 and S3 C. Only S1 and S4 D. Only S1 and S2

12. Which protocol converts domain names into IP addresses on the Internet?

Computer 📄 JOA IT (2026)

A. FTP B. HTTP C. HTTPS D. DNS

13. Which of the following best describes how wireless networks provide connectivity within an office environment?

Computer 📄 JOA IT (2026)

A. They rely primarily on Bluetooth signals for all internal communication. B. They require physical cables for every device to connect to the network. C. They use radio waves to transmit data between devices and access points. D. They use infrared signals that require direct line-of-sight between devices.

14. Why would a multinational company choose to implement a WAN instead of only LANs at each office?

Computer 📄 JOA IT (2026)

A. To reduce the speed of internal communication B. To ensure each office uses a separate internet connection C. To minimize the cost of networking equipment D. To enable centralized access to shared resources across countries

15. Why might an organization choose FDDI over Ethernet for their MAN?

Computer 📄 JOA IT (2026)

A. FDDI offers greater distance coverage and speed for metropolitan networks B. FDDI is less expensive than Ethernet for small offices C. FDDI is simpler to install than Ethernet D. FDDI uses wireless signals for easy setup

16. What is the primary purpose of Incognito Mode in a web browser?

Computer 📄 JOA IT (2026)

A. To permanently hide browsing activity from internet service providers B. To browse the internet without saving browsing history, cookies, or temporary data locally C. To increase internet speed by blocking all websites D. To protect the computer completely from viruses and malware

17. A hospital needs a network to connect its computers within a single building to securely manage patient records. Which network type should it implement for best performance and security?

Computer 📄 JOA IT (2026)

A. Local Area Network B. Metropolitan Area Network C. Wide Area Network D. Personal Area Network

18. A company experiences an increase in unwanted emails. Which protocol misconfiguration should they check first for abuse?

Computer 📄 JOA IT (2026)

A. Post Office Protocol (POP3) B. File Transfer Protocol (FTP) C. Internet Message Access Protocol (IMAP) D. Simple Mail Transfer Protocol (SMTP)

19. Which of the following best describes how the Slammer worm propagated after exploiting Microsoft SQL Server?

Computer 📄 JOA IT (2026)

A. It spread rapidly by scanning random IP addresses for vulnerable servers. B. It used social engineering to trick users into installing it. C. It sent infected email attachments to contacts. D. It required users to download malicious software from a website.

20. If a new type of malware spreads rapidly before security companies can analyze it, which antivirus method is most likely to detect it early?

Computer 📄 JOA IT (2026)

A. Sandboxing B. Heuristic analysis C. Firewall monitoring D. Signature-based detection

21. A company wants to analyze potential malware without risking its main network. Which approach should it use?

Computer 📄 JOA IT (2026)

A. Firewall B. Encryption C. Antivirus software D. Sandboxing

22. An employee receives an email from their 'IT department' requesting immediate password reset by clicking a link. The email address slightly differs from the official one. What is the most likely security threat in this scenario?

Computer 📄 JOA IT (2026)

A. Malware infection from attachment B. In-person social engineering C. Phishing attempt to steal login credentials D. Network sniffing over Wi-Fi

23. Which number system uses digits from 0 to 9?

Computer 📄 JOA IT (2026)

A. Binary system B. Octal system C. Hexadecimal system D. Decimal system

24. Suppose you are designing a digital system using octal numbers. Which of these should you use for valid octal representation?

Computer 📄 JOA IT (2026)

A. Numbers containing the digit 9 B. Numbers with only digits 0-7 C. Numbers containing the digit 8 D. Numbers with leading alphabet

25. In terms of data integrity, how does a DBMS outperform a file system?

Computer 📄 JOA IT (2026)

A. By allowing unlimited editing of records B. By duplicating records frequently C. By enforcing consistency constraints on data entries D. By deleting files permanently

Himachal Pradesh Computer - Practice Mock Test Set 13

📊 Live Score Summary

Quick Navigation Links

Boost Your Himachal Pradesh Computer Exam Preparation