Question

what does the third argument (3) refer to in the following formula: vlookup(10005, a1:c6, 3, false)?
number of the column containing the return value
location of the lookup table
cell with the lookup value
whether to return a value only when an exact match is found
question 17 (1 point)
kathy wants to add the numbers entered in a range of selected cells. to do this, which tab will she click on the menu that appears after clicking on totals in the quick analysis option?
sum
count
average
%total
question 18 (1 point)
when valerie used autofill to copy a formula, excel copied the format and removed shading from some cells. what can she do to prevent the formatting change?
click the autofill options button and then click fill without formatting.
click the autofill options button and then click fill formatting only.
click the paste options button and then click undo.
click the quick analysis button and then click fill without formatting

Explanation:

Answer:

number of the column containing the return value
Sum
Click the AutoFill Options button and then click Fill Without Formatting.