MO-200 試験問題を無料オンラインアクセス

試験コード:MO-200
試験名称:Microsoft Excel (Excel and Excel 2019)
認定資格:Microsoft
無料問題数:32
更新日:2025-09-05
評価
100%

問題 1

From the ''Graduation'' worksheet. Move the chart to a new chart sheet named ''Graduation Chart.'' Check the Solution below.

問題 2

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.

問題 3

On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' Check the Solution below.

問題 4

Remove hidden properties and personal information from the workbook. Do not remove any other content.
Check the Solution below.

問題 5

You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ''Substitutes'' worksheet beginning at cell A1, import the data from the Substitutes text file in the Documents folder. Use the first row of the data source as headers.
Check the Solution below.

コメントを追加

あなたのメールアドレスが公開されることはありません。個人情報に関する内容は隠されます *

insert code
画面にある文字を入力してください。