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

To sum values in a range.

Answer

To join two columns together.

Answer

To find the maximum value in a range.

Question 2

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

Accepted Answer

COUNTIF

Answer

SUMIF

Answer

IF

Answer

AVERAGEIF

Question 3

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

Accepted Answer

Firm to the bite

Answer

Soft and mushy

Answer

Overcooked

Answer

Crunchy

Question 4

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

Accepted Answer

Refrigerate them in a damp paper towel

Answer

Store them in a dry place

Answer

Freeze them immediately

Answer

Place them in direct sunlight

Question 5

What is the ideal internal temperature for cooking beef steaks?

Accepted Answer

145°F for medium-rare

Answer

165°F for medium-well

Answer

120°F for rare

Answer

160°F for well-done

Question 6

Which technique is used to infuse flavor into meat during cooking?

Accepted Answer

Marinating

Answer

Braising

Answer

Searing

Answer

Poaching

Question 7

What is the purpose of resting meat after cooking?

Accepted Answer

To redistribute the juices

Answer

To cool it down

Answer

To let the meat absorb more heat

Answer

To enhance the flavor by adding salt

Question 8

How should you handle hot oil when frying?

Accepted Answer

Use a deep fryer or a pan with a thermometer

Answer

Always add cold items directly to the oil

Answer

Never use a lid when frying

Answer

Let the oil reach a very high temperature

Question 9

What is the primary reason for allowing meat to rest after cooking?

Accepted Answer

To allow the juices to redistribute

Answer

To make the meat crispy

Answer

To increase the temperature

Answer

To make the meat more flavorful