Question 1

Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?
A) What-If Analysis
B) Data Validation
C) Remove Duplicates
D) Consolidate worksheet data.

Accepted Answer

The option to circle invalid data comes under the data validation option in the data tools group, hence B is the correct choice. The other options mentioned - What-If Analysis, Remove Duplicates, and Consolidate worksheet data - do not have any option to circle invalid data.

Question 2

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 option for clearing a comment from a cell is located in the Comments group on the Review tab. Therefore, the correct choice is D, the Comments group.

Question 3

To change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Accepted Answer

To change the text fill color of WordArt, you need to select the WordArt text, click Text Fill on the Drawing Tools Format tab (or Shape Format tab in some versions), and then pick the color you want. The Text Color option is not present; it's Text Fill for changing the fill color.

Question 4

Sophia wants to change the location of a picture linked to her workbook to a different drive.To do so,she can click on the following series: Data tab > Edit links group > Select link to change > Change Source > Change Source Dialog box > Use controls in the dialog box to locate and select the file for new source of the link > Open > OK.

Accepted Answer

Sophia should follow this series to change the location of a linked picture in her workbook: Right-click on the picture > Link Options > Change Source, or for changing links to external data sources (not specifically pictures), she would use: Data tab > Edit Links > Change Source. The detailed path provided mixes steps for changing external data links, not specifically for changing the location of a linked picture.

Question 5

To unprotect a workbook,open the Excel file,then click on Review > Unprotected Sheet,then enter the password for the unprotected sheet and click OK.

Accepted Answer

The given instructions correctly describe the steps to unprotect a workbook in Excel.

Question 6

Martha and Mike are working on a project where Martha is creating a template in MS Excel that Mike will work upon. She wants to insert the message "Select True or False from the drop-down list" in a cell under a column titled "Answer." What should she select as X in the following clicks/entries/selections: (Select) cell > Data > Data Validation > Input Message > (Check box) Show input message when cell is selected > X > (Insert in box) Select True or False form the drop-down list?
A) Title
B) Heading
C) Input message
D) Insert message

Accepted Answer

Martha should select "Input message" as X because that is the option where she can add the message "Select True or False from the drop-down list" to appear as a message when a user selects the cell in question. The other options, such as "Title," "Heading," and "Insert message," do not offer the same functionality for adding an input message.

Question 7

Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements.To do so,she can first unlock editable cells,then click Review tab > Protect Sheet > Allow all users of this worksheet to list > Select the elements you want people to be able to change > OK.

Accepted Answer

This statement accurately describes the process for protecting a worksheet with a password and allowing changes in selected elements.

Question 8

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?
A) Ctrl + Z
B) Alt + F8
C) Ctrl + Shift
D) Alt + T + M + R

Accepted Answer

The answer of Esperanza wants to record a macro to...

Question 9

Mila wants to restrict a cell to accept only whole numbers between 1 and 100.What should she select as X in the following clicks/entries/selections: Select cell.Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select)between > Minimum > (select)1 > Maximum > (select)10 > OK > Enter number between 1 and 100 in cell?
A) Decimal
B) List
C) Text length
D) Whole number

Accepted Answer

Selecting "Whole number" as X will ensure that the cell only accepts integers. From there, Mila can select "between" and then set the minimum to 1 and the maximum to 100, which will restrict the cell to only accept whole numbers between 1 and 100.

Question 10

To unprotect a workbook,open the Excel file,then click on File > Info > Protect Workbook > Encrypt with Password > OK.

Accepted Answer

The answer of To unprotect a workbook,open the Excel file,then...

Question 11

Kahir wants to delete a macro.To do this,he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box.Which of the following will he select as X in this series of selections?
A) Macros
B) Excel Add-ins
C) Stop Recording
D) Visual Basic Editor

Accepted Answer

In the given series of selections, Kahir first needs to go to the "Macro" option under the "Tools" menu. Therefore, he needs to select "Macros" as the option for X. Once he selects "Macros", he can then choose the macro that he wants to delete and proceed with the remaining steps.

Question 12

Jean-Michelle wants to record the steps of a task as a macro.She clicks on the following series: Click View > Macros > X > Macro Name > Select list to run > Y.Which of the following can be X and Y in the given steps?
A) X- View Macros,Y- Run
B) X- Record Macros,Y- Run
C) X- Pause Recording,Y- Step
D) X- Pause Recording,Y- Edit

Accepted Answer

The answer of Jean-Michelle wants to record the steps of...

Question 13

The Error Alert Style,Stop in the dropdown list that opens under Error Alert tab highlights the invalid entry that can be overtyped.

Accepted Answer

The Stop style in the Error Alert tab prevents the user from entering invalid data by displaying a message and only allows the user to proceed by entering valid data or canceling the entry. It does not highlight the invalid entry for overtyping.

