1. Emma was inputting a formula using Microsoft Excel when an error #DIV/0! appeared in the cell she was working on. Which of the following describes the reason for the error?

2. What formatting mark in Microsoft Word will Jacob use if he wants to have a caption beside a picture and end it with a text-wrapping break?

3. Shiela is giving a report in class using a PowerPoint presentation. In one of her slides, her friend commented that the content was copied from the internet without citing the source. How should Shiela react to her friend?

4. Mark bought a licensed version of Windows 10 operating system intended for a single user only. After installing it on his PC, he made a copy and installed it on his brother’s laptop, although he is aware that doing this is illegal. Which of the following will NOT be the result of his action?

5. Sarah is making an invitation for her friend’s wedding using a Microsoft Word template without an AutoSave feature. She was almost done when she accidentally clicked the close button without saving her document. What is likely to happen next?

6. Nelia owns a smartphone and uses this to pay her bills. However, she got locked out of her phone and unintentionally wiped out all the data containing all the passwords and information of her bank account. How may this possibly affect the way she pays her bills?

7. Joe was surfing the internet when he saw some interesting sites. He decided to save some of the websites so that he can easily go back to them. Which icon should he use to bookmark the sites?

A.

B.

C.

D.

8. Boyet needs a fast and reliable internet connection at home. Which of the following internet connection is the best for him to use?

9. Jake was preparing the sales report when he noticed that there is some data in his chart that need to be changed. Which of the following steps should he do?

10. Tina already prepared her sales report in a spreadsheet. Her team leader asked her to present it in a chart so that they can easily see the project sales. Which order of steps in making a chart, as shown above, should she follow to perform the task?

Refer to the illustration above.

11. June is working on a report for his online business in an MS Word document. He inserted a basic table but realized that he needs another table to compute his earnings for the whole year. Which of the following procedures should he execute?

12. Mrs. Ramirez is working on the final grades of her students using MS Excel. Which of the formulas given above should she used to calculate the average?

Refer to the illustration above.

13. John received an email announcing that he won Php 1,000,000.00 from an e-raffle. In order to claim his prize, he must access the given link immediately. He was redirected to a site that asked for his full name, contact number, address, and bank details. He answered the form right away, out of excitement. A day after, his bank notified him of an unauthorized withdrawal of a large amount from his account. What could John learn from his experience?

14. Aya is active in social media. She has hundreds of friends in her account, whom she may not know in real life. She just accepts anyone who sends her a request. One day, her account has been reported because of duplicate identity. Which explanation could Aya derive from this occurrence?

15. Sheryl’s best friend posted a news blog online stating that a person is being accused of being a drug lord. Her friend asked her to copy this on her own social media account. Which of the following best explains Sheryl’s hesitation to follow her friend’s request?

16. Janet joined a social media group with her village community members. After a season of wholesome communications, she started reading some very disrespectful hate comments, insulting some personalities. She thought that sending a suggestion for members to avoid such behavior might help, but it was generally ignored. If Janet wants to reduce the discomfort she experienced in this situation, which of the following will most probable help?

17. Social media offers a way to connect with others and share information, but it also comes with risks such as online victimization, public shaming, and the spread of fake news or embarrassing content. To protect oneself from becoming a victim of these negative online behaviors, which of the following actions is most important to AVOID on social media?

18. A family member seems to be experiencing psychological, social, and educational difficulties due to excessive internet use. You suspect this may be affecting their well-being and overall productivity. How can you approach this issue to verify your concern and provide constructive feedback?

19. Tony travels most of the time carrying all his needed documents. He sometimes forgets some important documents, which makes it difficult for him to do his work. He decided to purchase a mobile device that can scan and edit his documents and even send them thru email. Which of the following devices best suits his needs?

20. The errors #NAME?, #VALUE!, #REF! are some of the errors which appear when using Microsoft Excel. Which statement does NOT explain the reason for these errors?

21. Desktop computer problems are classified into three: computer viruses, hardware malfunctions and software issues. Which of the following desktop computer problems is organized correctly according to each category?

22. Elena’s co-worker sent her a file for their product research. Upon downloading, the file attachment does not open. Which type of desktop computer problem is she encountering?

23. Keyboard key combinations that zoom in and out of a worksheet involve using the ALT key. Which of the following is the correct sequence of steps in using the keyboard shortcut to open the Zoom dialog box and activate it to 75% view?

Refer to the illustration above.

24. The Magnifier tool on Windows helps users zoom in on parts of the screen for better visibility during presentations or other tasks. To use this feature, you can activate and control it using keyboard shortcuts. Below are the steps to manage the Magnifier tool:

Refer to the illustration above.

25. Christian successfully presented to the board of directors his new marketing strategy and he will now let the CEO view it for final approval. He will be showing this to him face-to-face. What is the best way for him to present his presentation to the CEO?”

26. Clara’s presentation was rearranged by Mark, but she was uncomfortable with the resulting series of slides that were saved. She wanted to have the original sequence back. Which type of view will allow her to see the slides altogether while rearranging them?

