HP Computer Practice Set 178 | Interactive MCQ Mock Test

1. An HR manager working in Microsoft Word 2021 needs to replace employee IDs across multiple sections of a document while reviewing each occurrence individually before replacement. Which action is more appropriate than using “Replace All”?

Computer 📄 JOA IT (2026)

A. Use Find Next with Replace B. Enable Read Mode C. Use AutoCorrect D. Apply Track Formatting

2. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

3. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

4. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

5. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

6. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

7. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

8. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

9. What is the result of pressing F2 while a cell is selected in Excel?

Computer 📄 JOA IT (2026)

A. It opens the formula bar B. It copies the cell's content C. It deletes the cell's content D. It enables editing the cell's current contents

10. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

11. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

12. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

13. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

14. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

15. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

16. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

17. How does the TRIM function affect a text string in Excel?

Computer 📄 JOA IT (2026)

A. It converts all text to lowercase letters B. It removes extra spaces from the text except for single spaces between words C. It counts the number of characters in the text D. It joins two text strings together

18. A company wants to compare best, worst, and most likely sales forecasts in one Excel worksheet. Which approach will most efficiently show these alternatives side-by-side?

Computer 📄 JOA IT (2026)