QUESTION NO: 1
On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.
On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.
Correct Answer:
Select a blank cell and press insert. Pick win/loss sparklines. Select the data range. Click and drag the bottom right corner for more.
Topic 6, Enrollment
Topic 6, Enrollment
QUESTION NO: 2
On the ''Prices'' worksheet, in the ''Tax column, enter a formula that multiples the value in the ''Unit Price'' column by cell L2.
Check the Solution below.
On the ''Prices'' worksheet, in the ''Tax column, enter a formula that multiples the value in the ''Unit Price'' column by cell L2.
Check the Solution below.
Correct Answer:
=_*_
QUESTION NO: 3
On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.
On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.
Correct Answer:
Select the range and type the name
QUESTION NO: 4
On the ''Sales'' worksheet, in the 'City Code'' column, modify the formula to display the letters in unpercase.
Check the Solution below.
On the ''Sales'' worksheet, in the 'City Code'' column, modify the formula to display the letters in unpercase.
Check the Solution below.
Correct Answer:
=UPPER(text)