How do you create a cell featuring a drop down list of values?

Suppose cell A1 has value '1' and cell B1 has value '2'. After merging cell A1 and B1, what will be the value of Cell A1?

How can you write an IF statement so that it has more than one criterion?

Which of the following is a concatenating operator?

What formula returns the number of cells in column A that are greater than 50?

In the formula =VLOOKUP(a2,c2:d100,2,false) the final argument indicates:

The study of human interaction with machines in general is called ____.

The if function's logical test returns _____ result.

The format painter button is found in the ____ group on the home tab of the ribbon.

The following sequence, 2, 4, 6, etc., is an example of a ____ series.

The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.