1. In the Excel chart shown below, there are a few vertical lines encircled in red. Which of the following terms best defines these lines?

Select the single best answer:

A. scatter line

B. data label

C. error bar

D. vertical grid line

E. data bar

2. Which of the following phrases give examples of when a user might see the ######## error?

Select all answers that apply: (Could be more than one)

A. when a text value is wider than the cell width

B. when a cell contains values with more than 253 characters

C. when the divisor is zero

D. when a formula references a blank cell

E. when a cell with date formatting contains a negative value

3. Which of the following options can be used to concatenate values?

Select all answers that apply: (Could be more than one)

A. the CONCATENATE function

B. a comma (,)

C. a semicolon (;)

D. an ampersand (&)

E. a hash (#)

4. Which of the following statements about the VLOOKUP function is false?

Select the single best answer:

A. The lookup value must be searchable in the first column of the table array argument.

B. The first argument of the function is the lookup value.

C. Values must be sorted in ascending order when using the "exact match" parameter.

D. It helps to find the value in the vertically formatted table.

E. It can be used as an alternative to the INDEX function in some cases.