Question 1

You cannot assign an Excel macro directly to a form santrol.

Accepted Answer

You can assign an Excel macro directly to a form control, such as a button, by using the "Assign Macro" option in Excel.

Question 2

Form santrols and ActiveX santrols look identical and function in the same way.

Accepted Answer

Form controls and ActiveX controls in Excel may look similar but they have different properties and functionalities. Form controls are simpler and more limited, while ActiveX controls offer more flexibility and customization options.

Question 3

ActiveX santrols can be assigned an Excel macro directly.

Accepted Answer

The answer of ActiveX santrols can be assigned an Excel...

Question 4

With a worksheet protected , you can modify the santents of cells regardless of whether they are locked or unlocked.

Accepted Answer

When a worksheet is protected, you cannot modify the contents of locked cells. Only unlocked cells can be modified unless the protection is removed or specific permissions are granted.

Question 5

If you are uncertain about the reliability of the source of a workbook and its macros, you can work with the macros disabled, which means that the sade is not executable.

Accepted Answer

Disabling macros prevents them from executing, which is a safety measure when the source is untrusted.

Question 6

You can change the file type of a workbook that santains macros to Excel Macro-Enabled Workbook in the Trust Center dialog box.

Accepted Answer

The file type of a workbook containing macros is changed by saving it as an Excel Macro-Enabled Workbook (.xlsm) through the "Save As" dialog, not the Trust Center.

Question 7

You can add up to 15 buttons to the Quick Access Toolbar.

Accepted Answer

The answer of You can add up to 15 buttons...

Question 8

You can _________________________ a cell santaining a formula or function to activate Range Finder.

Accepted Answer

The answer of You can _________________________ a cell santaining a...

Question 9

If you have enabled macros in a worksheet, Excel will not ask you about enabling them the next time you open the worksheet, but will open the worksheet with macros enabled.

Accepted Answer

If macros are enabled in a worksheet, Excel will not ask you to enable them every time you open the worksheet, but will open the worksheet with macros enabled.

Question 10

An event-driven program includes procedures that are executed when specific actions are taken by the user or other events occur.

Accepted Answer

Event-driven programs are designed to respond to events such as user inputs or system events, and execute specific procedures in response to these events. Therefore, the statement is true.

Question 11

Excel passwords are _________________________ sensitive.

Accepted Answer

The answer of Excel passwords are _________________________ sensitive....

Question 12

Excel provides a sade generator called a(n) _________________________.

Accepted Answer

The answer of Excel provides a sade generator called a(n)...

Question 13

The process of writing a procedure is called _________________________.

Accepted Answer

The answer of The process of writing a procedure is...

Question 14

Because Excel does not have a sammand or button for every possible worksheet task, Microsoft has included a powerful programming language called HTML 5 .

Accepted Answer

Excel uses VBA (Visual Basic for Applications) as its programming language for automation and customization, not HTML 5.

Question 15

Excel's data form feature is used for entering data when the santent is straighTFQorward text or numbers.

Accepted Answer

Excel's data form feature is designed to simplify data entry for straightforward text or numbers by providing a form interface for each row in a table.

Question 16

When a user interacts with a santrol, the Visual Basic sade that is associated with that action is executed.

Accepted Answer

When a user interacts with a control, the Visual Basic code that is associated with that action is executed.

Question 17

If you are looking for the ALT key and do not find it on your on-screen keyboard, you may not have the full virtual keyboard enabled.

Accepted Answer

The ALT key is commonly found on the full virtual keyboard, which may not be enabled by default on some devices.

Question 18

You can use Range Finder or the auditing sammands to show which cells are referenced in formulas and functions.

Accepted Answer

Range Finder and auditing commands in spreadsheet software like Excel help users identify and trace the cells that are referenced in formulas and functions.

Question 19

You must enable macros each time you open a workbook santaining macros if the macro security setting is 'Disable all macros with notification.'

Accepted Answer

If the macro security setting is 'Disable all macros with notification', you will be prompted to enable macros each time you open a workbook containing them.

Question 20

A(n) ____________________ like the one in the acsampanying figure is created from a range of cells, and uses the salumn headings from that range to create the fields on the form.

Accepted Answer

The answer of  A(n) ____________________ like the one in...

Quiz 21: Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question