Answer:
a. Locate
Explanation:
Question options (obtained on the net):
a. Locate
b. Sort
c. Filter
d. Replace
Explanation:
The largest value of the weights of the dog breed in row 43 is the maximum weight of the dog breed in the row
The 'MAX' formula or the 'Autosum' tool can be used to give the largest value in a row, or column
To locate the maximum value in MS Excel, the ADDRESS and MATCH and MAX functions are combined and entered into the blank cell on the right, specifying the same range for the MAX and MATCH functions, and a '0' for the MATCH function as well as a '1' for the ADDRESS function as follows;
=ADDRESS(MATCH(MAX(A1:E1), A1:E1, 0), 1)
Therefore, to navigate to the maximum weight, Emily should use a <em>locate</em>(ing) tool navigate to the information on the spread sheet
I think it’s A or D hope that helps
The answer is price i have gone over this specific lesson multiple times.
