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 is a part of the Data Validation feature in Excel. Hence, we need to select the Data tab, go to the Data Tools group, and then select the arrow next to Data Validation, which will display a drop-down menu with the option to Circle Invalid Data. Option A (What-If Analysis) is not relevant to circling invalid data, while option C (Remove Duplicates) and option D (Consolidate worksheet data) are completely different features and not relevant to this task.

Question 2

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 3

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

To delete a macro, Kahir needs to go to the Macros option under the Tools menu. Therefore, the correct choice for X in the given series of selections is Macros.

Question 4

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...

Question 5

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 the validation criteria and setting the minimum value to 1 and maximum to 100 will restrict the cell to accept only whole numbers between 1 and 100. Choosing "Decimal" would allow non-whole numbers to be entered, and "List" or "Text length" are not applicable for this type of validation.

Question 6

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" to protect her Excel spreadsheet with a password. This will prompt her to enter a password to open the Excel file, preventing unauthorized access. The other options listed (Mark as Final, Protect Current Sheet, and Protect Workbook Structure) do not involve setting a password for accessing the file.

Question 7

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 8

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.

Question 9

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 answer of To unprotect a workbook, open the Excel...

Question 10

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

Pressing Alt + F11 will open the VBA window in Excel where you can write and run macro code.

Question 11

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

The option for "Input message" is selected to add the message "Select True or False from the drop-down list" in a cell under the column titled "Answer."

Question 12

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

Question 13

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 14

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 15

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 16

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 17

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 18

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 is the correct set of steps to protect a worksheet with a password and allow changes in selected elements.

Question 19

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 20

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 contains the necessary tools to manage comments, including the Delete button to clear a comment from a cell.

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?

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.

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?

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

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?

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?

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.

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. ​

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

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.

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.

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.

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?

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?

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 unprotect a workbook, open the Excel file, then click on Review > Unprotected Sheet, then enter the password for the unprotected sheet and click OK.