HP Computer Practice Set 20 | Interactive MCQ Mock Test

1. Which action would allow you to rename an existing worksheet within an Excel workbook?

Computer 📄 JOA IT (2026)

A. Right-click the worksheet tab and select 'Rename' from the context menu. B. Rename the workbook file from Windows Explorer. C. Use the File menu to select 'Rename Sheet'. D. Double-click the Excel window's title bar.

2. A dataset contains sales for each month in cells D2:D13. How can you calculate the average sales, ignoring any cells with zero using a single Excel function?

Computer 📄 JOA IT (2026)

A. AVERAGEIFS B. AVERAGEIF C. SUMIF D. AVERAGE

3. A dataset contains sales for each month in cells D2:D13. How can you calculate the average sales, ignoring any cells with zero using a single Excel function?

Computer 📄 JOA IT (2026)

A. AVERAGEIFS B. AVERAGEIF C. SUMIF D. AVERAGE

4. In Microsoft Excel 2021, a financial analyst uses Goal Seek to determine the required sales value needed to achieve a target profit. The profit formula depends on multiple linked cells. What is the main purpose of Goal Seek?

Computer 📄 JOA IT (2026)

A. To determine input value for a desired output result B. To generate output values from existing charts C. To organize data into alphabetical order D. To apply visual formatting to worksheet data

5. In Microsoft Excel 2021, a financial analyst uses Goal Seek to determine the required sales value needed to achieve a target profit. The profit formula depends on multiple linked cells. What is the main purpose of Goal Seek?

Computer 📄 JOA IT (2026)

A. To determine input value for a desired output result B. To generate output values from existing charts C. To organize data into alphabetical order D. To apply visual formatting to worksheet data

6. In MS PowerPoint 2021, you are creating a slide that requires a custom table layout where rows and columns are not uniform. Which option allows you to manually draw the table structure?

Computer 📄 JOA IT (2026)

A. Insert → SmartArt B. Insert → Draw Table C. Design → Table D. View → Gridlines

7. In MS PowerPoint 2021, you are creating a slide that requires a custom table layout where rows and columns are not uniform. Which option allows you to manually draw the table structure?

Computer 📄 JOA IT (2026)

A. Insert → SmartArt B. Insert → Draw Table C. Design → Table D. View → Gridlines

8. Which of the following best explains the purpose of transitions in a PowerPoint presentation?

Computer 📄 JOA IT (2026)

A. Transitions change the layout of slides as you move through the presentation. B. Transitions automatically add new content to each slide during the presentation. C. Transitions animate individual objects on a slide rather than the entire slide change. D. Transitions provide visual effects between slides to improve the flow of the presentation.

9. Which of the following best explains the purpose of transitions in a PowerPoint presentation?

Computer 📄 JOA IT (2026)

A. Transitions change the layout of slides as you move through the presentation. B. Transitions automatically add new content to each slide during the presentation. C. Transitions animate individual objects on a slide rather than the entire slide change. D. Transitions provide visual effects between slides to improve the flow of the presentation.

10. In which situation would printing handouts for a PowerPoint presentation be most useful?

Computer 📄 JOA IT (2026)

A. When the presentation only includes images and no text B. When the session is a brief 5-minute update C. When only one slide is presented D. When participants need to review and annotate material after the session

11. In which situation would printing handouts for a PowerPoint presentation be most useful?

Computer 📄 JOA IT (2026)

A. When the presentation only includes images and no text B. When the session is a brief 5-minute update C. When only one slide is presented D. When participants need to review and annotate material after the session

12. Which option in the Print dialog allows you to print only the text content of your slides, excluding images and graphics?

Computer 📄 JOA IT (2026)

A. Notes Pages B. Slides (Full Page) C. Handouts D. Outline View

13. Which option in the Print dialog allows you to print only the text content of your slides, excluding images and graphics?

Computer 📄 JOA IT (2026)

A. Notes Pages B. Slides (Full Page) C. Handouts D. Outline View

14. A student wants to emphasize a key point in their slide by making the text bold and changing its color. Which process should they follow in PowerPoint?

Computer 📄 JOA IT (2026)

A. Select the text, then use the Home tab options to bold and change color B. Switch to Slide Sorter view C. Change the slide layout D. Right-click and choose a formatting option

15. A student wants to emphasize a key point in their slide by making the text bold and changing its color. Which process should they follow in PowerPoint?

Computer 📄 JOA IT (2026)

A. Select the text, then use the Home tab options to bold and change color B. Switch to Slide Sorter view C. Change the slide layout D. Right-click and choose a formatting option

16. Which best describes how a company could ensure secure internet access using Google Chrome and Microsoft Edge?

Computer 📄 JOA IT (2026)

A. By replacing the operating system with a new version B. By switching all users to a single browser C. By configuring security settings within each browser D. By installing additional RAM modules

17. Which best describes how a company could ensure secure internet access using Google Chrome and Microsoft Edge?

Computer 📄 JOA IT (2026)

A. By replacing the operating system with a new version B. By switching all users to a single browser C. By configuring security settings within each browser D. By installing additional RAM modules

18. Which company develops and maintains the Edge web browser?

Computer 📄 JOA IT (2026)

A. Apple B. Microsoft C. Google D. Mozilla

19. Which company develops and maintains the Edge web browser?

Computer 📄 JOA IT (2026)

A. Apple B. Microsoft C. Google D. Mozilla

20. Which statement BEST describes a hub in computer networking?

Computer 📄 JOA IT (2026)

A. Hub stores webpages permanently B. Hub broadcasts incoming data to all connected devices C. Hub intelligently filters packets to destination device only D. Hub works exactly like a firewall

21. Which statement BEST describes a hub in computer networking?

Computer 📄 JOA IT (2026)

A. Hub stores webpages permanently B. Hub broadcasts incoming data to all connected devices C. Hub intelligently filters packets to destination device only D. Hub works exactly like a firewall

22. Which statement correctly differentiates a static website from a dynamic website?

Computer 📄 JOA IT (2026)

A. Static websites display the same content to all users while dynamic websites can show different content based on user interaction B. Static websites allow users to interact with forms but dynamic websites do not C. Static websites always have multimedia but dynamic websites only have text D. Static websites automatically update content, dynamic websites never change

23. Which statement correctly differentiates a static website from a dynamic website?

Computer 📄 JOA IT (2026)

A. Static websites display the same content to all users while dynamic websites can show different content based on user interaction B. Static websites allow users to interact with forms but dynamic websites do not C. Static websites always have multimedia but dynamic websites only have text D. Static websites automatically update content, dynamic websites never change

24. In Google Chrome web browsers, keyboard shortcuts are used to improve navigation efficiency while working online. Which shortcut is used to open a new tab in Chrome?

Computer 📄 JOA IT (2026)

A. Ctrl + N B. Ctrl + T C. Ctrl + Shift + T D. Ctrl + Tab

25. In Google Chrome web browsers, keyboard shortcuts are used to improve navigation efficiency while working online. Which shortcut is used to open a new tab in Chrome?

Computer 📄 JOA IT (2026)

A. Ctrl + N B. Ctrl + T C. Ctrl + Shift + T D. Ctrl + Tab

Himachal Pradesh Computer - Practice Mock Test Set 20

📊 Live Score Summary

Quick Navigation Links

Boost Your Himachal Pradesh Computer Exam Preparation