MO-200試験無料問題集「Microsoft Excel (Excel and Excel 2019) 認定」
You are analyzing insurance sales data for the first six months of the year.
On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent).
Set the indent to 1.
Check the Solution below.
On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent).
Set the indent to 1.
Check the Solution below.
正解：
In the alignment tab, click increase indent.
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.
正解：
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
On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' Check the Solution below.
正解：
On the data tab, click filter. Display only alpine.
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.
正解：
=_*_