27. Gina works as an encoder at XYZ Advertising Company. Her boss requested her to create a new design for their brochures to be distributed. Which Microsoft Office application is best for her needs?

28. Which of the following pertains to the behavior of computer users, their compliance with standards in program creation and usage, and the impact of these practices on individuals and society?

29. May was given a spreadsheet file about the number of students in a class who have mobile phones. Based on the tabular data shown above, which of the following statements is true?

Refer to the illustration above.

30. A businessman uses spreadsheet to track the trend of his retail business sales. What is a correct statement based on the line graph?

Refer to the illustration above.

31. Clyde’s research work about the consumption of bananas in Sitio Maybunga was approved by his superior. He has printed his report and is ready to present it to the marketing heads. To make it impressive, he will use a PowerPoint presentation. Which of the following will he LEAST likely do?

32. Barangay Captain Lea is presenting her community project proposal to the city mayor, and she wants her file to be protected. In what document format should she save her proposal to retain its original contents?

33. Which of the following shows the correct arrangement of procedures in inserting an MS Word document as an object to a new PowerPoint presentation template?

34. David’s bimonthly sales proposal was saved in a document. He needs to transfer it to a portable document format to make sure that the original contents are preserved. Which of the following procedures does he need to follow?

35. If Bea wants to save a copy of her presentation on a flash drive using her filename, which is the correct order of steps for her to follow?

Refer to the illustration above.

36. Jose is saving his presentation in a portable document format. Which of the following steps should he do first?

37. Helen leads the group in a research study. Each member is tasked to give her/his views and opinions on the World Wide Web. While Helen is reading each output, she found many similarities in information. Which of the following characteristics should Helen consider in evaluating the different information regarding the internet?

38. Luisa is looking for the contact number of the school where her son is enrolled, because she needs to get the documents for registration. She tried to find out the school’s information on the internet but she got the wrong information. Which of the following must have happened?

39. Diane and Francis were given an assignment to provide insights about the article “Impact of Social Media on the Youth.” Diane saw that Francis copied some parts from another published article. Which action should Diane NOT consider if she wants Francis to avoid committing plagiarism?

40. There are some pirated copies of software that are sold in the market. What should a buyer do to avoid purchasing a pirated copy?

41. Paulo was given a task to verify topics about current events. After typing the keywords in www.google.com, different websites were generated. Which of the following statements will he LEAST likely consider in completing his task?

42. Mona is doing research for her class project. She is using Google to find online references. How would she determine which websites are credible?

43. Kristine was boarding the plane when she received an email from her boss informing her about a new project for her team. To inform her team, she quickly started to connect through the Wi-Fi of the plane to access the internet. Which of the following would be the easiest way for her to inform the team?

44. Nelson received an email from an unknown sender claiming that he had won a large cash prize. The email instructed him to provide his personal and financial details to claim his winnings. Believing the message, Nelson shared his sensitive information, but he never received the promised prize and even lost money from his bank account as a result? If Nelson had evaluated the source of the email more critically, which type of cybercrime could he have identified and avoided?

45. Jojo created a research project in ICT. His teacher sent the template via email. When he opened the file, he found that the attachment contained a virus. What must he do to protect his computer from virus infection?

46. Josie is browsing online when suddenly an advertisement for a new application pops up. It gives her the option to easily install the new application by just clicking DOWNLOAD from the pop-up window. Which is the best action that Josie could take if she does not want to be bothered by such ads?

47. Mercy received a text message from an unregistered number claiming to be the legal officer of ABC Company, telling her that she won Php 800,000.00 from an electronic draw. She was asked to give her personal data, credit card information. and PIN number, to meet the requirements before she can claim her prize. Which of the following statements above can raise doubt on the credibility of the message?

Refer to the illustration above.

48. Sharing the password of your account to others makes your mobile devices more vulnerable to data theft. It enables unauthorized access to control over computer network security. What should you do to avoid this?

49. Cyber violence cases are alarmingly increasing, and most of the victims are the youth. Which statement is the best reminder to protect oneself from becoming a victim of cyber violence?

50. One of the common risks online is cyberbullying. If Susan is just starting to use social media, which of the following actions should she AVOID to prevent becoming a victim of cyberbullying?

51. Rex spends 6 to 8 hours browsing the internet at home and often skips meals. Which of the following could best inhibit him from internet addiction?

52. When Leah opened her social media account, she saw a nude photo of herself that had been liked and shared online. What should be her first move in response to this incident?

53. Tristan learned to play a mobile game and spent most of his time playing. Slowly his behavior changed. He became impatient, had less sleep and spent little time on his studies. Tristan failed all his subjects. What conclusion can be drawn, based on the incident?

54. A junior high school student posted an article on his social media wall, complaining about the attitude of his teacher, stating it as a terrible working attitude. This was seen and commented on by his social media friends. Can the post be considered libelous and be a legitimate cause for disciplinary action?