최신Microsoft Excel (Excel and Excel 2019) - MO-200무료샘플문제
문제1
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.
정답:
=UPPER(text)
문제2
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
정답:
Click on the green plus sign and press axis titles.
문제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.
정답:
Select the range and type the name
문제4
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Check the Solution below.
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Check the Solution below.
정답:
On the home tab, click find and select and click find. Type agriculture and press find all. Select all and then delete them with the home tab by clicking delete sheet rows.