Question

A spreadsheet contains the maximum weight and maximum height for fifty dog breeds. The breeds are located in rows, and the weights and heights are listed in columns. Emily needs to determine the maximum weight of the dog breed in row 43. Which tool could she use to quickly navigate to the information?

Answer 1

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 locate(ing) tool navigate to the information on the spread sheet