Exam 11: User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Which of the following properties is used to specify the way the control is attached to the cells below it,while inserting a command button (ActiveX control)into a worksheet?

Musa wants to choose a standard color theme for an Excel worksheet he is working on.He clicks on the Page Layout tab and then clicks Colors.What should he do next to complete the procedure?

Return value comments help others understand what values are returned by a procedure.

If you want to write a macro for a workbook in use,you need to first click the name of the VBA Project in the Project Explorer window.

You can open the VBA editor with the keyboard shortcut Alt + F11.

To copy and paste comments in an Excel sheet,select the cell containing the comment and press Ctrl+V.Then select the cell where you want to paste the comment,right click on it and select Paste Special from the popup menu.

To turn track changes on in an Excel sheet,click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

Nadine wants to insert a sparkline in Excel using the Quick Analysis tool.She can do this by selecting the data for which she wants to add Sparklines,then in the empty column to the right side of the data click the Quick Analysis button,click Sparklines and select the type of Sparkline she wants.

For use as watermark,Alba wants to insert a picture as a worksheet background.For this,she clicks the worksheet she wants to display with a background,then selects an option X from the Page Layout tab in the Page Setup group.Alba then selects the picture for use as background,and then clicks Insert.What can X in her series of selections be?

Which of the following will you select on the Color and Lines tab to adjust the gradient,texture,and pattern of a form control?

Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously.For this,she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box.What can X and Y be in the series of clicks?

What should be selected in the Formula Bar to manually rename a form control button after clicking and selecting a new button?

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

To show a comment in an active cell,select the cell,then click Review tab > Comments group > Show/Hide Comment.

To set the default language,open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Which of the following properties is used to specify the name of the control while inserting a text box control (ActiveX control)into a worksheet?

Which of these combination of keys will you click to clear an outline?

In order to reject changes made by all users in a workbook,click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook)> Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.

To insert a spin button(form control)into a worksheet,click the Developer tab > Insert > Form Controls > Button labeled as "Aa."

Rukha has created two custom views of a worksheet.In one view,all rows and columns can be seen whereas in the other,specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?