M1 AND M2 QUIZ Exam Question And
Answers 2024
In the Sale Orders worksheet, map the XML table
elements with the name being NewOrders to also
Overwrite the existing data with new data and Adjust
column width. Then export the current worksheet as an
XML data file named NewOrdersXML in the
GMetrixTemplates folder in your Documents folder. -
correct answers✅If you do not have the Developer tab,
you will need it.
Click on the File tab, select Options, and select the
Customize Ribbon tab.
Make sure that Developer is checked in the Main
Tabssection. Click OK.
In the Sale Orders worksheet, click into the table. In the
Developer tab, go to the XMLgroup and click Map
Properties.
In the XML Map Propertieswindow, in the Name field,
enter NewOrders. Under the Data formatting and
layoutsection, check the Adjust column width box.
Under the When refreshing or importing data section,
check the Overwrite existing data with new data radio
button and click OK.
In the Developer tab, go to the XML group and click
Export.
Locate your GMetrixTemplates folder inside your
Documents folder. In the file name, enter NewOrdersXML
and set the type to XML Files (*.xml) and click Export.
,M1 AND M2 QUIZ Exam Question And
Answers 2024
Create a custom document property named Completed.
For the Type, use Yes or No with the value set as No. -
correct answers✅In the File tab, in the Info section,
click on the dropdown for Properties in the right-hand
column.
Click Advanced Properties and choose the Custom tab.
In Name:, type Completed. In the dropdown for Type:,
choose Yes or No. In Value:, click No.
Click Add.
Click OK.
On the Office Records worksheet, modify the sheet
protection so that when the sheet is protected, only the
cell range E66:G84can be selected. All other cells should
not be selectable. Protect the sheet without a password. -
correct answers✅Select the entire worksheet by
clicking the Select Allbutton in the upper-left corner of the
sheet.
In the Home tab, locate the Font group and click the Font
dialog box launcher. In the Format cells dialog box, select
the Protection tab, check the Locked checkbox once, and
click OK.
Select the Range E66:G84.
In the Home tab, locate the Font group and click the Font
dialog box launcher. In the Format cells dialog box, select
the Protection tab, uncheck the Lockedcheckbox, and
click OK.
,M1 AND M2 QUIZ Exam Question And
Answers 2024
In the Review tab, locate the Protect group and click
Protect Sheet.
In the Protect Sheet dialog, in the Allow all users of this
worksheet to: list, uncheck everything in the list except
Select unlocked cells and click OK.
Encrypt the workbook so that it requires a password to
open. Use GMetrix as the password. Mark the workbook
as final. - correct answers✅Click the File tab.
In Info, select Protect Workbook. Choose Encrypt with
Password.
Type in GMetrix as the password and click OK. Type
GMetrix again to verify the password and click OK.
Select the dropdown for Protect Workbookand click Mark
as Final.
Click OK.
Share the current workbook so that change history is
saved for 90 days. Update the changes automatically
every 10 minutes. - correct answers✅In the Review
tab, locate the Protect group and select Share
Workbook.Share Workbook is now a Legacy feature and
may need to be enabled:Go to the File tab and select
Options.In the Customize Ribbon group, use the Choose
commands from:dropdown to select All Commands.Scroll
down in the left window until you find Share Workbook
(Legacy).In the right window, select the Review tab and
, M1 AND M2 QUIZ Exam Question And
Answers 2024
then click New Group.With New Group (Custom) selected,
click the Add >>button.Click OK.Share Workbook
(Legacy) should now be available under the Reviewtab,
New Groupgroup.
In the Advanced tab, locate Track Changes. Keep the
history for 90 days.
Under Update Changes, choose Automatically every: and
choose 10minutes.
Click OK.
Display all the changes that have ever been made by
anyone to this document and not by when, who, or
where. Don't highlight the changes on the screen, and list
the changes on a new sheet. - correct answers✅In the
Review tab, locate the Protect group and select the Track
Changes dropdown. Select Highlight Changes...Track
Changes is now a Legacy feature and may need to be
enabled:Go to the File tab and then Options.In the
Customize Ribbon group, use the Choose commands
from: dropdown to select All Commands.Scroll down in
the left window until you find Track Changes (Legacy).In
the right window, select the Review tab and then click
New Group.With New Group (Custom) selected, click the
Add >> button.Click OK.Track Changes (Legacy) should
now be available under the Review tab, New Group group.
In the Highlight Changes dialog box, make sure When:,
Who:, and Where: are unchecked. Uncheck Highlight
changes on screen.
Answers 2024
In the Sale Orders worksheet, map the XML table
elements with the name being NewOrders to also
Overwrite the existing data with new data and Adjust
column width. Then export the current worksheet as an
XML data file named NewOrdersXML in the
GMetrixTemplates folder in your Documents folder. -
correct answers✅If you do not have the Developer tab,
you will need it.
Click on the File tab, select Options, and select the
Customize Ribbon tab.
Make sure that Developer is checked in the Main
Tabssection. Click OK.
In the Sale Orders worksheet, click into the table. In the
Developer tab, go to the XMLgroup and click Map
Properties.
In the XML Map Propertieswindow, in the Name field,
enter NewOrders. Under the Data formatting and
layoutsection, check the Adjust column width box.
Under the When refreshing or importing data section,
check the Overwrite existing data with new data radio
button and click OK.
In the Developer tab, go to the XML group and click
Export.
Locate your GMetrixTemplates folder inside your
Documents folder. In the file name, enter NewOrdersXML
and set the type to XML Files (*.xml) and click Export.
,M1 AND M2 QUIZ Exam Question And
Answers 2024
Create a custom document property named Completed.
For the Type, use Yes or No with the value set as No. -
correct answers✅In the File tab, in the Info section,
click on the dropdown for Properties in the right-hand
column.
Click Advanced Properties and choose the Custom tab.
In Name:, type Completed. In the dropdown for Type:,
choose Yes or No. In Value:, click No.
Click Add.
Click OK.
On the Office Records worksheet, modify the sheet
protection so that when the sheet is protected, only the
cell range E66:G84can be selected. All other cells should
not be selectable. Protect the sheet without a password. -
correct answers✅Select the entire worksheet by
clicking the Select Allbutton in the upper-left corner of the
sheet.
In the Home tab, locate the Font group and click the Font
dialog box launcher. In the Format cells dialog box, select
the Protection tab, check the Locked checkbox once, and
click OK.
Select the Range E66:G84.
In the Home tab, locate the Font group and click the Font
dialog box launcher. In the Format cells dialog box, select
the Protection tab, uncheck the Lockedcheckbox, and
click OK.
,M1 AND M2 QUIZ Exam Question And
Answers 2024
In the Review tab, locate the Protect group and click
Protect Sheet.
In the Protect Sheet dialog, in the Allow all users of this
worksheet to: list, uncheck everything in the list except
Select unlocked cells and click OK.
Encrypt the workbook so that it requires a password to
open. Use GMetrix as the password. Mark the workbook
as final. - correct answers✅Click the File tab.
In Info, select Protect Workbook. Choose Encrypt with
Password.
Type in GMetrix as the password and click OK. Type
GMetrix again to verify the password and click OK.
Select the dropdown for Protect Workbookand click Mark
as Final.
Click OK.
Share the current workbook so that change history is
saved for 90 days. Update the changes automatically
every 10 minutes. - correct answers✅In the Review
tab, locate the Protect group and select Share
Workbook.Share Workbook is now a Legacy feature and
may need to be enabled:Go to the File tab and select
Options.In the Customize Ribbon group, use the Choose
commands from:dropdown to select All Commands.Scroll
down in the left window until you find Share Workbook
(Legacy).In the right window, select the Review tab and
, M1 AND M2 QUIZ Exam Question And
Answers 2024
then click New Group.With New Group (Custom) selected,
click the Add >>button.Click OK.Share Workbook
(Legacy) should now be available under the Reviewtab,
New Groupgroup.
In the Advanced tab, locate Track Changes. Keep the
history for 90 days.
Under Update Changes, choose Automatically every: and
choose 10minutes.
Click OK.
Display all the changes that have ever been made by
anyone to this document and not by when, who, or
where. Don't highlight the changes on the screen, and list
the changes on a new sheet. - correct answers✅In the
Review tab, locate the Protect group and select the Track
Changes dropdown. Select Highlight Changes...Track
Changes is now a Legacy feature and may need to be
enabled:Go to the File tab and then Options.In the
Customize Ribbon group, use the Choose commands
from: dropdown to select All Commands.Scroll down in
the left window until you find Track Changes (Legacy).In
the right window, select the Review tab and then click
New Group.With New Group (Custom) selected, click the
Add >> button.Click OK.Track Changes (Legacy) should
now be available under the Review tab, New Group group.
In the Highlight Changes dialog box, make sure When:,
Who:, and Where: are unchecked. Uncheck Highlight
changes on screen.
