Microsoft Exam 77-427 Topic 8 Question 9 Discussion

In order to accomplish the task, Rick should take the following steps: Select all the five sheets. Write a disclaimer message in the A1 cell of the active sheet. Grouping of sheets is a feature provided in Microsoft Office Excel 2013. Selecting more than one sheet groups those sheets. When multiple sheets are grouped, data that a user enters or edits in the active sheet is reflected in all sheets in the group. To select all sheets, right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets. Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets.