When and why would data validation be useful in a worksheet?

Select one:

a. Control types of information that can be entered in a cell.

b. Stop the user from entering incorrect data.

c. Warn the user the data entered is incorrect

d. All of the above.

Question 2

Not yet answered

Scored out of 2.00

Flag question

Question text

What purpose does an input message serve when using Data Validation in a cell?

Select one:

a. Clutters up the worksheet.

b. Informs the user about what data to enter in the cell

c. Not necessary for good spreadsheet presentation.

d. None of the above.

Question 3

Not yet answered

Scored out of 2.00

Flag question

Question text

Which of the following is true with respect to the range of cells used to define the Table_array argument when using the VLOOKUP function?

Select one:

a. The lookup value must exist in the first row of this range.

b. The lookup value must exist in the first column of this range.

c. This range must be sorted in ascending order if the Range_lookup argument is defined with the word FALSE.

d. The range used to define the Table_array argument is the lookup value.

Question 4

Not yet answered

Scored out of 2.00

Flag question

Question text

Assume that the range B3:E23 is used to define the Table_array argument for an HLOOKUP function. How should the Row_index_num argument be defined if the output of the function should be the contents of the cell location in Row 15 in the same column as the lookup value?

Select one:

a. with the number 15

b. with the range B3:B15.

c. with cell location B15

d. with the number 13.

Question 5

Not yet answered

Scored out of 2.00

Flag question

Question text

Column A contains values that will be used to define the Lookup_value argument of a VLOOKUP function. The function will search for an exact match to the lookup value in the range A2:D15 in the Description List worksheet. The output of the function should be the contents in the cell location in Column C of the same row as the lookup value. Once the function is created, it will be copied and pasted to other cell locations in the same column. Which of the following VLOOKUP functions will provide an accurate result based on these criteria?

Select one:

a. =VLOOKUP(A4,Description List!A2:D15,2,FALSE)

b. =VLOOKUP($A$4,Description List!$A$2:$D$15,2,FALSE)

c. =VLOOKUP(A4,Description List!$A$2:$D$15,3,TRUE)

d. =VLOOKUP(A4,Description List!$A$2:$D$15,3,FALSE)