Microsoft Excel (Excel and Excel 2019) (MO-200) Free Practice Test
Question 1
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.
Check the Solution below.
Correct Answer:
=_*_
Question 2
On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.
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 3
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
Check the Solution below.
Correct Answer:
Click on the green plus sign and press axis titles.
Question 4
On the ''Enrollment'' worksheet, in cells G5:G25, insert Column sparkliness to compare the last, current, and next term values for each class period.
Check the Solution below.
Check the Solution below.
Correct Answer:
Select a blank cell and press insert. Pick column sparklines. Select the data range. Click and drag the bottom right corner for more.