Data Entry Clerk Test

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.

In a new code language called Adira, 

- '4A, 2B, 9C' means 'truth is eternal'
- '9C, 2B, 8G, 3F' means 'hatred is not eternal'
- '4A, 5T, 3F, 1X' means 'truth does not change'

What is the code for 'hatred' in Adira?

Fin copied the data from a printed sheet to the computer to upload to our server. How many attributes did they make an error in copying?

You are a professional chef reviewing a recipe for a cooking class you're teaching. The recipe is for a classic Margherita pizza and includes the following ingredients:

- Pizza dough
- Tomato sauce
- Mozzarella cheese
- Fresh basil
- Extra-virgin olive oil

However, when you read the step-by-step instructions, you see the following steps:

1. Preheat the oven to 475°F (245°C).
2. Roll out the pizza dough on a floured surface.
3. Spread the tomato sauce over the dough.
4. Arrange the sliced bell peppers and mushrooms evenly over the sauce.
5. Sprinkle mozzarella cheese on top.
6. Bake for 12-15 minutes until the crust is golden and the cheese is bubbly and slightly browned.
7. Remove from the oven and garnish with fresh basil and a drizzle of olive oil before serving.

What is the issue with the recipe instructions?

A: The oven temperature is set too high.
B: The pizza dough should not be rolled out on a floured surface.
C: The tomato sauce is applied in the wrong step.
D: Ingredients mentioned in the instructions are not listed in the recipe.
E: No issues were found in the recipe instructions.

Our data entry intern was helping us out with some work over the weekend. We took a small sample from their work to check for any mistakes. Could you help us understand how many of the intern's entries contained errors?

You are an executive assistant tasked with proofreading an email before it's sent to a potential client. Here's the draft:

Which of the following corrections should be made to this email?

A: Change "apprecaite" to "appreciate"
B: Change "optimizes" to "optimize"
C: Change "hesistate" to "hesitate"
D: Changes A and B
E: Changes B and C
F: Changes C and A
G: Changes A, B and C
H: No changes necessary

You are a public health officer reviewing a report on a recent outbreak of a rare disease in a small town. The report includes the following data:

- The outbreak started on June 1, 2023.
- The peak of the outbreak occurred in mid-July, with over 100 new cases daily.
- The outbreak was controlled by early August 2023.
- A total of 1,250 cases were reported.

However, in the section on patient demographics, the report states, "Of the 1,350 patients affected, 65% were adults (18-64), 20% were seniors (65 and above), and 15% were children (below 18)."

What is the discrepancy in the report?

A: The timeline of the outbreak is inconsistent.
B: The peak of the outbreak is misstated.
C: The total number of reported cases doesn't match with the patient demographics data.
D: The age groups for the demographics are incorrect.
E: No discrepancy was found in the report.

You are a technology analyst reviewing a report on the performance of a new software update. The report includes the following details:

- The update was released in January 2023.
- It targeted to improve processing speed by 15%.
- User feedback surveys report an average satisfaction score of 4 out of 5.
- Out of the 1000 survey responses, 850 users rated their satisfaction with the update as 3 or below.

What is the discrepancy in the report?

A: The release date of the software update is incorrect.
B: The projected improvement in processing speed is overstated.
C: The average user satisfaction score contradicts the findings of the user feedback survey.
D: The number of survey responses is incorrectly stated.
E: No discrepancy was found in the report.

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)