HP Computer Practice Set 5 | Interactive MCQ Mock Test

1. Excel function to count non-empty cells in a range?

Computer 📄 JOA IT (2022)

A. COUNTNB B. COUNTA C. COUNTNE D. COUNT

2. Number of worksheets in an Excel workbook by default?

Computer 📄 JOA IT (2022)

A. 3 B. 4 C. 2 D. 5

3. Default cell alignment for text and numbers in Excel?

Computer 📄 JOA IT (2022)

A. both left B. both right C. text right, num left D. text left, num right

4. Value for =WORKDAY("01−01−2022",22) (Sunday start)?

Computer 📄 JOA IT (2022)

A. 30-Jan-2022 B. 03-Feb-2022 C. 28-Jan-2022 D. 01-Feb-2022

5. Rotating data from rows to columns or vice-versa?

Computer 📄 JOA IT (2022)

A. Pivot table B. Scaling C. Transposing D. Range

6. Which is NOT a chart type supported by MS Excel?

Computer 📄 JOA IT (2022)

A. Area Chart B. Scatter Plot C. Volume Chart D. Line Chart

7. Feature to record and play keystrokes?

Computer 📄 JOA IT (2022)

A. Macro B. Format Painter C. Wrap Text D. Pivot Table

8. Which IP address is known as loopback address?

Computer 📄 JOA IT (2022)

A. 192.168.0.1 B. 127.0.0.1 C. 172.16.24.1 D. 10.0.0.1

9. Protocol used for mapping IPv4 to MAC addresses?

Computer 📄 JOA IT (2022)

A. DNS B. SNMP C. ARP D. TCP

10. Which of the following is NOT a valid local IPv4 address?

Computer 📄 JOA IT (2022)

A. 192.168.1.1 B. 10.0.0.5 C. 260.240.1.1 D. 172.16.24.1

11. Command using ICMP to test computer reachability?

Computer 📄 JOA IT (2022)

A. ipconfig B. arp C. ping D. touch

12. Popular Linux distribution supported by IBM?

Computer 📄 JOA IT (2022)

A. Red Hat B. Black Cap C. Blue Tee D. Yellow Tie

13. On-demand delivery of IT resources with pay-as-you-go?

Computer 📄 JOA IT (2022)

A. Cloud Computing B. AI C. Machine Learning D. IoT

14. Released in 1986, first IBM PC compatible virus?

Computer 📄 JOA IT (2022)

A. Heart B. Brain C. Mind D. Germ

15. Malware that looks like a genuine application?

Computer 📄 JOA IT (2022)

A. Virus B. Trojan horse C. Cookie D. Worm

16. What is the full form of TCP/IP?

Computer 📄 JOA IT (2022)

A. Transit/Inf. Prot B. Telecom/Inter Prot C. Trans. Carr/Inter Prot D. Trans. Cont/Inter Prot

17. Plain text info about browsing session stored on client?

Computer 📄 JOA IT (2022)

A. Database B. URL C. Cookie D. Signature

18. Popular file compression utility software?

Computer 📄 JOA IT (2022)

A. Convert B. Win Word C. WinZip D. Scandisk

19. Switches one of several input lines to a single output?

Computer 📄 JOA IT (2022)

A. Counter B. Decoder C. Register D. Multiplexer

20. HTML tag used to draw a horizontal line in a web page?

Computer 📄 JOA IT (2022)

A. <li> B. <hr> C. <tr> D. <br>

21. How many heading levels are supported by HTML?

Computer 📄 JOA IT (2022)

A. 5 B. 6 C. 7 D. 8

22. HTML tag used to create a cell in a table row?

Computer 📄 JOA IT (2022)

A. <cell> B. <br> C. <td> D. <dd>

23. Attribute of <img> to specify the URL of the image?

Computer 📄 JOA IT (2022)

A. src B. href C. file D. target

24. How is an inline CSS used in an HTML document?

Computer 📄 JOA IT (2022)

A. meta in head B. style attribute C. style in head D. external link

25. CSS rule to set background color of <h1> to red?

Computer 📄 JOA IT (2022)

A. h1{back...: red;} B. .h1{...: red;} C. #h1{...: red;} D. <h1>{...: red;}

Himachal Pradesh Computer - Practice Mock Test Set 5

📊 Live Score Summary

Quick Navigation Links

Boost Your Himachal Pradesh Computer Exam Preparation