Examlex

Solved

Using the Spreadsheet Below, Give the Cell Address Which Would

question 18

Essay

Using the spreadsheet below, give the cell address which would have the formula shown.  Cell Formula  Belongs in Cell =VLOOKUP(B18,$ B$10:$C$12,2)=VLOOKUP(D23,$ F$11:$G$14,2)=K19($I$16I19)=VLOOKUP(H27,$ B$10:$C$12,2)=AVERAGE(L18:L27)\begin{array}{|l|l|}\hline{\text { Cell Formula }} & \text { Belongs in Cell } \\\hline=\mathrm{VLOOKUP}(\mathrm{B} 18, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\\hline=\mathrm{VLOOKUP}(\mathrm{D} 23, \$ \mathrm{~F} \$ 11: \$ \mathrm{G} \$ 14,2) & \\\hline=\mathrm{K} 19^{*}(\$ \mathrm{I} \$ 16-\mathrm{I} 19) & \\\hline=\mathrm{VLOOKUP}(\mathrm{H} 27, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\\hline=\mathrm{AVERAGE}(\mathrm{L} 18: \mathrm{L} 27) & \\\hline\end{array}  Using the spreadsheet below, give the cell address which would have the formula shown.  \begin{array}{|l|l|} \hline{\text { Cell Formula }} & \text { Belongs in Cell } \\ \hline=\mathrm{VLOOKUP}(\mathrm{B} 18, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\ \hline=\mathrm{VLOOKUP}(\mathrm{D} 23, \$ \mathrm{~F} \$ 11: \$ \mathrm{G} \$ 14,2) & \\ \hline=\mathrm{K} 19^{*}(\$ \mathrm{I} \$ 16-\mathrm{I} 19) & \\ \hline=\mathrm{VLOOKUP}(\mathrm{H} 27, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\ \hline=\mathrm{AVERAGE}(\mathrm{L} 18: \mathrm{L} 27) & \\ \hline \end{array}


Definitions:

Product Liability Suit

A legal claim against a manufacturer or seller for producing or selling a defective product that caused harm to the consumer.

Negligence

The failure to exercise the level of care that a reasonably prudent person would under similar circumstances, resulting in harm.

Cause in Fact

A legal principle determining whether a defendant's actions are the actual cause of the plaintiff's injury.

Injury

A physical or mental harm to a person that is caused by an accident, disease, or some other event.

Related Questions