Question 1

Which of the following does a VBA macro manipulate?

Accepted Answer

VBA manipulates objects.An object in VBA is an item available for you to control in your code.

Question 2

Which of the following tools enables users to view and edit a VBA macro?

Accepted Answer

You perform actions in VBA by writing (or recording)code in a VBA macro.You view and edit VBA macros using the Visual Basic Editor (VBE).

Question 3

Which of the following is a component of a macro that performs some action on or with objects?

Accepted Answer

A VBA macro consists of Sub procedures.A Sub procedure is computer code that performs some action on or with objects.

Question 4

Which of the following statements is true about a macro in Excel?

Accepted Answer

A macro is a set of actions recorded or written by a user.For instance,you can create a macro that always prints your name in bold on a spreadsheet.You can name it PrintName and then reuse the PrintName macro in any spreadsheet.This term means that a series of steps is completed automatically.

Question 5

Which of the following Excel tools allows you to record a sequence of commands in Excel and save them?

Accepted Answer

The macro recorder is a software tool that lets you record a sequence of commands in Excel and save them as a macro.This is invaluable if you are struggling with some programming syntax.Just get the recorder to do it for you and then view the code to see how it is done.

Question 6

VBA is:

Accepted Answer

VBA,which stands for Visual Basic for Applications,is a programming language developed by Microsoft.Excel,along with the other members of Microsoft Office,includes the VBA language.VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.

Question 7

Which of the following is a built-in function in Excel and does not require a macro?

Accepted Answer

Some common uses for VBA macros: Developing new worksheet functions-Although Excel includes numerous built-in functions (such as SUM and AVERAGE),you can create custom worksheet functions that can greatly simplify your formulas.

Question 8

Which of the following Excel tools allows you to automate the building and running of complex calculations that are not included in the standard set of Excel functions?

Accepted Answer

VBA extends and customizes Excel,allowing you to do things that Excel itself is not able to do,such as calculating values in cells based on user input values.

Question 9

Which of the following is a set of Excel actions recorded or written by a user?

Accepted Answer

A macro is a set of actions recorded or written by a user.For instance,you can create a macro that always prints your name in bold on a spreadsheet.You can name it PrintName and then reuse the PrintName macro in any spreadsheet.

Question 10

Which of the following VBA macros can be used in a worksheet formula?

Accepted Answer

A VBA macro can also have Function procedures.A Function procedure is a VBA macro that returns a single value.You can call it from another VBA macro or even use it as a function in a worksheet formula.

Question 11

Which of the following refers to a place used to store a piece of information in Excel?

Accepted Answer

You can assign values to variables.A variable is a place to store a piece of information.You can use variables in your VBA macro to store such things as values,text,or property settings (such as a font color or alignment).

Question 12

Units of VBA code are often referred to as ____.

Accepted Answer

Units of VBA code are often referred to as macros.

Question 13

Mr.Joseph is the CEO of a leading manufacturing concern.He wanted his name and designation to appear in italics on all the spreadsheets of the company's annual report.Which of the following Excel action should he use to achieve this?

Accepted Answer

A macro is a set of actions recorded or written by a user.For instance,you can create a macro that always prints your name in bold on a spreadsheet.You can name it PrintName and then reuse the PrintName macro in any spreadsheet.

Question 14

Which of the following is a programming language that includes build-in commands that mimic the functionality available from menus and dialog boxes within an application?

Accepted Answer

A macro language is a programming language that includes built-in commands that mimic the functionality available from menus and dialog boxes within an application.

Question 15

Dan was making a science project.He wanted to automate the two steps of adding a background theme to the cells and then printing the worksheet.Which of the following Excel actions can help Dan achieve this?

Accepted Answer

A macro is a set of actions recorded or written by a user.For instance,you can create a macro that always prints your name in bold on a spreadsheet.You can name it PrintName and then reuse the PrintName macro in any spreadsheet.

Question 16

A(n)_____ in VBA is an item available for you to control in your code.

Accepted Answer

VBA manipulates objects.An object in VBA is an item available for you to control in your code.Excel provides more than 100 objects that you can manipulate.Examples of objects include a workbook,a worksheet,a cell range,a chart,and a shape.

Question 17

Which of the following is true about Function procedures?

Accepted Answer

A VBA macro can also have Function procedures.A Function procedure is a VBA macro that returns a single value.

Question 18

When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE).After a while he wanted to go back to the Excel application interface.Which of the following key(s)should Ben use to toggle between the Excel application interface and the VBE?

Accepted Answer

The quickest way to activate the VBE is to press Alt + F11 when Excel is active.To return to Excel,press Alt + F11 again.(Alt + F11 acts as a toggle between the Excel application interface and the VBE. )

Question 19

Which of the following is a VBA macro that returns a single value?

Accepted Answer

A VBA macro can also have Function procedures.A Function procedure is a VBA macro that returns a single value.

Question 20

Which of the following keys will you press to activate the VBE when Excel is active?

Accepted Answer

The quickest way to activate the VBE is to press Alt + F11 when Excel is active.To return to Excel,press Alt + F11 again.(Alt + F11 acts as a toggle between the Excel application interface and the VBE. )

Quiz 22: Programming in Excel With VBA

Which of the following does a VBA macro manipulate?

Which of the following tools enables users to view and edit a VBA macro?

Which of the following is a component of a macro that performs some action on or with objects?

Which of the following statements is true about a macro in Excel?

Which of the following Excel tools allows you to record a sequence of commands in Excel and save them?

VBA is:

Which of the following is a built-in function in Excel and does not require a macro?

Which of the following Excel tools allows you to automate the building and running of complex calculations that are not included in the standard set of Excel functions?

Which of the following is a set of Excel actions recorded or written by a user?

Which of the following VBA macros can be used in a worksheet formula?

Which of the following refers to a place used to store a piece of information in Excel?

Units of VBA code are often referred to as ____.

Mr.Joseph is the CEO of a leading manufacturing concern.He wanted his name and designation to appear in italics on all the spreadsheets of the company's annual report.Which of the following Excel action should he use to achieve this?

Which of the following is a programming language that includes build-in commands that mimic the functionality available from menus and dialog boxes within an application?

Dan was making a science project.He wanted to automate the two steps of adding a background theme to the cells and then printing the worksheet.Which of the following Excel actions can help Dan achieve this?

A(n) _____ in VBA is an item available for you to control in your code.

Which of the following is true about Function procedures?

When working on a worksheet,Ben was editing his macros using the Visual Basic Editor (VBE) .After a while he wanted to go back to the Excel application interface.Which of the following key(s) should Ben use to toggle between the Excel application interface and the VBE?

Which of the following is a VBA macro that returns a single value?

Which of the following keys will you press to activate the VBE when Excel is active?