Computer Literacy Test

You are unable to connect to the internet. All cables are properly connected and your Wi-Fi shows as connected with strong signal. What should you first check to resolve this issue?

A: Check if the router is turned on
B: Restart your computer
C: Check the DNS settings
D: Replace the Ethernet cable
E: Check your firewall settings
F: Flush the DNS cache

Your computer starts to run extremely slowly, there are unexpected ads popping up even when you're not browsing the internet, and your friends report receiving strange emails from your account. Which of the following is the most likely cause of these issues?

A: The hard drive is full
B: The CPU is overheating
C: You have installed conflicting software
D: Your computer is infected with malware
E: Your internet connection is slow
F: There are too many background applications running

File extensions help the system understand what type of file it is dealing with, and consequently, which applications can be used to open it. Given a list of file extensions, identify the one that typically represents a compressed file format.

Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?

We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:

We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Here’s a sample Excel data source:

Here’s the expected data format: 

Which of the following is the correct way to transform the data from the query editor to achieve the result?

A: Columns to Select: Student Only
B: Columns to Select: Student and Student ID
C: Columns to Select: Primary and Secondary
D: Command to Use: Pivot Column
E: Command to Use: Reverse Rows
F: Command to Use: Unpivot Columns

We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

A: =VLOOKUP("O-", A1:E10, 3, TRUE)
B: =VLOOKUP("O-", A1:E10, 3, FALSE)
C: =VLOOKUP("O-", D1:D10, 4)
D: =VLOOKUP("O-", D1:D10, 3)
E: =VLOOKUP("O-", A1:E10, 4, TRUE)
F: =VLOOKUP("O-", A1:E10, 4, FALSE)
G: =VLOOKUP("Kane", A1:E10, 4)

One sunny afternoon, Po, the legendary Kung Fu Panda, decided to take a break from his martial arts training and visit the bustling village market. He had a craving for his favorite dumplings and was eager to find the tastiest ones. As Po strolled through the market, his enthusiasm drew the attention of curious onlookers. They giggled and whispered as the giant panda, clad in his iconic Kung Fu attire, carefully examined fruits and vegetables, hunting for the freshest ingredients. At the dumpling stall, Po's excitement peaked, and he accidentally knocked over a tower of bamboo steamers. The vendor, surprisingly unflustered, smiled and said, "Ah, the great Dragon Warrior! No need to worry, Po. A few fallen steamers are nothing compared to the joy you bring to our village." The crowd erupted in laughter as Po sheepishly grinned and picked up the steamers. He left the market with a basket full of delicious dumplings and a heart warmed by the villagers' affection. The day Po went shopping would be fondly remembered as a delightful and hilarious break from the ordinary.

Once upon a time, in a picturesque village nestled at the base of a majestic mountain range, there lived a talented blacksmith named Charles. Charles was renowned throughout the land for his incredible craftsmanship and the unmatched quality of his creations. People traveled great distances to purchase his fine swords, delicate jewelry, and durable tools. Charles felt immense pride in his work and was always eager to share his knowledge with anyone who showed a genuine interest in his craft. One sunny day, as Charles hammered away at his anvil, a young woman named Emily approached his workshop with a sense of wonder in her eyes. She marveled at the intricate designs and the gleaming metalwork that adorned the walls. Feeling a deep desire to learn the art of blacksmithing, Emily hesitantly asked Charles if he would be willing to teach her the secrets of his trade. Charles, a generous soul, agreed without hesitation, and so began Emily's apprenticeship. Each day, she absorbed the lessons of her mentor, gradually honing her skills and developing her unique style. As time passed, Emily's creations began to rival those of Charles, and together they forged a partnership that brought their village even greater fame and prosperity. One fateful evening, a fierce storm rolled in, bringing with it torrential rain and unrelenting winds. Lightning illuminated the sky, casting eerie shadows across the village. Suddenly, a massive bolt of lightning struck Charles and Emily's workshop, setting it ablaze. The villagers, working tirelessly to extinguish the flames, managed to save their beloved blacksmiths' lives, but the workshop and all their creations were lost to the fire. Undeterred, Charles and Emily decided to rebuild their workshop and continue their shared passion for blacksmithing. With the support of their community, they created a new, even grander workshop, and their artistry continued to flourish. The tale of their resilience and unwavering determination became a beacon of inspiration for generations to come.