When and why woulddata validationbe 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.

Question2

Not yet answered

Scored out of 2.00

Flag question

Question text

What purpose does an input message serve when usingData Validationin 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.

Question3

Not yet answered

Scored out of 2.00

Flag question

Question text

WhichofthefollowingistruewithrespecttotherangeofcellsusedtodefinetheTable_array argument when using the VLOOKUPfunction?

Select one:

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

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

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

d.The range used to define the Table_array argument is the lookupvalue.

Question4

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 lookupvalue?

Select one:

a.with the number15

b.with the rangeB3:B15.

c.with cell locationB15

d.with the number13.

Question5

Not yet answered

Scored out of 2.00

Flag question

Question text

ColumnAcontainsvaluesthatwillbeusedtodefinetheLookup_valueargumentofaVLOOKUP function.Thefunctionwill searchforanexactmatchtothelookupvalueintherangeA2:D15in theDescription Listworksheet. 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)