Question 14

Which of the following combinations of keys will you press to open the VBA window and run a macro code?
A) Alt + F9
B) Alt + F11
C) Alt + F4
D) Alt + Tab

Accepted Answer

To open the VBA window, we use the shortcut key Alt + F11. Once the VBA window is open, we can run a macro code by either clicking on the run button in the toolbar or by pressing the F5 function key.

Question 15

To share a protected workbook,place it on a network location,then click Review > Share Workbook > Editing tab > (Select)Allow changes by more than one user > Advanced tab > (Select)options for tracking and updating changes > OK > File > Save As > Share.

Accepted Answer

The described steps are for older versions of Excel. In newer versions, such as Excel for Microsoft 365, sharing a workbook is done by clicking on Share in the upper right corner, inviting people to collaborate, or by saving the workbook to OneDrive or SharePoint and then sharing a link. The "Share Workbook" feature described has been deprecated.

Question 16

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

Loralie should select "Encrypt with Password" in the Protect Workbook box under Options in the File tab to protect her Excel spreadsheet with a password. This will require anyone who wants to access the data in the spreadsheet to enter the password before they can do so. Mark as Final is just a way to indicate that a workbook is complete and discourage further editing, Protect Current Sheet only protects a single worksheet within the workbook, and Protect Workbook Structure only prevents users from modifying the structure of the workbook (such as adding or deleting worksheets).

Question 17

Joyce wants to stop recording the steps of a task as a macro.She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save.Which of the following can X be in the given steps?
A) View Macros
B) Record Macros
C) Pause Recording
D) Stop Recording

Accepted Answer

In the given sequence, after selecting "View" and then "Macros," the next logical step to stop recording a macro would be to view the macros that are currently being recorded or available, which is done by selecting "View Macros." The other options (Record Macros, Pause Recording, Stop Recording) do not fit the sequence described, as they are actions to start, pause, or stop recording, not to navigate to where you can stop a macro.

Question 18

Nathan wants to run a macro from the developer tab.He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run.What should he click as X in this procedure?
A) Macros
B) Visual Basic
C) Record Macro
D) Macro Security

Accepted Answer

To run a macro from the Developer tab, after enabling the Developer tab and navigating to it, you should click on "Macros" to access the list of available macros. From there, you can select a macro and run it.

Question 19

To lock certain cells in a worksheet to protect them,select the cells,then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select)Locked check box > OK to close the popup window.Then click on Review tab > Changes group > Protect Sheet.

Accepted Answer

This is the correct procedure to lock certain cells in a worksheet to protect them.

Question 20

Kai wants to hide a worksheet with a password to prevent other users from viewing it.To do so,he can Click Review > Protect Workbook > Enter a password in the Password box > OK.He can then retype the password to confirm it,and then click OK.

Accepted Answer

This is the correct process to protect a workbook with a password in Microsoft Excel.

Quiz 12: Developing an Excel Application

Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?

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 change the text fill color of WordArt,we need to select the WordArt text,click Text Color on the Drawing Tools Format tab and pick the outline color you want.

To unprotect a workbook,open the Excel file,then click on Review > Unprotected Sheet,then enter the password for the unprotected sheet and click OK.

Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements.To do so,she can first unlock editable cells,then click Review tab > Protect Sheet > Allow all users of this worksheet to list > Select the elements you want people to be able to change > OK.

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?

To unprotect a workbook,open the Excel file,then click on File > Info > Protect Workbook > Encrypt with Password > OK.

Kahir wants to delete a macro.To do this,he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box.Which of the following will he select as X in this series of selections?

Jean-Michelle wants to record the steps of a task as a macro.She clicks on the following series: Click View > Macros > X > Macro Name > Select list to run > Y.Which of the following can be X and Y in the given steps?

The Error Alert Style,Stop in the dropdown list that opens under Error Alert tab highlights the invalid entry that can be overtyped.

Which of the following combinations of keys will you press to open the VBA window and run a macro code?

To share a protected workbook,place it on a network location,then click Review > Share Workbook > Editing tab > (Select)Allow changes by more than one user > Advanced tab > (Select)options for tracking and updating changes > OK > File > Save As > Share.

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?

Joyce wants to stop recording the steps of a task as a macro.She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save.Which of the following can X be in the given steps?

Nathan wants to run a macro from the developer tab.He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run.What should he click as X in this procedure?

To lock certain cells in a worksheet to protect them,select the cells,then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select)Locked check box > OK to close the popup window.Then click on Review tab > Changes group > Protect Sheet.

Kai wants to hide a worksheet with a password to prevent other users from viewing it.To do so,he can Click Review > Protect Workbook > Enter a password in the Password box > OK.He can then retype the password to confirm it,and then click OK.