FREE CES Advanced Excel Functions & Formulas Questions and Answers

Question 1

What is the purpose of the VLOOKUP function in Excel?

Accepted Answer

To lookup a value vertically in a table

Answer

The VLOOKUP function in Excel is designed to search for a specific value in the first column of a designated table array. Once found, it returns a corresponding value from a specified column in the same row. This effectively performs a vertical lookup, making it invaluable for retrieving related data.

Question 2

Which function is used to count the number of cells in a range that meet a specified condition?

Accepted Answer

COUNTIF

Answer

The COUNTIF function in Excel is specifically used to count the number of cells within a specified range that meet a single given criterion or condition. For example, it can count how many cells contain a certain text or a number greater than a specific value. This makes it a powerful tool for conditional data analysis.

Question 3

What does 'al dente' refer to in pasta cooking?

Accepted Answer

Firm to the bite

Answer

'Al dente' is an Italian term meaning 'to the tooth,' commonly used to describe pasta that is cooked to be firm but still tender when bitten. This texture indicates that the pasta is cooked through but retains a slight resistance. It prevents the pasta from becoming soft or mushy, ensuring a pleasant eating experience.

Question 4

How should you store fresh herbs to extend their shelf life?

Accepted Answer

Refrigerate them in a damp paper towel

Answer

Fresh herbs thrive in a cool, slightly humid environment, similar to how they grow. Wrapping them loosely in a damp paper towel and storing them in the refrigerator helps maintain their moisture without making them soggy. This method significantly extends their freshness and shelf life, preserving their flavor and aroma.

Question 5

What is the ideal internal temperature for cooking beef steaks?

Accepted Answer

145°F for medium-rare

Answer

The USDA recommends 145°F as the minimum safe internal temperature for whole cuts of beef, followed by a three-minute rest. This temperature typically results in a medium-rare doneness, characterized by a warm red center. This doneness is often preferred for steaks due to its tenderness and juiciness.

CES - Certified Excel Specialists Practice Test

CES - Certified Excel Specialists Practice Test

FREE CES Advanced Excel Functions & Formulas Questions and Answers