Click on the tab where you will find "Data Validation"

Keyboard controls

Add selection

You can add and move any pin on the image

Question $3$

$1$

Point

Click on the Legend.

Keyboard controls

Add selection

You can add and move any pin on the image

Question $4$

$1$

Point

vlookup.jpg

Imagine we want to calculate CURRENT YEAR's Quantity. It is based on LAST YEAR's Quantity and an increase amount based on the RATING and POLICY TABLE.

Which VLOOKUP formula would give us the CURRENT YEAR's quantity in cell D$6?$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)+$ B$6$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6$

VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6+$ B$6$

$=$ VLOOKUP $($ G$6,$ C$6$:I$10,2)*$ B$6+$ B$6$

$=$ VLOOKUP $($ C$6,$ $G$$6$:$I$$10,2)*$ B$6+$ B$6$

Question $5$

$1$

Point

If last year our revenue in cell E$5$ was $$125,000,000$ but this year we are expecting a decrease of $4\%$ which formula would be correct?

$=$ E$5*104\%$

E$5-($E$5*4\%)$

$=$ E$5*4\%-$ E$5$

$=$ E$5*96\%$

$=$ E$5-($ E$5*4)$

Question $6$

$1$

Point

If last year our revenue in cell L$5$ was $$215,000,000$ but this year we are expecting an Increase of $2\mathrm{.}5\%.$ Which formula would be correct?

$=$ L$5+$ L$5*2\mathrm{.}5$

$=$ L$5-$ L$5*\mathrm{.}025$

$=$ L$5+$ L$5*\mathrm{.}025$

L$5+$ L$5*2\mathrm{.}5\%$

$=$ L$5+$ L$5*\mathrm{.}25$

Question $7$

$1$

Point

In the image we want to calculate CURRENT YEAR's Quantity. It is based on LAST YEAR's QUANTITY increased by $3\%.$ Which of the following formulas would be correct to enter in D$4?$

Ifstatement.jpg

$=$ B$4+103\%$

$=$ B$4*103\%$

B$4+$ B$4*3\%$

B$4+($B$4*3\%)$

$=$ B$4*($ B$4+3\%)$

Question $8$

$1$

Point

Hide.jpg

In the screen shot, columns D$,$ E and F are missing. The command to bring them back is:

Bring Back

Return

Unhide

Unchange

Open Sesame

Find

Appear