Question 1

Which of the following should you select as X in the series of clicks to clear a comment from a cell: Cell containing comment > Review tab > X > Delete button?
A) Changes group
B) Proofing group
C) Language group
D) Comments group

Accepted Answer

The "Comments" group in the "Review" tab contains all the functions related to comments, including clearing them from a cell.

Question 2

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

Accepted Answer

To delete comments, you need to select the cell containing comments, right-click on it, and select the "Delete Comment" option from the menu.

Question 3

One can select the macro one wants to edit in the Macro Name box.

Accepted Answer

This is true, one can select the macro they want to edit from the Macro Name box.

Question 4

What is the default number of days for Excel change history?
A) 15
B) 30
C) 60
D) 90

Accepted Answer

The default number of days for Excel change history is 30. This means that any changes made to the spreadsheet within the past 30 days can be accessed in the version history.

Question 5

Stella wants to merge two workbooks.She begins by opening the workbooks,then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy,pressing and holding the Shift key,and then clicking on the last sheet tab.Then she right-clicks on one of the selected tabs and selects an option from the menu.Which of the following can her selection be?
A) Insert
B) Rename
C) View Code
D) Move or Copy

Accepted Answer

The option to "Move or Copy" the selected worksheets is the best choice for merging two workbooks, as it allows Stella to choose which workbook to copy the selected sheets into. The other options (Insert, Rename, View Code) do not directly relate to merging workbooks.

Question 6

The initial screen of Visual Basic Editor provides four GUI elements: Menu bar,Toolbar,Project Explorer,and Property Window.

Accepted Answer

This statement is true. The initial screen of Visual Basic Editor does provide these four GUI elements.

Question 7

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she select in the Protect Workbook box under Options in the File tab to do this?
A) Mark as Final
B) Encrypt with Password
C) Protect Current Sheet
D) Protect Workbook Structure

Accepted Answer

Encrypting with a password is the most effective way to protect an Excel workbook from unauthorized access. It requires entering a password before the file can be opened or any editing can be done. Options A (Mark as Final), C (Protect Current Sheet), and D (Protect Workbook Structure) do offer some level of protection, but they can be easily bypassed or disabled, providing less security than encryption with a password.

Question 8

Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?
A) Send
B) Send Now
C) Send to Mail Recipient
D) Send to Exchange Folder

Accepted Answer

"Send to Mail Recipient" is the option that should be selected in the Quick Access Toolbar to email a workbook as an attachment.

Question 9

To run code,use shortcut Ctrl+Alt+N.

Accepted Answer

This shortcut is used to run code in the Visual Studio Code editor.

Question 10

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Accepted Answer

This statement is true. To change theme effects, you need to click on Effects on the Page Layout tab and then select the set of effects that you want to use.

Question 11

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

Accepted Answer

This keyboard shortcut is used to open the VBA editor in Excel.

Question 12

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?
A) Insert
B) Developer
C) Formulas
D) Page Layout

Accepted Answer

The Page Layout tab usually contains options related to formatting the document and would be the most logical choice for finding the option to save a custom theme. The other options are unrelated to formatting and customization of the document theme.

Question 13

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office? A) The Specific People B) The People with Existing Access C) The Co-workers in . D) The People in .

Accepted Answer

The answer of Which of the following options will you...

Question 14

To choose a standard theme color,click on the Insert tab,click Colors,then pick the color set you want.

Accepted Answer

To choose a standard theme color, you should click on the Design tab, not the Insert tab, and then click Colors to pick the color set you want.

Question 15

The .NET Framework calls the Main procedure when it has loaded the application and is ready to pass control to it.

Accepted Answer

The Main procedure is the entry point of a .NET application and is automatically called by the .NET Framework when the application is loaded.

Question 16

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?
A) Pick the color set he wants.
B) Enter numbers on the Custom tab.
C) Select More Colors,and then pick a color on the Standard tab.
D) Under Customize Colors,click the button next to the theme color he wants to change and then pick a color under Theme Colors.

Accepted Answer

Musa should pick the color set he wants after clicking on the Colors option under the Page Layout tab to complete the procedure.

Question 17

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be?
A) Next
B) Delete
C) Previous
D) New Comment

Accepted Answer

The answer of Esther wants to accept track changes in...

Question 18

Sven wants to create a custom theme font set for the heading and body of a presentation.Under tab X,he selects Fonts,and then selects Create New Theme Fonts.Then he selects a heading font,a body font,types in a name for his theme font set and clicks Save.Which of the following can tab X be in the above-mentioned procedure?
A) Insert
B) Design
C) Review
D) Developer

Accepted Answer

The procedure described involves creating a custom theme font set, which is a design element. Therefore, tab X is most likely to be the Design tab in Microsoft PowerPoint.

Question 19

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?
A) X- View tab,Y- Show group
B) X- Insert tab,Y- Links group
C) X- Review tab,Y- Changes group
D) X- Developer tab,Y- Controls group

Accepted Answer

The steps described in the question mention the option to "Allow changes by more than one user at the same time", which is located in the Changes group under the Review tab. Therefore, X should be the Review tab, and Y should be the Changes group. Option A is incorrect because the Show group under the View tab does not have the necessary option to allow multiple users to edit the workbook simultaneously. Option B is incorrect because the Links group under the Insert tab is not related to sharing a workbook. Option D is incorrect because the Controls group under the Developer tab is for adding form controls and ActiveX controls to a workbook, not for sharing it.

Question 20

To open the macro dialog box for editing a macro in Visual Basic Editor,press Alt+F8.

Accepted Answer

Pressing Alt+F8 in the Visual Basic Editor opens the macro dialog box which allows you to edit macros.

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

Which of the following should you select as X in the series of clicks to clear a comment from a cell: Cell containing comment > Review tab > X > Delete button?

To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.

One can select the macro one wants to edit in the Macro Name box.

What is the default number of days for Excel change history?

The initial screen of Visual Basic Editor provides four GUI elements: Menu bar,Toolbar,Project Explorer,and Property Window.

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it.What should she select in the Protect Workbook box under Options in the File tab to do this?

Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?

To run code,use shortcut Ctrl+Alt+N.

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

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

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?

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

To choose a standard theme color,click on the Insert tab,click Colors,then pick the color set you want.

The .NET Framework calls the Main procedure when it has loaded the application and is ready to pass control to it.

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?

Esther wants to accept track changes in a file.To do this,she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab.She then clicks Accept to accept the track change.What can X in the procedure be?

To open the macro dialog box for editing a macro in Visual Basic Editor,press Alt+F8.